…in logs and not flushed from buffer pool so such log sequences can’t be overwritten in log files. By monitoring log sequence number and value up to which logs…in buffer pool, number of pages free, pages allocated by database pages and…
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
…and replica are different. binary log should be a good place to look for these. OK, the procedure: 1. on monitor…changes in parallel and…database size, scope of changes, and…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…and it well can affect your workload. So benchmark to be sure. In Innodb besides scalability changes in…in it was only recently found and fixed: http://bugs.mysql.com/bug.php?id=29560 Concerning a switch to Oracle’s main database…
Post: Filling the tmp partition with persistent connections
August 6, 2012 By 14 Comments
…binary log file. The application connects to the database using…in two, binlog_cache_size to hold transactions data and binlog_stmt_cache_size to hold non-transactional statements. Change… killing system in the end. Conclusion MySQL can creates …the best solution is to monitor your system. If your…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…in plain text. You can also use this for monitoring purposes (the CSV version is good for trending and alerting). Here MySQL…database and a userfor it. mysql> create database sbtest; Query OK, 1 row affected (0.01 sec) mysql…
Post: Effect of adaptive_flushing
December 4, 2009 By 5 Comments
… data. mysql> SHOW INNODB STATUS\G …. Database pages 2318457 Old database pages 855816 Modified db pages 457902 Log … really surprised. We can see a change in disk IO which mirrors the innodb pages…and not blindly follow advice you read on the internet, and have good monitoring and trending tools in…
Comment: Why you don't want to shard.
August 6, 2009 By 34 Comments
…monitoring systems. – Schema changes and other migrates are not always that much of a problem. If your entire development team is on the mysql…to change the database, not queries. This gives error handling, logging, full historys of everything that gets changed, and a number of other benefits. In …
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…MySQL for binary backups mydumper for logical backups mysqlbinlog 5.6 Amazon S3 monitoring…ALTER DATABASE DEFAULT CHARACTER SET
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
…And if you test to use the mysql server: [root@percona1 ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL…database inconsistency. We can bypass this behaviour by ignoring the split-brain by adding wsrep_provider_options = “pc.ignore_sb = true” in…
Post: Recovering CREATE TABLE statement from .frm file
December 17, 2008 By 5 Comments
…and we do ask for them for a different reason anyway) but there is never guaranty there were no schema changes in…MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 17 Server version: 5.1.30-community-log MySQL…
