Fermé

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 [url removed, login to view] [url removed, login to view] [url removed, login to view]

05:40:01 PM 1 209 [url removed, login to view] [url removed, login to view] [url removed, login to view]

05:50:01 PM 5 294 [url removed, login to view] [url removed, login to view] [url removed, login to view]

06:00:01 PM 1 308 [url removed, login to view] [url removed, login to view] [url removed, login to view]

06:10:01 PM 1 362 [url removed, login to view] [url removed, login to view] [url removed, login to view]

06:20:01 PM 1 413 [url removed, login to view] [url removed, login to view] [url removed, login to view]

06:30:04 PM 43 345 [url removed, login to view] [url removed, login to view] [url removed, login to view]

Average: 4 240 [url removed, login to view] [url removed, login to view] [url removed, login to view]

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 ([url removed, login to view] 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

Compétences : Joomla, MySQL, PHP

Voir plus : php catid, 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, taking calls

Concernant l'employeur :
( 6 commentaires ) Beijing, China

N° du projet : #2349789

11 freelance ont fait une offre moyenne de 508 $ pour ce travail

onenonly

Let the expert do that for you.

350 $ USD en 5 jours
(87 Commentaires)
6.7
experter

Hi Chris, Let expert do this for you.

250 $ USD en 4 jours
(35 Commentaires)
5.2
govind99

Hi Please check our PM.

220 $ USD en 7 jours
(11 Commentaires)
4.1
netbasevn

plz contact me, I will help you.

320 $ USD en 5 jours
(2 Commentaires)
3.9
defuz3d

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

225 $ USD en 15 jours
(5 Commentaires)
3.9
galaxianape

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

250 $ USD en 2 jours
(1 Commentaire)
3.5
predy88

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

100 $ USD en 3 jours
(1 Commentaire)
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 en 1 jour
(0 Commentaires)
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 en 30 jours
(0 Commentaires)
0.0
XiG873lHF

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

250 $ USD en 1 jour
(0 Commentaires)
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 Plus

1500 $ USD en 40 jours
(0 Commentaires)
0.0