On Tue, Sep 02, 2003 at 10:37:34AM -0700, James Kelty wrote: > So, we have a webmail application that uses a mysql server for holding > it's session information. Obviously this causes many > reads,updates,inserts, and deletes to happen. Here are my lock > statistics. > > | Table_locks_immediate | 73099 | > | Table_locks_waited | 32187 | > > This ratio seems REALLY bad to me.
It's not good. Especially if that's a small number of tables. > I'm wondering if there is anything I can do to tune the server a > little. I have 4G of memory on my system, but MySQL only seems to be > using about 64M. If giving it more would help with this a little, > how do I do that? What's your my.cnf file look like? How lagre are the data and index files? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.13: up 31 days, processed 1,373,610,821 queries (496/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
