On Tue, Dec 16, 2003 at 10:13:39PM +1100, Chris Nolan wrote: > There are a few things that could be happening: > > Are you using persistant connections from your web servers,
Yes - with Apache::DBI under mod_perl > 2. Which FS are you using? The native Solaris FS needs a bit of tuning > to get decent DB performance apparently. The DB is on a vanilla UFS partition. Do you have any references about this? I couldn't find anything on the MySQL site... > > 3. What sort of disk subsystem does the new box have? As the load is so > high, it seems that either MySQL is waiting on disk I/O or network I/O.... The database is on a single 120GB SCSI disk internal to the main unit. Nothing else is on that disk. If you have any suggestions for tests I could switch the machine into the system again and capture what is happening... MySQL runs in a single process of 720MB with the settings I gave it. > > 4. What table type(s) are you using on each box? Our database has 53 tables, all are MyISAM. The entire database takes up 1.9GB on disk. Almost all queries are lightweight ones of the form: select * from sometable where id=12345; where id is the primary key or, select id from sometable where customer=12345 where customer is indexed. > > Please write back! Let's fix this! :-) Many thanks for your help! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
