How to Restore / point in time recovery using binary logs MySQL
Kedar
In this post I will share a recovery scenario of a MySQL database restore from the binary logs. This post is also a good example of how we can achieve…
Browsing Category
MySQL
128 posts
Articles related to MySQL, Percona Server, MariaDB
MySQL grant syntax & dynamic database using wildcards
The MySQL grant syntax allows you to specify dynamic database names using the wildcard characters. This article explains the usecase of dynamic section of mysql grants.
Debugging Percona Xtradb (Galera) Cluster node startup / SST errors
A Percona Xtradb (Galera) Cluster node may fail to join it due to many possible mistakes causing SST to fail. It could be a configuration item or purely setup requirement. In this article we will be troubleshooting step by step the SST issues faced.
MariaDB slave restore using GTID & xtrabackup bug
Restoring MariaDB (MySQL) slave using Xtrabackup & GTID.
xtrabackup_51: not found & no ‘mysqld’ group in MySQL options
Recently I happen to setup a new MySQL instance with my tools – a standard MySQL 5.1+, xtrabackup setup and last-hotbackup.tar.gz. To restore from the backup we used xtrabackup binaries…
MySQL variable innodb_flush_method – summarized
innodb_flush_method variable specifies how InnoDB opens and flushes log and data files. In Innodb optimization, setting the variable innodb_flush_method tweaks the performance most of the times but there are cases…
One response to “MySQL variable innodb_flush_method – summarized”
Kedar,
Thanks a lot for info. But i have a question if you can answer that too, it’d be great.
Is there any disadvantages of setting innodb_flush_method=normal in Windows?
as with this option, we prevents mysql from using unbuffered IO OR native async IO.
Let me know of any disadvantages or harm that can possibly happens to mysql data by setting this option to “normal”