41554 blogs · [ { "id": "01a0bc20-8cb2-736f-bfd8-6419e18925cf", "title": "MySQL INSTANT DDL breaks EXCHANGE PARTITION", "url": "https://kedar.nitty-witty.com/blog/mysql-instant-ddl-breaks-exchange-partition?utm_source=rss&utm_medium=rss&utm_campaign=mysql-instant-ddl-breaks-exchange-partition", "published_at": "2026-09-14T13:36:10+00:00" }, { "id": "01a08cb8-2800-7094-9e88-96a52733590d", "title": "How to setup and use Percona Binlog Server (PBS)", "url": "https://kedar.nitty-witty.com/blog/how-to-setup-and-use-percona-binlog-server-pbs?utm_source=rss&utm_medium=rss&utm_campaign=how-to-setup-and-use-percona-binlog-server-pbs", "published_at": "2026-09-10T08:14:25+00:00" }, { "id": "01a08794-67cc-72b4-93d0-50fade7399b6", "title": "MySQL Major Version Upgrade Checklist – how to", "url": "https://kedar.nitty-witty.com/blog/mysql-major-version-upgrade-checklist-how-to?utm_source=rss&utm_medium=rss&utm_campaign=mysql-major-version-upgrade-checklist-how-to", "published_at": "2026-07-16T12:00:00+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f309788e4", "title": "InnoDB Flushing is simple – explained", "url": "https://kedar.nitty-witty.com/blog/innodb-flushing-is-simple-explained?utm_source=rss&utm_medium=rss&utm_campaign=innodb-flushing-is-simple-explained", "published_at": "2026-07-13T05:15:00+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f316977f4", "title": "MySQL Tools for Performance Tuning and Test Data Generation", "url": "https://kedar.nitty-witty.com/blog/mysql-tools-for-performance-tuning-and-test-data-generation?utm_source=rss&utm_medium=rss&utm_campaign=mysql-tools-for-performance-tuning-and-test-data-generation", "published_at": "2026-04-06T14:00:00+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f31f00065", "title": "How to fix write latency in MySQL 8.4 Upgrade", "url": "https://kedar.nitty-witty.com/blog/how-to-fix-write-latency-in-mysql-8-4-upgrade?utm_source=rss&utm_medium=rss&utm_campaign=how-to-fix-write-latency-in-mysql-8-4-upgrade", "published_at": "2026-04-04T17:01:09+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f32665e26", "title": "MySQL 8.4 disables AHI – Why and What you need to know", "url": "https://kedar.nitty-witty.com/blog/mysql-8-4-disables-ahi-why-and-what-you-need-to-know?utm_source=rss&utm_medium=rss&utm_campaign=mysql-8-4-disables-ahi-why-and-what-you-need-to-know", "published_at": "2026-01-19T18:18:11+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f32d343fb", "title": "How to checksum on AWS RDS for MySQL Replication 8.0 > 8.4", "url": "https://kedar.nitty-witty.com/blog/how-to-checksum-on-aws-rds-for-mysql-replication-8-0-8-4?utm_source=rss&utm_medium=rss&utm_campaign=how-to-checksum-on-aws-rds-for-mysql-replication-8-0-8-4", "published_at": "2025-11-04T11:45:00+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f3360270d", "title": "What MySQL configuration you hate the most?", "url": "https://kedar.nitty-witty.com/blog/what-mysql-configuration-you-hate-the-most?utm_source=rss&utm_medium=rss&utm_campaign=what-mysql-configuration-you-hate-the-most", "published_at": "2025-09-23T12:30:00+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f33913072", "title": "MySQL Podcast: InnoDB Cluster Group Replication", "url": "https://kedar.nitty-witty.com/blog/mysql-podcast-innodb-cluster-group-replication?utm_source=rss&utm_medium=rss&utm_campaign=mysql-podcast-innodb-cluster-group-replication", "published_at": "2025-09-15T12:26:07+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f33faf598", "title": "How to use tmux, a cheat sheet", "url": "https://kedar.nitty-witty.com/blog/how-to-use-tmux-a-cheat-sheet?utm_source=rss&utm_medium=rss&utm_campaign=how-to-use-tmux-a-cheat-sheet", "published_at": "2025-08-18T06:38:03+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f34e1664d", "title": "How to migrate PMM (Grafana) users", "url": "https://kedar.nitty-witty.com/blog/how-to-migrate-pmm-grafana-users?utm_source=rss&utm_medium=rss&utm_campaign=how-to-migrate-pmm-grafana-users", "published_at": "2025-08-04T12:05:00+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f3582ff58", "title": "A Unique Foreign Key issue in MySQL 8.4", "url": "https://kedar.nitty-witty.com/blog/a-unique-foreign-key-issue-in-mysql-8-4?utm_source=rss&utm_medium=rss&utm_campaign=a-unique-foreign-key-issue-in-mysql-8-4", "published_at": "2025-04-24T08:30:00+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f36508d49", "title": "How to Resolve Disk Space Issues in PMM: Case Study", "url": "https://kedar.nitty-witty.com/blog/how-to-resolve-disk-space-issues-in-pmm-case-study?utm_source=rss&utm_medium=rss&utm_campaign=how-to-resolve-disk-space-issues-in-pmm-case-study", "published_at": "2025-04-22T12:46:31+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f36dc2d86", "title": "MySQL Data Archiving basics – considerations, mistakes, best practices", "url": "https://kedar.nitty-witty.com/blog/mysql-data-archiving-basics-considerations-mistakes-best-practices?utm_source=rss&utm_medium=rss&utm_campaign=mysql-data-archiving-basics-considerations-mistakes-best-practices", "published_at": "2025-04-13T10:35:33+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f37d68956", "title": "Killer Blog for MySQL Administrators", "url": "https://kedar.nitty-witty.com/blog/killer-blog-for-mysql-administrators?utm_source=rss&utm_medium=rss&utm_campaign=killer-blog-for-mysql-administrators", "published_at": "2024-12-09T07:00:00+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f37fb25dd", "title": "MySQL 8 utf8mb4_0900_ai_ci collation confusion", "url": "https://kedar.nitty-witty.com/blog/mysql-8-utf8mb4_0900_ai_ci-collation-confusion?utm_source=rss&utm_medium=rss&utm_campaign=mysql-8-utf8mb4_0900_ai_ci-collation-confusion", "published_at": "2024-11-18T07:45:08+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f38dd5065", "title": "AI tools – technology and kids", "url": "https://kedar.nitty-witty.com/blog/ai-tools-technology-and-kids?utm_source=rss&utm_medium=rss&utm_campaign=ai-tools-technology-and-kids", "published_at": "2024-11-15T09:56:01+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f39ae4a79", "title": "Podcast: Duplicate Indexes in MySQL", "url": "https://kedar.nitty-witty.com/blog/podcast-duplicate-indexes-in-mysql?utm_source=rss&utm_medium=rss&utm_campaign=podcast-duplicate-indexes-in-mysql", "published_at": "2024-11-14T13:24:27+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f3a1cf26e", "title": "MySQL Podcast – Practical Learning & Training", "url": "https://kedar.nitty-witty.com/blog/mysql-podcast-practical-learning-training?utm_source=rss&utm_medium=rss&utm_campaign=mysql-podcast-practical-learning-training", "published_at": "2024-11-06T13:01:12+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f3a4ac4b0", "title": "MySQL Change Buffer – What When and FAQ", "url": "https://kedar.nitty-witty.com/blog/mysql-change-buffer-what-when-and-faq?utm_source=rss&utm_medium=rss&utm_campaign=mysql-change-buffer-what-when-and-faq", "published_at": "2024-11-04T17:08:30+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f3b20f0da", "title": "Understanding Return Codes of pt-upgrade: A quick guide", "url": "https://kedar.nitty-witty.com/blog/understanding-return-codes-of-pt-upgrade-a-quick-guide?utm_source=rss&utm_medium=rss&utm_campaign=understanding-return-codes-of-pt-upgrade-a-quick-guide", "published_at": "2024-10-14T06:47:25+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f3b73764c", "title": "Troubleshooting MySQL: Encryption can’t find Master Key", "url": "https://kedar.nitty-witty.com/blog/troubleshooting-mysql-encryption-cant-find-master-key?utm_source=rss&utm_medium=rss&utm_campaign=troubleshooting-mysql-encryption-cant-find-master-key", "published_at": "2024-09-23T11:30:27+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f3c0a340a", "title": "MySQL 8 upgrade may fail using checkForServerUpgrade", "url": "https://kedar.nitty-witty.com/blog/mysql-8-upgrade-may-fail-using-checkforserverupgrade?utm_source=rss&utm_medium=rss&utm_campaign=mysql-8-upgrade-may-fail-using-checkforserverupgrade", "published_at": "2024-03-07T04:28:41+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f3cf0cf1e", "title": "How to avoid data loss in MySQL Primary Key change", "url": "https://kedar.nitty-witty.com/blog/how-to-avoid-data-loss-in-mysql-primary-key-change?utm_source=rss&utm_medium=rss&utm_campaign=how-to-avoid-data-loss-in-mysql-primary-key-change", "published_at": "2024-03-01T12:17:14+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f3d29325d", "title": "MySQL Benchmarking and error in my_thread_global_end()", "url": "https://kedar.nitty-witty.com/blog/mysql-benchmarking-and-error-in-my_thread_global_end?utm_source=rss&utm_medium=rss&utm_campaign=mysql-benchmarking-and-error-in-my_thread_global_end", "published_at": "2024-02-20T08:12:20+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f3e18503c", "title": "How to save money in AWS RDS – Upgrade to MySQL 8", "url": "https://kedar.nitty-witty.com/blog/how-to-save-money-in-aws-rds-upgrade-to-mysql-8?utm_source=rss&utm_medium=rss&utm_campaign=how-to-save-money-in-aws-rds-upgrade-to-mysql-8", "published_at": "2024-02-08T05:51:42+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f3e65139b", "title": "How MySQL Binary Log Gets Its Number", "url": "https://kedar.nitty-witty.com/blog/how-mysql-binary-log-gets-its-number?utm_source=rss&utm_medium=rss&utm_campaign=how-mysql-binary-log-gets-its-number", "published_at": "2024-01-28T11:37:36+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f3f628095", "title": "Node has dropped from cluster error in Galera Cluster", "url": "https://kedar.nitty-witty.com/blog/node-has-dropped-from-cluster-error-in-galera-cluster?utm_source=rss&utm_medium=rss&utm_campaign=node-has-dropped-from-cluster-error-in-galera-cluster", "published_at": "2024-01-16T14:01:39+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f3fa8f43a", "title": "A year in MySQL Blogging – top blogs, summary and review", "url": "https://kedar.nitty-witty.com/blog/a-year-in-mysql-blogging-top-blogs-summary-and-review?utm_source=rss&utm_medium=rss&utm_campaign=a-year-in-mysql-blogging-top-blogs-summary-and-review", "published_at": "2024-01-04T11:38:34+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f3fe20e8d", "title": "How to filter MySQL slow queries using pt-query-digest", "url": "https://kedar.nitty-witty.com/blog/how-to-filter-mysql-slow-queries-using-pt-query-digest?utm_source=rss&utm_medium=rss&utm_campaign=how-to-filter-mysql-slow-queries-using-pt-query-digest", "published_at": "2023-12-30T07:03:33+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f403a85c7", "title": "What do you need to debug MySQL issues – a checklist", "url": "https://kedar.nitty-witty.com/blog/what-do-you-need-to-debug-mysql-issues-a-checklist?utm_source=rss&utm_medium=rss&utm_campaign=what-do-you-need-to-debug-mysql-issues-a-checklist", "published_at": "2023-12-11T14:20:42+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f40f74d51", "title": "How to get MySQL Primary Keys in one minute", "url": "https://kedar.nitty-witty.com/blog/how-to-get-mysql-primary-keys-in-one-minute?utm_source=rss&utm_medium=rss&utm_campaign=how-to-get-mysql-primary-keys-in-one-minute", "published_at": "2023-11-30T14:43:17+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f4153274f", "title": "Quick Look – MySQL Data Directory Files", "url": "https://kedar.nitty-witty.com/blog/quick-look-mysql-data-directory-files?utm_source=rss&utm_medium=rss&utm_campaign=quick-look-mysql-data-directory-files", "published_at": "2023-09-25T12:21:03+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f41af63ae", "title": "How to fix Percona XtraDB Cluster 8.0 Upgrade issues", "url": "https://kedar.nitty-witty.com/blog/how-to-percona-xtradb-cluster-8-0-upgrade-issues?utm_source=rss&utm_medium=rss&utm_campaign=how-to-percona-xtradb-cluster-8-0-upgrade-issues", "published_at": "2023-09-05T10:08:34+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f41cc22ed", "title": "One MySQL blog a day challenge", "url": "https://kedar.nitty-witty.com/blog/one-mysql-blog-a-day-challenge?utm_source=rss&utm_medium=rss&utm_campaign=one-mysql-blog-a-day-challenge", "published_at": "2023-07-31T14:20:39+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f420d1956", "title": "How to fix MySQL federated table error", "url": "https://kedar.nitty-witty.com/blog/how-to-fix-mysql-federated-table-error?utm_source=rss&utm_medium=rss&utm_campaign=how-to-fix-mysql-federated-table-error", "published_at": "2023-07-28T18:24:31+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f42c5e0aa", "title": "How to replicate without binary logs in MySQL", "url": "https://kedar.nitty-witty.com/blog/how-to-replicate-without-binary-logs-in-mysql?utm_source=rss&utm_medium=rss&utm_campaign=how-to-replicate-without-binary-logs-in-mysql", "published_at": "2023-07-27T14:47:44+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f4340c25c", "title": "MySQL fragmentation and how to defragment", "url": "https://kedar.nitty-witty.com/blog/mysql-fragmentation-and-how-to-defragment?utm_source=rss&utm_medium=rss&utm_campaign=mysql-fragmentation-and-how-to-defragment", "published_at": "2023-07-26T15:31:57+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f43d32dde", "title": "How to Fix Connection attributes of length xxx were truncated", "url": "https://kedar.nitty-witty.com/blog/how-to-fix-connection-attributes-of-length-xxx-were-truncated?utm_source=rss&utm_medium=rss&utm_campaign=how-to-fix-connection-attributes-of-length-xxx-were-truncated", "published_at": "2023-07-25T07:40:53+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f441f7684", "title": "How to overcome Throttling and Rate Exceeded Errors in DownloadDBLogFilePortion", "url": "https://kedar.nitty-witty.com/blog/how-to-overcome-throttling-and-rate-exceeded-errors-in-downloaddblogfileportion?utm_source=rss&utm_medium=rss&utm_campaign=how-to-overcome-throttling-and-rate-exceeded-errors-in-downloaddblogfileportion", "published_at": "2023-07-24T06:28:07+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f44b7c187", "title": "How to meet Signal 11 bug in MariaDB", "url": "https://kedar.nitty-witty.com/blog/how-to-meet-signal-11-bug-in-mariadb?utm_source=rss&utm_medium=rss&utm_campaign=how-to-meet-signal-11-bug-in-mariadb", "published_at": "2023-06-25T12:36:39+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f44b87cf1", "title": "How To Install specific version of MySQL 8 on Ubuntu", "url": "https://kedar.nitty-witty.com/blog/how-to-install-specific-version-of-mysql-8-on-ubuntu?utm_source=rss&utm_medium=rss&utm_campaign=how-to-install-specific-version-of-mysql-8-on-ubuntu", "published_at": "2023-06-08T04:38:25+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f44d3e746", "title": "How to MySQL Replication setup, Master GTID & SSL Encryption", "url": "https://kedar.nitty-witty.com/blog/how-to-mysql-replication-setup-master-gtid-ssl-encryption?utm_source=rss&utm_medium=rss&utm_campaign=how-to-mysql-replication-setup-master-gtid-ssl-encryption", "published_at": "2023-06-04T12:01:57+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f45468e81", "title": "Install exact version of Percona Server for MySQL on CentOS", "url": "https://kedar.nitty-witty.com/blog/install-exact-version-of-percona-server-for-mysql-on-centos?utm_source=rss&utm_medium=rss&utm_campaign=install-exact-version-of-percona-server-for-mysql-on-centos", "published_at": "2023-05-30T11:01:13+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f460ddaa0", "title": "MySQL Slow query log export and download in RDS", "url": "https://kedar.nitty-witty.com/blog/mysql-slow-query-log-export-and-review-in-rds?utm_source=rss&utm_medium=rss&utm_campaign=mysql-slow-query-log-export-and-review-in-rds", "published_at": "2023-05-30T09:05:57+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f4624dbae", "title": "How to fix 1030 Unknown generic error from engine in MySQL", "url": "https://kedar.nitty-witty.com/blog/1030-unknown-generic-error-from-engine-in-mysql?utm_source=rss&utm_medium=rss&utm_campaign=1030-unknown-generic-error-from-engine-in-mysql", "published_at": "2023-04-10T04:39:36+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f46268a3f", "title": "MySQL 8 – timestamp cannot be null and explicit_defaults_for_timestamp", "url": "https://kedar.nitty-witty.com/blog/mysql-8-timestamp-cannot-be-null-and-explicit_defaults_for_timestamp?utm_source=rss&utm_medium=rss&utm_campaign=mysql-8-timestamp-cannot-be-null-and-explicit_defaults_for_timestamp", "published_at": "2023-03-20T14:54:44+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f47001792", "title": "Restore single MySQL table (ibd) from Xtrabackup (video demo)", "url": "https://kedar.nitty-witty.com/blog/restore-single-mysql-table-from-xtrabackup?utm_source=rss&utm_medium=rss&utm_campaign=restore-single-mysql-table-from-xtrabackup", "published_at": "2022-12-14T17:39:51+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f475f91b1", "title": "MySQL Interview – ChatGPT is not your DBA", "url": "https://kedar.nitty-witty.com/blog/mysql-interview-chatgpt-is-not-your-dba?utm_source=rss&utm_medium=rss&utm_campaign=mysql-interview-chatgpt-is-not-your-dba", "published_at": "2022-12-14T13:51:58+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f484f20c0", "title": "Securing MySQL: Data Encryption with Percona Server and Vault", "url": "https://kedar.nitty-witty.com/blog/encryption-mysql-encryption-percona-vault-virtual-days-slides-video?utm_source=rss&utm_medium=rss&utm_campaign=encryption-mysql-encryption-percona-vault-virtual-days-slides-video", "published_at": "2022-12-10T00:00:25+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f487e55c3", "title": "Can not connect to ProxySQL: reasons and fixtures", "url": "https://kedar.nitty-witty.com/blog/can-not-connect-to-proxysql-reasons-and-fixtures?utm_source=rss&utm_medium=rss&utm_campaign=can-not-connect-to-proxysql-reasons-and-fixtures", "published_at": "2022-10-11T10:53:12+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f493b1d0e", "title": "Providing Friday Proofs to MySQL Consultants | Scripts Functions Routines", "url": "https://kedar.nitty-witty.com/blog/providing-friday-proofs-to-mysql-consultants?utm_source=rss&utm_medium=rss&utm_campaign=providing-friday-proofs-to-mysql-consultants", "published_at": "2022-09-24T11:50:04+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f49a273bc", "title": "The Low Hanging Fruits of MySQL – Percona Live Community 2022", "url": "https://kedar.nitty-witty.com/blog/the-low-hanging-fruits-of-mysql-percona-live-community-2022?utm_source=rss&utm_medium=rss&utm_campaign=the-low-hanging-fruits-of-mysql-percona-live-community-2022", "published_at": "2022-07-13T09:43:51+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f49fec464", "title": "Relay log read failure | 2 many dots can break your replication only once", "url": "https://kedar.nitty-witty.com/blog/relay-log-read-failure-2-many-dots-can-break-your-replication-only-once?utm_source=rss&utm_medium=rss&utm_campaign=relay-log-read-failure-2-many-dots-can-break-your-replication-only-once", "published_at": "2021-08-19T13:12:49+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f4ae104ce", "title": "MySQL Backup setup, automation using Holland, mysqldump on Ubuntu", "url": "https://kedar.nitty-witty.com/blog/mysql-backup-setup-automation-using-holland-mysqldump-on-ubuntu?utm_source=rss&utm_medium=rss&utm_campaign=mysql-backup-setup-automation-using-holland-mysqldump-on-ubuntu", "published_at": "2021-03-23T05:27:16+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f4bcf8ed0", "title": "Still have MySQL 5.6 variable binlog_error_action as IGNORE_ERROR?", "url": "https://kedar.nitty-witty.com/blog/still-have-mysql-5-6-variable-binlog_error_action-as-ignore_error?utm_source=rss&utm_medium=rss&utm_campaign=still-have-mysql-5-6-variable-binlog_error_action-as-ignore_error", "published_at": "2020-04-10T15:49:13+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f4c357029", "title": "ProxySQL Configuration & Startup Process explained", "url": "https://kedar.nitty-witty.com/blog/proxysql-configuration-file-startup-process-explained?utm_source=rss&utm_medium=rss&utm_campaign=proxysql-configuration-file-startup-process-explained", "published_at": "2019-10-08T17:55:35+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f4cccb8d6", "title": "MySQL backup shell script with status email", "url": "https://kedar.nitty-witty.com/blog/mysql-database-backup-shell-script-with-status-email?utm_source=rss&utm_medium=rss&utm_campaign=mysql-database-backup-shell-script-with-status-email", "published_at": "2019-04-09T06:11:17+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f4d19e6bb", "title": "दुर्गे दुर्घट भारी – श्री देवीची आरती | Aarti Durge Durghat Bhari | Marathi", "url": "https://kedar.nitty-witty.com/blog/aarti-durge-durghat-bhari-marathi?utm_source=rss&utm_medium=rss&utm_campaign=aarti-durge-durghat-bhari-marathi", "published_at": "2018-10-01T05:00:00+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f4d642c35", "title": "MySQL 8 Resource Group – introduction and dynamic allocation", "url": "https://kedar.nitty-witty.com/blog/mysql-8-resource-group-introduction-and-dynamic-allocation?utm_source=rss&utm_medium=rss&utm_campaign=mysql-8-resource-group-introduction-and-dynamic-allocation", "published_at": "2018-09-07T12:03:57+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f4d89c203", "title": "Galera cluster to AWS Aurora migration & HA_ERR_FOUND_DUPP_KEY", "url": "https://kedar.nitty-witty.com/blog/galera-cluster-to-aws-aurora-migration-ha_err_found_dupp_key?utm_source=rss&utm_medium=rss&utm_campaign=galera-cluster-to-aws-aurora-migration-ha_err_found_dupp_key", "published_at": "2018-08-13T06:15:05+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f4de8b17c", "title": "Restore A Table / Database From Full Backup – Yet Another Way", "url": "https://kedar.nitty-witty.com/blog/restore-a-table-database-from-full-backup-yet-another-way?utm_source=rss&utm_medium=rss&utm_campaign=restore-a-table-database-from-full-backup-yet-another-way", "published_at": "2018-06-29T15:43:55+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f4e4da961", "title": "Export MySQL database table to CSV (delimited / Excel) file", "url": "https://kedar.nitty-witty.com/blog/export-mysql-database-table-to-csv-delimited-excel-file?utm_source=rss&utm_medium=rss&utm_campaign=export-mysql-database-table-to-csv-delimited-excel-file", "published_at": "2018-01-29T18:18:27+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f4ea62b37", "title": "A tale of Corrupt InnoDB table, MySQL crash & recovery", "url": "https://kedar.nitty-witty.com/blog/a-tale-of-corrupt-innodb-table-mysql-crash-recovery?utm_source=rss&utm_medium=rss&utm_campaign=a-tale-of-corrupt-innodb-table-mysql-crash-recovery", "published_at": "2018-01-18T14:54:29+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f4f237189", "title": "How to Pause (Suspend) a process in Linux with kill signals", "url": "https://kedar.nitty-witty.com/blog/linux-shell-script-pause-a-process-with-kill-signals?utm_source=rss&utm_medium=rss&utm_campaign=linux-shell-script-pause-a-process-with-kill-signals", "published_at": "2018-01-09T13:12:17+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f4f54b260", "title": "Decoding Siebel Audit Trail with PLSQL", "url": "https://kedar.nitty-witty.com/blog/decoding-siebel-audit-trail-with-plsql?utm_source=rss&utm_medium=rss&utm_campaign=decoding-siebel-audit-trail-with-plsql", "published_at": "2017-12-14T10:30:57+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f4fab15bc", "title": "Reset root password on Galera Cluster (Percona or MariaDB)", "url": "https://kedar.nitty-witty.com/blog/reset-root-password-on-galera-cluster-percona-or-mariadb?utm_source=rss&utm_medium=rss&utm_campaign=reset-root-password-on-galera-cluster-percona-or-mariadb", "published_at": "2017-04-11T07:41:53+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f4fffe76c", "title": "MySQL to Galera Cluster Migration, Deadlock, Back to basics", "url": "https://kedar.nitty-witty.com/blog/mysql-to-galera-cluster-migration-deadlock-back-to-basics?utm_source=rss&utm_medium=rss&utm_campaign=mysql-to-galera-cluster-migration-deadlock-back-to-basics", "published_at": "2017-03-02T12:34:30+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f50ca5174", "title": "MySQL database restore issues using xtrabackup – facepalm moments", "url": "https://kedar.nitty-witty.com/blog/restoring-mysql-database-from-xtrabackup-facepalm-moments?utm_source=rss&utm_medium=rss&utm_campaign=restoring-mysql-database-from-xtrabackup-facepalm-moments", "published_at": "2016-06-13T13:53:18+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f50ef5e08", "title": "corrupted / crashed MyISAM + mysql_repair_threads = stuck “Repair with N threads”", "url": "https://kedar.nitty-witty.com/blog/corrupted-crashed-myisam-mysql_repair_threads-stuck-repair-with-n-threads?utm_source=rss&utm_medium=rss&utm_campaign=corrupted-crashed-myisam-mysql_repair_threads-stuck-repair-with-n-threads", "published_at": "2015-12-07T11:25:49+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f5155bf8d", "title": "Fixing inconsistency on MySQL Slave of Galera Cluster", "url": "https://kedar.nitty-witty.com/blog/fixing-inconsistency-on-mysql-slave-of-galera-cluster?utm_source=rss&utm_medium=rss&utm_campaign=fixing-inconsistency-on-mysql-slave-of-galera-cluster", "published_at": "2015-12-04T07:40:19+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f5204ea84", "title": "Setting-up second MySQL instance & replication on Linux in 10 steps", "url": "https://kedar.nitty-witty.com/blog/setting-up-second-mysql-instance-replication-on-linux-in-10-steps?utm_source=rss&utm_medium=rss&utm_campaign=setting-up-second-mysql-instance-replication-on-linux-in-10-steps", "published_at": "2015-11-04T11:59:09+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f52db596c", "title": "pt-table-checksum & Waiting to check replicas for differences: 0% 00:00 remain", "url": "https://kedar.nitty-witty.com/blog/pt-table-checksum-waiting-to-check-replicas-for-differences-0-0000-remain?utm_source=rss&utm_medium=rss&utm_campaign=pt-table-checksum-waiting-to-check-replicas-for-differences-0-0000-remain", "published_at": "2015-10-19T19:51:17+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f53cd6bf2", "title": "How to Add Remote MySQL Server to Nagios Monitoring", "url": "https://kedar.nitty-witty.com/blog/how-to-add-remote-mysql-server-to-nagios-monitoring?utm_source=rss&utm_medium=rss&utm_campaign=how-to-add-remote-mysql-server-to-nagios-monitoring", "published_at": "2015-08-17T11:47:46+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f548efe1b", "title": "MySQL Permission denied error 13 and solution", "url": "https://kedar.nitty-witty.com/blog/mysql-1018-hy000-cant-read-dir-errno-13-permission-denied?utm_source=rss&utm_medium=rss&utm_campaign=mysql-1018-hy000-cant-read-dir-errno-13-permission-denied", "published_at": "2015-07-20T14:57:29+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f5526c272", "title": "How to monitor MySQL backups", "url": "https://kedar.nitty-witty.com/blog/monitoring-mysql-database-backups?utm_source=rss&utm_medium=rss&utm_campaign=monitoring-mysql-database-backups", "published_at": "2015-07-01T06:45:20+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f55a5d5e0", "title": "Install Percona Monitoring Tools for Nagios – MySQL Plugins", "url": "https://kedar.nitty-witty.com/blog/install-percona-monitoring-tools-for-nagios-mysql-plugins?utm_source=rss&utm_medium=rss&utm_campaign=install-percona-monitoring-tools-for-nagios-mysql-plugins", "published_at": "2015-06-30T12:47:16+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f565a4f24", "title": "UMASK & UMASK_DIR – changing default MySQL file dir permissions", "url": "https://kedar.nitty-witty.com/blog/umask-umask_dir-changing-mysql-file-dir-permissions?utm_source=rss&utm_medium=rss&utm_campaign=umask-umask_dir-changing-mysql-file-dir-permissions", "published_at": "2015-06-24T07:06:06+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f574fcc39", "title": "XML to JSON converter in Siebel", "url": "https://kedar.nitty-witty.com/blog/xml-to-json-converter-in-siebel?utm_source=rss&utm_medium=rss&utm_campaign=xml-to-json-converter-in-siebel", "published_at": "2015-06-07T09:42:49+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f58019def", "title": "Setup and configure MySQL backup using Holland and Xtrabackup", "url": "https://kedar.nitty-witty.com/blog/setup-and-configure-mysql-backup-using-holland-and-xtrabackup?utm_source=rss&utm_medium=rss&utm_campaign=setup-and-configure-mysql-backup-using-holland-and-xtrabackup", "published_at": "2015-06-02T07:10:54+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f5870903b", "title": "Cannot connect to MySQL server on ‘localhost’: Cacti Error", "url": "https://kedar.nitty-witty.com/blog/cannot-connect-to-mysql-server-on-localhost-cacti-error?utm_source=rss&utm_medium=rss&utm_campaign=cannot-connect-to-mysql-server-on-localhost-cacti-error", "published_at": "2015-05-20T10:32:15+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f58e0f2b0", "title": "How-to extract from mysqldump | mysql-dump-splitter recipes", "url": "https://kedar.nitty-witty.com/blog/how-to-recipes-for-mysqldumpsplitter?utm_source=rss&utm_medium=rss&utm_campaign=how-to-recipes-for-mysqldumpsplitter", "published_at": "2015-04-28T10:28:58+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f59a956e3", "title": "How to fix definer does not exist error 1449 MySQL", "url": "https://kedar.nitty-witty.com/blog/solutions-mysql-error-1449-the-user-specified-as-a-definer-does-not-exist?utm_source=rss&utm_medium=rss&utm_campaign=solutions-mysql-error-1449-the-user-specified-as-a-definer-does-not-exist", "published_at": "2015-03-23T06:27:41+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f59ef8960", "title": "10 useful shell script code snippets | Linux", "url": "https://kedar.nitty-witty.com/blog/10-useful-shell-script-code-snippets-linux?utm_source=rss&utm_medium=rss&utm_campaign=10-useful-shell-script-code-snippets-linux", "published_at": "2015-03-10T08:38:37+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f5a607576", "title": "How to Restore / point in time recovery using binary logs MySQL", "url": "https://kedar.nitty-witty.com/blog/restore-dropped-mysql-database-from-binary-logs?utm_source=rss&utm_medium=rss&utm_campaign=restore-dropped-mysql-database-from-binary-logs", "published_at": "2015-02-23T12:42:12+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f5a9f7e1f", "title": "MySQL grant syntax & dynamic database using wildcards", "url": "https://kedar.nitty-witty.com/blog/mysql-grant-syntax-dynamic-database-using-wildcards?utm_source=rss&utm_medium=rss&utm_campaign=mysql-grant-syntax-dynamic-database-using-wildcards", "published_at": "2015-02-03T10:03:23+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f5ac61f91", "title": "Debugging Percona Xtradb (Galera) Cluster node startup / SST errors", "url": "https://kedar.nitty-witty.com/blog/debugging-percona-xtradb-galera-cluster-node-startup-sst-errors?utm_source=rss&utm_medium=rss&utm_campaign=debugging-percona-xtradb-galera-cluster-node-startup-sst-errors", "published_at": "2015-01-21T06:49:24+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f5bbe45f3", "title": "MariaDB slave restore using GTID & xtrabackup bug", "url": "https://kedar.nitty-witty.com/blog/mariadb-slave-restore-using-gtid-xtrabackup-bug?utm_source=rss&utm_medium=rss&utm_campaign=mariadb-slave-restore-using-gtid-xtrabackup-bug", "published_at": "2014-12-31T12:06:09+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f5c7ad295", "title": "xtrabackup_51: not found & no ‘mysqld’ group in MySQL options", "url": "https://kedar.nitty-witty.com/blog/innobackupex-1-5-1-fatal-error-no-mysqld-group-in-mysql-options?utm_source=rss&utm_medium=rss&utm_campaign=innobackupex-1-5-1-fatal-error-no-mysqld-group-in-mysql-options", "published_at": "2013-05-27T05:46:14+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f5cb64b21", "title": "Why we need a tester / QA – Software testing", "url": "https://kedar.nitty-witty.com/blog/why-we-need-a-tester-quality-analyst-software-testing?utm_source=rss&utm_medium=rss&utm_campaign=why-we-need-a-tester-quality-analyst-software-testing", "published_at": "2013-03-04T07:40:56+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f5d1cc461", "title": "MySQL variable innodb_flush_method – summarized", "url": "https://kedar.nitty-witty.com/blog/mysql-variable-innodb_flush_method-summarized?utm_source=rss&utm_medium=rss&utm_campaign=mysql-variable-innodb_flush_method-summarized", "published_at": "2013-01-10T11:21:21+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f5d9e54a9", "title": "Is your backup complete? – backup MySQL users privileges / grants – pt-show-grants", "url": "https://kedar.nitty-witty.com/blog/is-your-backup-complete-backup-mysql-users-privileges-grants?utm_source=rss&utm_medium=rss&utm_campaign=is-your-backup-complete-backup-mysql-users-privileges-grants", "published_at": "2012-12-17T12:48:10+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f5e98f157", "title": "MySQL function returns dates of specified day & between date range", "url": "https://kedar.nitty-witty.com/blog/mysql-function-to-get-dates-specified-day-date-range?utm_source=rss&utm_medium=rss&utm_campaign=mysql-function-to-get-dates-specified-day-date-range", "published_at": "2012-09-13T07:49:24+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f5ef95a20", "title": "How To Generate Random test Data In MySQL", "url": "https://kedar.nitty-witty.com/blog/generate-random-test-data-for-mysql-using-routines?utm_source=rss&utm_medium=rss&utm_campaign=generate-random-test-data-for-mysql-using-routines", "published_at": "2012-07-05T07:51:20+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f5f7d8d79", "title": "Men in Black-3 (MiB-3) – Xtreme Movie Review", "url": "https://kedar.nitty-witty.com/blog/men-in-black-3-mib-3-xtreme-movie-review?utm_source=rss&utm_medium=rss&utm_campaign=men-in-black-3-mib-3-xtreme-movie-review", "published_at": "2012-05-26T06:51:35+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f5fc51922", "title": "Load columnar text file into MySQL table", "url": "https://kedar.nitty-witty.com/blog/load-columnar-text-file-into-mysql-table?utm_source=rss&utm_medium=rss&utm_campaign=load-columnar-text-file-into-mysql-table", "published_at": "2012-05-03T16:21:08+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f601f7f6e", "title": "MySQL – Alter table-change datatype of column with foreign key", "url": "https://kedar.nitty-witty.com/blog/mysql-change-datatype-column-foreign-key-constraint?utm_source=rss&utm_medium=rss&utm_campaign=mysql-change-datatype-column-foreign-key-constraint", "published_at": "2012-04-23T12:08:30+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f60a43782", "title": "Selenium vs QTP differences and usage-quick reference", "url": "https://kedar.nitty-witty.com/blog/selenium-vs-qtp-differences-usage-quick-reference?utm_source=rss&utm_medium=rss&utm_campaign=selenium-vs-qtp-differences-usage-quick-reference", "published_at": "2012-03-17T16:20:22+00:00" }, { "id": "01a08794-67cd-7373-80fa-0a5f61333418", "title": "Access Control in MySQL Stored Routines: DEFINER, INVOKER & SQL SECURITY", "url": "https://kedar.nitty-witty.com/blog/access-control-in-mysql-stored-routines-by-example-definer-invoker-sql-security?utm_source=rss&utm_medium=rss&utm_campaign=access-control-in-mysql-stored-routines-by-example-definer-invoker-sql-security", "published_at": "2012-01-30T16:29:03+00:00" } ] posts Claim your blog

