Author: Ovais Tariq
- http://www.mysqlperformanceblog.com
Posts by Ovais Tariq:
-
OOM relation to vm.swappiness=0 in new kernel,
Apr 28 2014 in Insight for DBAs &kernel &memory &MySQL &oom &swap &swappiness &Zend Developer
-
Beware of MySQL 5.6 server UUID when cloning slaves,
Jan 21 2014 in Insight for DBAs &MySQL &MySQL 5.6 new features &MySQL 5.6 server UUID &Ovais Tariq &Percona MySQL Support &replication &Server UUID &Zend Developer
-
InnoDB scalability issues due to tables without primary keys,
Oct 17 2013 in contention &data dictionary &dict_sys &Innodb &insert performance &Insight for DBAs &Locking &mutex &MySQL &primary key &row-id &Zend Developer
-
Implications of Metadata Locking Changes in MySQL 5.5,
Feb 01 2013 in alter table &ddl &Insight for DBAs &Insight for Developers &metadata locking &MySQL &query cache &table cache &transaction &Transaction isolation &Zend Developer
-
DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL,
Jun 22 2012 in benchmarks &Insight for DBAs &MySQL &Zend Developer
-
A case for MariaDB’s Hash Joins,
May 30 2012 in batched key access &benchmarks &block nested loop &hash join &Insight for DBAs &JOIN Performance &MariaDB &MySQL &performance &Zend Developer
-
Benchmarking single-row insert performance on Amazon EC2,
May 16 2012 in benchmarks &ec2 &iiBench &insert performance &Insight for DBAs &MySQL &partitioning &Secondary indexes &write performance &Zend Developer
-
Join Optimizations in MySQL 5.6 and MariaDB 5.5,
Apr 04 2012 in batched key access &benchmarks &BKA &hash join &Insight for DBAs &io &JOIN Performance &join_buffer &MariaDB &mrr_buffer &multi range read &MySQL &MySQL Performance &nested loop join &optimizer &random read &read_rnd_buffer &sequential read &Zend Developer
-
Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5,
Mar 21 2012 in benchmarks &Innodb &Insight for DBAs &MariaDB &mrr_buffer &multi range read &MySQL &MySQL Index Scan &MySQL Indexes &Optimization &optimizer &query &random read &range lookup &read_rnd_buffer &secondary key lookup &sequential read &Zend Developer
-
Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact,
Mar 12 2012 in benchmarks &Innodb &Insight for DBAs &IO Performance &MariaDB &MySQL &MySQL Indexes &MySQL Performance &optimizer &Zend Developer