erreurs connection base de données => changement de serveur

Aller à :

Affichage hiérarchique \| Affichage linéaire erreurs connection base de données => changement de serveur
Auteur	Message

Breizhoo Hors ligne

Posteur Confirmé

Messages : 1 123
Inscription : Feb 2006

Message : #95

Envoyé le 23-09-2010 à 18:20

Citation :Message original : whinpo
j'ai plein de slow queries...
j'essaie des explain
il rame sur l'affichage des posts du jour...

Citation :SELECT tid, subject, icon FROM forum911net_threads WHERE fid <> 71 AND fid <> 53 AND (fid < 110 OR fid > 128) AND fid <> 132 AND fid <> 136 AND fid IN(1,2,3,4,5,6,7,8,12,11,13,51,18,16,33,23,24,25,26,27,28,29,30,31,32,35,38,41,63,42,40,49,45,44,46,47,48,50,58,66,69,74,88,133,141,139,142) ORDER BY lastpost DESC LIMIT 0, 15;

ça met mini 2 secondes à répondre...
quand on s'y met à tous..la machine ne tient pas..

Ah oui, il y a quelques opérateurs quand même !!! Shocked

Ca ne se simplifie pas tous les AND x<>y ?

Pour slow query, j'ai trouvé ça (facile à dire, moins à faire ...)
http://20bits.com/articles/10-tips-for-o...dont-suck/

So, you’re able to generate high-stress situations, but now you need to find the cracks. This is what profiling is for. Profiling enables you to find the bottlenecks in your configuration, whether they be in memory, CPU, network, disk I/O, or, what is more likely, some combination of all of them.

The very first thing you should do is turn on the MySQL slow query log and install mtop. This will give you access to information about the absolute worst offenders. Have a ten-second query ruining your web application? These guys will show you the query right off.

After you’ve identified the slow queries you should learn about the MySQL internal tools, like EXPLAIN, SHOW STATUS, and SHOW PROCESSLIST. These will tell you what resources are being spent where, and what side effects your queries are having, e.g., whether your heinous triple-join subselect query is sorting in memory or on disk. Of course, you should also be using your usual array of command-line profiling tools like top, procinfo, vmstat, etc. to get more general system performance information.

Trouver tous les messages de cet utilisateur

« Discussion précédente | Discussion suivante »

Messages dans cette discussion

erreurs connection base de données => changement de serveur - arma - 14-09-2010, 21:33

[] - yoann - 14-09-2010, 21:39

[] - Fabien - 14-09-2010, 21:41

[] - whinpo - 15-09-2010, 08:09

[] - whinpo - 21-09-2010, 20:33

[] - remchou - 21-09-2010, 20:35

[] - gentleman69 - 21-09-2010, 20:37

[] - LOOI911 - 21-09-2010, 20:39

[] - Max3976 - 21-09-2010, 20:44

[] - gfbt - 21-09-2010, 20:50

[] - ADX - 21-09-2010, 21:01

[] - ymmv - 21-09-2010, 21:07

[] - Oggy - 21-09-2010, 21:09

[] - roadking - 21-09-2010, 21:12

[] - Breizhoo - 21-09-2010, 21:14

[] - ymmv - 21-09-2010, 21:15

[] - phavard - 21-09-2010, 21:18

[] - remchou - 21-09-2010, 21:29

[] - olivier2L4E - 21-09-2010, 21:30

[] - ymmv - 21-09-2010, 21:32

[] - remchou - 21-09-2010, 21:33

[] - ymmv - 21-09-2010, 21:40

[] - patrick123 - 21-09-2010, 21:41

[] - ymmv - 21-09-2010, 21:42

[] - remchou - 21-09-2010, 21:44

[] - remchou - 21-09-2010, 21:49

[] - Phil911 - 21-09-2010, 21:57

[] - difparis - 21-09-2010, 21:59

[] - remchou - 21-09-2010, 22:00

[] - difparis - 21-09-2010, 22:01

[] - remchou - 21-09-2010, 22:02

[] - ymmv - 21-09-2010, 22:15

[] - JEANNOTCUP35 - 21-09-2010, 22:15

[] - ymmv - 21-09-2010, 22:17

[] - difparis - 21-09-2010, 22:19

[] - ymmv - 21-09-2010, 22:25

[] - difparis - 21-09-2010, 22:26

[] - ymmv - 21-09-2010, 23:01

[] - difparis - 21-09-2010, 23:08

[] - julianr - 21-09-2010, 23:22

[] - julianr - 21-09-2010, 23:24

[] - difparis - 21-09-2010, 23:36

[] - julianr - 21-09-2010, 23:55

[] - difparis - 21-09-2010, 23:57

[] - difparis - 22-09-2010, 00:09

[] - difparis - 22-09-2010, 00:18

[] - gsxfred - 22-09-2010, 05:28

[] - ymmv - 22-09-2010, 05:47

[] - ymmv - 22-09-2010, 05:55

[] - whinpo - 22-09-2010, 07:13

[] - ymmv - 22-09-2010, 07:37

[] - difparis - 22-09-2010, 07:43

[] - ymmv - 22-09-2010, 08:02

[] - whinpo - 22-09-2010, 08:13

[] - whinpo - 22-09-2010, 08:15

[] - ymmv - 22-09-2010, 08:29

