¿seríais tan amables de ayudarme a averiguar el origen del problema? el comando top no muestra nada... el log de mysql tampoco
algun otro log que me pueda orientar? algun programa que pueda instalar?
os estaría eternamente agradecido!
Full Version: Monitorizar mysql (ayudaaadmeee por favor)
Hola! estoy convencido de que hay algo en uno de mis foros que los ralentiza de una manera desesperante... ¿por qué digo esto? pues porque en un momento dado el foro vuela literalmente, y al cabo de un minuto sin motivo aparente, se hace leeeeeeeento... luego al ratito de nuevo perfecto... parece evidente que hay una consulta o programa que lo ralentiza... pero no doy con ello
¿seríais tan amables de ayudarme a averiguar el origen del problema? el comando top no muestra nada... el log de mysql tampoco
algun otro log que me pueda orientar? algun programa que pueda instalar?
os estaría eternamente agradecido!
¿seríais tan amables de ayudarme a averiguar el origen del problema? el comando top no muestra nada... el log de mysql tampoco
algun otro log que me pueda orientar? algun programa que pueda instalar?
os estaría eternamente agradecido!
Buscat mysqltop te aydará a ver los procesos activos.
Instala estos dos modulos antes de mytop (por lo gral no es necesario y las versiones no estan actualizadas por si quieres buscar alguna nueva).
Install TermReadKey:
cd /usr/local/src
wget http://search.cpan.org/CPAN/authors/id/J/J...Key-2.30.tar.gz
tar -zxf TermReadKey-2.30.tar.gz
cd TermRead*
perl Makefile.PL
make test
make
make install
cd ..
Now install DBI:
wget http://search.cpan.org/CPAN/authors/id/T/T...DBI-1.48.tar.gz
tar -zxf DBI-1.48.tar.gz
cd DBI*
perl Makefile.PL
make test
make
make install
cd ..
Finally install mytop:
wget http://jeremy.zawodny.com/mysql/mytop/mytop-1.4.tar.gz
tar -zxf mytop-1.4.tar.gz
cd mytop*
perl Makefile.PL
make test
make
make install
Ahora solo ejectua mytop y listo!
Texto de eth0.us lo puedes ver en ingles dando click aquÃ
Install TermReadKey:
cd /usr/local/src
wget http://search.cpan.org/CPAN/authors/id/J/J...Key-2.30.tar.gz
tar -zxf TermReadKey-2.30.tar.gz
cd TermRead*
perl Makefile.PL
make test
make
make install
cd ..
Now install DBI:
wget http://search.cpan.org/CPAN/authors/id/T/T...DBI-1.48.tar.gz
tar -zxf DBI-1.48.tar.gz
cd DBI*
perl Makefile.PL
make test
make
make install
cd ..
Finally install mytop:
wget http://jeremy.zawodny.com/mysql/mytop/mytop-1.4.tar.gz
tar -zxf mytop-1.4.tar.gz
cd mytop*
perl Makefile.PL
make test
make
make install
Ahora solo ejectua mytop y listo!
Texto de eth0.us lo puedes ver en ingles dando click aquÃ
QUOTE (fusionado @ Aug 27 2008, 03:43 AM) 
Instala estos dos modulos antes de mytop (por lo gral no es necesario y las versiones no estan actualizadas por si quieres buscar alguna nueva).
Install TermReadKey:
cd /usr/local/src
wget http://search.cpan.org/CPAN/authors/id/J/J...Key-2.30.tar.gz
tar -zxf TermReadKey-2.30.tar.gz
cd TermRead*
perl Makefile.PL
make test
make
make install
cd ..
Now install DBI:
wget http://search.cpan.org/CPAN/authors/id/T/T...DBI-1.48.tar.gz
tar -zxf DBI-1.48.tar.gz
cd DBI*
perl Makefile.PL
make test
make
make install
cd ..
Finally install mytop:
wget http://jeremy.zawodny.com/mysql/mytop/mytop-1.4.tar.gz
tar -zxf mytop-1.4.tar.gz
cd mytop*
perl Makefile.PL
make test
make
make install
Ahora solo ejectua mytop y listo!
Texto de eth0.us lo puedes ver en ingles dando click aquÃ
Install TermReadKey:
cd /usr/local/src
wget http://search.cpan.org/CPAN/authors/id/J/J...Key-2.30.tar.gz
tar -zxf TermReadKey-2.30.tar.gz
cd TermRead*
perl Makefile.PL
make test
make
make install
cd ..
Now install DBI:
wget http://search.cpan.org/CPAN/authors/id/T/T...DBI-1.48.tar.gz
tar -zxf DBI-1.48.tar.gz
cd DBI*
perl Makefile.PL
make test
make
make install
cd ..
Finally install mytop:
wget http://jeremy.zawodny.com/mysql/mytop/mytop-1.4.tar.gz
tar -zxf mytop-1.4.tar.gz
cd mytop*
perl Makefile.PL
make test
make
make install
Ahora solo ejectua mytop y listo!
Texto de eth0.us lo puedes ver en ingles dando click aquÃ
gracias amigo, acabo de instalarlo! veamos el resultado
QUOTE (jorge_kai @ Aug 27 2008, 10:27 PM)
gracias amigo, acabo de instalarlo! veamos el resultado
ayer instalé un programa similar (ajaxmytop) y hace aproximadamente 30 minutos el server quedó saturado... esto es lo que pude sacar con este programa... pasó de tener 5 o 6 entradas en mytop a tener decenas de golpe
utilizo vbulletin v7.3CODE
? - display this section; k - kill a thread; s - change interval; d - filter by database; h - filter by host; u - filter by user; c - filter by command; i - toggle idle threads; space - clear filters
Seconds Interval
Id
User
Host
db
Command
Time
State
Info
804335
htcmania
localhost
htcmania
Query
0
Opening tables
SELECT * FROM session WHERE sessionhash = '61b5ac1dc6d1c7ed0c996db7bfa71eff' AND lastac
804349
htcmania
localhost
htcmania
Query
0
Opening tables
SELECT * FROM session WHERE sessionhash = '9772bff3c8dae55f5bef97dad2bd67b7' AND lastac
804376
htcmania
localhost
htcmania
Query
0
Opening tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804382
htcmania
localhost
htcmania
Query
0
Opening tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804384
htcmania
localhost
htcmania
Query
0
Opening tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804390
htcmania
localhost
htcmania
Query
0
Opening tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804405
htcmania
localhost
htcmania
Query
0
Opening tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804407
htcmania
localhost
htcmania
Query
0
Opening tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804409
htcmania
localhost
htcmania
Query
0
Opening tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804410
htcmania
localhost
htcmania
Query
0
804411
htcmania
localhost
htcmania
Query
0
804412
htcmania
localhost
htcmania
Query
0
Opening tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804413
htcmania
localhost
htcmania
Query
0
804420
htcmania
localhost
htcmania
Query
0
Opening tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804425
htcmania
localhost
htcmania
Query
0
Opening tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804426
htcmania
localhost
htcmania
Query
0
Opening tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804427
htcmania
localhost
htcmania
Query
0
Opening tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804430
htcmania
localhost
htcmania
Query
0
Opening tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804092
htcmania
localhost
htcmania
Query
1
Opening tables
SELECT forumid, moderatorid, permissions, permissions2 FROM moderator WHERE userid = 14642 A
804111
htcmania
localhost
htcmania
Query
1
Opening tables
SELECT thread.threadid, thread.lastpost, thread.lastposter, thread.lastpostid, replycount, IF(vi
804112
htcmania
localhost
htcmania
Query
1
Opening tables
SELECT user.avatarid, user.avatarrevision, avatarpath, NOT ISNULL(customavatar.userid) AS hascustom,
804115
htcmania
localhost
htcmania
Query
1
Opening tables
SELECT thread.forumid, thread.firstpostid, thread.lastpost,
804124
htcmania
localhost
htcmania
Query
1
Opening tables
(SELECT permissions, permissions2, FIND_IN_SET(forumid, '41,35,1,-1') AS pos, forumid FROM modera
804128
htcmania
localhost
htcmania
Query
1
Opening tables
SELECT * FROM `ctms_messages` WHERE `userid`='26131' ORDER BY `timestamp` ASC
804331
htcmania
localhost
htcmania
Query
1
Opening tables
SELECT * FROM session WHERE sessionhash = 'f63d77e268df169d46315038a673c2e5' AND lastac
804332
htcmania
localhost
htcmania
Query
1
Opening tables
SELECT * FROM session WHERE sessionhash = '00af49ef95a2b34ef53eab215c319c69' AND lastac
804352
htcmania
localhost
htcmania
Query
1
Opening tables
SELECT * FROM session WHERE sessionhash = 'c3196c65b9d03d9945bb3b78c8c3984e' AND lastac
804403
htcmania
localhost
htcmania
Query
1
Opening tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804404
htcmania
localhost
htcmania
Query
1
Opening tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804415
htcmania
localhost
htcmania
Query
1
Opening tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804419
htcmania
localhost
htcmania
Query
1
Opening tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804285
htcmania
localhost
htcmania
Query
2
Opening tables
SELECT * FROM session WHERE sessionhash = 'c7aad2c32dfa11c7484bac6e8441e378' AND lastac
804318
htcmania
localhost
htcmania
Query
2
Opening tables
SELECT * FROM session WHERE userid = 0 AND host = '89.131.15.174' AND idhash = '41
804321
htcmania
localhost
htcmania
Query
2
Opening tables
SELECT * FROM session WHERE sessionhash = 'b1ae94600ab6f4ad711bd1dabda2b241' AND lastac
804353
htcmania
localhost
htcmania
Query
2
Opening tables
SELECT languageid, phrasegroup_global AS phrasegroup_global, phrasegroup_postbit AS phrasegrou
804375
htcmania
localhost
Query
2
show processlist
804380
htcmania
localhost
htcmania
Query
2
Opening tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804385
htcmania
localhost
htcmania
Query
2
Opening tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804386
htcmania
localhost
htcmania
Query
2
Opening tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804108
htcmania
localhost
htcmania
Query
3
Opening tables
SELECT post.*, IF(post.userid = 0, post.username, user.username) AS username FROM post AS post L
804233
htcmania
localhost
htcmania
Query
3
Opening tables
SELECT * FROM `ctms_messages` WHERE `userid`='0' ORDER BY `timestamp` ASC
804294
htcmania
localhost
htcmania
Query
3
Opening tables
SELECT * FROM session WHERE sessionhash = '746c4bf1d4f2a6608d6f76f9750fd5ce' AND lastac
804298
htcmania
localhost
htcmania
Query
3
Opening tables
SELECT * FROM session WHERE userid = 0 AND host = '89.140.94.67' AND idhash = 'fd5
804309
htcmania
localhost
htcmania
Query
3
Opening tables
SELECT * FROM session WHERE userid = 0 AND host = '84.123.215.254' AND idhash = '5
804372
htcmania
localhost
htcmania
Query
3
Opening tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804373
htcmania
localhost
htcmania
Query
3
Opening tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804377
htcmania
localhost
htcmania
Query
3
Opening tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804381
htcmania
localhost
htcmania
Query
3
Opening tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804399
htcmania
localhost
htcmania
Query
3
Opening tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804401
htcmania
localhost
htcmania
Query
3
Opening tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804269
htcmania
localhost
htcmania
Query
7
Opening tables
SELECT * FROM session WHERE sessionhash = '7854d340e676619ff1a1253722aee5b3' AND lastac
804281
htcmania
localhost
htcmania
Query
7
Opening tables
SELECT * FROM session WHERE sessionhash = 'e70d541f2d0d49d440f9a4c540f4b284' AND lastac
804141
htcmania
localhost
htcmania
Query
11
Opening tables
SELECT threadid FROM thread as thread WHERE thread.forumid NOT IN (0,34,39) and t
804396
htcmania
localhost
htcmania
Query
11
Opening tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804182
htcmania
localhost
htcmania
Query
13
Opening tables
SELECT * FROM session WHERE sessionhash = '84a2044285492ba0b595353116f65191' AND lastac
804217
htcmania
localhost
htcmania
Query
13
Opening tables
SELECT title, template FROM template WHERE templateid IN (1201,1210,0,1213,1214,1213,1214,0,32
804270
htcmania
localhost
htcmania
Query
13
Opening tables
SELECT * FROM session WHERE sessionhash = 'e70d541f2d0d49d440f9a4c540f4b284' AND lastac
804286
htcmania
localhost
htcmania
Query
13
Opening tables
SELECT * FROM session WHERE sessionhash = 'afcbc7b877a5f0e1405078abd367b734' AND lastac
804290
htcmania
localhost
htcmania
Query
13
Opening tables
SELECT * FROM session WHERE sessionhash = '6fa4f5e40d4f31626a328d9964bd491f' AND lastac
804300
htcmania
localhost
htcmania
Query
13
Opening tables
SELECT * FROM session WHERE sessionhash = '5ea8798f4adb14bf3f2a1422129cd952' AND lastac
804333
htcmania
localhost
htcmania
Query
13
Opening tables
SELECT * FROM session WHERE sessionhash = 'c7af159862b9cb954909361e37181ae3' AND lastac
804338
htcmania
localhost
htcmania
Query
13
Opening tables
SELECT * FROM session WHERE sessionhash = 'a3fdff0d4daa400d5da67de41e83f15d' AND lastac
804357
htcmania
localhost
htcmania
Query
13
Opening tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804361
htcmania
localhost
htcmania
Query
13
closing tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804364
htcmania
localhost
htcmania
Query
13
closing tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804365
htcmania
localhost
htcmania
Query
13
Opening tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804107
htcmania
localhost
htcmania
Query
14
Opening tables
SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, reply
804123
htcmania
localhost
htcmania
Query
14
closing tables
SHOW TABLES
804340
htcmania
localhost
htcmania
Query
14
Opening tables
SELECT * FROM session WHERE sessionhash = '5ea8798f4adb14bf3f2a1422129cd952' AND lastac
804398
htcmania
localhost
htcmania
Query
14
Opening tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804292
htcmania
localhost
htcmania
Query
15
Opening tables
SELECT * FROM session WHERE sessionhash = 'f63d77e268df169d46315038a673c2e5' AND lastac
804293
htcmania
localhost
htcmania
Query
15
Opening tables
SELECT * FROM session WHERE sessionhash = 'ae3c0f8c51edc115349e101161e857d0' AND lastac
804302
htcmania
localhost
htcmania
Query
15
Locked
SELECT * FROM session WHERE sessionhash = 'b6c9da55828cf5d6c97fc98e61c3aac5' AND lastac
804378
htcmania
localhost
htcmania
Query
15
closing tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804389
htcmania
localhost
htcmania
Query
15
closing tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804392
htcmania
localhost
htcmania
Query
15
closing tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804393
htcmania
localhost
htcmania
Query
15
closing tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804109
htcmania
localhost
htcmania
Query
16
Locked
UPDATE session SET lastactivity = 1219874212 WHERE sessionhash = 'd3b8cebd7f882523d285c50e
804114
htcmania
localhost
htcmania
Query
16
closing tables
SELECT * FROM `ctms_messages` WHERE `userid`='17135' ORDER BY `timestamp` ASC
804137
htcmania
localhost
htcmania
Query
16
closing tables
SHOW TABLES
804162
htcmania
localhost
htcmania
Query
16
Opening tables
SELECT cron.* FROM cron AS cron LEFT JOIN product AS product ON (cron.product = product.produc
804241
htcmania
localhost
htcmania
Query
16
Locked
SELECT * FROM session WHERE sessionhash = '55e0e3cf3126dffd4c38a1394fd28ef3' AND lastac
804325
htcmania
localhost
htcmania
Query
16
Opening tables
SELECT * FROM session WHERE sessionhash = 'fc8fb1b8e2388907d08a4a1f82e18c5c' AND lastac
804383
htcmania
localhost
htcmania
Query
16
closing tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804387
htcmania
localhost
htcmania
Query
16
closing tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804388
htcmania
localhost
htcmania
Query
16
closing tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804394
htcmania
localhost
htcmania
Query
16
closing tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804358
htcmania
localhost
htcmania
Query
17
Opening tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804366
htcmania
localhost
htcmania
Query
19
closing tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804173
htcmania
localhost
htcmania
Query
20
Opening tables
SELECT user.username, (user.options & 512) AS invisible, user.usergroupid, session.userid, ses
804262
htcmania
localhost
htcmania
Query
22
Locked
SELECT * FROM session WHERE sessionhash = '066a031267d53f9c2f11494fe5ff801e' AND lastac
804283
htcmania
localhost
htcmania
Query
22
Opening tables
SELECT * FROM session WHERE userid = 0 AND host = '83.52.255.58' AND idhash = '891
804319
htcmania
localhost
htcmania
Query
22
Locked
SELECT * FROM session WHERE sessionhash = 'dee4061c28e62f9a9b67a269ddfa4896' AND lastac
804359
htcmania
localhost
htcmania
Query
22
closing tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804278
htcmania
localhost
htcmania
Query
31
Locked
SELECT * FROM session WHERE sessionhash = 'e5e7273b2a577b318d0688f7d99930f4' AND lastac
804313
htcmania
localhost
htcmania
Query
31
Locked
SELECT * FROM session WHERE sessionhash = '420f859e0bcd477065f077792f2bf2eb' AND lastac
804354
htcmania
localhost
htcmania
Query
31
closing tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804347
htcmania
localhost
htcmania
Query
32
closing tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804348
htcmania
localhost
htcmania
Query
32
closing tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804350
htcmania
localhost
htcmania
Query
32
Opening tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804073
htcmania
localhost
htcmania
Query
33
Locked
UPDATE session SET lastactivity = 1219874210, location = '/showthread.php?t=7144', incalendar =
804307
htcmania
localhost
htcmania
Query
33
Locked
SELECT * FROM session WHERE sessionhash = 'b6922597d027ac649d6ad810aaaa0fc8' AND lastac
804342
htcmania
localhost
htcmania
Query
34
closing tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804299
htcmania
localhost
htcmania
Query
35
Locked
SELECT * FROM session WHERE userid = 0 AND host = '84.77.255.129' AND idhash = '14
804266
htcmania
localhost
htcmania
Query
37
Locked
SELECT * FROM session WHERE sessionhash = '679c5fe382744631df1a22ef0d0263fa' AND lastac
804271
htcmania
localhost
htcmania
Query
37
Locked
SELECT * FROM session WHERE userid = 0 AND host = '83.52.255.58' AND idhash = '891
804291
htcmania
localhost
htcmania
Query
37
Locked
SELECT * FROM session WHERE sessionhash = 'ae3c0f8c51edc115349e101161e857d0' AND lastac
804295
htcmania
localhost
htcmania
Query
37
Locked
SELECT * FROM session WHERE sessionhash = 'd7eb8be44d5e6fce3a2380e83515b8c1' AND lastac
804284
htcmania
localhost
htcmania
Query
38
Locked
SELECT * FROM session WHERE sessionhash = 'e70d541f2d0d49d440f9a4c540f4b284' AND lastac
804328
htcmania
localhost
htcmania
Query
38
closing tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804263
htcmania
localhost
htcmania
Query
39
Locked
SELECT * FROM session WHERE sessionhash = '5d7c167e062d84ce917c87f3c3da6a82' AND lastac
804323
htcmania
localhost
htcmania
Query
39
closing tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804275
htcmania
localhost
htcmania
Query
41
Locked
SELECT * FROM session WHERE sessionhash = 'c6547782d03bb73a3a6da2ab52e665b4' AND lastac
804277
htcmania
localhost
htcmania
Query
41
Locked
SELECT * FROM session WHERE sessionhash = '97b8378328809489130129180d8a3973' AND lastac
804279
htcmania
localhost
htcmania
Query
41
Locked
SELECT * FROM session WHERE sessionhash = 'a8c72f7c8d3cba5b539e7b862ae49e06' AND lastac
804280
htcmania
localhost
htcmania
Query
41
Locked
SELECT userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, IF
804314
htcmania
localhost
htcmania
Query
41
closing tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804316
htcmania
localhost
htcmania
Query
41
closing tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','pluginlist')
804093
htcmania
localhost
htcmania
Query
42
closing tables
SELECT text, languageid, special FROM phrase AS phrase LEFT JOIN phrasetype USING (fieldname)
804311
htcmania
localhost
htcmania
Query
42
closing tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804306
htcmania
localhost
htcmania
Query
44
closing tables
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache
804105
htcmania
localhost
htcmania
Query
45
Locked
UPDATE session SET newposts = '4' WHERE userid = 26971
804252
htcmania
localhost
htcmania
Query
45
Locked
SELECT * FROM session WHERE sessionhash = '7291a2a465ce490f02806457ad1b78c1' AND lastac
804254
htcmania
localhost
htcmania
Query
45
Locked
SELECT * FROM session WHERE sessionhash = 'f13cd7149b1ad434cf0597b2fca59b18' AND lastac
804255
htcmania
localhost
htcmania
Query
45
Locked
SELECT * FROM session WHERE sessionhash = '2a30c96d2f367b9380ab8d918e137b5d' AND lastac
804256
htcmania
localhost
htcmania
Query
45
Locked
SELECT * FROM session WHERE userid = 0 AND host = '91.117.247.34' AND idhash = 'bb
804199
htcmania
localhost
htcmania
Query
46
Locked
SELECT * FROM session WHERE userid = 0 AND host = '66.249.71.246' AND idhash = 'b7
804208
htcmania
localhost
htcmania
Query
46
Locked
SELECT * FROM session WHERE sessionhash = '1ad9817dec9ab54f07d9a89bfc61ace1' AND lastac
804226
htcmania
localhost
htcmania
Query
46
Locked
SELECT * FROM session WHERE sessionhash = '12c9966fe3bc1fd6294e766d4ab4cf94' AND lastac
804231
htcmania
localhost
htcmania
Query
46
Locked
SELECT * FROM session WHERE userid = 0 AND host = '62.87.93.78' AND idhash = 'b2d0
804218
htcmania
localhost
htcmania
Query
48
Locked
SELECT * FROM session WHERE sessionhash = '2a30c96d2f367b9380ab8d918e137b5d' AND lastac
804220
htcmania
localhost
htcmania
Query
48
Locked
SELECT * FROM session WHERE sessionhash = '034123fa737557f192c74eb909471f02' AND lastac
804229
htcmania
localhost
htcmania
Query
48
Locked
SELECT * FROM session WHERE sessionhash = '81c8cfe524c8dc7398593a3f9153bf72' AND lastac
804261
htcmania
localhost
htcmania
Query
49
Locked
SELECT * FROM session WHERE sessionhash = '7421968f42d5425ddf48ac22ddf6f547' AND lastac
804264
htcmania
localhost
htcmania
Query
49
Locked
SELECT userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, IF
803943
htcmania
localhost
htcmania
Query
50
Locked
UPDATE user SET posts = posts + 1, usertitle = 'Junior Member', lastpost = 1219874195, lastp
804035
htcmania
localhost
htcmania
Query
50
Locked
UPDATE session SET lastactivity = 1219874206, inforum = 0, inthread = 0, incalendar = 0, badloc
804101
htcmania
localhost
htcmania
Query
50
Locked
SELECT announcement.announcementid, startdate, title, announcement.views, user.username, user.
804166
htcmania
localhost
htcmania
Query
50
Locked
SELECT * FROM session WHERE sessionhash = 'a0aa02d438f23bf2a95308738e50ec10' AND lastac
804169
htcmania
localhost
htcmania
Query
50
Locked
SELECT * FROM session WHERE sessionhash = '90ce083facb78712129286df695fbb8a' AND lastac
804171
htcmania
localhost
htcmania
Query
50
Locked
SELECT * FROM session WHERE sessionhash = '4888c73923fe64ce32e13e5a57a0b609' AND lastac
804172
htcmania
localhost
htcmania
Query
50
Locked
SELECT * FROM session WHERE sessionhash = 'afcbc7b877a5f0e1405078abd367b734' AND lastac
804176
htcmania
localhost
htcmania
Query
50
Locked
SELECT * FROM session WHERE sessionhash = '37b66ee659af60ed1a3778fd1c215627' AND lastac
804193
htcmania
localhost
htcmania
Query
50
Locked
SELECT * FROM session WHERE userid = 0 AND host = '91.117.247.34' AND idhash = 'bb
804194
htcmania
localhost
htcmania
Query
50
Locked
SELECT * FROM session WHERE sessionhash = 'a7e9a37ab1e0e420b7c5b0315d28c8db' AND lastac
804198
htcmania
localhost
htcmania
Query
50
Locked
SELECT * FROM session WHERE userid = 0 AND host = '66.249.90.136' AND idhash = '91
804202
htcmania
localhost
htcmania
Query
50
Locked
SELECT * FROM session WHERE sessionhash = 'fbe9e55a90e4a564848c3744b85e0a9c' AND lastac
804203
htcmania
localhost
htcmania
Query
50
Locked
SELECT * FROM session WHERE sessionhash = '81c8cfe524c8dc7398593a3f9153bf72' AND lastac
804204
htcmania
localhost
htcmania
Query
50
Locked
SELECT * FROM session WHERE sessionhash = '55fa05a2db607c784a06dc7f73a334b1' AND lastac
804209
htcmania
localhost
htcmania
Query
50
Locked
SELECT * FROM session WHERE sessionhash = '746c4bf1d4f2a6608d6f76f9750fd5ce' AND lastac
804234
htcmania
localhost
htcmania
Query
50
Locked
SELECT * FROM session WHERE sessionhash = '5ea8798f4adb14bf3f2a1422129cd952' AND lastac
804235
htcmania
localhost
htcmania
Query
50
Locked
SELECT * FROM session WHERE sessionhash = '54c8ec08057b04b2b781035438956f98' AND lastac
804240
htcmania
localhost
htcmania
Query
50
Locked
SELECT * FROM session WHERE sessionhash = 'c6547782d03bb73a3a6da2ab52e665b4' AND lastac
804246
htcmania
localhost
htcmania
Query
50
Locked
SELECT * FROM session WHERE sessionhash = 'ae3c0f8c51edc115349e101161e857d0' AND lastac
804247
htcmania
localhost
htcmania
Query
50
Locked
SELECT * FROM session WHERE sessionhash = '8bf5ab8f7ce1dd93663a73ee9e626bb6' AND lastac
804251
htcmania
localhost
htcmania
Query
50
Locked
SELECT * FROM session WHERE sessionhash = 'e70d541f2d0d49d440f9a4c540f4b284' AND lastac
804224
htcmania
localhost
htcmania
Query
52
Locked
SELECT * FROM session WHERE sessionhash = 'e7e6ac4d9b52d5969ab0a5634e781864' AND lastac
804225
htcmania
localhost
htcmania
Query
52
Locked
SELECT * FROM session WHERE sessionhash = '8bb8e0f8070538cb93ce8933f06fc482' AND lastac
804228
htcmania
localhost
htcmania
Query
52
Locked
SELECT * FROM session WHERE sessionhash = '9db1e5e3286db6a0877ce863a4bf405c' AND lastac
804230
htcmania
localhost
htcmania
Query
52
Locked
SELECT * FROM session WHERE sessionhash = 'e70d541f2d0d49d440f9a4c540f4b284' AND lastac
804089
htcmania
localhost
htcmania
Query
53
Locked
UPDATE session SET lastactivity = 1219874211, location = '/private.php?do=showpm&pmid=48851
804155
htcmania
localhost
htcmania
Query
53
Locked
SELECT * FROM session WHERE sessionhash = '339cb1395db75865f7a670e300b0a802' AND lastac
804219
htcmania
localhost
htcmania
Query
53
Locked
SELECT * FROM session WHERE sessionhash = '5d1b556e3329c0ad92f1a3da2169ce1e' AND lastac
804221
htcmania
localhost
htcmania
Query
53
Locked
SELECT * FROM session WHERE sessionhash = '9d9ad099cb6b6eebdbeae8880b305d25' AND lastac
804133
htcmania
localhost
htcmania
Query
54
Locked
SELECT * FROM session WHERE sessionhash = '2338379d62291047651d3b0bae8a8c3a' AND lastac
804106
htcmania
localhost
htcmania
Query
55
Locked
UPDATE session SET lastactivity = 1219874212, location = '/member.php?find=lastposter&t=246
804207
htcmania
localhost
htcmania
Query
55
Locked
SELECT * FROM session WHERE sessionhash = 'f0a080cde20ef63f36776df8f0138e01' AND lastac
804211
htcmania
localhost
htcmania
Query
55
Locked
SELECT * FROM session WHERE sessionhash = 'b98a704de7f45a6365790eb8946d7517' AND lastac
804214
htcmania
localhost
htcmania
Query
55
Locked
SELECT * FROM session WHERE userid = 0 AND host = '83.213.46.2' AND idhash = '0e2a
804215
htcmania
localhost
htcmania
Query
55
Locked
SELECT * FROM session WHERE sessionhash = 'e70d541f2d0d49d440f9a4c540f4b284' AND lastac
804216
htcmania
localhost
htcmania
Query
55
Locked
SELECT * FROM session WHERE sessionhash = 'afcbc7b877a5f0e1405078abd367b734' AND lastac
804177
htcmania
localhost
htcmania
Query
56
Locked
SELECT * FROM session WHERE sessionhash = '6ca8f4d4d4c6523b2131ffab2670ef7d' AND lastac
804178
htcmania
localhost
htcmania
Query
56
Locked
SELECT * FROM session WHERE sessionhash = 'a4c604e0a5b90d8bbfa16b86809e3e05' AND lastac
804200
htcmania
localhost
htcmania
Query
56
Locked
SELECT * FROM session WHERE sessionhash = '90ce083facb78712129286df695fbb8a' AND lastac
804245
htcmania
localhost
htcmania
Query
56
Locked
SELECT * FROM session WHERE sessionhash = 'b6c9da55828cf5d6c97fc98e61c3aac5' AND lastac
804129
htcmania
localhost
htcmania
Query
57
Locked
SELECT * FROM session WHERE userid = 0 AND host = '89.140.94.67' AND idhash = 'fd5
804140
htcmania
localhost
htcmania
Query
57
Locked
SELECT * FROM session WHERE userid = 0 AND host = '62.57.227.210' AND idhash = '90
804143
htcmania
localhost
htcmania
Query
57
Locked
SELECT * FROM session WHERE sessionhash = 'bcb37562f723b5c462577a8a5d106c2f' AND lastac
804170
htcmania
localhost
htcmania
Query
57
Locked
SELECT * FROM session WHERE sessionhash = '6fa4f5e40d4f31626a328d9964bd491f' AND lastac
804174
htcmania
localhost
htcmania
Query
57
Locked
SELECT * FROM session WHERE sessionhash = 'b1ae94600ab6f4ad711bd1dabda2b241' AND lastac
804179
htcmania
localhost
htcmania
Query
57
Locked
SELECT * FROM session WHERE sessionhash = 'e70d541f2d0d49d440f9a4c540f4b284' AND lastac
804195
htcmania
localhost
htcmania
Query
57
Locked
SELECT * FROM session WHERE sessionhash = 'f6b904ce72cf0caca5d6fa6d2ca1e481' AND lastac
804113
htcmania
localhost
htcmania
Query
58
Locked
SELECT * FROM session WHERE sessionhash = 'ce3aa3ccab8e91f94198aeb32624a1b1' AND lastac
804135
htcmania
localhost
htcmania
Query
58
Locked
SELECT * FROM session WHERE sessionhash = '0e6414dea9c9656f741864f8b834886e' AND lastac
804149
htcmania
localhost
htcmania
Query
61
Locked
SELECT * FROM session WHERE sessionhash = '1ad9817dec9ab54f07d9a89bfc61ace1' AND lastac
804156
htcmania
localhost
htcmania
Query
61
Locked
SELECT * FROM session WHERE sessionhash = '84a2044285492ba0b595353116f65191' AND lastac
804160
htcmania
localhost
htcmania
Query
61
Locked
SELECT * FROM session WHERE sessionhash = '746c4bf1d4f2a6608d6f76f9750fd5ce' AND lastac
804164
htcmania
localhost
htcmania
Query
61
Locked
SELECT * FROM session WHERE sessionhash = '25597fa9dcb1ae6909bb7b07bb4c2b6f' AND lastac
804132
htcmania
localhost
htcmania
Query
62
Locked
SELECT * FROM session WHERE sessionhash = 'ff011956c2413027ddcbbec2a8028b6f' AND lastac
804139
htcmania
localhost
htcmania
Query
62
Locked
SELECT * FROM session WHERE sessionhash = '5ab4faf5317aa97d292af83dec79d77b' AND lastac
804146
htcmania
localhost
htcmania
Query
62
Locked
SELECT * FROM session WHERE sessionhash = '26b4b39368750070b004b1faa6216acc' AND lastac
804147
htcmania
localhost
htcmania
Query
62
Locked
SELECT * FROM session WHERE sessionhash = '4fb25383290c6497110cfeec66a184f5' AND lastac
804148
htcmania
localhost
htcmania
Query
62
Locked
SELECT * FROM session WHERE sessionhash = '2933de3d6105d14ae17858c87bf4e4ae' AND lastac
804150
htcmania
localhost
htcmania
Query
62
Locked
SELECT * FROM session WHERE sessionhash = '13fb1ecd2e416e4e69b1d2f9c908cc65' AND lastac
804154
htcmania
localhost
htcmania
Query
62
Locked
SELECT * FROM session WHERE sessionhash = '0e6414dea9c9656f741864f8b834886e' AND lastac
804157
htcmania
localhost
htcmania
Query
62
Locked
SELECT * FROM session WHERE sessionhash = 'd1e801f8cb2c0361cdc76735ddce2b31' AND lastac
804158
htcmania
localhost
htcmania
Query
62
Locked
SELECT * FROM session WHERE sessionhash = '60065c0e03145ef2849cd644e442f14f' AND lastac
804159
htcmania
localhost
htcmania
Query
62
Locked
SELECT * FROM session WHERE sessionhash = 'e4f36212624e8065b2eb14c31c00c106' AND lastac
804163
htcmania
localhost
htcmania
Query
62
Locked
SELECT * FROM session WHERE sessionhash = '61ae6d481008d28ed7a61999ad36f304' AND lastac
804151
htcmania
localhost
htcmania
Query
64
Locked
SELECT * FROM session WHERE sessionhash = '51d98257c8b99ae691192bdaa9b6bd4f' AND lastac
804152
htcmania
localhost
htcmania
Query
64
Locked
SELECT * FROM session WHERE sessionhash = '798a11f3233b8c7cd52369e86004927e' AND lastac
804153
htcmania
localhost
htcmania
Query
64
Locked
SELECT * FROM session WHERE sessionhash = '716453e84344b67249e955668632ae95' AND lastac
804168
htcmania
localhost
htcmania
Query
64
Locked
SELECT * FROM session WHERE sessionhash = '6d0a29b5bdd6841600d07fddb90414c8' AND lastac
804175
htcmania
localhost
htcmania
Query
64
Locked
SELECT * FROM session WHERE sessionhash = '5ab4faf5317aa97d292af83dec79d77b' AND lastac
804096
htcmania
localhost
htcmania
Query
66
Locked
UPDATE session SET lastactivity = 1219874211, location = '/local_links.php?catid=23', useragent
804119
htcmania
localhost
htcmania
Query
66
Locked
SELECT * FROM session WHERE sessionhash = 'c7aad2c32dfa11c7484bac6e8441e378' AND lastac
804121
htcmania
localhost
htcmania
Query
66
Locked
SELECT * FROM session WHERE sessionhash = 'b83dd1f29335f0d12cd1edfe2df246f0' AND lastac
804144
htcmania
localhost
htcmania
Query
66
Locked
SELECT * FROM session WHERE sessionhash = '3df95ba66bc605a8b6f07d46afa936e4' AND lastac
804088
htcmania
localhost
htcmania
Query
73
Copying to tmp table
SELECT session.userid, session.host, session.useragent, avatarpath, NOT ISNULL(customavatar.filedata
804086
htcmania
localhost
htcmania
Query
91
UPDATE user SET lastactivity = 1219874210 WHERE userid = 20441
Probablemente necesitas reconfigurar el MySQL y tambien revisar la tabla de sesiones, aunque sería bueno que hicieras una optimización general de las tablas, puedes usar el MyPHPAdmin para hacerlo.
Cuantos registros y tamaño tiene las tablas?
Cuantos registros y tamaño tiene las tablas?
Herramientas:
MySQLTuner
mysqlreport
[hr]
Perl Script
http://mysqltuner.com/mysqltuner.pl
Features:
* Memory Usage: Calculates MySQL memory usage at max load and makes recommendations for increasing or decreasing the MySQL memory footprint. Per-thread and server-wide buffer data is calculated separately for an accurate snapshot of the server’s configuration.
* Slow Queries: Reviews the amount of slow queries relative to the total queries. Slow query time limits are also analyzed and recommendations are made.
* Connections: Current and historical connection counts are reviewed.
* Key Buffer: Takes configuration data and compares it to the actual indexes found in MyISAM tables. Key cache hit rates are calculated and variable adjustments are suggested.
* Query Cache: Query cache hit rates and usage percentages are used to make recommendations for the query cache configuration variables.
* Sorting & Joins: Per-thread buffers that affect sorts and joins are reviewed along with the statistics from the queries run against the server.
* Temporary Tables: Variable recommendations are made to reduce temporary tables that are written to the disk.
* Table Cache: Compares total tables opened to the currently open tables. Calculates the table cache hit rate in order to make suggestions.
* Open Files: Determines if the server will approach or run into the open file limit set by the operating system or the MySQL server itself.
* Table Locks: Finds table locking that forces queries to wait and makes suggestions for reducing locks that require a wait.
* Thread Cache: Calculates how many times MySQL must create a new thread to respond to a query.
* Aborted Connections: Finds applications that are not closing connections to MySQL properly.
* Read/Write Ratios: Calculates the percentage of read and write operations on your MySQL installation.
Usage:
# ./mysqltuner.pl --help
MySQLTuner 0.9.0 - MySQL High Performance Tuning Script
Bug reports, feature requests, and downloads at http://mysqltuner.com/
Maintained by Major Hayden (major@mhtx.net)
Important Usage Guidelines:
To run the script with the default options, run the script without arguments
Allow MySQL server to run for at least 24-48 hours before trusting suggestions
Some routines may require root level privileges (script will provide warnings)
Performance and Reporting Options
--skipsize Don't enumerate tables and their types/sizes
(Recommended for servers with many tables)
--skipversion Don't check for updates to MySQLTuner
Output Options:
--nogood Remove OK responses
--nobad Remove negative/suggestion responses
--noinfo Remove informational responses
--nocolor Don't print output in color
Here is a sample of the script’s output on a well optimized server:
>> MySQLTuner 0.9.0 - Major Hayden
>> Bug reports, feature requests, and downloads at http://mysqltuner.com/
>> Run with ‘–help’ for additional options and output filtering
——– General Statistics ————————————————–
[OK] You have the latest version of MySQLTuner
[OK] Currently running supported MySQL version 5.0.51a-log
[OK] Operating on 64-bit architecture
——– Storage Engine Statistics ——————————————-
[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 491M (Tables: 1424)
[--] Data in InnoDB tables: 9M (Tables: 151)
——– Performance Metrics ————————————————-
[--] Up for: 19d 16h 14m 3s (57M q [33.636 qps], 5M conn, TX: 185B, RX: 5B)
[--] Reads / Writes: 77% / 23%
[--] Total buffers: 2.7M per thread and 606.0M global
[OK] Maximum possible memory usage: 743.5M (37% of installed RAM)
[OK] Slow queries: 0% (81/57M)
[!!] Highest connection usage: 100% (51/50)
[OK] Key buffer size / total MyISAM indexes: 256.0M/210.9M
[OK] Key buffer hit rate: 99.3%
[OK] Query cache efficiency: 71.4%
[!!] Query cache prunes per day: 2752
[OK] Sorts requiring temporary tables: 0%
[OK] Temporary tables created on disk: 2%
[OK] Thread cache hit rate: 99%
[!!] Table cache hit rate: 2%
[OK] Open file limit used: 4%
[OK] Table locks acquired immediately: 99%
[OK] InnoDB data size / buffer pool: 9.8M/50.0M
——– Recommendations —————————————————–
General recommendations:
Reduce or eliminate persistent connections to reduce connection usage
Increase table_cache gradually to avoid file descriptor limits
Variables to adjust:
max_connections (> 50)
wait_timeout (< 15)
interactive_timeout (< 15)
query_cache_size (> 256M)
table_cache (> 4096)
[hr]
Descargar Perl Script
http://hackmysql.com/scripts/mysqlreport
http://tag1consulting.com/MySQL_Monitoring_and_Tuning
Fuente:
http://foro.elhacker.net/desarrollo_web/he...-t214396.0.html
MySQLTuner
mysqlreport
[hr]
QUOTE
MySQLTuner is a high-performance MySQL tuning script written in perl that will provide you with a snapshot of a MySQL server’s health. Based on the statistics gathered, specific recommendations will be provided that will increase a MySQL server’s efficiency and performance. The script gives you automated MySQL tuning that is on the level of what you would receive from a MySQL DBA.
Perl Script
http://mysqltuner.com/mysqltuner.pl
Features:
* Memory Usage: Calculates MySQL memory usage at max load and makes recommendations for increasing or decreasing the MySQL memory footprint. Per-thread and server-wide buffer data is calculated separately for an accurate snapshot of the server’s configuration.
* Slow Queries: Reviews the amount of slow queries relative to the total queries. Slow query time limits are also analyzed and recommendations are made.
* Connections: Current and historical connection counts are reviewed.
* Key Buffer: Takes configuration data and compares it to the actual indexes found in MyISAM tables. Key cache hit rates are calculated and variable adjustments are suggested.
* Query Cache: Query cache hit rates and usage percentages are used to make recommendations for the query cache configuration variables.
* Sorting & Joins: Per-thread buffers that affect sorts and joins are reviewed along with the statistics from the queries run against the server.
* Temporary Tables: Variable recommendations are made to reduce temporary tables that are written to the disk.
* Table Cache: Compares total tables opened to the currently open tables. Calculates the table cache hit rate in order to make suggestions.
* Open Files: Determines if the server will approach or run into the open file limit set by the operating system or the MySQL server itself.
* Table Locks: Finds table locking that forces queries to wait and makes suggestions for reducing locks that require a wait.
* Thread Cache: Calculates how many times MySQL must create a new thread to respond to a query.
* Aborted Connections: Finds applications that are not closing connections to MySQL properly.
* Read/Write Ratios: Calculates the percentage of read and write operations on your MySQL installation.
Usage:
# ./mysqltuner.pl --help
MySQLTuner 0.9.0 - MySQL High Performance Tuning Script
Bug reports, feature requests, and downloads at http://mysqltuner.com/
Maintained by Major Hayden (major@mhtx.net)
Important Usage Guidelines:
To run the script with the default options, run the script without arguments
Allow MySQL server to run for at least 24-48 hours before trusting suggestions
Some routines may require root level privileges (script will provide warnings)
Performance and Reporting Options
--skipsize Don't enumerate tables and their types/sizes
(Recommended for servers with many tables)
--skipversion Don't check for updates to MySQLTuner
Output Options:
--nogood Remove OK responses
--nobad Remove negative/suggestion responses
--noinfo Remove informational responses
--nocolor Don't print output in color
Here is a sample of the script’s output on a well optimized server:
>> MySQLTuner 0.9.0 - Major Hayden
>> Bug reports, feature requests, and downloads at http://mysqltuner.com/
>> Run with ‘–help’ for additional options and output filtering
——– General Statistics ————————————————–
[OK] You have the latest version of MySQLTuner
[OK] Currently running supported MySQL version 5.0.51a-log
[OK] Operating on 64-bit architecture
——– Storage Engine Statistics ——————————————-
[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 491M (Tables: 1424)
[--] Data in InnoDB tables: 9M (Tables: 151)
——– Performance Metrics ————————————————-
[--] Up for: 19d 16h 14m 3s (57M q [33.636 qps], 5M conn, TX: 185B, RX: 5B)
[--] Reads / Writes: 77% / 23%
[--] Total buffers: 2.7M per thread and 606.0M global
[OK] Maximum possible memory usage: 743.5M (37% of installed RAM)
[OK] Slow queries: 0% (81/57M)
[!!] Highest connection usage: 100% (51/50)
[OK] Key buffer size / total MyISAM indexes: 256.0M/210.9M
[OK] Key buffer hit rate: 99.3%
[OK] Query cache efficiency: 71.4%
[!!] Query cache prunes per day: 2752
[OK] Sorts requiring temporary tables: 0%
[OK] Temporary tables created on disk: 2%
[OK] Thread cache hit rate: 99%
[!!] Table cache hit rate: 2%
[OK] Open file limit used: 4%
[OK] Table locks acquired immediately: 99%
[OK] InnoDB data size / buffer pool: 9.8M/50.0M
——– Recommendations —————————————————–
General recommendations:
Reduce or eliminate persistent connections to reduce connection usage
Increase table_cache gradually to avoid file descriptor limits
Variables to adjust:
max_connections (> 50)
wait_timeout (< 15)
interactive_timeout (< 15)
query_cache_size (> 256M)
table_cache (> 4096)
[hr]
QUOTE
mysqlreport makes a friendly report of important MySQL status values. mysqlreport transforms the values from SHOW STATUS into an easy-to-read report that provides an in-depth understanding of how well MySQL is running. mysqlreport is a better alternative (and practically the only alternative) to manually interpreting SHOW STATUS.
Descargar Perl Script
http://hackmysql.com/scripts/mysqlreport
http://tag1consulting.com/MySQL_Monitoring_and_Tuning
Fuente:
http://foro.elhacker.net/desarrollo_web/he...-t214396.0.html
Juas, pero que bueno ver tanta ayuda, esperemos que el del problema nos informe como le fue para dar por cerrado este tema.
Saludos.
Saludos.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.