mysql text datatype SELECT query slow even with tmp dir on tmpfs
I have a SELECT five table join query that has TEXT field in it. Even though the mysql tmp dir is mounted on tmpfs the SELECT query is slow. Below is the PROFILE of the SELECT query and the tmpfs configuration. Does anyone know what could be the issue here?
tmpfs /var/lib/mysqltmpfs tmpfs size=10g,uid=mysql,gid=mysql,mode=0755 0 0
mysql> SHOW PROFILE;
+----------------------+----------+
| Status | Duration |
+----------------------+----------+
| starting | 0.000214 |
| checking permissions | 0.000047 |
| checking permissions | 0.000044 |
| checking permissions | 0.000044 |
| checking permissions | 0.000044 |
| checking permissions | 0.000046 |
| Opening tables | 0.000091 |
| init | 0.000096 |
| System lock | 0.000055 |
| optimizing | 0.000061 |
| statistics | 0.000282 |
| preparing | 0.000066 |
| Creating tmp table | 0.000116 |
| executing | 0.000046 |
| Sending data | 0.188435 |
| end | 0.000225 |
| removing tmp table | 0.123960 |
| end | 0.000232 |
| query end | 0.000058 |
| closing tables | 0.000098 |
| freeing items | 0.000107 |
| cleaning up | 0.000095 |
+----------------------+----------+
Subject
Views
Written By
Posted
mysql text datatype SELECT query slow even with tmp dir on tmpfs
1460
February 22, 2016 08:36AM
730
February 22, 2016 12:35PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.