Show all constraints
by admin | Apr 1, 2016 | information_schema
This select shows all constraints for all tables in point of view of every table. So there are of course duplicities but we can see all constraints for table at once. select * from ( select CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, CONSTRAINT_NAME, TABLE_CATALOG,...Recent Posts
- Investigation of locks on MySQL tables
- Settings for parallel replication workers
- How to clean or resize the ibtmp1 file in MySQL
- Check MySQL slow log from command line
- Relay log read failure: Could not parse relay log event entry – binary log is corrupted
- How to change data type of column used in foreign key
- Tiny fun with TINYINT data type
- How to handle errcode 28 – no space left
- What can happen when you try to use very big VARCHAR columns
- Message “Could not increase number of max_open_files” in MySQL error log
- MySQL 5.7 parameter range_optimizer_max_mem_size
- Setting MySQL chain replication
- MySQL memory usage / settings
- Problems with remote login into MySQL caused by performance_schema tables
- How to handle heavy changes in MySQL replication with ansible
- Error ‘You cannot ‘ALTER’ a log table if logging is enabled’ on query. Default database: ‘mysql’. Query: ‘ALTER TABLE slow_log
- Switch the binlog format at runtime
- Bash script – restore non-replica from data files backuped with Percona XtraBackup
- MySQL replication troubleshooting – replication error on replica
- Bash script: create backup with Percona XtraBackup
- Clone database with Percona xtrabackup
- Experiences with tuning of MySQL 5.7 replicas
- Move MySQL data files / log files / temp directory to the different disk on Ubuntu / Debian
- Create new replica by copying data and log files on OS level
- Global status – table open cache
Categories
- Ansible (3)
- Backup + Restoration (3)
- Data manipulations (1)
- Database design (4)
- Global Status (2)
- information_schema (2)
- Locks (2)
- mySQL on Linux (1)
- Performance (9)
- Replication (15)
- Settings (4)
- Storage engines (4)
- Transactions (6)
- Troubleshooting (9)
- Useful small hints (4)
- Usefull scripts (3)