…/lib/mysql/ib_logfile* -rw-rw—- 1 mysql mysql 536870912 May 21 22:23 /var/lib/mysql/ib_logfile0 -rw-rw—- 1 mysql mysql 536870912 May…_now_faster And from the manual: http://dev.mysql.com/doc/refman/5.5/en/innodb-performance-recovery.html “If you kept… redo log files artificially low because recovery took a long time, you can consider increasing the file size.”
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… nutshell, here is how one would start the memcached plugin: mysql> install plugin daemon_memcached soname ‘libmemcached.so’; In an effort… for setting up the plugin: http://dev.mysql.com/doc/refman/5.6/en/innodb-memcached-setup.html As a quick benchmark… additional memcached hardware Cost of operations time to maintain an additional system Impact of warmup time to application Cost of disk space…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… the MRR optimization available in MySQL 5.6 here: http://dev.mysql.com/doc/refman/5.6/en/mrr-optimization.html and as… query time for MySQL 5.6, increase of 0.02s. But the query times for MariaDB 5.5 are greater than both MySQL 5…, and the query time for MySQL 5.6 and MariaDB 5.5 jumps to ~11min (this is the query time for MySQL 5.5…
Post: Getting MySQL Core file on Linux
August 26, 2011 By 1 Comment
… consider two things – disk space and restart time. The core file will dump all MySQL Server memory content including buffer pool which… wrong easier, you may be looking at many times the amount of memory MySQL consumes worth of disk space. You have to…/sbin/mysqld[0x516a61] The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find…
Post: FOSDEM 2013: MySQL And Friends Community Dinner
January 16, 2013 By 3 Comments
… years, the ‘MySQL And Friends’ community is gathering to have a dinner on the Saturdaynight of FOSDEM. This time it is on…?lang=en Chaussée de Boondael, 455 1050, Ixelles If you wish to attend, please register at http://fosdemmysqlandfriendsdinner2013.eventbrite.com FOSDEM MySQL… Schedule is available at https://fosdem.org/2013/schedule/track/mysql_and_friends/ I also recommend joining us on Friday for…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… 0 to the time those looping statement were first inserted. Another way to see it is by monitoring your MySQL server with… master (mysql 1) is changed to the position returned by SHOW MASTER STATUS on mysql 4 (this position will increase every time writes…://dev.mysql.com/doc/refman/5.1/en/replication-implementation-details.html [2] http://dev.mysql.com/doc/refman/5.1/en/replication-options…
Post: New variable slave_max_allowed_packet for slave servers
July 24, 2012 By 2 Comments
… I’m going to deliver MySQL Training (Sep 3-6) in Madrid. This is the first time we are going to deliver… the previous link to get more information. En Septiembre voy a impartir Formación de MySQL en Madrid (Sep 3-6). Está será la primera vez que se dará la formación en Español 
Si estás interesado haz click en…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take…
Post: Handling big result sets
June 26, 2006 By 13 Comments
…MYSQL_NUM)) { } // Free resultset mysql_free_result($result); $time_end = microtime(true); $time = $time_end – $time_start; echo “execution time: “.$time.” s”; mysql_close($link); ?> Inital execution time…? Let’s look mysql_query function: http://www.php.net/manual/en/function.mysql-query.php. …
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
…to distribute the computation of aggregation queries over time. I realised that I could apply these same…resource which speaks SQL, but right now only MySQL storage nodes are supported. Amdahl’s law applies…materialized views: http://scholar.google.com/scholar?hl=en&lr=&q=related:Y6OKUW79CGQJ:scholar….
