Well, there isn't a my.cnf file, so other that setting the max_connections with the -O option, it's whatever is default for 3.23.56.
-James On Tue, 2003-09-02 at 10:50, Jeremy Zawodny wrote: > 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 -- James Kelty E-Commerce / Financial Systems Administrator Portland State University 503.725.9152 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
