…the database (this does not include constraints identified via metadata files!) Anomalies – Identifies possible relationships between columns/tables based on names…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…mysql_slowlogd. This daemon is similar to running `tail -f slow.log`, except that it knows how to follow the…mysql-schema schema_name –query-log-stdin –dispatcher-plugin thread-pool –thread-pool-threads-count 100 –session-init-query \”set innodb_fake_changes…
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
…the room with Monty when he detailed how long this would take). I was also the first MySQL Consultant from MySQL Inc to…the numbers of database connections the thread pool supported. I was not part of the…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
…how it works internally because there are many documents about that: http://dev.mysql…the master: # mysqldump –all-databases…changing GTID_PURGED manually but we can’t change it with SET because is a read only variable. The only way to change…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
…MySQL database server: You’re a uni student who wants to learn the…the Composite RCA (PAL & NTSC) connector. Once you have your hardware, here is how to get Percona Server for MySQL up and running: Insert the…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
…of how to install and run FlexCDC, and concludes with a demonstration of the utility. As a reminder, the first post covered the… appropriate name. The Binary Log is the MySQL log which records changes to tables in the database. FlexCDC reads the binary log to determine what rows have changed. Because…
Post: Find and remove duplicate indexes
June 20, 2012 By 9 Comments
…name); mysql> alter table t add index(name); mysql> show create table t\G [...] KEY `name` (`name`), KEY `name_2` (`name`), KEY `name_3` (`name`) [...] MySQL detects that the ‘name…
Post: Realtime stats to pay attention to in Percona XtraDB Cluster and Galera
November 26, 2012 By 4 Comments
…the aim to show folks what they should be watching (at least from my opinion, this is subject to change…the remaining minority and will not allow database operations. cnf This is wserep_cluster_conf_id — the version # of the cluster configuration. This changes…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’G *************************** 1. row *************************** Name…to show (click show/hide to change the columns) That the “public dns” field is selected SSH to the public DNS entry of the node on the…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
…to isolate some functionalities from Mark Callaghan’s MySQL patch bundle. They were extensions adding per-user and per-table accounting to the database…the basic statistics on the database activity broken down by users, tables or indexes. Monitoring those numbers every minute can show you changes…
