Better you create a PHP page that run "SHOW INNODB STATUS" :-)
Hope that will solve your problem.
Remigiusz Sokołowski wrote:
Ady Wicaksono wrote:
You should try
*SHOW INNODB STATUS \G;*
Remigiusz Soko?owski wrote:
Hi!
problem is not critical, however it would be nice to get some
workaround
from time to time I check innodb status - the most interesting
sections, I believe, are:
FILE I/O, INSERT BUFFER AND ADAPTIVE HASH INDEX, LOG, BUFFER POOL
AND MEMORY and ROW OPERATIONS
unfortunately they are at the bottom of whole report and that is
problem, because in one of databases I manage lock and transaction
info is so long, that other information is not displayed at all.
Any advice?
TIA
Remigiusz
that is, what I actually do - problem is in the returned report - it
has probably some limited size
here shortcut of what I get:
--------------------------------------------------------------------------------
*************************** 1. row ***************************
Status:
=====================================
050831 15:51:14 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 46 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 970202675, signal count 398405600
--Thread 4063170811 has waited at mem0pool.c line 334 for 0.00 seconds
the semaphore:
Mutex at 0x8508b0c created file mem0pool.c line 205, lock var 0
waiters flag 0
wait is ending
Mutex spin waits 3608862448, rounds 1320533442, OS waits 1902410973
RW-shared spins 276597184, OS waits 84173756; RW-excl spins 633297018,
OS waits 54606698
------------------------
LATEST DETECTED DEADLOCK
------------------------
050822 13:00:02
*** (1) TRANSACTION:
TRANSACTION 0 1759896686, ACTIVE 0 sec, process no 15919, OS thread id
3200827462 starting index read
mysql tables in use 4, locked 4
LOCK WAIT 866 lock struct(s), heap size 60736, undo log entries 270
MySQL thread id 235920701, query id 2425092039 front-1.rozrywka.srv
10.0.4.1 user_cron Sending data
/* Generowanie tabelki powiazan utwor_artysta skupiajacej w sobie dane
z kilku tabel, zawierajce zmiany utworow z ostatnich 20 minut.
Wykorzystywane do szybszego wyciagania informacji o danym utworze w
calym serwisie. */
REPLACE INTO utwor_artysta (arNazwa, arLicencja, arZnany, gaNazwa, utId,
utNaz
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 0 page no 44322 n bits 128 index `PRIMARY` of
table `wp_mp3/utwor_artysta` trx id 0 1759896686 lock_mode X locks rec
but not gap waiting
Record lock, heap no 52 PHYSICAL RECORD: n_fields 59; 1-byte offs
FALSE; info bits 0
0: len 4; hex 80000421; asc !;; 1: len 6; hex 000068e24004; asc h
@ ;; 2: len 7; hex 0000031ff33c5a; asc <Z;; 3: len 7; hex
735562634f6445; asc sUbcOdE;; 4: len 1; hex 03; asc ;; 5: len 1; hex
02; asc ;; 6: len 6; hex 5472616e6365; asc Trance;; 7: len 30; hex
31277374206772616465202d206561726c79206f6c642062726f6b656e20; asc 1'st
grade - early old broken ;...(truncated); 8: len 0; hex ; asc ;; 9:
len 0; hex ; asc ;; 10: len 1; hex 01; asc ;; 11: len 1; hex 01; asc
;; 12: len 1; hex 01; asc ;; 13: len 1; hex 01; asc ;; 14: len 1;
hex 02; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;; 17:
len 0; hex ; asc ;; 18: len 0; hex ; asc ;; 19: len 0; hex ; asc ;;
20: len 0; hex ; asc ;; 21: len 0; hex ; asc ;; 22: len 0; hex ; asc
;; 23: len 0; hex ; asc ;; 24: len 0; hex ; asc ;; 25: len 0; hex ;
asc ;; 26: len 0; hex ; asc ;; 27: len 0; hex ; asc ;; 28: len 0; hex
; asc ;; 29: len 0; hex ; asc ;; 30: len 5; hex 31333a3531; asc
13:51;; 31: len 2; hex 00a0; asc ;; 32: len 1; hex ff; asc ;; 33:
len 1; hex 00; asc ;; 34: len 1; hex 03; asc ;; 35: len 1; hex 02;
asc ;; 36: len 0; hex ; asc ;; 37: len 3; hex 803f79; asc ?y;; 38:
len 3; hex 0002bc; asc ;; 39: len 3; hex 000268; asc h;; 40: len
3; hex 00027d; asc };; 41: len 5; hex 2020312e30; asc 1.0;; 42:
len 3; hex 000001; asc ;; 43: len 2; hex 0000; asc ;; 44: len 8;
hex 80001230bb10f1d6; asc 0 ;; 45: len 8; hex 8000123c722153d5;
asc <r!S ;; 46: len 1; hex 00; asc ;; 47: len 2; hex 010e; asc
;; 48: len 2; hex 4535; asc E5;; 49: len 2; hex 0000; asc ;; 50: len
2; hex 0000; asc ;; 51: len 2; hex 04c4; asc ;; 52: len 8; hex
8000000000000000; asc ;; 53: len 2; hex 0000; asc ;; 54: SQL
NULL, size 8 ; 55: SQL NULL, size 8 ; 56: len 1; hex 01; asc ;; 57:
len 3; hex 800000; asc ;; 58: len 3; hex 800000; asc ;;
*** (2) TRANSACTION:
TRANSACTION 0 1759896728, ACTIVE 0 sec, process no 15916, OS thread id
3200815171 fetching rows, thread declared inside InnoDB 466
mysql tables in use 2, locked 2
32 lock struct(s), heap size 2496
MySQL thread id 235920640, query id 2425092110 front-1.rozrywka.srv
10.0.4.1 mp3 Sorting result
INSERT INTO temp_sg_najnowsze_utwory SELECT utId, utNazwa, arId,
arNazwa, gaNazwa, gaId, utMP3, utKeszSciagniecia,
DATE_FORMAT(utCzasDodania,"%Y-%m-%d") as utCzas FROM utwor_artysta
WHERE utStatus="zaakceptowany" AND utPublikacja_SG = 1 ORDER BY
utCzasDodania DESC, arNazwa LIMIT 14
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 0 page no 44322 n bits 128 index `PRIMARY` of
table `wp_mp3/utwor_artysta` trx id 0 1759896728 lock mode S
Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; 1-byte offs TRUE;
info bits 0
0: len 9; hex 73757072656d756d00; asc supremum ;;
Record lock, heap no 2 PHYSICAL RECORD: n_fields 59; 1-byte offs
FALSE; info bits 0
0: len 4; hex 800003ea; asc ;; 1: len 6; hex 000068debf6a; asc
h j;; 2: len 7; hex 0000031fea2c2c; asc ,,;; 3: len 8; hex
41706f7374617465; asc Apostate;; 4: len 1; hex 04; asc ;; 5: len 1;
hex 02; asc ;; 6: len 5; hex 4d6574616c; asc Metal;; 7: len 14; hex
476f646c79206c61756768746572; asc Godly laughter;; 8: len 0; hex ; asc
;; 9: len 0; hex ; asc ;; 10: len 1; hex 01; asc ;; 11: len 1; hex
01; asc ;; 12: len 1; hex 01; asc ;; 13: len 1; hex 01; asc ;; 14:
len 1; hex 02; asc ;; 15: len 0; hex ; asc ;; 16: len 0; hex ; asc ;;
17: len 0; hex ; asc ;; 18: len 0; hex ; asc ;; 19: len 0; hex ; asc
;; 20: len 0; hex ; asc ;; 21: len 0; hex ; asc ;; 22: len 0; hex ;
asc ;; 23: len 0; hex ; asc ;; 24: len 0; hex ; asc ;; 25: len 0; hex
; asc ;; 26: len 0; hex ; asc ;; 27: len 0; hex ; asc ;; 28: len 0;
hex ; asc ;; 29: len 0; hex ; asc ;; 30: len 5; hex 30363a3132; asc
06:12;; 31: len 2; hex 0080; asc ;; 32: len 1; hex ff; asc ;; 33:
len 1; hex 00; asc ;; 34: len 1; hex 03; asc ;; 35: len 1; hex 02;
asc ;; 36: len 0; hex ; asc ;; 37: len 3; hex 8016c0; asc ;; 38:
len 3; hex 0001ba; asc ;; 39: len 3; hex 000391; asc ;; 40: len
3; hex 001c69; asc i;; 41: len 5; hex 2020372e39; asc 7.9;; 42:
len 3; hex 000011; asc ;; 43: len 2; hex 0000; asc ;; 44: len 8;
hex 80001230b64bd0aa; asc 0 K ;; 45: len 8; hex 8000123c72214a74;
asc <r!Jt;; 46: len 1; hex 00; asc ;; 47: len 2; hex 0084; asc
;; 48: len 2; hex 4d20; asc M ;; 49: len 2; hex 0000; asc ;; 50: len
2; hex 0000; asc ;; 51: len 2; hex 0488; asc ;; 52: len 8; hex
8000000000000000; asc ;; 53: len 2; hex 0000; asc ;; 54: SQL
NULL, size 8 ; 55: SQL NULL, size 8 ; 56: len 1; hex 01; asc ;; 57:
len 3; hex 800000; asc ;; 58: len 3; hex 800000; asc ;;
:
:
:
and so on as in the last paragraph. Sections, I'm interested in, are
cut off
Regards
Remigiusz
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
