… libdbd-mysql-perl package. Fixed by adding the package dependency. Bug fixed #1003776. XtraDB changed page tracking used to hold the log… the log reads needlessly, potentially limiting performance on write-intensive workloads. Bug fixed #1171699. Missing path separator between the directory and file….04. Bug fixed #1186690. Under very rare circumstances, deleting a zero-size bitmap file at the right moment would make server stop…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… align=”alignright” width=”247″] Percona Server for MySQL version 5.6.11-60.3[/caption]… #1185686. Under very rare circumstances, deleting a zero-size bitmap file at the right moment would…page tracking used to hold the log system mutex for the log reads needlessly, potentially limiting performance…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…t open logfile ‘/var/log/corosync.log‘ for reason: Permission denied …MySQL [p_mysql] (unmanaged) p_mysql:0 (ocf::percona:mysql): Master percona1 (unmanaged) p_mysql:1 (ocf::percona:mysql): Slave percona2 (unmanaged) p_mysql:2 (ocf::percona:mysql… file /etc/corosync/service.d/pcmk you need to delete…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
…_Retry: 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_IO_Running… the master position has been deleted, replication will restart at the beginning of the first available binary log, which is very likely…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…–mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-log-… log file for debugging purposes. Streaming logs from stdin Percona Playback now supports the –query-log…changes to prevent INSERTs, UPDATEs, and DELETEs from corrupting the data on the …
Post: Be careful rotating MySQL logs
December 9, 2007 By 7 Comments
…. When log file is reopened MySQL will be practically unavailable causing unanticipated downtime. The workaround for this problem is very simple – instead of deleting MySQL log file – rename it, call “FLUSH LOGS” which will be instant as it will not involve complex delete operation and when you can delete the log file…
Post: How to change innodb_log_file_size safely
July 9, 2011 By 17 Comments
If you need to change MySQL’s innodb_log_file_size parameter (see How to calculate a good InnoDB log file size), you can’t… away (don’t delete) the log files, which are named ib_logfile0, ib_logfile1, and so on. Check the error log to ensure there… delete the old log files. The typical error message you’ll see in the client when InnoDB has refused to start due to log file…
Post: Percona XtraDB Cluster (PXC): what about GRA_*.log files ?
December 19, 2012 By Leave a Comment
…: MySQL replication log Now we need to select one GRA log file: [root@node2 mysql]# ls GRA_*.log GRA_3_3.log [root@node2 mysql]# file GRA_3_3.log GRA_3_3.log: data [root@node2 mysql]# ls… they really represent a problem or not, you can manually delete them. This was also discussed in galera-codership mailing list…
Post: Backing up binary log files with mysqlbinlog
January 18, 2012 By 2 Comments
… the binary log files which could still lead to data loss depending on the interval you back them up. Recently in MySQL 5… that supports connecting to remote MySQL instances and dumping binary log data to local disks ( http://dev.mysql.com/doc/refman/5.6…. By default if you do not supply the binary log file, mysqlbinlog deletes and overwrites them all that is undesired behaviour in our…
Post: Recovery deleted ibdata1
August 10, 2012 By 9 Comments
… case when a customer deleted the InnoDB main table space – ibdata1 – and redo logs – ib_logfile*. MySQL keeps InnoDB files open all the time… existence of these files! But after the restart InnoDB will detect that there is neither system table space nor log files, so it…. Let’s simulate the accident. For that I will delete /var/lib/mysql/ib* files, while sysbench generates read/write activity: Screen0: root…
