Question : I have a very simple setup of a master MySQL DB with one slave MySQL DB replicating from […]
Tag: mysql-5.6
Why is MariaDB 10 refusing to use my index on a date field?
Question : I have the following table definition: CREATE TABLE `bets` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `id_mp` bigint(20) NOT […]
Can I use table aliases in a MySQL DELETE statement?
Question : This does not work: DELETE FROM topics AS t , posts AS p USING t INNER JOIN p […]
MySQL 5.6 – Query Performance Issue. Searching for Slug
Question : I’ve a case where I don’t know how to better the performance of this query. This is a […]
Select maximum of a count in a grouped clause
Question : I have the following tables: Vehicles(v͟i͟n͟, model,category) Sales(s͟a͟l͟e͟I͟D͟, staffID,customerID,date) vehicleSold(saleID,v͟i͟n͟,salePrice) When I join these tables using: select YEAR(Sales.saleDate) […]
Performance issue | MySQL Consumes more than 80%+ memory and 2000%+ CPU
Question : Everyday during the peak time my server getting slow or down. Our hosting provider insisting us to upgrade […]
Is there any performance reason to append an unused AUTO_INCREMENT column in MySQL 5.6?
Question : In my work environment, MySQL has some weird stuff with performance, and one of the other devs wanted […]
How to get row count from all tables of a schema ( without using information schema )
Question : The query should collect data from table name , schema name from information.schema and row count should be […]
Replicating from MySQL 5.1 master to 5.6 slave failing because ‘INSERT … VALUES (NOW())’ results in ‘Error_code: 1062’
Question : I am migrating away from some old MySQL 5.1 servers to some new MySQL 5.6 servers. During this […]
Issues with mysql enterprise backup, assertion failure on restore
Question : I’m trying to restore a backup to a new server, but having some issues with corruption. The source […]