On Wed, Dec 17, 2003 at 03:53:04AM +1100, Chris Nolan wrote: > > > >The DB is on a vanilla UFS partition. Do you have any references about > >this? I couldn't find anything on the MySQL site... > > > > > > > There's nothing on the MySQL site but I do remember reading a comparison > between Solaris x86 and > Linux that showed that UFS gained quite a massive speedup for DB-style > operations by turning on something > similar to (or perhaps the very same thing as) soft updates.
Thanks. I'll look it up. > >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... > > > > > Is the disk subsystem in the original box similar? No, the Linux box has a single, internal EIDE drive with nearly everything on a single 40GB partition. > > > Hmmm....it's very, very unlikely, but have you checked to ensure that > MySQL is using the indexes on the Solaris box (with EXPLAIN SELECT...) ? It's definitely running indexed. > Additionally, > what's your approximate balance of SELECT, UPDATE, INSERT and DELETE > operations? The fact that there's such a huge difference here is odd... >From our working slave server: Sel: 85% Ins: 03% Upd: 09% Del: 01% Key reads: 303184 Key read requests: 846809596 Open tables: 133 > > > You're welcome! A few other questions have come to mind: > > 1. Are you using MySQL 3.23.52 on the Solaris box as well? Version 3.23.58 on the Solaris box. Is this likely to be a problem? > 2. Have you tried facing Stockholm and begging for salvation? Worth a try I guess :-) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]