June 19, 2013

Post: The small improvements of MySQL 5.6: Duplicate Index Detection

May 31, 2013 By Leave a Comment

… mysql> ALTER TABLE test ADD INDEX (col2); Query OK, 0 rows affected (0.25 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> SHOW… warning (0.56 sec) Records: 0 Duplicates: 0 Warnings: 1 mysql> SHOW WARNINGS\G *************************** 1. row *************************** Level: Note Code: 1831 Message: Duplicate index… is a human mistake, as it is a waste of resources that could potentially impact our performance, and should be avoided…

Filed Under: Insight for DBAs, MySQL, On Ground Training, Percona Toolkit, Training Tagged With: , , , , , , , , ,

Post: Announcing Percona XtraBackup 2.1.1 GA

May 15, 2013 By Leave a Comment

… features for MySQL backup. The new 2.1.1 GA version offers improved performance, enterprise-grade security, and lower resource usage. This…. innobackupex now uses Perl’s DBD::MySQL package for server communication instead of spawning the MySQL command line client. Support for InnoDB… perform the Incremental Backups now. Bugs Fixed: innobackupex is using SHOW MASTER STATUS to obtain binlog file and position. This could…

Filed Under: MySQL, Percona XtraBackup Tagged With:

Post: The write cache: Swap insanity tome III

April 19, 2013 By 5 Comments

…need to interleave the allocation of memory for the MySQL process using the numactl utility, drop the file… is one of the nodes. That caused resource failovers. Resource failover when there’s no fencing and when …quick survey of the servers I have access to showed that the common values are 20 and 40….

Filed Under: Hardware and Storage, Insight for DBAs, MySQL Tagged With: , , ,

Post: Rare evil MySQL Bug

November 20, 2009 By 7 Comments

… restart MySQL quickly currently I have a test MySQL showing some …Resource temporarily unavailable) [pid 19229] accept(16392, 0x7fffffac70b0, [18423225245113516048]) = -1 EAGAIN (Resource temporarily unavailable) [pid 19229] accept(16392, 0x7fffffac70b0, [18423225245113516048]) = -1 EAGAIN (Resource…

Filed Under: Insight for DBAs, MySQL Tagged With:

Post: Troubleshooting MySQL Memory Usage

March 21, 2012 By 5 Comments

… simple problem on the surface becomes challenge with MySQL because there are no clear resource usage metrics available, and so in most… first things I do as it is least intrusive. Run SHOW ENGINE INNODB STATUS and look for memory information block, which… these are rather rare in MySQL. Most suspected memory leaks end up being some run away resource usage, though these can happen…

Filed Under: Insight for DBAs, MySQL

Post: MySQL extensions for hosting

April 24, 2008 By 11 Comments

…they will be constantly “battling” for the resources, each one caring only for his own…: 85 Commit_transactions: 0 Rollback_transactions: 0 mysql> SHOW TABLE_STATISTICS LIKE ‘hosting2%’; +——————————–+———–+————–+————————-+ | Table | Rows_read | Rows…

Filed Under: Percona Software Tagged With:

Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks

August 17, 2012 By 17 Comments

…well and good, but what is the tradeoff? Not locking resources cluster-wide means that there can be locking conflicts.  …32) ); Query OK, 0 rows affected (0.02 sec) node2 mysql> show create table autoinc\G *************************** 1. row *************************** Table: autoinc Create Table: …

Filed Under: MySQL, XtraDB Cluster

Post: Time for Zero Administration effort at MySQL ?

January 8, 2012 By 4 Comments

… do not count variables/options which do not have matching SHOW VARIABLES value, and settings done by changing tables rather than… or about other components in MySQL which makes it hard to manage memory, a lot of resource allocation done per connection without taking state of system into account. Is not it silly for example MySQL would…

Filed Under: MySQL

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

… Industries | 27.557558059692383 | | 408 | Free Colorado DMV Resources and Driving Records | 24.933029174804688 | | 48 | California … column named “value”. OK, sounds easy enough: mysql: SHOW CREATE TABLE innodb_myisam_stopword\G *************************** 1. row *************************** Table…

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

Post: ALTER TABLE: Creating Index by Sort and Buffer Pool Size

June 27, 2012 By 4 Comments

… look as following in terms of data and index size: mysql> show table status like “sbtest” \G *************************** 1. row *************************** Name: sbtest Engine… they forget what bottleneck might be somewhere else where memory resources might be just needed more. Take Away: If you’re…

Filed Under: Insight for DBAs, MySQL
« Older Posts