….0 database with MySQL 5.1 with no problems in most cases. When storage type changes, such as DECIMAL field got whole another meaning in MySQL…. The changes which got a lot of publicity over years is change of TIMESTAMP output format in MySQL 4.1 or changing JOIN evaluation in 5…’re something like SELECT name FROM users WHERE id=5 you can probably go to the earliest MySQL version and still get…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
…many reasons for wanting a small MySQL database server: You’re a uni student who wants … permanent DNS name (like pi.yourdomain.com) by binding the reserved IP to a DNS name in your router’… password in the configuration file, update it in Tunnelier now also) Re-connect to see if your password change…
Post: Analyzing Slow Query Table in MySQL 5.6
February 18, 2013 By 1 Comment
…database response time is being spent. This month we saw the GA release of MySQL… read the logging code in MySQL 5.6.10 source, in file sql/log.cc. … in the past, but here’s mine: cat <<'GO' | mysql –raw –skip-column-names –…Kill,Debug,Ping,Time,Delayed insert,Change user,Binlog Dump,Table Dump,…
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…in MySQL 5.5 (different version is added back in MySQL…MySQL 5.6 has more changes in…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
… to consider is string comparison in MySQL is case insensitive by …only by first column. Regarding changing primary key to include …In regards to extending an index being better than adding a new one: Let’s say I have a table named…database that has about 400GB of indexes. The indexes can’t fit in…
Post: Percona XtraDB Cluster 5.5.20 - Beta release
February 23, 2012 By 10 Comments
… is available in pre-release series for XtraBackup 2.0 Despite Galera 2.0 has status “production ready”, we still name our… XtraDB Cluster works with databases created in MySQL / Percona Server Application compatibility. There is no or minimal application changes required to start work with…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…In MySQL 5.6 the default value of innodb_old_blocks_time is changed…DATABASE_PAGES: 7163 * DATABASE_PAGES: 7162 OLD_DATABASE_PAGES: 2624 * OLD_DATABASE_PAGES: 2623 MODIFIED_DATABASE_PAGES: 0 * MODIFIED_DATABASE…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… snapshot to reflect the changes that have happened in the database, instead of replaying binary logs… statements. Each MV name will be taken from the table name specified in each statement. …_top_customers MV, ordering them in descending order: mysql> call flexviews.create( -> ‘demo’,'dashboard_top…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…the database. The first step is to find out what MySQL instances …’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max… and table structures can be changed. Queries can be broken into …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… MySQL manual, especially the option …procedureblogpercona.commanual Com_change_dbblogpercona.commanual Com_change_masterblogpercona….wait_timeoutblogpercona.commanual locked_in_memoryblogpercona.commanual logblogpercona….log_warningsblogpercona.commanual skip_name_resolveblogpercona.commanual skip_…
