June 19, 2013

Post: Implementing SchemaSpy in your MySQL environment

June 4, 2013 By 2 Comments

…of a schema in a database and generates a visual representation of it in a browser-displayable format. It lets you click through the hierarchy of database tables…to leave you with the impression that this is the only component of the tool.  There are additional tabs: Tables – Names, number of…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: ,

Post: Choosing a MySQL HA Solution - Post-Webinar Q&A

June 7, 2013 By Leave a Comment

…in the MySQL manual. You can configure the slave to only replicate a specific database, a set of databases, or specific tables…getting a lot of “bad file descriptor” errors. I was able to get the server up with –skip-grant-tables…

Filed Under: Insight for DBAs, Insight for Developers, MySQL, MySQL Webinars Tagged With: , , ,

Post: How to recover table structure from InnoDB dictionary

April 22, 2013 By 4 Comments

…table name in form database_name/table_name e.g. sakila/actor. `ID` is a table identifier. We will need the table id to find indexes of the table. mysql…

Filed Under: Insight for DBAs, MySQL Tagged With: , , , , , ,

Post: Is Synchronous Replication right for your app?

May 14, 2013 By 18 Comments

…to persist after a crash, it has to get to disk. This has no effect on standard MySQL replication from this instance, since MySQL…in between the statements that is not safe to retry after the database state changes. retry deadlocks Now we start to get…

Filed Under: MySQL, Percona Software, XtraDB Cluster Tagged With: , , , , , ,

Post: How to recover a single InnoDB table from a Full Backup

January 25, 2012 By 10 Comments

…in the conclusion section of this post. This post will be focus on how to recover a single tablespace using stock MySQL…table must be enabled. Then, our first step is to get a consistent backup. First we need to copy all the data to…

Filed Under: Insight for DBAs, MySQL, Percona Software

Post: Modeling MySQL Capacity by Measuring Resource Consumptions

March 8, 2011 By 1 Comment

…number of “Questions” or “Com_select” to get amount of IO per query or per Select. It is good to…How to get CPU consumption per query ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql…table 1% yes, 98% no # Tmp table on 1% yes, 98% no In…String: # Databases # Hosts localhost…

Filed Under: Insight for DBAs, MySQL

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

…to get a sense of how it works compared to traditional MyISAM FTS. We’ll get to performance in the third installment. For now, the important number here is to…to get rid of them is to actually rebuild the table. -rw-rw—-. 1 mysql mysql…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Is disk Everything for MySQL Performance ?

April 25, 2008 By 7 Comments

…of the database fits in memory. These days we can get 64G of memory for pretty commodity prices and this allows you to get a lot of data in…how much data we can comfortably put in MySQL Instance without getting in…

Filed Under: Hardware and Storage Tagged With:

Post: Find unused indexes

June 30, 2012 By Leave a Comment

…how to find duplicate indexes. This time we’ll learn how to find unused indexes to…to get realistic information about what is happening in the server. To generate some load on the database I’m going to…to get the list of unused indexes: mysql> SELECT INNODB_INDEX_STATS.TABLE…

Filed Under: Insight for DBAs, Insight for Developers, MySQL, Percona Software

Post: MySQL Upgrade Webinar Questions Followup

June 28, 2012 By 7 Comments

…to get them to be same as in old version. Q: What is about running 2 instances of MySQL with different versions to…database binary incompatible with MySQL. Our focus on compatibility is indeed so high there are number of great features which are disabled by default to…

Filed Under: Insight for DBAs, MySQL
« Older Posts