Cookies must be enabled past this point.
phpMyAdmin demo - MySQL

Runtime Information

ajax clock Refresh Live traffic chart Live conn./process chart

Network traffic since startup: 111.5 MiB

This MySQL server has been running for 0 days, 4 hours, 9 minutes and 56 seconds. It started up on May 17, 2012 at 05:10 PM.

Traffic 1 ø per hour
Received 103.6 MiB 24.9 MiB
Sent 7.9 MiB 1.9 MiB
Total 111.5 MiB 26.8 MiB
Connections ø per hour %
max. concurrent connections 12 --- ---
Failed attempts 6 1.44 0.13%
Aborted 0 0 0%
Total 4,603 1,105.01 100.00%
Processes ID User Host Database Command Time Status SQL query Show Full Queries
Kill 2549 pma localhost None Sleep 9156 --- ---
Kill 2550 root localhost None Sleep 9156 --- ---
Kill 4601 pma localhost phpmyadmin Sleep 0 --- ---
Kill 4602 root localhost mysql Query 0 --- SHOW PROCESSLIST
ajax clock Refresh Live query chart

Questions since startup: 178,181 Documentation
ø per hour: 42,775
ø per minute: 713
ø per second: 12

Statements # ø per hour %
insert 158 k 38 k 88.92%
set option 9,217 2,212.7 5.17%
select 3,317 796.3 1.86%
change db 1,432 343.8 0.80%
show binlogs 670 160.8 0.38%
create table 656 157.5 0.37%
show tables 622 149.3 0.35%
show table status 552 132.5 0.31%
show databases 391 93.9 0.22%
commit 375 90 0.21%
show variables 322 77.3 0.18%
show fields 298 71.5 0.17%
show status 216 51.9 0.12%
create view 175 42 0.10%
show create table 165 39.6 0.09%
show keys 163 39.1 0.09%
drop table 150 36 0.08%
create trigger 150 36 0.08%
show grants 143 34.3 0.08%
create db 138 33.1 0.08%
show slave status 136 32.6 0.08%
show master status 136 32.6 0.08%
drop db 100 24 0.06%
replace 62 14.9 0.03%
load 50 12 0.03%
create procedure 25 6 0.01%
show storage engines 24 5.8 0.01%
grant 18 4.3 0.01%
show processlist 13 3.1 0.01%
show triggers 10 2.4 0.01%
show plugins 7 1.7 <0.01%
create user 5 1.2 <0.01%
show warnings 1 0.2 <0.01%
show procedure status 1 0.2 <0.01%
show function status 1 0.2 <0.01%
{"insert":"158440","set option":"9217","select":"3317","change db":"1432","show binlogs":"670","create table":"656","show tables":"622","Other":3827}
Filters
ajax clock Refresh
Variable Value Description
Aborted clientsDocumentation 0 The number of connections that were aborted because the client died without closing the connection properly.
Aborted connectsDocumentation 6 The number of failed attempts to connect to the MySQL server.
Binlog cache disk useDocumentation 0 The number of transactions that used the temporary binary log cache but that exceeded the value of binlog_cache_size and used a temporary file to store statements from the transaction.
Binlog cache useDocumentation 0 The number of transactions that used the temporary binary log cache.
Binlog stmt cache disk useDocumentation 0
Binlog stmt cache useDocumentation 0
Bytes receivedDocumentation 108.7 M
Bytes sentDocumentation 8.3 M
Com admin commandsDocumentation 77
Com assign to keycacheDocumentation 0
Com alter dbDocumentation 0
Com alter db upgradeDocumentation 0
Com alter eventDocumentation 0
Com alter functionDocumentation 0
Com alter procedureDocumentation 0
Com alter serverDocumentation 0
Com alter tableDocumentation 0
Com alter tablespaceDocumentation 0
Com analyzeDocumentation 0
Com beginDocumentation 0
Com binlogDocumentation 0
Com call procedureDocumentation 0
Com change dbDocumentation 1.4 k
Com change masterDocumentation 0
Com checkDocumentation 0
Com checksumDocumentation 0
Com commitDocumentation 375
Com create dbDocumentation 138
Com create eventDocumentation 0
Com create functionDocumentation 0
Com create indexDocumentation 0
Com create procedureDocumentation 25
Com create serverDocumentation 0
Com create tableDocumentation 656
Com create triggerDocumentation 150
Com create udfDocumentation 0
Com create userDocumentation 5
Com create viewDocumentation 175
Com deleteDocumentation 0
Com delete multiDocumentation 0
Com doDocumentation 0
Com drop dbDocumentation 100
Com drop eventDocumentation 0
Com drop functionDocumentation 0
Com drop indexDocumentation 0
Com drop procedureDocumentation 0
Com drop serverDocumentation 0
Com drop tableDocumentation 150
Com drop triggerDocumentation 0
Com drop userDocumentation 0
Com drop viewDocumentation 0
Com empty queryDocumentation 0
Com flushDocumentation 0
Com grantDocumentation 18
Com ha closeDocumentation 0
Com ha openDocumentation 0
Com ha readDocumentation 0
Com helpDocumentation 0
Com insertDocumentation 158.4 k
Com insert selectDocumentation 0
Com install pluginDocumentation 0
Com killDocumentation 0
Com loadDocumentation 50
Com lock tablesDocumentation 0
Com optimizeDocumentation 0
Com preload keysDocumentation 0
Com purgeDocumentation 0
Com purge before dateDocumentation 0
Com release savepointDocumentation 0
Com rename tableDocumentation 0
Com rename userDocumentation 0
Com repairDocumentation 0
Com replaceDocumentation 62
Com replace selectDocumentation 0
Com resetDocumentation 0
Com resignalDocumentation 0
Com revokeDocumentation 0
Com revoke allDocumentation 0
Com rollbackDocumentation 0
Com rollback to savepointDocumentation 0
Com savepointDocumentation 0
Com selectDocumentation 3.3 k
Com set optionDocumentation 9.2 k
Com signalDocumentation 0
Com show authorsDocumentation 0
Com show binlog eventsDocumentation 0
Com show binlogsDocumentation 670
Com show charsetsDocumentation 0
Com show collationsDocumentation 0
Com show contributorsDocumentation 0
Com show create dbDocumentation 0
Com show create eventDocumentation 0
Com show create funcDocumentation 0
Com show create procDocumentation 0
Com show create tableDocumentation 165
Com show create triggerDocumentation 0
Com show databasesDocumentation 391
Com show engine logsDocumentation 0
Com show engine mutexDocumentation 0
Com show engine statusDocumentation 0
Com show eventsDocumentation 0
Com show errorsDocumentation 0
Com show fieldsDocumentation 298
Com show function statusDocumentation 1
Com show grantsDocumentation 143
Com show keysDocumentation 163
Com show master statusDocumentation 136
Com show open tablesDocumentation 0
Com show pluginsDocumentation 7
Com show privilegesDocumentation 0
Com show procedure statusDocumentation 1
Com show processlistDocumentation 13
Com show profileDocumentation 0
Com show profilesDocumentation 0
Com show relaylog eventsDocumentation 0
Com show slave hostsDocumentation 0
Com show slave statusDocumentation 136
Com show statusDocumentation 216
Com show storage enginesDocumentation 24
Com show table statusDocumentation 552
Com show tablesDocumentation 622
Com show triggersDocumentation 10
Com show variablesDocumentation 322
Com show warningsDocumentation 1
Com slave startDocumentation 0
Com slave stopDocumentation 0
Com stmt closeDocumentation 0
Com stmt executeDocumentation 0
Com stmt fetchDocumentation 0
Com stmt prepareDocumentation 0
Com stmt reprepareDocumentation 0
Com stmt resetDocumentation 0
Com stmt send long dataDocumentation 0
Com truncateDocumentation 0
Com uninstall pluginDocumentation 0
Com unlock tablesDocumentation 0
Com updateDocumentation 0
Com update multiDocumentation 0
Com xa commitDocumentation 0
Com xa endDocumentation 0
Com xa prepareDocumentation 0
Com xa recoverDocumentation 0
Com xa rollbackDocumentation 0
Com xa startDocumentation 0
CompressionDocumentation OFF
ConnectionsDocumentation 4.6 k The number of connection attempts (successful or not) to the MySQL server.
Created tmp disk tablesDocumentation 851 The number of temporary tables on disk created automatically by the server while executing statements. If Created_tmp_disk_tables is big, you may want to increase the tmp_table_size value to cause temporary tables to be memory-based instead of disk-based.
Created tmp filesDocumentation 6 How many temporary files mysqld has created.
Created tmp tablesDocumentation 5.3 k The number of in-memory temporary tables created automatically by the server while executing statements.
Delayed errorsDocumentation 0 The number of rows written with INSERT DELAYED for which some error occurred (probably duplicate key).
Delayed insert threadsDocumentation 0 The number of INSERT DELAYED handler threads in use. Every different table on which one uses INSERT DELAYED gets its own thread.
Delayed writesDocumentation 0 The number of INSERT DELAYED rows written.
Flush commandsDocumentation 1 The number of executed FLUSH statements.
Handler commitDocumentation 1.4 k The number of internal COMMIT statements.
Handler deleteDocumentation 0 The number of times a row was deleted from a table.
Handler discoverDocumentation 0 The MySQL server can ask the NDB Cluster storage engine if it knows about a table with a given name. This is called discovery. Handler_discover indicates the number of time tables have been discovered.
Handler prepareDocumentation 0
Handler read firstDocumentation 549 The number of times the first entry was read from an index. If this is high, it suggests that the server is doing a lot of full index scans; for example, SELECT col1 FROM foo, assuming that col1 is indexed.
Handler read keyDocumentation 4.7 M The number of requests to read a row based on a key. If this is high, it is a good indication that your queries and tables are properly indexed.
Handler read lastDocumentation 1
Handler read nextDocumentation 2.8 M The number of requests to read the next row in key order. This is incremented if you are querying an index column with a range constraint or if you are doing an index scan.
Handler read prevDocumentation 0 The number of requests to read the previous row in key order. This read method is mainly used to optimize ORDER BY ... DESC.
Handler read rndDocumentation 57 k The number of requests to read a row based on a fixed position. This is high if you are doing a lot of queries that require sorting of the result. You probably have a lot of queries that require MySQL to scan whole tables or you have joins that don't use keys properly.
Handler read rnd nextDocumentation 264.3 k The number of requests to read the next row in the data file. This is high if you are doing a lot of table scans. Generally this suggests that your tables are not properly indexed or that your queries are not written to take advantage of the indexes you have.
Handler rollbackDocumentation 2 The number of internal ROLLBACK statements.
Handler savepointDocumentation 0
Handler savepoint rollbackDocumentation 0
Handler updateDocumentation 163.3 k The number of requests to update a row in a table.
Handler writeDocumentation 1.6 M The number of requests to insert a row in a table.
Innodb buffer pool pages dataDocumentation 836 The number of pages containing data (dirty or clean).
Innodb buffer pool pages dirtyDocumentation 0 The number of pages currently dirty.
Innodb buffer pool pages flushedDocumentation 29.5 k The number of buffer pool pages that have been requested to be flushed.
Innodb buffer pool pages freeDocumentation 7.3 k The number of free pages.
Innodb buffer pool pages miscDocumentation 11 The number of pages busy because they have been allocated for administrative overhead such as row locks or the adaptive hash index. This value can also be calculated as Innodb_buffer_pool_pages_total - Innodb_buffer_pool_pages_free - Innodb_buffer_pool_pages_data.
Innodb buffer pool pages totalDocumentation 8.2 k Total size of buffer pool, in pages.
Innodb buffer pool read ahead rndDocumentation 0 The number of "random" read-aheads InnoDB initiated. This happens when a query is to scan a large portion of a table but in random order.
Innodb buffer pool read aheadDocumentation 0
Innodb buffer pool read ahead evictedDocumentation 0
Innodb buffer pool read requestsDocumentation 19 M The number of logical read requests InnoDB has done.
Innodb buffer pool readsDocumentation 434 The number of logical reads that InnoDB could not satisfy from buffer pool and had to do a single-page read.
Innodb buffer pool wait freeDocumentation 0 Normally, writes to the InnoDB buffer pool happen in the background. However, if it's necessary to read or create a page and no clean pages are available, it's necessary to wait for pages to be flushed first. This counter counts instances of these waits. If the buffer pool size was set properly, this value should be small.
Innodb buffer pool write requestsDocumentation 5.9 M The number writes done to the InnoDB buffer pool.
Innodb data fsyncsDocumentation 2.7 k The number of fsync() operations so far.
Innodb data pending fsyncsDocumentation 0 The current number of pending fsync() operations.
Innodb data pending readsDocumentation 0 The current number of pending reads.
Innodb data pending writesDocumentation 0 The current number of pending writes.
Innodb data readDocumentation 11.4 M The amount of data read so far, in bytes.
Innodb data readsDocumentation 572 The total number of data reads.
Innodb data writesDocumentation 17.1 k The total number of data writes.
Innodb data writtenDocumentation 660.6 M The amount of data written so far, in bytes.
Innodb dblwr pages writtenDocumentation 14.7 k The number of pages that have been written for doublewrite operations.
Innodb dblwr writesDocumentation 387 The number of doublewrite operations that have been performed.
Innodb have atomic builtinsDocumentation ON
Innodb log waitsDocumentation 0 The number of waits we had because log buffer was too small and we had to wait for it to be flushed before continuing.
Innodb log write requestsDocumentation 369.5 k The number of log write requests.
Innodb log writesDocumentation 1.9 k The number of physical writes to the log file.
Innodb os log fsyncsDocumentation 1.9 k The number of fsync() writes done to the log file.
Innodb os log pending fsyncsDocumentation 0 The number of pending log file fsyncs.
Innodb os log pending writesDocumentation 0 Pending log file writes.
Innodb os log writtenDocumentation 177.8 M The number of bytes written to the log file.
Innodb page sizeDocumentation 16.4 k The compiled-in InnoDB page size (default 16KB). Many values are counted in pages; the page size allows them to be easily converted to bytes.
Innodb pages createdDocumentation 403 The number of pages created.
Innodb pages readDocumentation 433 The number of pages read.
Innodb pages writtenDocumentation 14.7 k The number of pages written.
Innodb row lock current waitsDocumentation 0 The number of row locks currently being waited for.
Innodb row lock timeDocumentation 0 The total time spent in acquiring row locks, in milliseconds.
Innodb row lock time avgDocumentation 0 The average time to acquire a row lock, in milliseconds.
Innodb row lock time maxDocumentation 0 The maximum time to acquire a row lock, in milliseconds.
Innodb row lock waitsDocumentation 0 The number of times a row lock had to be waited for.
Innodb rows deletedDocumentation 0 The number of rows deleted from InnoDB tables.
Innodb rows insertedDocumentation 1.2 M The number of rows inserted in InnoDB tables.
Innodb rows readDocumentation 5 M The number of rows read from InnoDB tables.
Innodb rows updatedDocumentation 0 The number of rows updated in InnoDB tables.
Innodb truncated status writesDocumentation 0
Key blocks not flushedDocumentation 0 The number of key blocks in the key cache that have changed but haven't yet been flushed to disk. It used to be known as Not_flushed_key_blocks.
Key blocks unusedDocumentation 13.1 k The number of unused blocks in the key cache. You can use this value to determine how much of the key cache is in use.
Key blocks usedDocumentation 337 The number of used blocks in the key cache. This value is a high-water mark that indicates the maximum number of blocks that have ever been in use at one time.
Key read requestsDocumentation 1 M The number of requests to read a key block from the cache.
Key readsDocumentation 232 The number of physical reads of a key block from disk. If Key_reads is big, then your key_buffer_size value is probably too small. The cache miss rate can be calculated as Key_reads/Key_read_requests.
Key write requestsDocumentation 450.4 k The number of requests to write a key block to the cache.
Key writesDocumentation 144.4 k The number of physical writes of a key block to disk.
Last query costDocumentation 0 The total cost of the last compiled query as computed by the query optimizer. Useful for comparing the cost of different query plans for the same query. The default value of 0 means that no query has been compiled yet.
Max used connectionsDocumentation 12 The maximum number of connections that have been in use simultaneously since the server started.
Not flushed delayed rowsDocumentation 0 The number of rows waiting to be written in INSERT DELAYED queues.
Open filesDocumentation 251 The number of files that are open.
Open streamsDocumentation 0 The number of streams that are open (used mainly for logging).
Open table definitionsDocumentation 147
Open tablesDocumentation 149 The number of tables that are open.
Opened filesDocumentation 13.3 k
Opened table definitionsDocumentation 1.6 k
Opened tablesDocumentation 3.9 k The number of tables that have been opened. If opened tables is big, your table cache value is probably too small.
Performance schema cond classes lostDocumentation 0
Performance schema cond instances lostDocumentation 0
Performance schema file classes lostDocumentation 0
Performance schema file handles lostDocumentation 0
Performance schema file instances lostDocumentation 0
Performance schema locker lostDocumentation 0
Performance schema mutex classes lostDocumentation 0
Performance schema mutex instances lostDocumentation 0
Performance schema rwlock classes lostDocumentation 0
Performance schema rwlock instances lostDocumentation 0
Performance schema table handles lostDocumentation 0
Performance schema table instances lostDocumentation 0
Performance schema thread classes lostDocumentation 0
Performance schema thread instances lostDocumentation 0
Prepared stmt countDocumentation 0
Qcache free blocksDocumentation 15 The number of free memory blocks in query cache. High numbers can indicate fragmentation issues, which may be solved by issuing a FLUSH QUERY CACHE statement.
Qcache free memoryDocumentation 16.3 M The amount of free memory for query cache.
Qcache hitsDocumentation 2.1 k The number of cache hits.
Qcache insertsDocumentation 656 The number of queries added to the cache.
Qcache lowmem prunesDocumentation 0 The number of queries that have been removed from the cache to free up memory for caching new queries. This information can help you tune the query cache size. The query cache uses a least recently used (LRU) strategy to decide which queries to remove from the cache.
Qcache not cachedDocumentation 2.7 k The number of non-cached queries (not cachable, or not cached due to the query_cache_type setting).
Qcache queries in cacheDocumentation 423 The number of queries registered in the cache.
Qcache total blocksDocumentation 880 The total number of blocks in the query cache.
QueriesDocumentation 184.9 k
QuestionsDocumentation 159.9 k
Rpl statusDocumentation AUTH_MASTER The status of failsafe replication (not yet implemented).
Select full joinDocumentation 0 The number of joins that do not use indexes. If this value is not 0, you should carefully check the indexes of your tables.
Select full range joinDocumentation 0 The number of joins that used a range search on a reference table.
Select rangeDocumentation 1 The number of joins that used ranges on the first table. (It's normally not critical even if this is big.)
Select range checkDocumentation 0 The number of joins without keys that check for key usage after each row. (If this is not 0, you should carefully check the indexes of your tables.)
Select scanDocumentation 3.8 k The number of joins that did a full scan of the first table.
Slave heartbeat periodDocumentation 0
Slave open temp tablesDocumentation 0 The number of temporary tables currently open by the slave SQL thread.
Slave received heartbeatsDocumentation 0
Slave retried transactionsDocumentation 0 Total (since startup) number of times the replication slave SQL thread has retried transactions.
Slave runningDocumentation OFF This is ON if this server is a slave that is connected to a master.
Slow launch threadsDocumentation 0 The number of threads that have taken more than slow_launch_time seconds to create.
Slow queriesDocumentation 0 The number of queries that have taken more than long_query_time seconds.Documentation
Sort merge passesDocumentation 0 The number of merge passes the sort algorithm has had to do. If this value is large, you should consider increasing the value of the sort_buffer_size system variable.
Sort rangeDocumentation 1 The number of sorts that were done with ranges.
Sort rowsDocumentation 58.9 k The number of sorted rows.
Sort scanDocumentation 93 The number of sorts that were done by scanning the table.
Ssl accept renegotiatesDocumentation 0
Ssl acceptsDocumentation 0
Ssl callback cache hitsDocumentation 0
Ssl cipherDocumentation
Ssl cipher listDocumentation
Ssl client connectsDocumentation 0
Ssl connect renegotiatesDocumentation 0
Ssl ctx verify depthDocumentation 0
Ssl ctx verify modeDocumentation 0
Ssl default timeoutDocumentation 0
Ssl finished acceptsDocumentation 0
Ssl finished connectsDocumentation 0
Ssl session cache hitsDocumentation 0
Ssl session cache missesDocumentation 0
Ssl session cache modeDocumentation NONE
Ssl session cache overflowsDocumentation 0
Ssl session cache sizeDocumentation 0
Ssl session cache timeoutsDocumentation 0
Ssl sessions reusedDocumentation 0
Ssl used session cache entriesDocumentation 0
Ssl verify depthDocumentation 0
Ssl verify modeDocumentation 0
Ssl versionDocumentation
Table locks immediateDocumentation 136.4 k The number of times that a table lock was acquired immediately.
Table locks waitedDocumentation 0 The number of times that a table lock could not be acquired immediately and a wait was needed. If this is high, and you have performance problems, you should first optimize your queries, and then either split your table or tables or use replication.
Tc log max pages usedDocumentation 0
Tc log page sizeDocumentation 0
Tc log page waitsDocumentation 0
Threads cachedDocumentation 6 The number of threads in the thread cache. The cache hit rate can be calculated as Threads_created/Connections. If this value is red you should raise your thread_cache_size.
Threads connectedDocumentation 4 The number of currently open connections.
Threads createdDocumentation 12 The number of threads created to handle connections. If Threads_created is big, you may want to increase the thread_cache_size value. (Normally this doesn't give a notable performance improvement if you have a good thread implementation.)
Threads runningDocumentation 1 The number of threads that are not sleeping.
UptimeDocumentation 0 days, 4 hours, 9 minutes and 56 seconds
Uptime since flush statusDocumentation 0 days, 4 hours, 9 minutes and 56 seconds
Key buffer fraction % 20.29 % Percentage of used key cache (calculated value)
Key write ratio % 32.06 % Percentage of physical writes compared to write requests (calculated value)
Key read ratio % 0.02 % Key cache miss calculated as rate of physical reads compared to read requests (calculated value)
Threads cache hitrate % 99.74 % Thread cache hit rate (calculated value)
Add chart Rearrange/edit charts
Refresh rate

Chart columns
Chart arrangement 2
Import  Export  Reset to default

Run analyzer Instructions
1 On a busy server, the byte counters may overrun, so those statistics as reported by the MySQL server may be incorrect.
2 The arrangement of the charts is stored to the browsers local storage. You may want to export it if you have a complicated set up.
phpMyAdmin demo server, currently running Git revision RELEASE_3_5_1-4462-geb16216 from master branch.