Welcome, Guest
Username Password: Remember me

Server crash for MySql load
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Server crash for MySql load

Server crash for MySql load 12 years, 11 months ago #7202

  • theant
  • OFFLINE
  • Fresh Boarder
  • Posts: 16
  • Karma: 0
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

  • C00L
  • OFFLINE
  • Administrator
  • Posts: 191
  • Karma: 0
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

  • theant
  • OFFLINE
  • Fresh Boarder
  • Posts: 16
  • Karma: 0
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

  • dryabov
  • OFFLINE
  • Administrator
  • Denis Ryabov, Lead Developer
  • Posts: 4863
  • Karma: 105
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

  • theant
  • OFFLINE
  • Fresh Boarder
  • Posts: 16
  • Karma: 0
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

  • dryabov
  • OFFLINE
  • Administrator
  • Denis Ryabov, Lead Developer
  • Posts: 4863
  • Karma: 105
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).
  • Page:
  • 1
Time to create page: 0.33 seconds

By continuing to use this site you consent to the use of cookies on your device as described in our cookie policy unless you have disabled them. This site will not function correctly without cookies.

I accept cookies from this site.