Skip to main content

ERROR 1206 (HY000): The total number of ...

ERROR 1206 (HY000): The total number of locks exceeds the lock table size

while running queries on a Large number of rows and your DB engine is InnoDB, you will face this error. Basic reason for this is, Mysql is out of Lock Space, You need to increase the value of “innodb_buffer_pool_size” edit my.cnf see the highlighted line “innodb_buffer_pool_size=2G” for me I needed to manage much rows so […]

MySQL – Show Running Queries

MySQL – Show Running Queries

MySQL Show Running Queries it is deadly simple :D. login to your MySQL , and use this query “show processlist” it will only show the first 100 characters of the query. if you need to see the complete query To show the full query run to get data in rows instead of columns,

MySQL Substring Count

MySQL Substring Count

I needed to count the parts of a string (varchar) which are separated by a `;` (semi colon) if I use PHP, i always need to fetch the rows and then explode or any thing else. which was really time consuming A very useful function for counting parts of string using Mysql. and here is […]