How iowait impacts System performance System or any server’s performance heavily depends on IOPS. And if MySql is running on the System, it requires disk of high IOPS. Lots of select queries running simultaneously cause high iowait if disk dont have high IOPS. High iowait means cpu is waiting for I/O access. That increase the…

selecting data from mysql db using regular expression

A regular expression is a powerful way of specifying a pattern for a complex search. Below is a simple example. select email from foo where email REGEXP ‘$’; In the above example, It will list all the email which ends with “$” sign is used to denote the end of the string.