Question : I’m trying to select the time field from five tables and return the oldest time. The userid field […]
Tag: mysql
Optimize schema and query for overlapping date ranges query
Question : We have a database where we track the price of products from different sellers. If I strip everythin […]
Mysql Replication trigger not executing on slave
Question : Mixed replication is enabled. MySQL master has a table Products that has triggers on update and delete. On […]
Dog slow query, needs optimizing, please help
Question : I found this query in our web app that has been made by hired programmers. It performs like […]
Maintaining a production big table
Question : I have a very large table: Table1 in a production environment which I need to alter a column […]
get all posts with their associative tags without duplicates
Question : Two tables. Post and Tag. Many to Many bi-directional relationship. Post Table Tag Table Post_Tag Pivot Table ————— […]
MySQL Cluster – Got error 1601 ‘Out extents, tablespace full’ from NDB
Question : I am trying to do some tests on MySQL Cluster. I am creating my database using following commands: […]
What is the best way to know the structure of a database [closed]
Question : Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the […]
Usefulness of Foreign Key WITHOUT reference option
Question : Sorry, if this is naive question, but I searched a lot and did not get a vivid answers. […]
MySQL – Simple update is very slow and causing high load average with large amount of server
Question : Simple update is very slow and causing high load average with large amount of server : table name […]