Question : What will be the query to add UPPERCASE Constraint to a column of pre-existing table? The question demands […]
Category: MySQL
Increasing mysql ram usage to decrease disk activity
Question : I would like to know if the increasing the following parameters will improve the mysql performance. | query_cache_size […]
Count total where owner_user_id = some_value and deleted_by_owner = 0 or to_user_id = some_value and deleted_by_to = 0
Question : I didn’t know if this is possible using just a query or if I need some procedural logic […]
MySQL intermittent slow queries
Question : After recently migrating MySQL 5.1 to a new, faster server, I’m seeing occasional and seemingly random periods where […]
What is the use of ibdata1 file in mysql?
Question : I have application which has the backend db as Mysql(InnoDb engine), and currently my client wants to decrease […]
Mysql preventing truncate and drop table statements for a specific table
Question : I have a MySQL table that serves as an immutable event store. I added triggers to prevent rows […]
Alternative for creating Database and inside Database having schemes like Oracle in MySQL
Question : In oracle we have database inside database we have schemes and inside schemas we have tables. For Example […]
Filter out rows which the text on that current row is contained in the text of the following row
Question : I wonder if it’s possible, in a SELECT, to filter out rows which the text on that current […]
combined contents of 2 columns can’t contain duplicates
Question : This is a hard question to ask. I find it difficult to put into words. I have two […]
Question on having a MySQL 5.1 replicate from a MySQL 5.6 DB
Question : I have a question in regards of what potential issues that might happen with a MySQL 5.1 DB […]