A lot of people are running MySQL Master-Master replication pairs in Active-Passive mode for purpose of high availabilities using MMM or other solutions. Such solutions generally have one major problem – you have to be very carefully switching writes as if you do not do it atomically (such as some scripts […]Read more
Mark Callaghan has graciously accepted to be the closing keynote speaker for Percona Live: San Francisco!
Mark is best known for his work behind MySQL @ Facebook, where he and his team maintain one of the largest MySQL installations around.Â They also contribute back to the community with a publicly available branch of enhancements, improved […]
When does Innodb Start Transaction ? The answer looks obvious – when you issue “BEGIN” command. This is however wrong answer from engine point of you. Run “SHOW INNODB STATUS” and you will see “not started” status in transaction list.
It is only when you read (or write) to INNODB table […]
Percona Server version 5.1.54-12.5 is now available for download. It is now the current stable release version.
Functionality Added or Changed
Percona ServerÂ 5.1.54-12.5 is based on MySQL 5.1.54.
New Features Added: None
Added system variable innodb_log_block_size and new value “keep_average” to system variable adaptive_checkpoint in Improved InnoDB I/O Scalability. (Yasufumi Kinoshita)
AddedÂ new value “ALL_O_DIRECT” to […]
Finding bad queries is a big part of optimization. A scientific optimization process can be simplified to “can anything be improved for less than it costs not to improve it? – if not, we’re done.” In databases, we care most about the work the database is doing. That is, queries. […]Read more
I’ve posted a new white paper about the implementation and benefits of Percona Server’s fast-restart capabilities. Briefly, after shutting down and restarting or rebooting the server, it can be back to full performance in a couple of minutes. That’s minutes, not hours or days. This matters a lot for keeping uptime […]Read more
I am constantly referring to the amazing MySQL manual, especially the option and variable reference table. But just as frequently, I want to look up blog posts on variables, or look for content in the Percona documentation or forums. So I present to you what is now my newest Firefox toolbar bookmark: […]Read more
On January 31st, I’ll be giving a webinar whose title is “Choosing a High-Availability Solution”. Although the subject is not new, we keep receiving many questions regarding HA and MySQL so we thought it would be a good idea to present a webinar on the topic. The content will be a revised […]Read more
I again work with the system which needs high insertion rate for data which generally fits in memory. Last time I worked with similar system it used MyISAM and the system was built using multiple tables. Using multiple key caches was the good solution at that time and we could get over […]Read more