Suljettu

huge joomla website down and up many times every day

I need a expert to solve the problem. Below is our diagnosis:

site's mysql queries are taking too long.

The load is consistently high.

05:20:01 PM runq-sz plist-sz ldavg-1 ldavg-5 ldavg-15

05:30:01 PM 8 211 6.16 5.89 5.35

05:40:01 PM 1 209 6.37 6.57 6.08

05:50:01 PM 5 294 6.89 6.77 6.38

06:00:01 PM 1 308 5.91 6.40 6.43

06:10:01 PM 1 362 5.83 5.70 5.98

06:20:01 PM 1 413 5.45 5.31 5.63

06:30:04 PM 43 345 13.04 8.89 6.91

Average: 4 240 4.76 4.71 4.65

The indexes do not appear to be very effective.

========================================================================

mysql> explain SELECT [url removed, login to view] FROM bak_content AS a USE INDEX ( idx_composite );

+----+-------------+-------+-------+---------------+---------------+---------+------+---------+-------------+

| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |

+----+-------------+-------+-------+---------------+---------------+---------+------+---------+-------------+

| 1 | SIMPLE | a | index | NULL | idx_composite | 775 | NULL | 3617840 | Using index |

+----+-------------+-------+-------+---------------+---------------+---------+------+---------+-------------+

1 row in set (0.04 sec)

========================================================================

explain SELECT [url removed, login to view], [url removed, login to view], CASE WHEN CHAR_LENGTH([url removed, login to view]) THEN CONCAT_WS(":", [url removed, login to view], [url removed, login to view]) ELSE [url removed, login to view] END as slug, CASE WHEN CHAR_LENGTH([url removed, login to view]) THEN CONCAT_WS(":", [url removed, login to view], [url removed, login to view]) ELSE [url removed, login to view] END as catslug FROM bak_content AS a LEFT JOIN bak_categories AS cc ON [url removed, login to view] = [url removed, login to view] WHERE [url removed, login to view] = 109 AND [url removed, login to view] > '3234-1265, 3234-1270, 3234-1275, 3234-1280, 3234-1552' ORDER BY [url removed, login to view] LIMIT 1;

+----+-------------+-------+-------+----------------------------------------+----------------+---------+-------+--------+-------------+

| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |

+----+-------------+-------+-------+----------------------------------------+----------------+---------+-------+--------+-------------+

| 1 | SIMPLE | a | ref | idx_catid,idx_composite,idx_composite2 | idx_composite2 | 4 | const | 871696 | Using where |

| 1 | SIMPLE | cc | const | PRIMARY | PRIMARY | 4 | const | 1 | |

+----+-------------+-------+-------+----------------------------------------+----------------+---------+-------+--------+-------------+

========================================================================

The bak_content table is 3,617,840 rows and that first query still goes through them all even though it calls for an index.

Please note: bak_content is the table in use. It is not for backup.

Sincerely,

Chris

Taidot: Joomla, MySQL, PHP

Näytä lisää: php catid, all day every day, joomla website times, website sec, website down, php mysql join table, mysql join table, mysql table join, php mysql load table, php load table, mysql backup table, backup website, php slug, load average, joomla slug, joomla table mysql, load php joomla, 209, mysql queries using, simple joomla backup, huge load, order taking website, php mysql table join, query joomla php, backup mysql using php

Tietoa työnantajasta:
( 6 arvostelua ) Beijing, China

Projektin tunnus: #2349789

11 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

onenonly

Let the expert do that for you.

$350 USD 5 päivässä
(87 arvostelua)
6.7
experter

Hi Chris, Let expert do this for you.

$250 USD 4 päivässä
(35 arvostelua)
5.2
govind99

Hi Please check our PM.

$220 USD 7 päivässä
(11 arvostelua)
4.1
netbasevn

plz contact me, I will help you.

$320 USD 5 päivässä
(2 arvostelua)
3.9
defuz3d

Let a Joomla Professional handle this one. More in PM.

$225 USD 15 päivässä
(5 arvostelua)
3.9
galaxianape

Hi, you can rely on us to solve this issue. We have experience to fix this. Thanks Ricky

$250 USD 2 päivässä
(1 arvostelu)
3.5
predy88

i had a similar problem with my website ! it can be fixed .

$100 USD 3 päivässä
(1 arvostelu)
1.0
jobsimworkz

No problem, Have tons of experience on that, Most of my joomla customers face this issue too. Please have a backup 1st though. can do it in a few hours or lesser

$120 USD 1 päivässä
(0 arvostelua)
0.0
vkbansallx

free advise u r using queries which take too much processing time. chk it on a table with just 10000 records

$2000 USD 30 päivässä
(0 arvostelua)
0.0
XiG873lHF

Custom software development - <b><i>Removed by Admin</i></b>

$250 USD 1 päivässä
(0 arvostelua)
0.0
gaiagrid

Hello My name is Amrit representing GaiaGrid, Inc. We are a development, design and marketing firm located and operated out of the United States, specifically in New Jersey. Please review your inbox for further details Lisää

$1500 USD 40 päivässä
(0 arvostelua)
0.0