Back to kedar.nitty-witty.com

Blog · corpus.blog/blogs/kedar.nitty-witty.com/posts

kedar.nitty-witty.com

kedar.nitty-witty.com

2026

MySQL INSTANT DDL breaks EXCHANGE PARTITION original ↗

14 Sept 2026

How to setup and use Percona Binlog Server (PBS)original ↗

10 Sept 2026

MySQL Major Version Upgrade Checklist – how to original ↗

16 Jul 2026

InnoDB Flushing is simple – explained original ↗

13 Jul 2026

MySQL Tools for Performance Tuning and Test Data Generation original ↗

6 Apr 2026

How to fix write latency in MySQL 8.4 Upgrade original ↗

4 Apr 2026

MySQL 8.4 disables AHI – Why and What you need to know original ↗

19 Jan 2026

2025

How to checksum on AWS RDS for MySQL Replication 8.0 > 8.4 original ↗

4 Nov 2025

What MySQL configuration you hate the most?original ↗

23 Sept 2025

MySQL Podcast: InnoDB Cluster Group Replication original ↗

15 Sept 2025

How to use tmux, a cheat sheet original ↗

18 Aug 2025

How to migrate PMM (Grafana) users original ↗

4 Aug 2025

A Unique Foreign Key issue in MySQL 8.4 original ↗