[] - whinpo - 22-09-2010, 09:09

[] - difparis - 22-09-2010, 09:15

[] - Breizhoo - 22-09-2010, 11:53

[] - steff5L6 - 22-09-2010, 11:54

[] - Oggy - 22-09-2010, 22:47

[] - whinpo - 22-09-2010, 22:48

[] - gfbt - 22-09-2010, 22:51

[] - arma - 22-09-2010, 22:51

[] - arma - 22-09-2010, 22:52

[] - Oggy - 22-09-2010, 22:52

[] - gfbt - 22-09-2010, 22:53

[] - LOOI911 - 22-09-2010, 23:50

[] - difparis - 23-09-2010, 00:03

[] - LOOI911 - 23-09-2010, 00:15

[] - LOOI911 - 23-09-2010, 00:34

[] - Brioche - 23-09-2010, 08:04

[] - Carreraz - 23-09-2010, 09:37

[] - whinpo - 23-09-2010, 11:52

[] - whinpo - 23-09-2010, 11:54

[] - Oggy - 23-09-2010, 17:04

[] - aym - 23-09-2010, 17:05

[] - Carreraz - 23-09-2010, 17:10

[] - Oggy - 23-09-2010, 17:17

[] - LOOI911 - 23-09-2010, 17:19

[] - Breizhoo - 23-09-2010, 17:33

[] - climchaud - 23-09-2010, 17:34

[] - hervé44 - 23-09-2010, 17:41

[] - Grenouille51 - 23-09-2010, 17:44

[] - Breizhoo - 23-09-2010, 17:46

[] - Grenouille51 - 23-09-2010, 17:47

[] - whinpo - 23-09-2010, 17:52

[] - Satanas 33 - 23-09-2010, 17:52

[] - Pam17 - 23-09-2010, 17:55

[] - Breizhoo - 23-09-2010, 18:04

[] - Julien - 23-09-2010, 18:08

[] - whinpo - 23-09-2010, 18:13

[] - Satanas 33 - 23-09-2010, 18:16

[] - climchaud - 23-09-2010, 18:17

[] - Breizhoo - 23-09-2010 18:20

[] - Breizhoo - 23-09-2010, 18:23

[] - profge - 23-09-2010, 18:31

[] - Breizhoo - 23-09-2010, 18:36

[] - whinpo - 23-09-2010, 18:54

[] - remchou - 23-09-2010, 20:18

[] - difparis - 23-09-2010, 20:43

[] - Mascotte - 23-09-2010, 20:48

[] - steph42360 - 23-09-2010, 20:51

[] - chris-91 - 23-09-2010, 20:57

[] - Mascotte - 23-09-2010, 21:20

[] - tinga - 23-09-2010, 21:25

[] - LOOI911 - 23-09-2010, 21:27

[] - difparis - 23-09-2010, 21:31

[] - excelsior - 23-09-2010, 21:33

[] - gentleman69 - 23-09-2010, 21:33

[] - tinga - 23-09-2010, 21:35

[] - Mascotte - 23-09-2010, 21:38

[] - tinga - 23-09-2010, 21:43

[] - profge - 23-09-2010, 21:46

[] - nono - 23-09-2010, 21:47

[] - scotland - 23-09-2010, 21:47

[] - steph42360 - 23-09-2010, 21:49

[] - gentleman69 - 23-09-2010, 21:49

[] - Mascotte - 23-09-2010, 21:55

[] - steph42360 - 23-09-2010, 21:56

[] - gentleman69 - 23-09-2010, 21:57

[] - steph42360 - 23-09-2010, 21:58

[] - profge - 23-09-2010, 21:58

[] - gentleman69 - 23-09-2010, 22:09

[] - Mascotte - 23-09-2010, 22:39

[] - whinpo - 24-09-2010, 08:20

[] - difparis - 24-09-2010, 08:23

[] - Boub42 - 24-09-2010, 08:28

[] - whinpo - 24-09-2010, 08:31

[] - LOOI911 - 24-09-2010, 08:40

[] - Mascotte - 24-09-2010, 08:44

[] - LOOI911 - 24-09-2010, 08:44

[] - difparis - 24-09-2010, 09:16

[] - whinpo - 24-09-2010, 10:02

[] - difparis - 24-09-2010, 10:05

[] - vincent - 24-09-2010, 10:10

[] - whinpo - 24-09-2010, 10:16

[] - whinpo - 24-09-2010, 10:19

[] - enbaseX51 - 24-09-2010, 10:22

[] - ADX - 24-09-2010, 10:42

[] - difparis - 24-09-2010, 10:46

[] - Pascal - 24-09-2010, 10:47

[] - mickey3.2 - 24-09-2010, 11:11

[] - philippe911 - 24-09-2010, 11:55

[] - Breizhoo - 24-09-2010, 12:04

[] - LOOI911 - 24-09-2010, 12:06

[] - whinpo - 24-09-2010, 12:13

[] - LOOI911 - 24-09-2010, 12:36

[] - Breizhoo - 24-09-2010, 17:59

[] - yoann - 26-09-2010, 23:19

[] - Phaius - 26-09-2010, 23:46

[] - Pitou - 27-09-2010, 21:08

[] - whinpo - 28-09-2010, 07:08

[] - FLA69LP - 28-09-2010, 09:25

Aller à :