Are you the only one using the MySQL engine on your server?
The relevante portion of the MySQL docs is:
Which I didn't mean to imply wasn't (if I did). The more active your system is, the more open tables you'll have. BUT -- MySQL is in charge of this.
Links, and any well behaved DBI:
For information purposes...
Check your MySQL stats at your lowest level of traffic time -- see what the threads and tables stats are.
Also, see if you shut your server down for 5 minutes if that changes the stats. (Some persistants are probably 10 minutes... but most should be under 5 minutes).
I keep close tabs on my server stats, and I've not see these sort of numbers. I'm curious.
[This message has been edited by pugdog (edited January 05, 2000).]
The relevante portion of the MySQL docs is:
Quote:
MySQL is multithreaded, so it may have many queries on the same table simultaneously. To minimize the problem with two threads having different states on the same file, the table is opened independently by each concurrent thread. This takes some memory and one extra file descriptor for the data file. The index file descriptor is shared between all threads.Which I didn't mean to imply wasn't (if I did). The more active your system is, the more open tables you'll have. BUT -- MySQL is in charge of this.
Links, and any well behaved DBI:
For information purposes...
Check your MySQL stats at your lowest level of traffic time -- see what the threads and tables stats are.
Also, see if you shut your server down for 5 minutes if that changes the stats. (Some persistants are probably 10 minutes... but most should be under 5 minutes).
I keep close tabs on my server stats, and I've not see these sort of numbers. I'm curious.
[This message has been edited by pugdog (edited January 05, 2000).]