24 Apr 2025

How to Resolve Disk Space Issues in PMM: Case Study original ↗

22 Apr 2025

MySQL Data Archiving basics – considerations, mistakes, best practices original ↗

13 Apr 2025

2024

Killer Blog for MySQL Administrators original ↗

9 Dec 2024

MySQL 8 utf8mb4_0900_ai_ci collation confusion original ↗

18 Nov 2024

AI tools – technology and kids original ↗

15 Nov 2024

Podcast: Duplicate Indexes in MySQL original ↗

14 Nov 2024

MySQL Podcast – Practical Learning & Training original ↗

6 Nov 2024

MySQL Change Buffer – What When and FAQ original ↗

4 Nov 2024

Understanding Return Codes of pt-upgrade: A quick guide original ↗

14 Oct 2024

Troubleshooting MySQL: Encryption can’t find Master Key original ↗

23 Sept 2024

MySQL 8 upgrade may fail using checkForServerUpgrade original ↗

7 Mar 2024

How to avoid data loss in MySQL Primary Key change original ↗

1 Mar 2024

MySQL Benchmarking and error in my_thread_global_end()original ↗

20 Feb 2024

How to save money in AWS RDS – Upgrade to MySQL 8 original ↗

8 Feb 2024

How MySQL Binary Log Gets Its Number original ↗

