May 24, 2012

Post: Load management Techniques for MySQL

… MySQL configuration, queries and hardware, even though fixing these does help in many cases. Whatever powerful and well tuned system you…” between them can be a good idea. It also often helps with monopolizing replication thread. For example if I need to…

Comment: mysql-proxy, urgh performance and scalability ?

… a solution for production server. was wondering if you can help in installation and configuration, tutorials or anything, as i tried…

Comment: Joining many tables in MySQL - optimizer_search_depth

Ovais, Syntactic hints surely help pushing the performance in case of particular queries but surely …

Comment: How to load large files safely into InnoDB with LOAD DATA INFILE

…! As I was reading the part about replication, can you help re-affirm this statement about replication? I’ve observed things…

Post: Introducing Zend DBi as a MySQL Replacement on IBM i

… forward for IBM i users, and asked if we’d help them. We’re delighted to do so. The result is…

Comment: How to change innodb_log_file_size safely

… many other configuration values have been ignored. Thanks for your help Baron.

Comment: How to change innodb_log_file_size safely

… i’m overlooking. this seems dead simple. thanks for any help. chris

Comment: How to calculate a good InnoDB log file size

Hi! I come from Viet Nam. Now i want to check capacity (free space & used space) of datafile on InnoDB (MySQL). How to command? I just research for MySQL, hope you help me. Big thanks!

Comment: What to tune in MySQL Server after installation

… while loop in my application. I request to all please help me to resolve the issue. I shall be thankful to…

Post: Testing STEC SSD MACH16 200GB SLC

… to see how stable the performance is, and it really helps to observe some artifacts, as you will see in following…