… and restart it: mysql> show slave status\G [...] Slave_IO_Running: No Slave_SQL_Running: Yes [...] The error log tells us why the… not on slave #2: # slave #1 mysql> change master to master_auto_position = 1; mysql> start slave; and let’s create a… slave status\G [...] Auto_Position: 1 -> GTID-based positioning # Slave #2 mysql> show slave status\G [...] Auto_Position: 0 -> File-based positioning Conclusion…
Comment: How to calculate a good InnoDB log file size
May 21, 2013 By 38 Comments
…—- 1 mysql mysql 536870912 May 21 22:23 /var/lib/mysql/ib_logfile1 Tue May 21 22:23:15 CDT 2013 Log sequence number 17750417191 Tue May 21 22:24:15 CDT 2013 Log sequence number 17750981011 -rw-rw—- 1 mysql mysql 536870912 May 21 22:24 /var/lib/mysql/ib_logfile0 -rw-rw—- 1 mysql mysql 536870912…
Comment: How to calculate a good InnoDB log file size
May 22, 2013 By 38 Comments
…—- 1 mysql mysql 536870912 May 22 12:55 /var/lib/mysql/ib_logfile1 Wed May 22 13:34:00 CDT 2013 Log sequence number 18342929533 Wed May 22 13:35:00 CDT 2013 Log sequence number 18343465682 -rw-rw—- 1 mysql mysql 536870912 May 22 13:35 /var/lib/mysql/ib_logfile0 -rw-rw—- 1 mysql mysql 536870912…
Comment: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
Wow, I pulled all the 300GB drives out of my MySQL servers years ago. I don’t need the space of… old drives. So fast, that for linear writes, like httpd logs, they are as fast as older SSDs. But the newer… as big, and much faster than the 300GB HDDs, on MySQL type loads.
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
… node is crashed and I have this error in my log : 07:53:55 UTC – mysqld got signal 11 ; This could…:53:56 mysqld_safe mysqld from pid file /var/lib/mysql/srv-d2-mysql02.pid ended in an another environment I…
Post: Rotating MySQL slow logs safely
April 18, 2013 By 7 Comments
… still being executed. To prevent MySQL from filling the slow log buffer, we disable the MySQL slow logs temporarily during log rotation. Putting it all… configuration file for a slow log that illustrates these best practices: /var/mysql/slow_query.log { nocompress create 660 mysql mysql size 1G dateext missingok…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
…: 60 Master_Log_File: Read_Master_Log_Pos: 4 Relay_Log_File: mysql_sandbox35302-relay-bin.000001 Relay_Log_Pos: 4 Relay_Master_Log_File: Slave…: 60 Master_Log_File: Read_Master_Log_Pos: 4 Relay_Log_File: mysql_sandbox35302-relay-bin.000001 Relay_Log_Pos: 4 Relay_Master_Log_File: Slave… Connect_Retry: 60 Master_Log_File: Read_Master_Log_Pos: 4 Relay_Log_File: mysql_sandbox18676-relay-bin.000001 Relay_Log_Pos: 4 [...] As stated…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… slow log volume.) The slow logs are served, via HTTP, by mysql_slowlogd. This daemon is similar to running `tail -f slow.log`, except…/slow | percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-log-stdin –dispatcher-plugin thread…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… Percona Server for MySQL 5.5.28-29.3 which could cause a server to hang when binary log is enabled. Bug… contention on log_sys->mutex in write-intensive workloads. Bug fixed #1163439 (Alexey Kopytov). Ported back from the upstream MySQL 5.6 the fix for unnecessary log_flush_order_mutex acquisition. Bug fixed #1163262…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
Galera/Percona XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users jump … sure to go through these basics. log_slave_updates is REQUIRED You need to have log_slave_updates enabled on the cluster… will not be written to the slave’s binary unless log_slave_updates is enabled, this is similar to Percona XtraDB…