28 Jan 2024

Node has dropped from cluster error in Galera Cluster original ↗

16 Jan 2024

A year in MySQL Blogging – top blogs, summary and review original ↗

4 Jan 2024

2023

How to filter MySQL slow queries using pt-query-digest original ↗

30 Dec 2023

What do you need to debug MySQL issues – a checklist original ↗

11 Dec 2023

How to get MySQL Primary Keys in one minute original ↗

30 Nov 2023

Quick Look – MySQL Data Directory Files original ↗

25 Sept 2023

How to fix Percona XtraDB Cluster 8.0 Upgrade issues original ↗

5 Sept 2023

One MySQL blog a day challenge original ↗

31 Jul 2023

How to fix MySQL federated table error original ↗

28 Jul 2023

How to replicate without binary logs in MySQL original ↗

27 Jul 2023

MySQL fragmentation and how to defragment original ↗

26 Jul 2023

How to Fix Connection attributes of length xxx were truncated original ↗

25 Jul 2023

How to overcome Throttling and Rate Exceeded Errors in DownloadDBLogFilePortion original ↗

24 Jul 2023

How to meet Signal 11 bug in MariaDB original ↗

25 Jun 2023

How To Install specific version of MySQL 8 on Ubuntu original ↗

8 Jun 2023

How to MySQL Replication setup, Master GTID & SSL Encryption original ↗

