Question : This is my query SELECT user_name,candidate_id FROM user AS usr INNER JOIN candidate as can ON usr.user_id = […]
Category: MySQL
MySQL – SQL statement to test minimum length of the word ‘ft_min_word_len’
Question : I’m trying to understand FULLTEXT indexes. Is there some SQL query to test ‘ft_min_word_len’ variable? I’ve tried to […]
What is the cost of adding a foreign key in mysql?
Question : I have an application which has a product_def table defining all products. The recrods in product_def are fixed […]
How can I reinitialize some MyISAM tables without restarting MySQL?
Question : I’m using rsync to copy some measurement data from one PC to the server. Is it possible to […]
How database buffer pool work?
Question : For example we have 2 scenarios: Scenario 1:- We have very small buffer pool size of 100MB. My […]
After mysql_upgrade to 5.7, optimizer not using index on large IN clause
Question : I have a similar issue to some other people have described. In MySQL 5.6.23-72.1-log, a query with a […]
GROUP BY parentId and MAX childId
Question : My tables are below: crm_conversions crm_messages_of_conversions crm_receivers_of_messages I want to get all of conversions of an user with […]
MySQL Database on RDS with memory issues
Question : I am facing high memory utilization issue on RDS MySQL server. We are having other issues too, can […]
Updating data to a new column [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]
Check if a database table has been renamed
Question : My app has a list of an external db’s tables and it needs to be regularly updated. How […]