Server crash for MySql load

Hello
after just 1 day of testing I had to disable the mobile component/plugin. Our dedicated server crashed yesterday. Our provider has said that it happened because of the overload caused on mysql by tera wurl requests. Is it possible?
Our site - mbnews.it, a news magazine - has about 8.000 readers/day. Our site has 4 gb of ram.
Regards

Terawurfl should not cause a mysql/server crash in normal conditions (we have many users on shared/VP servers w/ heavy traffic). There might be another problem causing this? Is 8K/day pure mobile traffic you have? Can you provide more info on the problem?

Thanks for the reply. 8k is the medium global traffic.
I can report this, maybe can help you (please advice me if there are critical data to hide)

+------+----------------------+-----------+-------------+----------------+------+----------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command
| Time | State | Info
|
+------+----------------------+-----------+-------------+----------------+------+----------------------+------------------------------------------------------------------------------------------------------+
| 886 | DELAYED | localhost | mbnewsi_cms | Delayed insert
| 41 | Waiting for INSERT |
|
| 1423 | mbnewsi | localhost | mbnewsi_cms | Query
| 8 | Copying to tmp table | SELECT a.id , CASE WHEN
CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as
slu |
| 1425 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 135 | |
|
| 1440 | mbnewsi | localhost | mbnewsi_cms | Query
| 8 | Sorting result | SELECT a.*, u.name, u.username, cc.image
AS image, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":" |
| 1441 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 131 | |
|
| 1457 | mbnewsi | localhost | mbnewsi_cms | Query
| 7 | Sorting result | SELECT a.*, u.name, u.username, cc.image
AS image, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":" |
| 1465 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 125 | |
|
| 1496 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 9 | |
|
| 1498 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 116 | |
|
| 1504 | mbnewsi | localhost | mbnewsi_cms | Query
| 7 | Sorting result | SELECT a.*, u.name, u.username, cc.image
AS image, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":" |
| 1506 | mbnewsi | localhost | mbnewsi_cms | Query
| 11 | Sorting result | SELECT a.*, u.name, u.username, cc.image
AS image, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":" |
| 1507 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 114 | |
|
| 1508 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 113 | |
|
| 1520 | mbnewsi | localhost | mbnewsi_cms | Query
| 11 | Sorting result | SELECT a.*, u.name, u.username, cc.image
AS image, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":" |
| 1522 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 112 | |
|
| 1538 | admin | localhost | psa | Sleep
| 72 | |
|
| 1547 | mbnewsi | localhost | mbnewsi_cms | Query
| 9 | Copying to tmp table | SELECT a.id , CASE WHEN
CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as
slu |
| 1550 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 105 | |
|
| 1574 | mbnewsi | localhost | mbnewsi_cms | Query
| 6 | Sorting result | SELECT a.*, u.name, u.username, cc.image
AS image, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":" |
| 1575 | mbnewsi | localhost | mbnewsi_cms | Query
| 9 | Sorting result | SELECT a.*, u.name, u.username, cc.image
AS image, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":" |
| 1576 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 100 | |
|
| 1578 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 99 | |
|
| 1582 | mbnewsi | localhost | mbnewsi_cms | Query
| 1 | Locked | SELECT a.*, u.name, u.username, cc.image
AS image, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":" |
| 1583 | mbnewsi | localhost | mbnewsi_cms | Query
| 9 | Sorting result | SELECT a.*, u.name, u.username, cc.image
AS image, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":" |
| 1584 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 98 | |
|
| 1588 | mbnewsi | localhost | mbnewsi_cms | Query
| 11 | Sorting result | SELECT a.*, u.name, u.username, cc.image
AS image, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":" |
| 1591 | mbnewsi | localhost | mbnewsi_cms | Query
| 11 | Sorting result | SELECT a.*, u.name, u.username, cc.image
AS image, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":" |
| 1593 | mbnewsi | localhost | mbnewsi_cms | Query
| 2 | Sorting result | SELECT a.*, u.name, u.username, cc.image
AS image, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":" |
| 1597 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 95 | |
|
| 1598 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 95 | |
|
| 1621 | mbnewsi | localhost | mbnewsi_cms | Query
| 1 | Locked | SELECT a.*, u.name, u.username, cc.image
AS image, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":" |
| 1624 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 88 | |
|
| 1628 | mbnewsi | localhost | mbnewsi_cms | Query
| 1 | Locked | SELECT a.*, u.name, u.username, cc.image
AS image, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":" |
| 1631 | mbnewsi | localhost | mbnewsi_cms | Query
| 10 | Sorting result | SELECT a.*, u.name, u.username, cc.image
AS image, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":" |
| 1633 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 86 | |
|
| 1635 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 85 | |
|
| 1636 | mbnewsi | localhost | mbnewsi_cms | Query
| 1 | Locked | SELECT a.*, u.name, u.username, cc.image
AS image, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":" |
| 1639 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 85 | |
|
| 1649 | mbnewsi | localhost | mbnewsi_cms | Query
| 2 | Sorting result | SELECT a.*, u.name, u.username, cc.image
AS image, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":" |
| 1651 | mbnewsi | localhost | mbnewsi_cms | Query
| 1 | Locked | SELECT a.*, u.name, u.username, cc.image
AS image, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":" |
| 1652 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 79 | |
|
| 1654 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 77 | |
|
| 1667 | mbnewsi | localhost | mbnewsi_cms | Query
| 1 | Locked | SELECT title, id FROM jos_content WHERE
id = 23173 |
| 1672 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 73 | |
|
| 1680 | mbnewsi | localhost | mbnewsi_cms | Query
| 1 | Locked | SELECT a.*, u.name, u.username, cc.image
AS image, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":" |
| 1686 | mbnewsi | localhost | mbnewsi_cms | Query
| 1 | Locked | SELECT title, id FROM jos_content WHERE
id = 23173 |
| 1687 | mbnewsi | localhost | mbnewsi_cms | Query
| 1 | Locked | SELECT a.*, u.name, u.username, cc.image
AS image, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":" |
| 1688 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 67 | |
|
| 1689 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 67 | |
|
| 1693 | mbnewsi | localhost | mbnewsi_cms | Query
| 1 | Locked | SELECT a.*, u.name, u.username, cc.image
AS image, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":" |
| 1695 | mbnewsi | localhost | mbnewsi_cms | Query
| 10 | Sorting result | SELECT a.*, u.name, u.username, cc.image
AS image, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":" |
| 1700 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 62 | |
|
| 1704 | mbnewsi | localhost | mbnewsi_cms | Query
| 0 | Locked | SELECT a.*, u.name, u.username, cc.image
AS image, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":" |
| 1707 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 59 | |
|
| 1708 | mbnewsi | localhost | mbnewsi_cms | Query
| 1 | Locked | SELECT title, id FROM jos_content WHERE
id = 23173 |
| 1712 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 58 | |
|
| 1727 | mbnewsi | localhost | mbnewsi_cms | Query
| 10 | Locked | SELECT title, id FROM jos_content WHERE
id = 22658 |
| 1729 | mbnewsi | localhost | mbnewsi_cms | Query
| 4 | Sorting result | SELECT a.*, u.name, u.username, cc.image
AS image, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":" |
| 1730 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 53 | |
|
| 1731 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 17 | |
|
| 1732 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 53 | |
|
| 1733 | mbnewsi | localhost | mbnewsi_cms | Query
| 11 | Sorting result | SELECT a.*, CASE WHEN
CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as
slug, |
| 1734 | mbnewsi | localhost | mbnewsi_cms | Query
| 11 | Sorting result | SELECT a.*, CASE WHEN
CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as
slug, |
| 1735 | mbnewsi | localhost | mbnewsi_cms | Query
| 11 | Sorting result | SELECT a.*, CASE WHEN
CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as
slug, |
| 1741 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 18 | |
|
| 1742 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 50 | |
|
| 1744 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 49 | |
|
| 1749 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 48 | |
|
| 1755 | mbnewsi | localhost | mbnewsi_cms | Query
| 1 | Locked | SELECT a.id, a.sectionid, a.access, CASE
WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias |
| 1757 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 46 | |
|
| 1758 | mbnewsi | localhost | mbnewsi_cms | Query
| 10 | Sorting result | SELECT a.*, CASE WHEN
CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as
slug, |
| 1759 | mbnewsi | localhost | mbnewsi_cms | Query
| 11 | Sorting result | SELECT a.*, CASE WHEN
CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as
slug, |
| 1761 | mbnewsi | localhost | mbnewsi_cms | Query
| 10 | Sorting result | SELECT a.*, CASE WHEN
CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as
slug, |
| 1762 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 45 | |
|
| 1764 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 45 | |
|
| 1765 | mbnewsi | localhost | mbnewsi_cms | Query
| 1 | Locked | SELECT a.*, u.name, u.username, cc.image
AS image, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":" |
| 1767 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 44 | |
|
| 1768 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 18 | |
|
| 1769 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 43 | |
|
| 1773 | mbnewsi | localhost | mbnewsi_cms | Query
| 11 | Sorting result | SELECT a.*, CASE WHEN
CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as
slug, |
| 1774 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 2 | |
|
| 1775 | mbnewsi | localhost | mbnewsi_cms | Query
| 11 | Sorting result | SELECT a.*, CASE WHEN
CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as
slug, |
| 1776 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 39 | |
|
| 1778 | mbnewsi | localhost | mbnewsi_cms | Query
| 11 | Sorting result | SELECT a.*, CASE WHEN
CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as
slug, |
| 1779 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 38 | |
|
| 1780 | mbnewsi | localhost | mbnewsi_cms | Query
| 1 | Locked | SELECT a.*, CASE WHEN
CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as
slug, |
| 1781 | mbnewsi | localhost | mbnewsi_cms | Query
| 1 | Locked | SELECT a.*, CASE WHEN
CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as
slug, |
| 1782 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 38 | |
|
| 1784 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 37 | |
|
| 1785 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 37 | |
|
| 1787 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 37 | |
|
| 1788 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 13 | |
|
| 1789 | mbnewsi | localhost | mbnewsi_cms | Query
| 10 | Sorting result | SELECT a.*, CASE WHEN
CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as
slug, |
| 1790 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 36 | |
|
| 1791 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 36 | |
|
| 1792 | mbnewsi | localhost | mbnewsi_cms | Query
| 7 | Sorting result | SELECT a.*, CASE WHEN
CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as
slug, |
| 1793 | mbnewsi | localhost | mbnewsi_cms | Query
| 1 | Locked | SELECT a.*, CASE WHEN
CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as
slug, |
| 1794 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 35 | |
|
| 1796 | mbnewsi | localhost | mbnewsi_cms | Query
| 11 | Sorting result | SELECT a.*, CASE WHEN
CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as
slug, |
| 1797 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 34 | |
|
| 1798 | mbnewsi | localhost | mbnewsi_cms | Query
| 10 | Locked | SELECT a.*, CASE WHEN
CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as
slug, |
| 1799 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 34 | |
|
| 1800 | mbnewsi | localhost | mbnewsi_cms | Query
| 8 | Sorting result | SELECT a.*, CASE WHEN
CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as
slug, |
| 1801 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 33 | |
|
| 1802 | mbnewsi | localhost | mbnewsi_cms | Query
| 11 | Sorting result | SELECT a.*, CASE WHEN
CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as
slug, |
| 1803 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 32 | |
|
| 1804 | mbnewsi | localhost | mbnewsi_cms | Query
| 11 | Sorting result | SELECT a.*, CASE WHEN
CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as
slug, |
| 1805 | mbnewsi | localhost | mbnewsi_cms | Query
| 1 | Locked | SELECT a.id, a.sectionid, a.access, CASE
WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias |
| 1806 | mbnewsi | localhost | mbnewsi_cms | Query
| 11 | Sorting result | SELECT a.*, CASE WHEN
CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as
slug, |
| 1807 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 30 | |
|
| 1808 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 30 | |
|
| 1809 | mbnewsi | localhost | mbnewsi_cms | Query
| 1 | Locked | SELECT a.*, CASE WHEN
CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as
slug, |
| 1810 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 27 | |
|
| 1811 | mbnewsi | localhost | mbnewsi_cms | Query
| 2 | Sorting result | SELECT a.*, CASE WHEN
CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as
slug, |
| 1813 | mbnewsi | localhost | mbnewsi_cms | Query
| 10 | Locked | SELECT a.id, a.title, a.created,
a.introtext, a.fulltext, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCA |
| 1814 | mbnewsi | localhost | mbnewsi_cms | Query
| 1 | Locked | SELECT a.*, CASE WHEN
CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as
slug, |
| 1815 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 25 | |
|
| 1816 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 25 | |
|
| 1817 | mbnewsi | localhost | mbnewsi_cms | Query
| 1 | Locked | SELECT a.*, CASE WHEN
CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as
slug, |
| 1818 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 24 | |
|
| 1819 | mbnewsi | localhost | mbnewsi_cms | Query
| 1 | Locked | SELECT a.*, CASE WHEN
CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as
slug, |
| 1820 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 24 | |
|
| 1823 | mbnewsi | localhost | mbnewsi_cms | Query
| 1 | Locked | SELECT a.*, CASE WHEN
CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as
slug, |
| 1824 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 1 | |
|
| 1825 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 23 | |
|
| 1826 | mbnewsi | localhost | mbnewsi_cms | Query
| 1 | Locked | SELECT a.id, a.sectionid, a.access, CASE
WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias |
| 1828 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 22 | |
|
| 1831 | mbnewsi | localhost | mbnewsi_cms | Query
| 3 | Sorting result | SELECT a.*, CASE WHEN
CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as
slug, |
| 1832 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 20 | |
|
| 1835 | mbnewsi | localhost | mbnewsi_cms | Query
| 0 | Locked | SELECT a.id, a.title, a.created,
a.introtext, a.fulltext, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCA |
| 1840 | mbnewsi | localhost | mbnewsi_cms | Query
| 1 | Locked | SELECT a.id, a.title, a.created,
a.introtext, a.fulltext, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCA |
| 1844 | mbnewsi | localhost | mbnewsi_cms | Query
| 2 | Locked | SELECT a.id, a.title, a.created,
a.introtext, a.fulltext, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCA |
| 1845 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 13 | |
|
| 1847 | mbnewsi | localhost | mbnewsi_cms | Query
| 1 | Locked | UPDATE jos_content SET hits = ( hits +
1 ) WHERE id='23193' |
| 1848 | mbnewsi | localhost | mbnewsi_cms | Query
| 10 | Locked | SELECT a.id, a.title, a.alias,
a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid |
| 1849 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 10 | |
|
| 1850 | mbnewsi | localhost | mbnewsi_cms | Query
| 1 | Locked | UPDATE jos_content SET hits = ( hits +
1 ) WHERE id='23193' |
| 1851 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 10 | |
|
| 1852 | mbnewsi | localhost | mbnewsi_cms | Query
| 8 | Copying to tmp table | SELECT a.id, a.title, a.alias,
a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid |
| 1854 | mbnewsi | localhost | mbnewsi_cms | Query
| 8 | Copying to tmp table | SELECT a.id, a.title, a.alias,
a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid |
| 1855 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 8 | |
|
| 1856 | mbnewsi | localhost | mbnewsi_cms | Query
| 1 | Locked | UPDATE jos_content SET hits = ( hits +
1 ) WHERE id='23193' |
| 1857 | mbnewsi | localhost | mbnewsi_cms | Query
| 1 | Locked | UPDATE jos_content SET hits = ( hits +
1 ) WHERE id='23193' |
| 1858 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 4 | |
|
| 1859 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 8 | |
|
| 1860 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 8 | |
|
| 1861 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 5 | |
|
| 1863 | mbnewsi | localhost | mbnewsi_cms | Query
| 6 | Sorting result | SELECT a.hits, a.id, a.sectionid,
a.title, a.created, u.name FROM jos_content AS a LEFT JOIN jos_use |
| 1865 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 6 | |
|
| 1866 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 4 | |
|
| 1867 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 4 | |
|
| 1868 | mbnewsi | localhost | mbnewsi_cms | Query
| 1 | Locked | UPDATE jos_content SET hits = ( hits +
1 ) WHERE id='23193' |
| 1869 | mbnewsi | localhost | mbnewsi_cms | Query
| 1 | Locked | UPDATE jos_content SET hits = ( hits +
1 ) WHERE id='23193' |
| 1872 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 5 | |
|
| 1873 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 4 | |
|
| 1874 | mbnewsi | localhost | mbnewsi_cms | Query
| 1 | Locked | UPDATE jos_content SET hits = ( hits +
1 ) WHERE id='23193' |
| 1875 | mbnewsi | localhost | mbnewsi_cms | Query
| 1 | Locked | UPDATE jos_content SET hits = ( hits +
1 ) WHERE id='23095' |
| 1876 | mbnewsi | localhost | mbnewsi_cms | Query
| 1 | Locked | UPDATE jos_content SET hits = ( hits +
1 ) WHERE id='23193' |
| 1878 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 4 | |
|
| 1879 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 4 | |
|
| 1880 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 3 | |
|
| 1882 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 3 | |
|
| 1883 | mbnewsi | localhost | mbnewsi_cms | Query
| 1 | Locked | UPDATE jos_content SET hits = ( hits +
1 ) WHERE id='23193' |
| 1884 | mbnewsi | localhost | mbnewsi_cms | Query
| 1 | Locked | UPDATE jos_content SET hits = ( hits +
1 ) WHERE id='14470' |
| 1885 | mbnewsi | localhost | mbnewsi_cms | Query
| 1 | Locked | UPDATE jos_content SET hits = ( hits +
1 ) WHERE id='23193' |
| 1886 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 2 | |
|
| 1887 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 2 | |
|
| 1888 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 2 | |
|
| 1891 | unauthenticated user | localhost | | Connect
| | Reading from net |
|
| 1892 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 2 | |
|
| 1893 | mbnewsi | localhost | mbnewsi_cms | Sleep
| 2 | |
|
| 1894 | admin | localhost | | Query
| 0 | | show processlist
|
+------+----------------------+-----------+-------------+----------------+------+----------------------+------------------------------------------------------------------------------------------------------+

Requests you posted come from com_content component. I'd suggest you change tables with many INSERTs from MyISAM to InnoDB format (usually jos_content, jos_session, jos_users, etc.) to prevent full table locking on insert.

How to? just changing it into PhpMyAdmin? does this affect joomla performance/upgrade?

Yes. It doesn't affect upgrade (and you can switch back to MyISAM in the case of problems with preformance, but usually InnoDB speed up highloaded sites).