pt-mysql-summary SLAVE
# Percona Toolkit MySQL Summary Report #######################
System time | 2015-06-17 14:19:59 *****
# Instances ##################################################
Port Data Directory Nice OOM Socket
===== ========================== ==== === ======
PORT /home/mysql2/ 0 0 ПУТЬ ДО СОКЕТА
/var/lib/mysql 0 0
# MySQL Executable ###########################################
Path to executable | /usr/sbin/mysqld
Has symbols | No
# Report On Port ПОРТ ########################################
User | root@localhost
Time | 2015-06-17 14:19:59 (UTC)
Hostname | SLAVE
Version | 5.5.42-37.1 Percona Server (GPL), Release 37.1, Revision 39acee0
Built On | debian-linux-gnu x86_64
Started | 2015-06-17 14:17 (up 0+00:02:44)
Databases | 4
Datadir | DATADIR
Processes | 1 connected, 1 running
Replication | Is not a slave, has 0 slaves connected
Pidfile | /var/lib/mysql/pidfile.pid (exists)
# Processlist ################################################
Command COUNT(*) Working SUM(Time) MAX(Time)
------------------------------ -------- ------- --------- ---------
Query 1 1 0 0
User COUNT(*) Working SUM(Time) MAX(Time)
root 1 1 0 0
Host COUNT(*) Working SUM(Time) MAX(Time)
localhost 1 1 0 0
db COUNT(*) Working SUM(Time) MAX(Time)
NULL 1 1 0 0
State COUNT(*) Working SUM(Time) MAX(Time)
# Status Counters (Wait 10 Seconds) ##########################
Variable Per day Per second 11 secs
Aborted_connects 6000
Bytes_received 800000 9 200
Bytes_sent 12500000 150 2250
Com_select 1500 1
Com_show_status 1000
Com_show_variables 500
Connections 8000 1
Created_tmp_files 3000
Created_tmp_tables 1500 6
Flush_commands 500
Handler_read_first 1500
Handler_read_rnd_next 450000 4 40
Handler_write 400000 4 40
Innodb_adaptive_hash_cells 150000000 1750
Innodb_adaptive_hash_non_hash_searches 10000
Innodb_background_log_sync 500
Innodb_buffer_pool_bytes_data 1250000000 15000
Innodb_buffer_pool_read_requests 250000 2
Innodb_buffer_pool_reads 80000
Innodb_checkpoint_max_age 4000000000 45000
Innodb_checkpoint_target_age 4000000000 45000
Innodb_data_fsyncs 1500
Innodb_data_read 2500000000 30000
Innodb_data_reads 80000
Innodb_data_writes 1500
Innodb_data_written 800000 9
Innodb_dict_tables 4000
Innodb_ibuf_segment_size 1000
Innodb_ibuf_size 500
Innodb_log_writes 500
Innodb_lsn_current 800000000 10000
Innodb_lsn_flushed 800000000 10000
Innodb_lsn_last_checkpoint 800000000 10000
Innodb_master_thread_1_second_loops 500
Innodb_master_thread_background_loops 500
Innodb_master_thread_main_flush_loops 500
Innodb_master_thread_sleeps 500
Innodb_max_trx_id 900000 10
Innodb_mem_adaptive_hash 1250000000 12500
Innodb_mem_dictionary 300000000 3500
Innodb_mem_total 70000000000 800000
Innodb_mutex_os_waits 500
Innodb_mutex_spin_rounds 15000
Innodb_mutex_spin_waits 500
Innodb_oldest_view_low_limit_trx_id 900000 10
Innodb_os_log_fsyncs 1500
Innodb_os_log_written 250000 3
Innodb_pages_read 80000
Innodb_read_views_memory 45000
Innodb_descriptors_memory 4000000 50
Innodb_s_lock_os_waits 1000
Innodb_s_lock_spin_rounds 30000
Innodb_s_lock_spin_waits 1000
Open_table_definitions 17500
Opened_files 40000 4
Opened_table_definitions 17500
Opened_tables 17500
Queries 4500 3
Questions 4000 3
Select_scan 1500
Table_locks_immediate 20000
Threads_created 8000 1
Uptime 90000 1 1
# Table cache ################################################
Size | 400
Usage | 6%
# Key Percona Server features ################################
Table & Index Stats | Disabled
Multiple I/O Threads | Enabled
Corruption Resilient | Enabled
Durable Replication | Disabled
Import InnoDB Tables | Disabled
Fast Server Restarts | Disabled
Enhanced Logging | Disabled
Replica Perf Logging | Disabled
Response Time Hist. | Disabled
Smooth Flushing | Enabled
HandlerSocket NoSQL | Disabled
Fast Hash UDFs | Unknown
# Plugins ####################################################
InnoDB compression | ACTIVE
# Query cache ################################################
query_cache_type | ON
Size | 0.0
Usage | 0%
HitToInsertRatio | 0%
# 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.42-37.1
Buffer Pool Size | 128.0M
Buffer Pool Fill | 1%
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 | 0
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 | 8.0M
Pct Used | 20%
Unflushed | 0%
# Security ###################################################
Users | 7 users, 2 anon, 2 w/o pw, 2 old pw
Old Passwords | OFF
# Binary Logging #############################################
# 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 | 1M
thread_stack | 256k
log | OFF
log_error | /var/lib/mysql/****.err
log_warnings | 1
log_slow_queries | OFF
log_queries_not_using_indexes | OFF
log_slave_updates | OFF
pt-mysql-summary MASTER
System time | 2015-06-17 12:14:41
3306 /var/lib/mysql 0 0 /var/run/mysqld/mysqld.sock
# Report On Port 3306 ########################################
Time | 2015-06-17 17:14:41 (MSK)
Hostname | ******
Version | 5.5.43-37.2-log Percona Server (GPL), Release 37.2, Revision 6202fee
Started | 2015-06-16 19:09 (up 0+22:04:57)
Databases | 24
Datadir | ******
Processes | 70 connected, 3 running
Replication | Is not a slave, has 1 slaves connected
Pidfile | /var/run/mysqld/mysqld.pid (exists)
Binlog Dump 1 1 1000 1000
Query 2 2 0 0
Sleep 60 0 60000 12500
slave 1 1 1000 1000
***** 60 1 0 0
slave IP 1 1 1000 1000
localhost 60 2 0 0
NULL 2 2 1000 1000
60 0 0 0
Master has sent all binlog to 1 1 1000 1000
NULL 2 2 0 0
Usage | 100%
HandlerSocket NoSQL | Not Supported
# Percona XtraDB Cluster #####################################
Size | 16.0M
Usage | 80%
HitToInsertRatio | 600%
Version | 5.5.43-37.2
Buffer Pool Fill | 100%
Buffer Pool Dirty | 25%
Checkpoint Age | 4M
History List Len | 4285
Pending I/O Writes | 0 buf pool (0 LRU, 0 flush list, 0 page); 0 AIO, 0 sync, 0 log IO (1 log, 0 chkp); 0 pwrites
Pending I/O Flushes | 0 buf pool, 1 log
Transaction States | 64xnot started, 1xnot started flushing log
Key Cache | 16.0M
Pct Used | 25%
Users | 31 users, 0 anon, 0 w/o pw, 0 old pw
Binlogs | 80
Zero-Sized | 0
Total Size | 6.3G
binlog_format | MIXED
expire_logs_days | 10
sync_binlog | 0
server_id | 55
binlog_do_db |
binlog_ignore_db |
max_allowed_packet | 16M
thread_stack | 192k
log_error | /var/log/mysql/mysql.log
# The End ####################################################
MASTER:
pt-summary:
# Percona Toolkit System Summary Report ######################
Date | 2015-06-17 14:21:14 UTC (local TZ: MSK +0300)
Hostname | *******************
Uptime | ********************
System | System manufacturer; System Product Name; vSystem Version (Desktop)
Service Tag | System Serial Number
Platform | Linux
Release | Debian GNU/Linux 7.8 (wheezy) (wheezy)
Kernel | 2.6.32-5-amd64
Architecture | CPU = 64-bit, OS = 64-bit
Threading | NPTL 2.13
SELinux | No SELinux detected
Virtualized | No virtualization detected
# Processor ##################################################
Processors | physical = 1, cores = 4, virtual = 8, hyperthreading = yes
Speeds | 8x1600.000
Models | 8xIntel(R) Core(TM) i7-3770 CPU @ 3.40GHz
Caches | 8x8192 KB
# Memory #####################################################
Total | 15.4G
Free | 103.6M
Used | physical = 15.3G, swap allocated = 8.0G, swap used = 908.1M, virtual = 16.2G
Buffers | 381.7M
Caches | 11.7G
Dirty | 244 kB
UsedRSS | 3.9G
Swappiness | 60
DirtyPolicy | 20, 10
DirtyStatus | 0, 0
Locator Size Speed Form Factor Type Type Detail
========= ======== ================= ============= ============= ===========
ChannelA-DIMM0 4096 MB 1333 MHz DIMM DDR3 Synchronous
ChannelA-DIMM1 4096 MB 1333 MHz DIMM DDR3 Synchronous
ChannelB-DIMM0 4096 MB 1333 MHz DIMM DDR3 Synchronous
ChannelB-DIMM1 4096 MB 1333 MHz DIMM DDR3 Synchronous
# Mounted Filesystems ########################################
Filesystem Size Used Type Opts Mountpoint
/dev/md1 496M 12% ext3 rw /boot
/dev/md2 1016G 9% ext4 rw /
/dev/md3 1,8T 96% ext4 rw /home
# Disk Partioning ############################################
Device Type Start End Size
============ ==== ========== ========== ==================
/dev/md0 Disk 8588873728
/dev/md1 Disk 536858624
/dev/md2 Disk 1099510439936
/dev/md3 Disk 1891951246336
# Kernel Inode State #########################################
dentry-state | 46401 39451 45 0 0 0
file-nr | 1856 0 1614292
inode-nr | 48519 7346
# Network Config #############################################
Controller | Realtek Semiconductor Co., Ltd. RTL8111/8168B PCI Express Gigabit Ethernet controller (rev 09)
FIN Timeout | 60
Port Range | 61000
# Interface Statistics #######################################
interface rx_bytes rx_packets rx_errors tx_bytes tx_packets tx_errors
========= ========= ========== ========== ========== ========== ==========
lo 3500000000 300000000 0 3500000000 300000000 0
eth0 2000000000 4500000000 0 2000000000 35000000 0
# Network Devices ############################################
Device Speed Duplex
========= ========= =========
eth0 1000Mb/s Full
# Network Connections ########################################
Connections from remote IP addresses
States of connections
ESTABLISHED 15
FIN_WAIT1 1
LISTEN 15
SYN_RECV 1
TIME_WAIT 100
# Top Processes ##############################################
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
****** mysql 20 0 848m 226m 8168 S 6,2 1,4 37:46.47 mysqld
****** root 20 0 24404 1636 1084 R 6,2 0,0 0:00.01 top
1 root 20 0 10604 692 576 S 0,0 0,0 3:39.32 init
2 root 20 0 0 0 0 S 0,0 0,0 0:02.37 kthreadd
3 root rt 0 0 0 0 S 0,0 0,0 0:00.65 migration/0
4 root 20 0 0 0 0 S 0,0 0,0 6:22.36 ksoftirqd/0
5 root rt 0 0 0 0 S 0,0 0,0 0:00.00 watchdog/0
6 root rt 0 0 0 0 S 0,0 0,0 0:00.11 migration/1
7 root 20 0 0 0 0 S 0,0 0,0 1:04.94 ksoftirqd/1
# Notable Processes ##########################################
PID OOM COMMAND
**** -17 sshd
**** -17 udevd
pt-summary SLAVE:
Date | 2015-06-17 14:26:17 UTC (******)
Uptime | ******
System | ASUSTeK Computer INC.; KGP(M)E-D16; vSystem Version (Desktop)
Service Tag | ******
Kernel | 3.2.0-4-amd64
Processors | physical = 2, cores = 16, virtual = 32, hyperthreading = yes
Speeds | 16x1400.000, 16x2100.000
Models | 32xAMD Opteron(TM) Processor 6272
Caches | 32x2048 KB
Total | 94.6G
Free | 46.2G
Used | physical = 48.4G, swap allocated = 0.0, swap used = 0.0, virtual = 48.4G
Buffers | 230.5M
Caches | 34.0G
Dirty | 3192 kB
UsedRSS | 13.2G
DIMM_D1 16384 MB 1333 MHz DIMM DDR3 Synchronous
DIMM_D2 16384 MB 1333 MHz DIMM DDR3 Synchronous
DIMM_G1 16384 MB 1333 MHz DIMM DDR3 Synchronous
DIMM_G2 16384 MB 1333 MHz DIMM DDR3 Synchronous
DIMM_H1 16384 MB 1333 MHz DIMM DDR3 Synchronous
DIMM_H2 16384 MB 1333 MHz DIMM DDR3 Synchronous
DIMM_A1 {EMPTY} Unknown {OUT OF SPEC} DDR3 Synchronous
DIMM_A2 {EMPTY} Unknown {OUT OF SPEC} DDR3 Synchronous
DIMM_B1 {EMPTY} Unknown {OUT OF SPEC} DDR3 Synchronous
DIMM_B2 {EMPTY} Unknown {OUT OF SPEC} DDR3 Synchronous
DIMM_C1 {EMPTY} Unknown {OUT OF SPEC} DDR3 Synchronous
DIMM_C2 {EMPTY} Unknown {OUT OF SPEC} DDR3 Synchronous
DIMM_E1 {EMPTY} Unknown {OUT OF SPEC} DDR3 Synchronous
DIMM_E2 {EMPTY} Unknown {OUT OF SPEC} DDR3 Synchronous
DIMM_F1 {EMPTY} Unknown {OUT OF SPEC} DDR3 Synchronous
DIMM_F2 {EMPTY} Unknown {OUT OF SPEC} DDR3 Synchronous
******
dentry-state | 19702 15518 45 0 0 0
file-nr | 1600 0 9911237
inode-nr | 16998 294
# LVM Volumes ################################################
Unable to collect information
# LVM Volume Groups ##########################################
# RAID Controller ############################################
Controller | Fusion-MPT SAS
Connections to local IP addresses
Connections to top 10 local ports
ESTABLISHED 40
LISTEN 70
TIME_WAIT 3000
Базу перезаливали на слэйв много раз, не помогает!
Слэйв существенно мощнее мастера, из под root на слеэйве:
show processlist;
+----+-------------+-----------+------+---------+-------+----------------------------------+------------------+-----------+---------------+-----------+
| Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined | Rows_read |
| 2 | system user | | NULL | Connect | 40685 | Waiting for master to send event | NULL | 0 | 0 | 0 |
| 3 | system user | | NULL | Connect | 42875 | Reading event from the relay log | NULL | 0 | 1 | 1 |
| 7 | root | localhost | NULL | Query | 0 | NULL | show processlist | 0 | 0 | 0 |
show slave status;
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: **********
Master_User: *******
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000177
Read_Master_Log_Pos: 33395470
Relay_Log_File: mysqld2-relay-bin.000002
Relay_Log_Pos: 19206
Relay_Master_Log_File: mysql-bin.000177
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 19609659
Relay_Log_Space: 13805175
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 13282
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 55
1 row in set (0,00 sec)
Exec_Master_Log_Pos и Relay_Log_Space бегут, но Seconds_Behind_Master все больше и больше. На практике такое первый раз и это ненормально.....
Спасибо огромное, так и сделал! Вопрос закрыт!:)
Два диска с одним параметром монтирования (/boot) не позволяет загрузчик создать.
Bios boot partition нету в debian installation
загрузился с live CD . parted выдал:
Model: ATA ST3000DM001-9YN1 (scsi)
Disk /dev/sda: 3001GB
Sector size (logical/physical): 512B/4096B
Partition Table: gpt
Number Start End Size File system Name Flags
1 1049kB 500MB 499MB ext3 boot
2 500MB 3001GB 3000GB raid
Disk /dev/sdb: 3001GB
1 1049kB 500MB 499MB ext3 msftdata
echo "deb http://ftp.ru.debian.org/debian/ wheezy main contrib non-free" >> /etc/apt/sources.list apt-get update && apt-get install -y parted parted -l /dev/sda parted -l /dev/sdb
не найден кандидат на установку
поподробней пожалуйста
к сожелению такой программы не установлено, соответственно компьютер без выхода в интернет, стоит голый debian 7.8.0
/usr/sbin/grub-setup: Предупр: This GPT partition label has no BIOS Boot Partition; embedding won't be possible!.
/usr/sbin/grub-setup: ошибка: встраивание невозможно, но оно необходимо для междисковой установки.
