Download
Webboard

FAQ/





MySQL.RU - Webboard




Table_locks_waited = 54881041 (zhil) 25/08/2004 - 17:11:45
      Re: Sorry (zhil) 25/08/2004 - 17:12:51
      Re: (zhil) 25/08/2004 - 17:14:55
      Re: InnoDB (Marat_L) 26/08/2004 - 08:47:56



From: zhil - 25/08/2004 - 17:11:45
Subject:Table_locks_waited = 54881041
-----------------
Ҭ֬ ѬܬѬ Ҭܬ Ӭ٬߬ڬܬݬ
߬ Ѭ۬ ߬ݬѬ۬ ڬԬ ѬҬݬڬ ݬ٬ӬѬ֬ݬ֬ Ѭլ֬۬ڬ ֬߬ Ѭ ( Ѭެ ܬެ߬ Ѭ֬Ѭ 5-10 Ѭ ֬ܬ߬լ)
-٬ Ԭ (֬լݬجڬ֬ݬ߬) Ѭ۬ ߬Ѭڬ߬Ѭ֬ ڬ. լ߬ ج Ѭ߬ڬ ެج֬ ٬լѬӬѬ 0.007 ֬. ެج֬ 10 ֬ܬ߬. ֬ڬӬѬ ߬ Ѭ߬ڬѬ ߬ ڬݬ٬ڬ ѬҬݬڬ ݬ٬ӬѬ֬ݬ֬ - ܬ ݬڬѬ֬ ߬ Ҭݬ ֬ ߬ լ (0.02 - 0.2 ֬)Ѭܬݬܬ ߬ ڬ-٬ ݬܬ ѬҬݬڬ ݬ٬ӬѬ֬ݬ֬?

֬Ӭ֬ 4 ֬߬ P4 2.4 Ghz, 2 Gb DDR
֬Ӭ֬ Ѭܬڬ֬ܬ ݬ߬ ڬԬ. (ڬ ֬ Ѭ Ѭ۬ ެ֬߬ ֬Ѭ֬ެ).

ܬѬܬڬ ֬֬ެ֬߬߬ Ѭڬڬܬ
Uptime 681638
Questions 278515267
Com_update 36003636
Com_select 64948509
Com_lock_tables 59783
Com_insert 266733
Com_delete 57469
Com_change_db 21851041
Table_locks_waited 54881041
Table_locks_immediate 49577019
----------
ѬҬݬڬ ٬֬
Format fixed
Rows 109,777
Row length 1,214
Row size 1,294 Bytes
Data 130,146 KB
Index 8,563 KB
Total 138,709 KB
----------
٬߬ڬܬݬ Ѭ ڬլ֬ ڬެڬ٬Ѭڬ, ܬ ߬ڬ ެج֬ ܬѬ٬Ѭ.
1. Ѭ٬Ҭڬ users ߬ ܬ ѬҬݬڬ լ߬٬߬Ѭ߬ެ ڬ٬߬Ѭܬ (߬Ѭڬެ֬ ֬Ӭެ ڬެӬݬ ݬԬڬ߬)
2. ٬լѬ ѬҬݬڬ, ܬ ֬֬Ҭڬ Ӭ ݬ ڬ ѬҬݬڬ ݬ٬ӬѬ֬ݬ֬, ܬ ߬ѬڬҬݬ֬ Ѭ ڬݬ٬ ٬Ѭܬڬ߬ ѬҬݬڬ heap. ެ֬֬ ݬ ެ ѬҬݬڬ heap'e Ѭ٬Ҭڬ ߬ ֬ ܬ ѬҬݬڬ? (߬Ѭڬެ֬ ج ֬Ӭެ ڬެӬݬ)
3. ج ߬ѬӬ֬߬ ݬ, ߬ Questions = 278M,
Com_update+Com_select+Com_insert+Com_delete ڬެ֬߬ 100M
ܬլ ݬ ֬ 178 ެݬ. ٬Ѭ?


[ - !]



MySQL.RU!
, , :
- - FAQ
-
-
, ( , MySQL, , , , .)
, , .
 :
 E-mail:
 :
 :
: Code
16833



  | |