Speedup MySQL with tmpfsedit23 Jan 2015
Today we will deal with temporary tables and files.
At first lets examine the MySQL whether it actually uses temporary tables writings with
Yes, it is definitely does. Just one thing to know is that
Temporary tables are not always flushed to disk, since the time to live of temporary table is rather small.
Lets find where MySQL saves temporary tables
If you had no success with previous one find out with the query
Let’s make sure that MySQL intensively writing in this folder using great
This is a good sign, so lets do the rest.
Add the following string to the
Now let’s apply it without reboot
Now check how faster is scrolling the listing in
This optimization will be useful also for many other services such as anti-viruses, PHP and web servers, Java and so on.