4 Jun 2023

Install exact version of Percona Server for MySQL on CentOS original ↗

30 May 2023

MySQL Slow query log export and download in RDS original ↗

30 May 2023

How to fix 1030 Unknown generic error from engine in MySQL original ↗

10 Apr 2023

MySQL 8 – timestamp cannot be null and explicit_defaults_for_timestamp original ↗

20 Mar 2023

2022

Restore single MySQL table (ibd) from Xtrabackup (video demo)original ↗

14 Dec 2022

MySQL Interview – ChatGPT is not your DBA original ↗

14 Dec 2022

Securing MySQL: Data Encryption with Percona Server and Vault original ↗

10 Dec 2022

Can not connect to ProxySQL: reasons and fixtures original ↗

11 Oct 2022

Providing Friday Proofs to MySQL Consultants | Scripts Functions Routines original ↗

24 Sept 2022

The Low Hanging Fruits of MySQL – Percona Live Community 2022 original ↗

13 Jul 2022

2021

Relay log read failure | 2 many dots can break your replication only once original ↗

19 Aug 2021

MySQL Backup setup, automation using Holland, mysqldump on Ubuntu original ↗

23 Mar 2021

2020

Still have MySQL 5.6 variable binlog_error_action as IGNORE_ERROR?original ↗

