Re: Analyse ralentissement transaction MySQL
Le 12/03/2010 17:57, vic ros a écrit :
Peux tu faire :
mysql> show profile ipc for query 5;
mysql> show profile ipc for query 2;
+--------------------------------+-----------+---------------+-------------------+
| Status | Duration | Messages_sent |
Messages_received |
+--------------------------------+-----------+---------------+-------------------+
| (initialization) | 0.000005 | 0 |
0 |
| checking query cache for query | 0.000037 | 0 |
0 |
| checking permissions | 0.000006 | 0 |
0 |
| Opening tables | 0.000007 | 0 |
0 |
| System lock | 0.000004 | 0 |
0 |
| Table lock | 0.000022 | 0 |
0 |
| init | 0.00003 | 0 |
0 |
| optimizing | 0.000006 | 0 |
0 |
| statistics | 0.000039 | 0 |
0 |
| preparing | 0.000009 | 0 |
0 |
| executing | 0.000003 | 0 |
0 |
| Sorting result | 0.016989 | 0 |
0 |
| Sending data | 86.218978 | 0 |
0 |
| end | 0.000007 | 0 |
0 |
| query end | 0.000002 | 0 |
0 |
| freeing items | 0.000007 | 0 |
0 |
| closing tables | 0.000004 | 0 |
0 |
| logging slow query | 0.000025 | 0 |
0 |
+--------------------------------+-----------+---------------+-------------------+
18 rows in set (0,04 sec)
Toujours sending data. Perso ca ne me parle pas plus quant à une piste à
explorer.
Greg
Reply to: