+------+-----------+-----------+-----------+---------+------+--------------------+------------------
------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State
| Info
|
+------+-----------+-----------+-----------+---------+------+--------------------+------------------
------------------------------------------------------------------------------------+
| 1966 | root | localhost | mysql | Sleep | 1655 |
|
|
| 2221 | artmaster | localhost | artmaster | Query | 1 | removing tmp
table | SELECT * FROM `s4oai_virtuemart_products_ru_ru` as l JOIN
`s4oai_virtuemart_products` AS p using (` |
| 2222 | root | localhost | | Query | 0 |
| show processlist
|
+------+-----------+-----------+-----------+---------+------+--------------------+------------------
------------------------------------------------------------------------------------+
+------+-----------+-----------+-----------+---------+------+--------------------+------------------
------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State
| Info
|
+------+-----------+-----------+-----------+---------+------+--------------------+------------------
------------------------------------------------------------------------------------+
| 1966 | root | localhost | mysql | Sleep | 1656 |
|
|
| 2221 | artmaster | localhost | artmaster | Query | 2 | removing tmp
table | SELECT * FROM `s4oai_virtuemart_products_ru_ru` as l JOIN
`s4oai_virtuemart_products` AS p using (` |
| 2223 | root | localhost | | Query | 0 |
| show processlist
|
+------+-----------+-----------+-----------+---------+------+--------------------+------------------
------------------------------------------------------------------------------------+
+------+-----------+-----------+-----------+---------+------+--------------------+------------------
------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State
| Info
|
+------+-----------+-----------+-----------+---------+------+--------------------+------------------
------------------------------------------------------------------------------------+
| 1966 | root | localhost | mysql | Sleep | 1657 |
|
|
| 2221 | artmaster | localhost | artmaster | Query | 3 | removing tmp
table | SELECT * FROM `s4oai_virtuemart_products_ru_ru` as l JOIN
`s4oai_virtuemart_products` AS p using (` |
| 2224 | root | localhost | | Query | 0 |
| show processlist
|
+------+-----------+-----------+-----------+---------+------+--------------------+------------------
------------------------------------------------------------------------------------+
+------+-----------+-----------+-----------+---------+------+--------------------+------------------
------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State
| Info
|
+------+-----------+-----------+-----------+---------+------+--------------------+------------------
------------------------------------------------------------------------------------+
| 1966 | root | localhost | mysql | Sleep | 1658 |
|
|
| 2221 | artmaster | localhost | artmaster | Query | 4 | removing tmp
table | SELECT * FROM `s4oai_virtuemart_products_ru_ru` as l JOIN
`s4oai_virtuemart_products` AS p using (` |
| 2225 | root | localhost | | Query | 0 |
| show processlist
|
+------+-----------+-----------+-----------+---------+------+--------------------+------------------
------------------------------------------------------------------------------------+
9 6 67 18 0 0| 0 75M| 120k 121k| 0 0 |1623 7635
12 3 52 31 0 1| 0 89M| 509k 510k| 0 0 |2404 7915
19 4 48 29 0 1| 0 115M| 814k 816k| 0 0 |2683 9367
19 4 50 26 0 1| 0 74M| 535k 536k| 0 0 |2727 8526
25 4 62 8 0 1|8192B 20M| 326k 326k| 0 0 |1863 9891