10 Apr 2020

2019

ProxySQL Configuration & Startup Process explained original ↗

8 Oct 2019

MySQL backup shell script with status email original ↗

9 Apr 2019

2018

दुर्गे दुर्घट भारी – श्री देवीची आरती | Aarti Durge Durghat Bhari | Marathi original ↗

1 Oct 2018

MySQL 8 Resource Group – introduction and dynamic allocation original ↗

7 Sept 2018

Galera cluster to AWS Aurora migration & HA_ERR_FOUND_DUPP_KEY original ↗

13 Aug 2018

Restore A Table / Database From Full Backup – Yet Another Way original ↗

29 Jun 2018

Export MySQL database table to CSV (delimited / Excel) file original ↗

29 Jan 2018

A tale of Corrupt InnoDB table, MySQL crash & recovery original ↗

18 Jan 2018

How to Pause (Suspend) a process in Linux with kill signals original ↗

9 Jan 2018

2017

Decoding Siebel Audit Trail with PLSQL original ↗

14 Dec 2017

Reset root password on Galera Cluster (Percona or MariaDB)original ↗

11 Apr 2017

MySQL to Galera Cluster Migration, Deadlock, Back to basics original ↗

2 Mar 2017

2016

MySQL database restore issues using xtrabackup – facepalm moments original ↗

