May 26, 2012

Post: MySQL Consulting - Being on your own

… Great The market is now great for MySQL Consulting. The number of MySQL users is growing rapidly thanks for MySQL Marketing and Sales departments and…. It may be as simple as adding few indexes and tuning MySQL Server settings. It is more the question of knowing there to… it for free as it would not be worth billing hassles anyway. We also answer a lot of questions on our forum

Post: The ultimate tool for generating optimal my.cnf files for MySQL

… many years of experience, deep knowledge of MySQL and the full application stack, and familiarity …tuning primer or question-and-answer script that spits out “optimal” parameters for my.cnf. Most of the time these servers… advice you see on the web in forums — much of it is fundamentally wrong, even…

Page: Presentations

MySQL Server Settings Tuning MySQL Users Conference 2007, Santa Clara,CA, April 2007 Presentation covering most important MySQL Settings which should be tuned for optimal MySQL

Post: MySQL Users Conference Presentation Proposals

forum posts. Transactional Storage Engines Performance We’re looking at performance at Open Source Transactional Storage engine MySQLServer Without Breaking User Experience MySQL Replication is asynchronous this means you should be using slaves only for

Post: Return of the Query Cache, win a Percona Live ticket

…cache single choke-point in the server. Now that’s gone. As of MySQL 5.5, the query cache … cache tuning guide. The second important change is really minor. It didn’t improve anything in the server‘…serious contention when it happens. For example, it alerted a user on our forum to the fact that the …

Comment: Innodb Performance Optimization Basics

…regularly and getting suggestions from the forums I’ve been able to …10 seconds! Now that I’ve tuned everything up in the settings …settings too high and restart your mysql server, mysql wont instantly complain. What I think… impair your performance! My only wishes for mysql would be that they would …