With generic asynchronous MySQL Replication we often use skip_slave_counter to tackle / skip anonymous transactions which creates errors or halt MySQL Replication. But if we try to skip slave counter whilst GTID_MOD is ON we get following error. ERROR 1858 (HY000): sql_slave_skip_counter can not be set when the server is running with @@GLOBAL.GTID_MODE = ON. […]
Reduce startup and shutdown time by using warm up innodb buffer pool For database servers having large memory utilisation and have big innodb_buffer_pool_size , it takes longer to stop and start the instance. This is because more data and indexes stored in huge innodb_buffer_pool. This data and indexes are used by queries running on the […]
Few issues I came across when dealing with MySQL performance. Let us go through these problems one by one. Swap usage: MySQL loves memory as almost all databases do but MySQL tries to utilise all the possible available memory. In order to restrict MySQL to use allocated memory resources we should implement following:- Swapiness Swappiness […]
Oracle VS MySQL file architecture For Oracle database administrator, when it comes to learn new technology it always starts from comparison with respect to physical or logical architecture. Physical file architecture comparison is given below , I hope it will be very useful for Oracle or MySQL database administrators who want to learn either of […]
