SHOW GLOBAL VARIABLES like 'table_definition_cache';
SHOW GLOBAL VARIABLES like 'table_open_cache';
SHOW GLOBAL VARIABLES like 'table_open_cache_instances';
SET @@GLOBAL.table_definition_cache=4800;
SET @@GLOBAL.table_open_cache=4800;
-- if a table restrict you to insert data becasue the length is smaller and
-- you realy want to get rid of the restriction
-- do this
show global variables like '%sql%mode';
SELECT @@GLOBAL.sql_mode;
SELECT @@SESSION.sql_mode;
set global sql_mode='NO_ENGINE_SUBSTITUTION';
SET SESSION sql_mode = 'NO_ENGINE_SUBSTITUTION';
-- also set it here
-- /etc/my.cnf
-- http://dev.mysql.com/doc/refman/5.6/en/sql-mode.html
