Here is my favorite handy query to get the list of tables in MySQL without Primary Key : [crayon-6703f4fa5553a174081405/] This my shortest article ever, hope …
Read More »Mikael HOUNDEGNON
What you should know before changing MySQL max_connections variable
Have you tried connecting to your MySQL server only to get the annoying error, “too many connections” ? This means that the number of …
Read More »How to Catch Ctrl-C in Shell Script
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 …
Read More »MySQL updatable/Insertable views
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 …
Read More »Best practice to avoid duplicate entry errors on the slave
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 …
Read More »Setup a simple MySQL Master Slave Replication
– Requirements This topic assumes that you have user with sudo privileges and have MySQL installed on both server(Master & Slave). If you do not …
Read More »SSH Login Without Password Using ssh-keygen & ssh-copy-id
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. …
Read More »Connect to MySQL Server without password in safe mode
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 …
Read More »Alter large MySQL table without blocking reads or writes with pt-online-schema-change
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 …
Read More »MySQL Crashed by OOM Killer (out of memory). Why? How to prevent them?
Do the operating systems kill your MySQL instances from time to time? Are some database servers swapping constantly? These are relatively common problems. Why? …
Read More »