Here is my favorite handy query to get the list of tables in MySQL without Primary Key : [crayon-67678fd42fc0e224229361/] This my shortest article ever, hope …

  Have you tried connecting to your MySQL server only to get the annoying error, “too many connections” ? This means that the number of …

  To trap Ctrl-C in a shell script, we will need to use the trap shell builtin command. When a user sends a Ctrl-C interrupt …

  In MySQL, views are not only query-able but also updatable. It means that you can use the INSERTor UPDATE statement to insert or update rows of the base table through the …

  In a Master/Slave replication data consistency is a biggest concern and is very easy  to break your replication with  issues such as duplicate keys, missing …

– Requirements This topic assumes that you have user with sudo privileges and have MySQL installed on both server(Master & Slave). If you do not …

  You can login to a remote Linux server without entering password in 3 simple steps using ssky-keygen and ssh-copy-id as explained in this article. …

This article contains information about mysql safe mode such as start mysql in safe mode, find mysqld_safe location, changing password. MySQL Safe Mode Sometime you …

  pt-online-schema-change is a binary part of Percona-toolkit packages by Percona. It’s one of the most stable and efficient, tools for performing large MySQL table structure change in …

  Do the operating systems kill your MySQL instances from time to time? Are some database servers swapping constantly? These are relatively common problems. Why? …