MySQL indexes are often used to make performance better. However, they can make performance suffer if you are not using them properly. MySQL Guru Sheeri Cabral explains the pitfalls to avoid with indexes and how to utilize compound indexes to maximize index availability with the least amount of write overhead. …
When MySQL was owned my MySQL AB it was doomed because it was a “toy” database. Soon after Sun bought MySQL AB for $1billion there was concern that MySQL was doomed at Sun…. and when Oracle bought Sun things looked even worse. That being said, the truth is a lot …
Gerry Narvaja of Tokutek discusses Performance at Scale with TokuDB. TokuDB is an open source, high-performance storage engine for MySQL and MariaDB that dramatically improves scalability and operational efficiency. TokuDB is for Big Data applications with demanding requirements that are not met by the your current storage engine, and reduces …
Many strategies exist for increasing the performance of a MySQL database. Some attempt to make each access to the data faster: for example, faster hardware may be used, or system settings may be tweaked. Other approaches attempt to decrease the total number of database operations: for example, by caching database …
Learn if running MySQL 5.6 on Amazon RDS is a viable solution for your business. Percona’s Consultant Ryan Lowe discusses the benefits, challenges, and keys to success when running MySQL 5.6 on Amazon RDS.
Troubleshooting MySQL doesn’t need to involve trial-and-error, and it doesn’t need to take a long time. You need only two things: a good process and good tools. This session will show you an approach that the speaker has used to solve many frustrating problems quickly, and open source tools that …
