… the MySQL manual. You can configure the slave to only replicate a specific database, a set of databases, or … same machine if you use the BLACKHOLE storage engine) in between the actual master and the slaves… of SHOW PROCESSLIST that might be a sign that trouble is brewing. Or if you watch your MySQL…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… the show with keynotes and I recall one of them saying something like, “12 full-time engineers are working on MySQL server.” The MySQL… and MaxDB database looked like it had a solid future. MySQL Cluster and MySQL Press were announced during this event; “High Performance MySQL” 1st…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…the waters of the MySQL buffer pool is a cross-post from Groupon’s engineering blog, and …server has an issue. At Groupon, our standard MySQL database configuration follows this active/passive pattern. There is…this (we did 39 measurements), the next graph shows chunk 4’s workload warmed up with chunk…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… combinations with taskset. The following chart shows a results comparison on a single-…-trivial amount of updates to the database, all SELECT queries, even those participating…0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… ON Frm file corrupt, zeroed out, lost or SHOW CREATE TABLE crashes MySQL There is yet another source of information about the…, PRIMARY KEY (`NAME`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 `NAME` is a human readable table name in form database_name/table_name e…_ID`,`POS`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 Fields names explain their content. Index id in our example is 1679: mysql> SELECT * FROM…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… amazing MySQL manual, especially the option and …show_databasesblogpercona.commanual Com_show_engine_logsblogpercona.commanual Com_show_engine_mutexblogpercona.commanual Com_show_engine_statusblogpercona.commanual Com_show_errorsblogpercona.commanual Com_show_eventsblogpercona.commanual Com_show…
Post: Be productive with the MySQL command line
December 21, 2012 By 14 Comments
… to the rescue: mysql> pager grep sequence PAGER set to ‘grep sequence’ mysql> show engine innodb status\Gselect sleep(60);show engine innodb status\G Log … with -A Database changed mysql> select count(*) from sakila; ERROR 1146 (42S02): Table ‘sakila.sakila’ doesn’t exist mysql> select count(*) …
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
…MySQL database …mysql client: [root@alarmpi ~]# /usr/bin/mysql Welcome to the MySQL monitor. Commands end with ; or \g. [...] mysql> SHOW ENGINES; +——————–+———+—————————————————————————-+————–+——+————+ | Engine…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
…database server for those things which need to be cached — system files, binary log, FRM files, MySQL MyISAM system tables etc. Starting MySQL… over time: mysql> show table status like “post_channel” \G *************************** 1. row *************************** Name: post_channel Engine: InnoDB …
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… with your own optimized settings and one database engine would like to use itself. At this … performance it will give. As “SHOW TABLE STATUS” is not showing index sized in the release … MySQL Storage Engine level for MySQL – reading rows in their physical order can be applied to most storage engines…