13 Jun 2016

2015

corrupted / crashed MyISAM + mysql_repair_threads = stuck “Repair with N threads”original ↗

7 Dec 2015

Fixing inconsistency on MySQL Slave of Galera Cluster original ↗

4 Dec 2015

Setting-up second MySQL instance & replication on Linux in 10 steps original ↗

4 Nov 2015

pt-table-checksum & Waiting to check replicas for differences: 0% 00:00 remain original ↗

19 Oct 2015

How to Add Remote MySQL Server to Nagios Monitoring original ↗

17 Aug 2015

MySQL Permission denied error 13 and solution original ↗

20 Jul 2015

How to monitor MySQL backups original ↗

1 Jul 2015

Install Percona Monitoring Tools for Nagios – MySQL Plugins original ↗

30 Jun 2015

UMASK & UMASK_DIR – changing default MySQL file dir permissions original ↗

24 Jun 2015

XML to JSON converter in Siebel original ↗

7 Jun 2015

Setup and configure MySQL backup using Holland and Xtrabackup original ↗

2 Jun 2015

Cannot connect to MySQL server on ‘localhost’: Cacti Error original ↗

20 May 2015

How-to extract from mysqldump | mysql-dump-splitter recipes original ↗

28 Apr 2015

How to fix definer does not exist error 1449 MySQL original ↗

