Posts by Arunjith Aravindan:
- Using MySQL 8 Persisted System Variables, Oct 27 2020 in Insight for DBAs &Insight for Developers &MySQL &mysql-and-variants &Zend Developer
- MySQL 8.0 Hot Rows with NOWAIT and SKIP LOCKED, Jun 29 2018 in application performance &Innodb &InnoDB locks &MySQL &MySQL 8.0 &row locking &SELECT...FOR UPDATE &Zend Developer
- 5 free handy tools for monitoring and managing MySQL replication, Mar 09 2015 in Arunjith Aravindan &I/O thread &MySQL &MySQL Replication &Percona Software &Percona Toolkit &Primary &pt-heartbeat &pt-slave-find &pt-slave-restart &pt-table-checksum &pt-table-sync &SQL &Zend Developer
- The MySQL Query Cache: How it works, plus workload impacts (good and bad), Jan 02 2015 in Arunjith Aravindan &MySQL &MySQL query cache &percona server &Peter Zaitsev &Primary &query caching &query optimization &query tuning &Zend Developer
- How a set of queries can be killed in MySQL using Percona Toolkit’s pt-kill, Nov 19 2014 in Arunjith Aravindan &Insight for DBAs &MySQL &Percona Software &Percona Toolkit &Primary &pt-kill &slow queries &Zend Developer
- How to avoid hash collisions when using MySQL’s CRC32 function, Oct 13 2014 in Arunjith Aravindan &checksum queries &CRC32 &hash functions &MD5 &Message-Digest algorithm 5 &MySQL &MySQL tables &Percona Toolkit &Primary &pt-table-checksum &pt-table-sync &Zend Developer