Mysql Convert Json Data Type Column Into Rows

mysqladmin to kill the runaway query

Run the following commands: mysqladmin -uusername -ppassword pr Then note down the process id. mysqladmin -uusername -ppassword kill pid

Do Not ORDER BY RAND()

If you really need random rows out of your results, there are much better ways of doing it. Granted it takes additional code, but you will prevent a bottleneck that gets exponentially worse as your data grows. The problem is, MySQL will have to perform RAND() operation (which takes processing power) for every single row […]