Mysql news

short mobi-news for mysql

/mysqlreport-3.5/mysqlreport logi

MySQL 5.0.44 uptime 21 1:28:23 Fri Aug 20 12:04:24 2010

__ Key _________________________________________________________________

Buffer used 14.16M of 16.00M %Used: 88.48

Current 2.10M %Usage: 13.13

Write hit 96.45%

Read hit 98.52%

__ Questions ___________________________________________________________

Total 21.15M 11.6/s

DMS 14.03M 7.7/s %Total: 66.34

Com_ 5.46M 3.0/s 25.79

+Unknown 942.73k 0.5/s 4.46

COM_QUIT 721.89k 0.4/s 3.41

Slow 10 s 9.32k 0.0/s 0.04 %DMS: 0.07 Log: OFF

DMS 14.03M 7.7/s 66.34

SELECT 12.10M 6.6/s 57.21 86.23

UPDATE 1.12M 0.6/s 5.29 7.97

INSERT 506.35k 0.3/s 2.39 3.61

DELETE 304.68k 0.2/s 1.44 2.17

REPLACE 2.46k 0.0/s 0.01 0.02

Com_ 5.46M 3.0/s 25.79

set_option 1.92M 1.1/s 9.10

show_fields 937.96k 0.5/s 4.43

show_create 930.10k 0.5/s 4.40

__ SELECT and Sort _____________________________________________________

Scan 4.44M 2.4/s %SELECT: 36.69

Range 467.67k 0.3/s 3.86

Full join 7.68k 0.0/s 0.06

Range check 0 0/s 0.00

Full rng join 98.09k 0.1/s 0.81

Sort scan 1.31M 0.7/s

Sort range 636.59k 0.3/s

Sort mrg pass 85.77k 0.0/s

__ Table Locks _________________________________________________________

Waited 3.87k 0.0/s %Total: 0.02

Immediate 16.26M 8.9/s

__ Tables ______________________________________________________________

Open 64 of 64 %Cache: 100.00

Opened 2.04M 1.1/s

__ Connections _________________________________________________________

Max used 101 of 100 %Max: 101.00

Total 721.93k 0.4/s

__ Created Temp ________________________________________________________

Disk table 2.77M 1.5/s

Table 4.14M 2.3/s Size: 32.0M

File 154.94k 0.1/s

__ Threads _____________________________________________________________

Running 2 of 3

Cached 0 of 0 %Hit: 0

Created 721.93k 0.4/s

Slow 191 0.0/s

__ Aborted _____________________________________________________________

Clients 70 0.0/s

Connects 6.99k 0.0/s

__ Bytes _______________________________________________________________

Sent 1.48G 813.3/s

Received 3.87G 2.1k/s

__ InnoDB Buffer Pool __________________________________________________

Usage 0 of 0 %Used: 0.00

Read hit 0.00%

Pages

Free 0 %Total: 0.00

Data 0 0.00 %Drty: 0.00

Misc 0 0.00

Latched 0 0.00

Reads 0 0/s

From file 0 0/s 0.00

Ahead Rnd 0 0/s

Ahead Sql 0 0/s

Writes 0 0/s

Flushes 0 0/s

Wait Free 0 0/s

__ InnoDB Lock _________________________________________________________

Waits 0 0/s

Current 0

Time acquiring

Total 0 ms

Average 0 ms

Max 0 ms

__ InnoDB Data, Pages, Rows ____________________________________________

Data

Reads 0 0/s

Writes 0 0/s

fsync 0 0/s

Pending

Reads 0

Writes 0

fsync 0

Pages

Created 0 0/s

Read 0 0/s

Written 0 0/s

Rows

Deleted 0 0/s

Inserted 0 0/s

Read 0 0/s

Updated 0 0/s

  • 0 Comments
  • Filed under: MySQL Example
  • source mysla query

  • 0 Comments
  • Filed under: Uncategorized
  • 0 Comments
  • Filed under: MySQL news
  • 0 Comments
  • Filed under: MySQL news
  • 0 Comments
  • Filed under: MySQL news
  • 0 Comments
  • Filed under: MySQL news
  • 0 Comments
  • Filed under: MySQL news
  • 0 Comments
  • Filed under: MySQL news
  • 0 Comments
  • Filed under: MySQL news
  • 0 Comments
  • Filed under: MySQL news
  • hosting seo ? h7 xenon ? Auschwitz concentration camp ? dunjaec river gorge