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

> Original message text:
> 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 ެݬ. ٬Ѭ?
>


From: zhil - 25/08/2004 - 17:14:55
Subject:
-----------------

( 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 o 1,214
Row size o 1,294 Bytes
Data 130,146 KB
Index 8,563 KB
Total 138,709 KB



[ - !]



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



  | |