CPU Usage and MySQL...

2003-08-31 Thread jkelty
Hello, I have a strange problem with my mysql server. The mysql process seems to be using between 60 and 70 percent of the CPU at all times. Even when it is seemingly idle (not active queries). I'm not sure what to look for to see what it is doing other than truss'ing the process (I'm running

Table locking...

2003-08-18 Thread jkelty
Hello, I just have a question about the table locking in 3.23.56. If I am inserting a row into a table that is MyISAM type, is the entire table locked? And, if so, what does this mean for concurrent selects? -James -- MySQL General Mailing List For list archives:

Re: Table locking...

2003-08-18 Thread jkelty
I could fix this if I changed the table type to InnoDB, correct? -James Quoting Jeremy Zawodny [EMAIL PROTECTED]: On Mon, Aug 18, 2003 at 10:41:55AM -0700, [EMAIL PROTECTED] wrote: Hello, I just have a question about the table locking in 3.23.56. If I am inserting a row into a table