In my post MySQL 5.5.8 and Percona Server: being adaptive I mentioned that I used … FusionIO 320GB MLC card, and run tpcc-mysql benchmark with 500W using Percona Server 5.5.8. Here is relevant part of config what…), and another with –innodb-log-block-size=4096. Full benchmark command is tpcc_start localhost tpcc500 root “” 500 24 10 3600…
Post: Common MySQL traps webinar questions followup
January 17, 2013 By 1 Comment
…(15) could be good to store such values (A CHAR(8) too, but it will become a problem if you need… all versions of MySQL? If not which versions? The recommendations I made are valid for all versions up to 5.5, and most should still be valid with 5.6. Q: I have good command of SQL query writing and wanted to learn MySQL…
Post: MySQL Query Cache WhiteSpace and comments
March 20, 2008 By 9 Comments
… like “%c%”; +———-+ | count(*) | +———-+ | 0 | +———-+ 1 row in set (8.79 sec) mysql> select count(*) from fact where val like “%c%”; +———-+ |… MySQL Command Line Client for any tests involving comments Repeating queries from PHP instead we can learn the following about MySQL 5….
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018 … 0 TABLE_ROWS_READ: 610954 SELECT_COMMANDS: 181243 UPDATE_COMMANDS: 0 OTHER_COMMANDS: 0 COMMIT_TRANSACTIONS: 181243 ROLLBACK_TRANSACTIONS…469.31 0.99 # Bytes sent 8.77G 11 55.41M 5.15k 3.88k 258.55k 1….
Post: Percona testing: Quick test clusters with kewpie!
January 13, 2012 By Leave a Comment
… -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 Server version: 5.5.17-log Source distribution wsrep… -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 Server version: 5.5.17-log Source distribution wsrep…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
… the mysql server: [root@percona1 ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 868 Server version: 5.5.24… INFO: view(view_id(PRIM,577c0ad0-d570-11e1-0800-198f7634d8ec,8) memb { 577c0ad0-d570-11e1-0800-198f7634d8ec, 593e68c8-d570-11e1-0800…
Post: Copying InnoDB tables between servers
July 31, 2009 By 11 Comments
… now available in our latest releases of XtraBackup 0.8.1 and XtraDB-6. Now I am going …tv). Let’s take tpcc schema and running standard MySQL ® 5.0.83, and assume we want to copy …MysqlDataDir/testimport dir. When it’s done, final import command: alter table order_line import tablespace; now some …
Post: Recovering Linux software RAID, RAID5 Array
August 27, 2011 By 2 Comments
Dealing with MySQL you might need to deal with RAID recovery every so …/sdc3 3 0 0 3 removed 4 8 67 4 active sync /dev/sde3 5 8 83 5 spare rebuilding /dev/sdf3 In this… do it. It could be by design as using such commands wrong way can ruin your RAID array. What you can…
Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances
June 29, 2010 By 9 Comments
…command compared to the web based console. Create the security group The instances involved in the MySQL…3]; $STATUS = $fields[5]; $START…8-042548a451fce8400660f6031f4da6f0223dd5dd 2 Nodes configured, unknown expected votes 1 Resources configured. ============ Online: [ monitor hamysql ] Install MySQL…
Post: Checking for a live database connection considered harmful
May 5, 2010 By 38 Comments
… to the ‘ping’ or ‘statistics’ command at the MySQL protocol level, which will increment Com_admin_commands in SHOW GLOBAL STATUS, or a… I saw a Ruby on Rails app where the ‘Administrator command: statistics’ command was taking over 40% of the server’s total… scores # 4 0xA3A0423749EC0E37 851.0152 5.8% 6020 0.1414 UPDATE user_datas # 5 0x813031B8BBC3B329 822.0041 5.6% 23299 0.0353 COMMIT # 6…
