Question : The query should collect data from table name , schema name from information.schema and row count should be […]
Tag: information-schema
Query databases that have MYISAM tables that do not have only fulltext index tables
Question : I am trying to query from the information_schema where the database (table_schema) has MYISAM tables but does not […]
Predicting the primary keys exhaustion in MySQL based on rate of insertion
Question : We are running out of primary keys for our table in production. We do not want that to […]
INFORMATION_SCHEMA.GLOBAL_VARIABLES alternative in 5.7? More info about show_compatibility_56
Question : mysql> SELECT * FROM GLOBAL_VARIABLES; ERROR 3167 (HY000): The ‘INFORMATION_SCHEMA.GLOBAL_VARIABLES’ feature is disabled; see the documentation for ‘show_compatibility_56’ […]
How is INFORMATION_SCHEMA implemented in MySQL?
Question : The INFORMATION_SCHEMA is, in theory, a set of views specified in the SQL standard that allow the user […]
Does MySQL 5.5 support shared database with separate schema?
Question : I am developing a SaaS based product using MySQL 5.5 as the backend database. I want to keep […]
Select query on information_schema is too slow
Question : SELECT * FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA = DATABASE() AND CONSTRAINT_NAME = ‘FK_FOLDER_FILTER_CONTRACT_CATEGORY_CONTRACT_CATEGORY’ AND CONSTRAINT_TYPE = ‘FOREIGN KEY’; The […]
Which databases are backed up by “mysqldump –all-databases”?
Question : Which databases are included in the dump generated by mysqldump –all-databases? By my experience, that should be all […]
Whats the difference between information_schema.user_privileges and mysql.user?
Question : I have the notion that privileges set in mysql.user should reflect in information_schema.user_privileges but when I try to […]
Why does information_schema have “YES” and “NO” character strings rather than booleans?
Question : I was taken by surprise to find that the is_nullable column for this query is typed as character […]