How to fix definer does not exist error 1449 MySQL
Kedar
Explaining and providing solutions of MySQL error 1449: The user specified as a definer does not exist using SQL SECURITY INVOKER and DEFINER.
Browsing Tag
MySQL
77 posts
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…
Is your backup complete? – backup MySQL users privileges / grants – pt-show-grants
Everybody knows the criticality of backup. You might have had your database dumped, data directory copied, flat files exported and even config and binary log files backed-up. But did you…