23 Mar 2015

10 useful shell script code snippets | Linux original ↗

10 Mar 2015

How to Restore / point in time recovery using binary logs MySQL original ↗

23 Feb 2015

MySQL grant syntax & dynamic database using wildcards original ↗

3 Feb 2015

Debugging Percona Xtradb (Galera) Cluster node startup / SST errors original ↗

21 Jan 2015

2014

MariaDB slave restore using GTID & xtrabackup bug original ↗

31 Dec 2014

2013

xtrabackup_51: not found & no ‘mysqld’ group in MySQL options original ↗

27 May 2013

Why we need a tester / QA – Software testing original ↗

4 Mar 2013

MySQL variable innodb_flush_method – summarized original ↗

10 Jan 2013

2012

Is your backup complete? – backup MySQL users privileges / grants – pt-show-grants original ↗

17 Dec 2012

MySQL function returns dates of specified day & between date range original ↗

13 Sept 2012

How To Generate Random test Data In MySQL original ↗

5 Jul 2012

Men in Black-3 (MiB-3) – Xtreme Movie Review original ↗

26 May 2012

Load columnar text file into MySQL table original ↗

3 May 2012

MySQL – Alter table-change datatype of column with foreign key original ↗

23 Apr 2012

Selenium vs QTP differences and usage-quick reference original ↗

17 Mar 2012

Access Control in MySQL Stored Routines: DEFINER, INVOKER & SQL SECURITY original ↗

30 Jan 2012