Hi!
Nowadays we've conducted something what I can call extended testing of
MySQL on Solaris10/x86.
The most annoying issue is a problem with locking queries to MyISAM-type
tables.
Mechanism seems to be simple to explain - long running query locks table
for READ, next there is some DML query which must wait for this lock to
be removed, and then every other query must also wait (even SELECTs,
because it seems they wait for DML to complete), while wait times became
completely unacceptable
However this is the issue only on Solaris. The same application/database
running on Linux has no such problems. The other thing is, that the same
set of queries runs on Solaris much slower than on Linux - what at least
partially explains no problems on Linux
There is enabled disk-buffering, key buffer is even bigger than on
Linux, we try mysql in versions 4 and 5, nonetheless on Solaris there is
locking, on Linux there is not.
Queries beeing executed make count(*) by full scan (due to hardly
selective conditions (sex etc)) on table with ~10000 rows and join to
another table with ~1000000 rows.
Any comments ?
Best regards
Remigiusz
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
