June 19, 2013

Post: Open Source, the MySQL market (and TokuDB in particular)

May 10, 2013 By 13 Comments

…information that does not come from the vendor of…number of…of truth in the article “Dead database walking: MySQL’s creator on why the future belongs to MariaDB.” To quote that article: “In…

Filed Under: MySQL Tagged With: , , , , , , ,

Post: SHOW INNODB STATUS walk through

July 17, 2006 By 40 Comments

… of internal Innodb performance counters, statistics, information about transaction processing and all kinds of other things. In MySQL 5 number of…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: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

…of “new” InnoDB tablespace files in our database…in set (4.60 sec) mysql> select * from information_schema.innodb_…of the diagnostic output isn’t working quite right. Intuitively, I would expect some changes in total…of my application unless I also make a nontrivial number of code changes. In part 2 of…

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

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

November 26, 2012 By 4 Comments

…of a single PXC node in my cluster, node3 to be precise, so some information is cluster-wide, other information…database operations. cnf This is wserep_cluster_conf_id — the version # of…of some node timeouts to prevent this. # The number of nodes in … and there are 3 nodes total belonging to it. …

Filed Under: MySQL, XtraDB Cluster

Post: Evaluating IO subsystem performance for MySQL Needs

March 5, 2008 By 23 Comments

… in uncached reads and writes because this correspond to general database…Total transferred 11.808Gb (201.52Mb/sec) 12897.22 Requests/sec executed Test execution summary: total time: 60.0001s total number of events: 773835 total… can get similar information by analyzing iostat numbers and that …

Filed Under: Benchmarks, Hardware and Storage Tagged With:

Post: Identifying the load with the help of pt-query-digest and Percona Server

December 29, 2011 By 3 Comments

…of time query waited for row locks, etc). So you can see there is a plethora of useful information…total query execution time and the average query execution time, the number of tmp tables created in memory vs on-disk, percentage of…Databases” section of the output also shows the name of the databases…

Filed Under: Insight for DBAs, MySQL

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…in set (0.03 sec) Find biggest databases…

Filed Under: Insight for DBAs Tagged With: , ,

Post: Replaying database load with Percona Playback

October 25, 2012 By 9 Comments

…number of transactions per seconds that a database… valuable information: SET GLOBAL…total of 51 queries had errors. Expected 372462 rows, got 371851 (a difference of 611) Number of queries where number of…number of rows? Usually because the data set is not exactly the same on PROD and DEV servers. In…

Filed Under: Insight for DBAs, MySQL

Post: On Good Instrumentation

May 31, 2010 By 1 Comment

…many variables in environment which change – load, number of concurrent users, database, the way users use the system but in …If it is 10.000 queries executed and total response time is 4 sec I know … to put it in the comments for queries you execute. Optional Tracing The information in lower layers …

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

Post: Finding out largest tables on MySQL Server

February 4, 2008 By 27 Comments

… 1024 * 1024 * 1024 ), 2), ‘G’) total_size, ROUND(index_length / data_length, 2) idxfrac FROM information_schema.TABLES ORDER … and rounding to see number of rows in millions and data and index size in GB so I … I’ve added INFORMATION_SCHEMA to the query so it works whatever database you have active. …

Filed Under: Insight for DBAs Tagged With:
« Older Posts