Question : I’m configuring this across two different servers on two different hosting companies. Here is the tutorial I’ve followed […]
Category: MySQL
Database inserts/updates slow only in Production
Question : We have a int/test/staging/production Mysql database setup. A Java application(using Hibernate) that periodically generates up to 200,000 updates/inserts […]
What’s the equivalent of –safe-updates of mysql in MS SQL Server?
Question : In MySQL, you can use the feature called –safe-updates (–i-am-a-dummy) to limit the number of rows updated per […]
MySql – alternate of auto_increment on multiple columns
Question : Since auto_increment on multiple columns is supported in MyISAM engine only and I can’t use it because of […]
Execute Subquery once only
Question : How do I execute a Subquery once in a Query like this http://sqlfiddle.com/#!9/8b149d/1/0 select id, ( select group_concat(user) […]
Get the quantity of sold products on a specific day, keeping all products
Question : I’m building a database for daily sales report, for example: 2 apples sold for 2.50 on 2021-02-12 1 […]
Aggregate query optimization
Question : Could you please help me to optimize this query – currently it takes ~4 minutes to run this […]
In MySQL, does the order of the columns in a WHERE clause affect query performance,why? [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
How to select rows with a particular rank per partition?
Question : I want to pick the row with the highest value in a column based on partitioning on another […]
Mysql slow query log always include “# Time:”
Question : I am trying to parse the mysql slow log with logstash so it’s important that the format is […]