…database, all SELECT queries, even those participating in read-only transactions, start suffering from…mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
…MySQL database…Select the image file (about 1.8GB .img file) and select the destination drive to write the image to. Make sure you selected…mysql-clients-5.5.30-1-armv6h 736.6 KiB 395K/s 00:02 [########################################################] 100% :: Retrieving packages from…
Post: Recovering CREATE TABLE statement from .frm file
December 17, 2008 By 5 Comments
…from .frm file ? Recovering from .frm for Innodb Table If we simply copy .frm file back to the database we will see the following MySQL… test]# mysql test; Reading…mysql> select * from test_innodb; ERROR 2013 (HY000): Lost connection to MySQL server during query Recovering CREATE TABLE from .frm file…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…mysql> select * from information_schema.innodb_buffer_pool_stats\G *************************** 1. row *************************** POOL_ID: 0 POOL_SIZE: 8191 FREE_BUFFERS: 1024 DATABASE_PAGES: 7162 OLD_DATABASE…
Post: Concatenating MyISAM files
November 19, 2012 By 5 Comments
…select * from MyISAM_table1 and so on for the 16 files. Since MyISAM are flat files…mysql: mysql> use test Database changed mysql> flush tables; Query OK, 0 rows affected (0.00 sec) mysql> select * from…
Post: Announcing Percona Playback 0.5
November 26, 2012 By
… of one database server to another. Currently it can read queries from MySQL query-log and tcpdump files and run them on other MySQL server. With… run on the original. Additional statistics, like the query types (SELECT, UPDATE,…) with the proportion off faster and slower statement for…
Post: Quickly finding unused indexes (and estimating their size)
December 5, 2012 By 2 Comments
… their database size on…from several servers In the case of this client, they had a master and several slaves taking read…SELECT. I can now select my droppable (unused) indexes from this view: mysql> select * from…file_per_table, then you can rebuild the tablespace for your table by simply doing: mysql…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
…mysql -e ‘select * from flexviews.binlog_consumer_status\G’ -uroot *************************** 1. row *************************** server_id: 999 master_log_file…select from that table you won’t see anything changing, even if you are writing into your database…
Post: Replaying database load with Percona Playback
October 25, 2012 By 9 Comments
…any configuration change on your MySQL database the first advice usually is: – …run both SELECT and DML queries. There is still no –read-only parameter…mysql-host=127.0.0.1 –mysql-user=root –mysql-schema=my_db –query-log-file… expected 211 for query: SELECT DISTINCT ol_i_id FROM order_line WHERE ol…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
… from the slaves, no master to master setup needed. Selection…MySQL is already running. It should match the my.cnf pid_file setting. socket: The MySQL unix socket file…read_only setting on the slave so, make sure the application database use doesn’t have the SUPER privilege which overrides read…
