Ever wondered what SQL statements are fired when you click on various options in phpMyAdmin. You can learn a great deal of SQL if you can just observe what is happening behind the scenes! All you have to do is just check the localhost.log file in your data directory of mysql. run the following in(…)
free howtos tutorials on mysql, Mysql 4.0, Mysql 5.0, Replication , Backup installation, configuration, support, technical quries, tips
i was getting the following error while taking database backup [root@solr7 ~]# mysqldump -u root -p**** ostn>ostn mysqldump: Couldn’t execute ‘SELECT @@GTID_MODE’: Unknown system variable ‘GTID_MODE’ (1193) This error is in part due to the introduction of Global Transaction Identifiers (GTIDs) in MySQL 5.6. GTIDs make it simple to # track and compare replication across(…)
Some times you will be getting replication errors on the slaves , this might be coming because of theÂ followingÂ any one of the reason Might have killed a queryÂ in betweenÂ in the master server Duplicate entry Version difference , due to this some of the queries may not work in slaves Any other reasons You can put(…)
I was Converting my Database Engine from Innodb to MyISAM and i got the following error “Cannot delete or update a parent row: a foreign key constraint fails” Solution: I took the entire backup of the DB and edited the file andÂ changedÂ the Â ”ENGINE=MyISAM”Â and restored it to a new DB.
If you get Â #2002 Cannot log in to the MySQL server in phpMyAdmin change $cfg['Servers'][$i]['host'] = ‘localhost’; to $cfg['Servers'][$i]['host'] = ’127.0.0.1′;
If you get this error messageÂ like “Wrong permissions on configuration file, should not be world writable!” in phpMyAdmin and page can not load.It could be because config.inc.php isÂ given write permission. Simply runÂ chmod a-w config.inc.php commandÂ it will solve your problem.
Steps to Recover a corrupt table in mysql 1)Â Â Â Â Â Go to Â /var/lib/mysql/DB_Name Â (Assuming DB is stored in given path) 2)Â Â Â Â Â Run below command to scan whole DB to check for errors. myisamchk /var/lib/mysql/DB_NAME/*.MYI >> /tmp/myisamchk_log.txt (Report will be exported in .txt format) Use can see babel_user is corrupted 3)Â Â Â Â Â Now run myisamchk â€“r babel_user.MYI command(…)
Example InnoDB my.cnf file for high end GNU/Linux machines #—————————————————————- # # my.cnf file # # # See: # # http://dev.mysql.com/doc/refman/5.1/en/server-options.html # http://dev.mysql.com/doc/refman/5.1/en/option-files.html # # You can also dump all the variables set for mysqld with: # # mysqld –verbose –help # #—————————————————————- [client] # These options apply to all client applications # Port and(…)
This is an example config file for a 64bit 8GB GNU/Linux machine running mainly InnoDB. This config file will not work on a 32bit instance as it is configured to address more memory than 32bit procceses allow. This configuration assumes that this will be a replication master. If this is a slave and it doesn’t(…)
Bin log position is used to set the replication in MySQL. Â One of the easiest way to set the replication in Mysql in the following ways. First Take the entire Dump of MySQL with mysql command mysqldump -u root -p –all-databases –master-data=2 > dump_file21102010 The second head the 100 lines in the dump file to(…)
AmazonÂ EC2Â makes it easy to get a large number of servers on which to run MySQL, but there are many choices to be made about the server and storage to use. There are 5 types of servers: small, large, extra-large, high-cpu medium and high-cpu extra-large. There are at least two types of storage: local disk andÂ EBS.(…)
This session focuses onÂ ZFSÂ performance with MySQL, and explores its suitability for deploying workloads based on MyISAM and InnoDB.Â ZFSÂ performance relative to other file systems and the impact ofÂ ZFSÂ compression on MySQL performance will also be examined. TheÂ ZFSÂ Intent Log (ZIL) and the second level Adaptive Replacement Cache (L2ARC) benefit from low latencies, and benchmark results will be presented(…)