ml at kiewel-online
Jan 18, 2009, 11:54 PM
Post #6 of 6
(1071 views)
Permalink
|
The 7crewz wrote:
> Buffer pool hit rate 1000 / 1000
In my point of view: 1000 request out of 1000 are processed by buffer
pool, that is a buffer pool hit ratio of 100 percent.
> What is this mean ?
> And hit ratio ?
> I realy don't understand thanks
>
> Sent from 7crewz BlackBerry® wireless device via Vodafone-Celcom Mobile.
>
> -----Original Message-----
> From: "The 7crewz" <7crewz [at] gmail>
>
> Date: Mon, 19 Jan 2009 07:41:04
> To: DBMail mailinglist<dbmail [at] dbmail>
> Subject: Re: [Dbmail] mysql !!! Its This Normal ?
>
>
> Can anybody show me how to see this log ?
> Sent from 7crewz BlackBerry® wireless device via Vodafone-Celcom Mobile.
>
> -----Original Message-----
> From: Uwe Kiewel <ml [at] kiewel-online>
>
> Date: Mon, 19 Jan 2009 08:39:33
> To: DBMail mailinglist<dbmail [at] dbmail>
> Subject: Re: [Dbmail] mysql !!! Its This Normal ?
>
>
> 7CREWZ wrote:
>> Hello to All
>>
>> This i grep from mysql with command show innodb status; is
>> any things error or have to modified ? user arround 2K with 8Gb ram Quad
>> Core CPU take this snapshot on peak time... and high traffic
>>
>
> I don't see any problem. No pending operations, bufferpool hit ratio is
> excelent.
>
>>
>> --------
>> FILE I/O
>> --------
>> I/O thread 0 state: waiting for i/o request (insert buffer thread)
>> I/O thread 1 state: waiting for i/o request (log thread)
>> I/O thread 2 state: waiting for i/o request (read thread)
>> I/O thread 3 state: waiting for i/o request (write thread)
>> Pending normal aio reads: 0, aio writes: 0,
>> ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
>> Pending flushes (fsync) log: 0; buffer pool: 0
>> 61168 OS file reads, 1123401 OS file writes, 568696 OS fsyncs
>> 0.00 reads/s, 0 avg bytes/read, 8.77 writes/s, 2.91 fsyncs/s
>> -------------------------------------
>> INSERT BUFFER AND ADAPTIVE HASH INDEX
>> -------------------------------------
>> Ibuf: size 1, free list len 3, seg size 5,
>> 277 inserts, 277 merged recs, 94 merges
>> Hash table size 10624987, used cells 1495954, node heap has 2379 buffer(s)
>> 281.31 hash searches/s, 246.08 non-hash searches/s
>> ---
>> LOG
>> ---
>> Log sequence number 2 1887995420
>> Log flushed up to 2 1887995420
>> Last checkpoint at 2 1887978254
>> 0 pending log writes, 0 pending chkp writes
>> 397643 log i/o's done, 1.50 log i/o's/second
>> ----------------------
>> BUFFER POOL AND MEMORY
>> ----------------------
>> Total memory allocated 5986025278; in additional pool allocated 12776960
>> Buffer pool size 327680
>> Free buffers 0
>> Database pages 325301
>> Modified db pages 61
>> Pending reads 0
>> Pending writes: LRU 0, flush list 0, single page 0
>> Pages read 65491, created 376929, written 1256434
>> 0.00 reads/s, 0.09 creates/s, 8.36 writes/s
>> Buffer pool hit rate 1000 / 1000
>> --------------
>> ROW OPERATIONS
>> --------------
>> 0 queries inside InnoDB, 0 queries in queue
>> 1 read views open inside InnoDB
>> Main thread process no. 8107, id 1173395776, state: sleeping
>> Number of rows inserted 1183858, updated 329127, deleted 142409, read
>> 1310553240
>> 2.55 inserts/s, 1.18 updates/s, 0.09 deletes/s, 3094.27 reads/s
>> ----------------------------
>> END OF INNODB MONITOR OUTPUT
>> ============================
>>
>>
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> DBmail mailing list
>> DBmail [at] dbmail
>> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
> _______________________________________________
> DBmail mailing list
> DBmail [at] dbmail
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> DBmail mailing list
> DBmail [at] dbmail
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
DBmail mailing list
DBmail [at] dbmail
https://mailman.fastxs.nl/mailman/listinfo/dbmail
|
