MARKS TUTORIAL

Why all queries are going into slow query log in MySQL We got a problem that every query that we ran in MySQL database got logged into slow query log even if the “ Query_time” of that query is of sub seconds say 0.0034 whereas our “ long_query_time” is set to 8 seconds.  -- Reason we found out for this behavior: After investigation we found out that the parameter “log_queries_not_using_indexes” was set to ON and that is why all queries land into slow query log as they were not using indexes. We turn it off and it solves our problem. But if you do need logging of queries not using indexes then please do turn it on.  set global log_queries_not_using_indexes=0; set global log_queries_not_using_indexes=1; or set global log_queries_not_using_indexes=OFF; set global log_queries_not_using_indexes=ON; Remember it will not persist database restart, for that you have to do parameter setting in my.cnf Some of the Parameters related to slow qu...

How to Install MySQL from binary tar in Linux or Unix To install MySQL in UNIX like system(s) you can follow various approaches as you like it.   -- Install MySQL using RPM packages.     -- Install MySQL using pre-compiled binary tar file in the format tar.gz     --Install MySQL by compiling it from source code. Note : Make sure that all files related to MySQL Server are owned by proper user  say owner(mysql) and group(mysql). The last approach gives the maximum flexibility but also do require a lot of effort on your part. In this article we are going to discuss the second approach that is Install MySQL using pre-compiled binary tar file in the format tar.gz Oracle provides a set of binary distributions of MySQL. These include binary distributions in the form of compressed tar files (files with a .tar.gz extension) for a number of platforms, as well as binaries in platform-specific package formats for selected platforms....