June 19, 2013

Post: Reasons for MySQL Replication Lag

July 29, 2011 By 9 Comments

… change, though often subtle as computers are state machines and with no external and internal … pool size could cause performance problems. MySQL Restart MySQL Restarts may include recovery time but what … can hurt replication traffic well after they are ended. I’ve seen cases when overly eager …

Filed Under: Insight for DBAs, MySQL Tagged With:

Post: Percona Live MySQL Conference and Expo 2013: The talks I want to see

February 12, 2013 By 4 Comments

…’d probably end up in Galera Cluster Best Practices, though I’ve heard that talk from Seppo (Codership) before. MySQL Query Anti… why it’s a hard problem to solve. State of the Art for MySQL Multi-Master Replication - (Robert Hodges, Continuent) –  Robert is… instruction about what some migration strategies might look like. Using MySQL Performance Schema to debug performance issues - (Zburivsky Danil, Pythian) – I…

Filed Under: Events and Announcements, MySQL, Percona Live Tagged With: , ,

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

…_time | | | optimize_end_time | | | stopword_table_name | | | use_stopword | 1 | | table_state | 0 | +—————————+———+ 10 rows in set (0.02 sec) mysql> optimize table…_time | | | optimize_end_time | | | stopword_table_name | | | use_stopword | 1 | | table_state | 0 | +—————————+———+ 10 rows in set (0.00 sec) mysql> delete from…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark

March 11, 2013 By 7 Comments

…MySQL 5.5 and MySQL 5.6, no tuning at all Config 2: MySQL… changes which pages end up staying …state = p2.state order by p1.duration desc; +—–+———————-+———–+———-+———–+———–+——-+——-+————–+————–+——-+——-+ | seq | state | …

Filed Under: MySQL Tagged With: , , , , ,

Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes

July 25, 2012 By 6 Comments

… test to use the mysql server: [root@percona1 ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 868…: Local state seqno (6) is greater than group seqno (5): states diverged. Aborting to avoid potential data loss. Remove ‘/var/lib/mysql//grastate…

Filed Under: MySQL, XtraDB Cluster

Post: Automation: A case for synchronous replication

September 19, 2012 By 2 Comments

… rotation for some reason… with essentially zero impact to the end user. The performance problems are also handled different way – the… they often fail harder than MySQL Replication, taking longer time to recover and get back to operational state. Conclusion: If you’re looking for setting up HA solution for MySQL check out synchronous replication based solutions in additionally to MySQL…

Filed Under: Insight for DBAs, MySQL

Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A

October 28, 2012 By 4 Comments

…to perform a state transfer, which can be IST (Incremental State Transfer) and SST (Snapshot State Transfer). If… on asynchronous replication, galera and built-in mysql replication are independent from each other. Q:… because of this option, and you can end up having 2 different clusters serving data…

Filed Under: MySQL, XtraDB Cluster

Post: Percona XtraDB Cluster (PXC): what about GRA_*.log files ?

December 19, 2012 By Leave a Comment

…: data [root@node2 mysql]# ls -l GRA_3_3.log -rw-rw—-. 1 mysql mysql 106 Nov 29 23…TIMESTAMP meta=0 nullable=0 is_null=0 */ DELIMITER ; # End of log file ROLLBACK /* added by mysqlbinlog */; /*!50003…7af1ab8e-3a70-11e2-0800-66155499f3af version: 2 local: 0 state: APPLYING flags: 1 conn_id: 8 trx_id:…

Filed Under: MySQL, Percona Software, XtraDB Cluster

Post: Shard-Query EC2 images available

May 11, 2011 By 2 Comments

…PRIMARY KEY (`airport_id`), KEY `CityName` (`CityName`), KEY `State` (`State`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT=’… from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_…[1] 12359 $ tail -f ./raw — Q1 … At the end, you will get a result output …

Filed Under: MySQL

Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables

March 23, 2012 By 20 Comments

…mysql> show processlist; +——-+——+———–+———-+———+——+————————-+—————————–+———–+—————+———–+ | Id | User | Host | db | Command | Time | State…

Filed Under: Insight for DBAs, MySQL
« Older Posts
Newer Posts »