Purging binary logs from MySQL Master safely
In this post we will discus about the different ways we can purge binary logs safely in MySQL, We recommend you to confirm before purging the binary logs from the master, all logs were applied […]
Articles by MinervaDB Corporation
MySQL 8 invisible indexes
MySQL 8 supports invisible indexes, This allows you to on-demand enable/disable indexes from being used by MySQL optimizer. Now please don’t get confused with “disabled indexes“, “invisible indexes are not disabled indexes, MYISAM supports disabled indexes, […]
How InnoDB confirms maximum transaction durability in MySQL 8 ?
In transaction processing systems we have to guarantee the transaction committed will be durable permanently. For example, In an online commerce platform, The completed transaction will remain safe even if the system crashes. This can […]
How to monitor Linux operations ?
All our customers are on Linux, They have multiple flavors of Linux actually – Ubuntu, CentOS, RedHat Linux, Oracle Linux, SUSE Linux etc. Though we are an full-service everything MySQL shop, Our consulting, support and […]
Rotating MySQL slow query log
MySQL slow_query_log logrotate We often enable MySQL slow_query_log to proactively troubleshoot the performance, There is so lot of information with-in slow_query_log which is enough to address most common (even complex ones occasionally) MySQL performance bottlenecks. What if […]
How to change the number or size of InnoDB Redo Log Files ?
To change the number or the size of your InnoDB redo log files, please follow the steps below: Step 1: Stop the MySQL server and confirm that it has shutdown without any errors Step 2: […]
MySQL 8.0 : Improved error logging
We extensively use MySQL error logging for proactive diagnostics, MySQL 8 has improved error logging which is capable of sending multiple format (like JSON) logs to multiple destinations like Kibana for log processing and analysis. […]
Configuring innodb_force_recovery to troubleshoot InnoDB page corruption
I personally don’t encourage my readers to follow this post in production without clearly understanding about InnoDB page corruption error troubleshooting, Setting innodb_force_recovery is done only when there is innodb page corruption emergency. By default […]
Vacation DBA Services
DBA job in an large internet property or technology company is highly stressful and often they end-up working extended working hours (occasionally weekends also) Corporations globally are committed to guaranteeing maximum work-life balance for their […]
Benchmarking CPU, Memory, file I/O and mutex performance using Sysbench
We already have written blog on Sysbench (https://minervadb.com/index.php/2018/03/13/benchmarking-mysql-using-sysbench-1-1/) , so in this blog we are not covering basic details like installation and configuration of Sysbench. In this blog we are just specific on benchmarking CPU, […]