Welcome,
Guest
|
Server crash for MySql load
(1 viewing) (1) Guest
|
TOPIC: Server crash for MySql load
Server crash for MySql load 12 years, 11 months ago #7202
|
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 |
|
Re: Server crash for MySql load 12 years, 11 months ago #7204
|
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?
|
|
Re: Server crash for MySql load 12 years, 11 months ago #7205
|
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 | +------+----------------------+-----------+-------------+----------------+------+----------------------+------------------------------------------------------------------------------------------------------+ |
|
Re: Server crash for MySql load 12 years, 11 months ago #7207
|
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.
|
The following user(s) said Thank You: okie
|
Re: Server crash for MySql load 12 years, 11 months ago #7208
|
How to? just changing it into PhpMyAdmin? does this affect joomla performance/upgrade?
|
|
Re: Server crash for MySql load 12 years, 11 months ago #7209
|
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).
|
|
|
Time to create page: 0.33 seconds