Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- root@precise32:~/percona-toolkit-2.2.7/bin# ./pt-mysql-summary
- # Percona Toolkit MySQL Summary Report #######################
- System time | 2014-09-18 15:58:29 UTC (local TZ: UTC +0000)
- # Instances ##################################################
- Port Data Directory Nice OOM Socket
- ===== ========================== ==== === ======
- # MySQL Executable ###########################################
- Path to executable | /usr/sbin/mysqld
- Has symbols | No
- # Report On Port 3306 ########################################
- User | root@localhost
- Time | 2014-09-18 15:58:29 (UTC)
- Hostname | precise32
- Version | 5.5.35-0ubuntu0.12.04.2-log (Ubuntu)
- Built On | debian-linux-gnu i686
- Started | 2014-09-15 13:54 (up 3+02:04:15)
- Databases | 24
- Datadir | /var/lib/mysql/
- Processes | 2 connected, 1 running
- Replication | Is not a slave, has 0 slaves connected
- Pidfile | /var/run/mysqld/mysqld.pid (exists)
- # Processlist ################################################
- Command COUNT(*) Working SUM(Time) MAX(Time)
- ------------------------------ -------- ------- --------- ---------
- Query 1 1 0 0
- Sleep 1 0 0 0
- User COUNT(*) Working SUM(Time) MAX(Time)
- ------------------------------ -------- ------- --------- ---------
- cacti 1 0 0 0
- root 1 1 0 0
- Host COUNT(*) Working SUM(Time) MAX(Time)
- ------------------------------ -------- ------- --------- ---------
- localhost 2 1 0 0
- db COUNT(*) Working SUM(Time) MAX(Time)
- ------------------------------ -------- ------- --------- ---------
- cacti 1 0 0 0
- NULL 1 1 0 0
- State COUNT(*) Working SUM(Time) MAX(Time)
- ------------------------------ -------- ------- --------- ---------
- 1 0 0 0
- NULL 1 1 0 0
- # Status Counters (Wait 10 Seconds) ##########################
- Variable Per day Per second 11 secs
- Binlog_cache_use 2
- Binlog_stmt_cache_use 1500
- Bytes_received 30000000000 350000 350000
- Bytes_sent 35000000000 400000 400000
- Com_admin_commands 1
- Com_change_db 350
- Com_insert 2
- Com_replace 1500
- Com_select 10000 1
- Com_set_option 400
- Com_show_create_table 45
- Com_show_fields 2
- Com_show_tables 7
- Com_show_variables 1
- Com_truncate 300
- Connections 300 1
- Created_tmp_disk_tables 20 1
- Created_tmp_files 4
- Created_tmp_tables 80 4
- Handler_commit 1500
- Handler_prepare 5
- Handler_read_first 600
- Handler_read_key 9000
- Handler_read_next 3
- Handler_read_rnd 1500
- Handler_read_rnd_next 2000 80
- Handler_update 1500
- Handler_write 2500 35
- Innodb_buffer_pool_bytes_data 10000000 125
- Innodb_buffer_pool_pages_flushed 30
- Innodb_buffer_pool_read_requests 17500
- Innodb_buffer_pool_reads 700
- Innodb_buffer_pool_write_requests 90
- Innodb_data_fsyncs 20
- Innodb_data_read 12500000 150
- Innodb_data_reads 700
- Innodb_data_writes 40
- Innodb_data_written 900000 10
- Innodb_dblwr_pages_written 30
- Innodb_dblwr_writes 3
- Innodb_log_write_requests 7
- Innodb_log_writes 9
- Innodb_os_log_fsyncs 15
- Innodb_os_log_written 9000
- Innodb_pages_read 700
- Innodb_pages_written 30
- Innodb_rows_inserted 5
- Innodb_rows_read 15
- Key_read_requests 10000
- Key_reads 15
- Open_table_definitions 50
- Opened_files 2250 5
- Opened_table_definitions 600
- Opened_tables 800
- Qcache_hits 125000000 1500 1500
- Qcache_inserts 10000
- Qcache_not_cached 60 1
- Queries 125000000 1500 1500
- Questions 125000000 1500 1500
- Select_scan 15
- Table_locks_immediate 10000
- Uptime 90000 1 1
- # Table cache ################################################
- Size | 400
- Usage | 40%
- # Key Percona Server features ################################
- Table & Index Stats | Not Supported
- Multiple I/O Threads | Enabled
- Corruption Resilient | Not Supported
- Durable Replication | Not Supported
- Import InnoDB Tables | Not Supported
- Fast Server Restarts | Not Supported
- Enhanced Logging | Not Supported
- Replica Perf Logging | Not Supported
- Response Time Hist. | Not Supported
- Smooth Flushing | Not Supported
- HandlerSocket NoSQL | Not Supported
- Fast Hash UDFs | Unknown
- # Percona XtraDB Cluster #####################################
- # Plugins ####################################################
- InnoDB compression | ACTIVE
- # Query cache ################################################
- query_cache_type | ON
- Size | 16.0M
- Usage | 0%
- HitToInsertRatio | 1250000%
- # Schema #####################################################
- Specify --databases or --all-databases to dump and summarize schemas
- # Noteworthy Technologies ####################################
- SSL | No
- Explicit LOCK TABLES | No
- Delayed Insert | No
- XA Transactions | No
- NDB Cluster | No
- Prepared Statements | No
- Prepared statement count | 0
- # InnoDB #####################################################
- Version | 5.5.35
- Buffer Pool Size | 128.0M
- Buffer Pool Fill | 25%
- Buffer Pool Dirty | 0%
- File Per Table | OFF
- Page Size | 16k
- Log File Size | 2 * 5.0M = 10.0M
- Log Buffer Size | 8M
- Flush Method |
- Flush Log At Commit | 1
- XA Support | ON
- Checksums | ON
- Doublewrite | ON
- R/W I/O Threads | 4 4
- I/O Capacity | 200
- Thread Concurrency | 0
- Concurrency Tickets | 500
- Commit Concurrency | 0
- Txn Isolation Level | REPEATABLE-READ
- Adaptive Flushing | ON
- Adaptive Checkpoint |
- Checkpoint Age | 0
- InnoDB Queue | 0 queries inside InnoDB, 0 queries in queue
- Oldest Transaction | 0 Seconds
- History List Len | 422
- Read Views | 1
- Undo Log Entries | 0 transactions, 0 total undo, 0 max undo
- Pending I/O Reads | 0 buf pool reads, 0 normal AIO, 0 ibuf AIO, 0 preads
- Pending I/O Writes | 0 buf pool (0 LRU, 0 flush list, 0 page); 0 AIO, 0 sync, 0 log IO (0 log, 0 chkp); 0 pwrites
- Pending I/O Flushes | 0 buf pool, 0 log
- Transaction States | 1xnot started
- # MyISAM #####################################################
- Key Cache | 16.0M
- Pct Used | 10%
- Unflushed | 0%
- # Security ###################################################
- Users | 460 users, 2 anon, 6 w/o pw, 6 old pw
- Old Passwords | OFF
- # Binary Logging #############################################
- Binlogs | 12
- Zero-Sized | 0
- Total Size | 4.4M
- binlog_format | ROW
- expire_logs_days | 10
- sync_binlog | 0
- server_id | 1
- binlog_do_db |
- binlog_ignore_db |
- # Noteworthy Variables #######################################
- Auto-Inc Incr/Offset | 1/1
- default_storage_engine | InnoDB
- flush_time | 0
- init_connect |
- init_file |
- sql_mode |
- join_buffer_size | 128k
- sort_buffer_size | 2M
- read_buffer_size | 128k
- read_rnd_buffer_size | 256k
- bulk_insert_buffer | 0.00
- max_heap_table_size | 16M
- tmp_table_size | 16M
- max_allowed_packet | 16M
- thread_stack | 192k
- log | OFF
- log_error | /var/log/mysql/error.log
- log_warnings | 1
- log_slow_queries | OFF
- log_queries_not_using_indexes | OFF
- log_slave_updates | OFF
- # Configuration File #########################################
- Config File | /etc/mysql/my.cnf
- [client]
- port = 3306
- socket = /var/run/mysqld/mysqld.sock
- [mysqld_safe]
- socket = /var/run/mysqld/mysqld.sock
- nice = 0
- [mysqld]
- user = mysql
- pid-file = /var/run/mysqld/mysqld.pid
- socket = /var/run/mysqld/mysqld.sock
- port = 3306
- basedir = /usr
- datadir = /var/lib/mysql
- tmpdir = /tmp
- lc-messages-dir = /usr/share/mysql
- skip-external-locking
- bind-address = 0.0.0.0
- key_buffer = 16M
- max_allowed_packet = 16M
- thread_stack = 192K
- thread_cache_size = 8
- myisam-recover = BACKUP
- query_cache_limit = 1M
- query_cache_size = 16M
- log_error = /var/log/mysql/error.log
- slow_query_log = 0;
- server-id = 1
- log_bin = /var/log/mysql/mysql-bin.log
- expire_logs_days = 10
- max_binlog_size = 100M
- binlog_format = row
- [mysqldump]
- quick
- quote-names
- max_allowed_packet = 16M
- [mysql]
- [isamchk]
- key_buffer = 16M
- # The End ####################################################
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement