Mysql Big Data table update is slow _ MySQL

Mysql Big Data table update is slow to solve bitsCN.com

Mysql Big Data table update is slow to solve

Problem description:

Data tables of tens of millions, update where gid = "adadfadsfasdf", and the returned results are between 70 ms and 1 s.

Analysis:

If the table is large, you may need to retrieve the index first and then the page. However, even if it is a disk operation, each disk operation takes 5 ms and takes about 20 or 30 ms.

So the time must have been spent on io wait.

Use iostat-x-d 1 3 to display the wait time for dozens of milliseconds

So the time is indeed spent on io wait.

Solution:

Reduce io

Increase the mysql memory. it turns out to be 10 GB, and now it is 50 GB.

BitsCN.com