June 18, 2013

Post: How Percona does a MySQL Performance Audit

…operating parameters are. Can…database. The first step is to find out what MySQLrun the following: wget http://hackmysql.com/scripts/mysqlsla perl mysqlsla -lt slow /path/to/slow.logMySQL Proxy, packet sniffing, or other techniques to get more information than the slow log…be changed. Queries…on while

Post: The new cool MySQL patch has landed! Check your queries performance!

LOGGING OF THE REPLICATED STATEMENTS Normally MySQL will not write into slow log any queries executed by the slave’s SQL thread. This patch allows you to change that behavior with the new parameterlog-slowrun successfully under stress with both synthetic benchmarks and real database

Post: Updated msl (microslow) patch, installation walk-through!

mysql-5.0.51a) % su root Password: First you should apply the changes to the database configuration, specifically you need to enable slow loggingdatabase configuration, load, etc. Configuration There are several parameters related to slow log

Post: Detailed review of Tokutek storage engine

run some benchmarks. Tuning of TokuDB is much easier than InnoDB, there only few parameters to change, and actually out-of-box things runninglogs put into mysql, application performance logs to more complex log like clicks, user movements and actions on site, visits tracking etc. While

Post: SHOW INNODB STATUS walk through

while workload being IO bound still. Next, number of file IO operations is shown as well as computed averages. This is parameterslog sequence, all changes up to which has been flushed from buffer pool. Changes having higher log sequences may still only be recored in logsDatabase

Comment: Database problems in MySQL/PHP Applications

parametersWhileMySQL Could be slow with Large Tables article. Deciding whether or not to let the databasechanges are being made on the master and all those changesdatabase with reasonable > amount of data in it. And do run EXPLAIN for your queries, especially > if you see them in slow query log

Post: Analyzing air traffic performance with InfoBright and MonetDB

…example I also run the same …version: 5.1.14-log build number (… is: mysql -S /tmp/mysql-ib.sock …query for any database benchmarker is SELECT…rows, the slowness here is similar …. Results with changes: Years, InfoBright, MonetDB … pass query as parameter, otherwise I… I understand), while InfoBright ICE …