PUBLIC MARKS with tags performance & mysql

Avec MySQL Proxy, vous serez capable de filtrer les requêtes avant de les transmettre au serveur, réécrire certaines requêtes, rediriger les écritures sur le maître et les lectures sur l'esclave dans le cas de réplication, etc.

I gave a tutorial at OSCON last week on tuning MySQL queries, the EXPLAIN statement, the optimizer, and benchmarking. I've gone ahead and put the tutorial materials online now:

talks about current state behavior and performance properties of Innodb, Falcon, PBXT and SolidDB Storage Engines

In this article, we're going to go through the entire process of installing, configuring and testing DRBD, Heartbeat and MySQL running in a 2 node cluster environment. This will be a bare bones configuration, best practices and security will take a back seat while we learn how all the different pieces work together.

Stories of heavy-duty services relying on MySQL

already digged deeper

If you read the MySQL manual you might have seen the ORDER BY RAND() to randomize the the rows and using the LIMIT 1 to just take one of the rows.

Quelques conseils pour améliorer les perfs InnoDB

What is often underestimated is impact of MySQL Performance by complex queries on large data sets(ie some large aggregate queries) and batch jobs. It is not rare to see queries which were taking milliseconds to stall for few seconds, especially in certain OS configurations, and on low profile servers (ie having only one disk drive) even if you just have one such query running concurrently.

Conseils pour l'amélioration des performances InnoDB