June 19, 2013

Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages

February 17, 2012 By 10 Comments

…of the total number of bytes in all the transaction logs, but I’m unsure if that’s always the case. Remember our transaction logs are circular, and the…

Filed Under: MySQL Tagged With: , ,

Post: Researching your MySQL table sizes

March 17, 2008 By 28 Comments

…of data sizes so here it goes: Find total number of tables, rows, total data in index size for given MySQL Instance SELECT count(*) tables, concat(round(sum(table…in set (0.03 sec) Find biggest databases SELECT count(*) tables, table_schema,concat(round(sum(table…

Filed Under: Insight for DBAs Tagged With: , ,

Post: Advanced index analysis with mk-index-usage

November 11, 2010 By 2 Comments

…the index usage into tables in a database, so you can query them with SQL. I logged all queries to the blog for a…total…tables any way you want. The documentation includes a number of other canned queries you can run. I found a…

Filed Under: Insight for DBAs, MySQL

Post: SHOW INNODB STATUS walk through

July 17, 2006 By 40 Comments

…a‘ where i=1 *** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 0 page no 16403 n bits 72 index `PRIMARY` of table…in additional memory pool (so you can check if it is sized right), total number of pages in buffer pool, number of pages free, pages allocated by database…

Filed Under: Insight for DBAs Tagged With:

Post: How Percona does a MySQL Performance Audit

November 24, 2008 By 17 Comments

…find the biggest tables and so forth. If the server is heavily loaded or has a lot of data, touching the INFORMATION_SCHEMA can take a…the depth and complexity of the analysis we do. A lot of times, customers will tell us up front to limit the work to some number of…

Filed Under: Insight for Developers Tagged With:

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

February 26, 2013 By 1 Comment

… yet. Having loaded the data, the first thing we notice is that there are a lot of “new” InnoDB tablespace files in our database directory: -rw… in total_word_count, or optimize_(start|end)_time, and the like. However, if I check some of the other I_S tables, I do find that the number of…

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

Post: Finding out largest tables on MySQL Server

February 4, 2008 By 27 Comments

…the purpose so I can easily find it later, plus it is quite handy in a way it presents information: SELECT CONCAT(table_schema, ‘.’, table…number of rows in millions and data and index size in GB so I can save on counting zeros. The…

Filed Under: Insight for DBAs Tagged With:

Post: Two Types of MySQL Users

May 10, 2010 By 5 Comments

In comments to my previous post I got number number of…a drop in the total amount of MySQL users which is in hundreds of thousands to the millions. Do not get me wrong this is a very important group of…of being good enough database for lower costs. You will find for a lot of users in the…

Filed Under: Insight for Developers, MySQL

Post: Introducing new type of benchmark

February 25, 2012 By 16 Comments

…the database as much as possible, bombarding the system with queries with no pause. That rarely happens in…the response time we may expect having a given arrival rate What is the optimal number of working threads (the…

Filed Under: Benchmarks, MySQL

Post: Realtime stats to pay attention to in Percona XtraDB Cluster and Galera

November 26, 2012 By 4 Comments

…The number of nodes in the cluster. Node This is state data about the local node that the tool happens to be connected to. name The name of…find the node slowing the others down. dst This does not go under the Flow group.  This is wsrep_cert_deps_distance — This is a…

Filed Under: MySQL, XtraDB Cluster
« Older Posts