Always remain updated about current software development trends

Articles having tag: INNODB

Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5

By Ovais Tariq

This is the second blog post in the series of blog posts leading up to the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. This blog post is aimed at the optimizer enhancement Multi Range Read (MRR). Its available in both MySQL 5.6 and...

A Story of MySQL and InnoDB at Facebook Told by Mark Callaghan

By Alex Popescu

A Story of MySQL and InnoDB at Facebook Told by Mark Callaghan:Just whetting your apetite for this interview with Mark Callaghan about MySQL, InnoDB, and his work at Facebook: Q: How do you make MySQL both "less slow" and "faster" at...

Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact

By Ovais Tariq

I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one. So in the same way this blog post is aimed at a new optimizer...

WhySQL: MySQL/InnoDB ACID Guarantees for Evernote

By Alex Popescu

WhySQL: MySQL/InnoDB ACID Guarantees for Evernote:Dave Engberg has published on the Evernote Techblog a post explaining why the Atomicity, Consistency, and Durability characteristics of a single replicated MySQL/InnoDB deployment are essential to the way Evernote...

The relationship between Innodb Log checkpointing and dirty Buffer pool pages

By Jay Janssen

This is a time-honored topic, and there’s no shortage of articles on the topic on this blog. I wanted to write a post trying to condense and clarify those posts, as it has taken me a while to really understand this relationship. Some basic facts Most...

Optimizing InnoDB for creating 30,000 tables (and nothing else)

By Stewart Smith

Once upon a time, it would have been considered madness to even attempt to create 30,000 tables in InnoDB. That time is now a memory. We have customers with a lot more tables than a mere 30,000. There have historically been no tests for anything near this many...

MySQL 5.6.4 Development Milestone Now Available!

By Rob Young

I am pleased to announce that the MySQL Database 5.6.4 development milestone release ("DMR") is now available fordownload (select the Development Release tab). MySQL 5.6.4 includes all 5.5 production-ready features and provides an aggreation...

MySQL 5.6.4 Development Milestone Now Available!

By Rob Young

I am pleased to announce that the MySQL Database 5.6.4 development milestone release ("DMR") is now available fordownload (select the Development Release tab). MySQL 5.6.4 includes all 5.5 production-ready features and provides an aggreation...

Full-Text Search with InnoDB

By Bertrand Matthelié

@font-face { font-family: "Arial"; }@font-face { font-family: "Times"; }@font-face { font-family: "Cambria"; }p.MsoNormal, li.MsoNormal, div.MsoNormal { margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman"; }a:link, span.MsoHyperlink...

Full-Text Search with InnoDB

By Bertrand Matthelié

@font-face { font-family: "Arial"; }@font-face { font-family: "Times"; }@font-face { font-family: "Cambria"; }p.MsoNormal, li.MsoNormal, div.MsoNormal { margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman"; }a:link, span.MsoHyperlink...