I am trying to push the performance of a Mysql database a little more,
it's pretty busy, but I hope to squeeze a tad more out of it.


I am a newbie/pretty clueless wrt MySQL in general, so ...


I run the status command, and see the following.


mysql Ver 12.20 Distrib 4.0.13, for pc-linux (i686)

Connection id:          27840031
Current database:
Current user:           [EMAIL PROTECTED]
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Server version:         4.0.13-log
Protocol version:       10
Connection:             Localhost via UNIX socket
Client characterset:    latin1
Server characterset:    latin1
UNIX socket:            /var/lib/mysql/mysql.sock
Uptime:                 4 days 14 hours 26 min 56 sec

Threads: 161  Questions: 128065100  Slow queries: 0  Opens: 657  Flush
tables: 1  Open tables: 512  Queries per second avg: 322.082

----

The value for Open Tables is 512, which looks suspiciously to me like
it's hit a limit. Is there a way to increase that limit? Or am I
misunderstanding what status is telling me?


--
Jim Richardson     http://www.eskimo.com/~warlock
Ahhh... I see the fuck-up fairy has visited us again.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to