Re: MyISAM not scaling well
Thanks Rick!
=============================
Well, as queries are read-only, I think that table-based locking or row locking will not make any difference.
Flow style means that the thread client launches a query after finishing the previous one, without closing connection to server between queries.
There are about 60 queries per second.
All clients are hitting the only one server machine.
20% of 16 cores means that only 1 core is being used at 20%, so this is very low CPU usage.
=============================
However, I have done a test that clarifies all this situation:
In order to see if contention was located at the MySQL server, I executed several servers at the same machine. In this way, the different servers where accessing in read-only mode to the same files that contain the database data.
And I launched, from a different machine, one thread client per server. Now, if there was any contention in the server, it should disappear, and the CPU usage should increase.
However, the CPU usage was the same. This means that the bottleneck is in the data files themselves: the bottleneck is in the disk, in this case, SSD disks (using HDD is even worst). So I think nothing can be done about this... At least, this is not a MySQL problem.
Regards