mysql-5.6 Archives

status table join slows down query by 10 seconds

By adminPosted on February 3, 2023

Question : Got an issue with a fair few queries in our system that all rely on a status table […]

By adminPosted on January 31, 2023

Question : I created large innodb table mysql> select count(*) from big_data; +———-+ | count(*) | +———-+ | 23822336 | […]

By adminPosted on January 31, 2023

Question : This question already has answers here: Why are the passwords in MySQL (5.x) not salted? (1 answer) MYSQL […]

By adminPosted on January 30, 2023

Question : Recently, one of my servers had a crash. I had alot of trouble but managed to restore everything. […]

By adminPosted on January 27, 2023

Question : I have a query that takes 15 seconds to get 350 results in a MySQL 5.6 Server and […]

By adminPosted on January 23, 2023

Question : I have a practice problem on Database implementation and am confused. For this database, I need to store […]

By adminPosted on January 22, 2023

Question : Lately the server’s been going a bit haywire and we’ve spent several weeks chasing down leads to no […]

By adminPosted on January 20, 2023

Question : We are running Percona MySQL 5.6.30. We’ve had an issue where a PHP script on a different host […]

By adminPosted on January 19, 2023

Question : I move client wordpress sites from one VPS to another, it all went smooth until I moved a […]

By adminPosted on January 13, 2023

Question : I am trying to create a Column for my table only if it does not exist. I have […]