Question : We have 300 databases in our environment mixed of MyISAM and Innodb(innodb_file_per_table has been enabled) tables.Using MySQL 5.5.19 […]
Tag: mysql
How to improve INSERT speed in large table that has unique constraint
Question : I have a simple MyISAM table: explain entities; +————+————-+——+—–+——————-+—————-+ | Field | Type | Null | Key | […]
MySQL/MariaDB data directory backup
Question : I am using a solution of backblaze B2 / duplicity / duply to create backups of my databases. […]
How to get goup concat of count value using sub query
Question : I’m trying to get group concat of count value here table below I want this structure: | y […]
Database for opening times of locations
Question : I’m designing a database for opening times and created this solution. The specifications of the database which will […]
Should I repeat UNIQUE constraint on similar multi-index?
Question : The index are on tuples, ordered sets, of columns, but the UNIQUE constraint or qualifiant for an index […]
MySQL #1054 – Unknown column ‘masterdata_hyung_event.eventId’ in ‘on clause’ on deep join tables
Question : So, I have this query SELECT * FROM hyung LEFT JOIN masterdata_hyung_description ON hyung.descriptionId = masterdata_hyung_description.hyungDescriptionId CROSS JOIN […]
Best way to associate multiple records with one another
Question : What is the best database design to associate multiple rows with another another. Let’s say we have a […]
Users complain that system runs slow when mysqldump is in progress
Question : The MYSQL database (ibdata1) is of size 73 GB and is configured to run as a dedicated database […]
Data sync between two local Mysql databases in different system in same netwrok
Question : I am using mysql as database for my application and for the purpose of fail over and I […]