Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql [localhost] {msandbox} (test) > select var55.variable_name,left(var55.variable_value,40) value55, left(var56.variable_value,40) var56 from var55 left join var56 on var55.variable_name=var56.variable_name where var55.variable_value!=var56.variable_value;
- +---------------------------------------------------+------------------------------------------+------------------------------------------+
- | variable_name | value55 | var56 |
- +---------------------------------------------------+------------------------------------------+------------------------------------------+
- | PERFORMANCE_SCHEMA | OFF | ON |
- | PID_FILE | /mnt/data/sandboxes/msb_5_5_30/data/mysq | /mnt/data/sandboxes/msb_5_6_10/data/mysq |
- | CHARACTER_SETS_DIR | /mnt/nfs/dist/mysql-5.5.30-linux2.6-x86_ | /mnt/nfs/dist/mysql-5.6.10-linux-glibc2. |
- | PERFORMANCE_SCHEMA_MAX_COND_INSTANCES | 1000 | 836 |
- | PERFORMANCE_SCHEMA_MAX_MUTEX_INSTANCES | 1000000 | 3282 |
- | OLD_PASSWORDS | OFF | 0 |
- | INNODB_STATS_ON_METADATA | ON | OFF |
- | PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_SIZE | 10 | 5 |
- | PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_LONG_SIZE | 10000 | 100 |
- | PERFORMANCE_SCHEMA_MAX_RWLOCK_INSTANCES | 1000000 | 1724 |
- | PERFORMANCE_SCHEMA_MAX_TABLE_HANDLES | 100000 | 2223 |
- | INNODB_LOG_FILE_SIZE | 5242880 | 50331648 |
- | BASEDIR | /mnt/nfs/dist/5.5.30 | /mnt/nfs/dist/5.6.10 |
- | BACK_LOG | 50 | 80 |
- | OPEN_FILES_LIMIT | 1024 | 5000 |
- | INNODB_AUTOEXTEND_INCREMENT | 8 | 64 |
- | MAX_CONNECT_ERRORS | 10 | 100 |
- | SORT_BUFFER_SIZE | 2097152 | 262144 |
- | LC_MESSAGES_DIR | /mnt/nfs/dist/mysql-5.5.30-linux2.6-x86_ | /mnt/nfs/dist/mysql-5.6.10-linux-glibc2. |
- | MAX_ALLOWED_PACKET | 1048576 | 4194304 |
- | JOIN_BUFFER_SIZE | 131072 | 262144 |
- | TMPDIR | /mnt/data/sandboxes/msb_5_5_30/tmp | /mnt/data/sandboxes/msb_5_6_10/tmp |
- | TABLE_OPEN_CACHE | 400 | 2000 |
- | INNODB_VERSION | 5.5.30 | 1.2.10 |
- | INNODB_BUFFER_POOL_INSTANCES | 1 | 8 |
- | QUERY_CACHE_SIZE | 0 | 1048576 |
- | SLOW_QUERY_LOG_FILE | /mnt/data/sandboxes/msb_5_5_30/data/dpe0 | /mnt/data/sandboxes/msb_5_6_10/data/dpe0 |
- | TABLE_DEFINITION_CACHE | 400 | 1400 |
- | PORT | 5530 | 5610 |
- | QUERY_CACHE_TYPE | ON | OFF |
- | REPORT_PORT | 5530 | 5610 |
- | PERFORMANCE_SCHEMA_MAX_FILE_INSTANCES | 10000 | 1556 |
- | SQL_MODE | | NO_ENGINE_SUBSTITUTION |
- | INNODB_OLD_BLOCKS_TIME | 0 | 1000 |
- | LOG_ERROR | /mnt/data/sandboxes/msb_5_5_30/data/msan | /mnt/data/sandboxes/msb_5_6_10/data/msan |
- | VERSION_COMPILE_OS | linux2.6 | linux-glibc2.5 |
- | THREAD_CACHE_SIZE | 0 | 9 |
- | PLUGIN_DIR | /mnt/nfs/dist/5.5.30/lib/plugin/ | /mnt/nfs/dist/5.6.10/lib/plugin/ |
- | SYNC_RELAY_LOG | 0 | 10000 |
- | GENERAL_LOG_FILE | /mnt/data/sandboxes/msb_5_5_30/data/dpe0 | /mnt/data/sandboxes/msb_5_6_10/data/dpe0 |
- | PERFORMANCE_SCHEMA_MAX_TABLE_INSTANCES | 50000 | 445 |
- | SYNC_RELAY_LOG_INFO | 0 | 10000 |
- | SLAVE_LOAD_TMPDIR | /mnt/data/sandboxes/msb_5_5_30/tmp | /mnt/data/sandboxes/msb_5_6_10/tmp |
- | SECURE_AUTH | OFF | ON |
- | VERSION | 5.5.30 | 5.6.10 |
- | INNODB_CONCURRENCY_TICKETS | 500 | 5000 |
- | INNODB_PURGE_THREADS | 0 | 1 |
- | INNODB_OPEN_FILES | 300 | 2000 |
- | INNODB_DATA_FILE_PATH | ibdata1:10M:autoextend | ibdata1:12M:autoextend |
- | INNODB_PURGE_BATCH_SIZE | 20 | 300 |
- | PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES | 1000 | 224 |
- | SOCKET | /tmp/mysql_sandbox5530.sock | /tmp/mysql_sandbox5610.sock |
- | INNODB_FILE_PER_TABLE | OFF | ON |
- | SYNC_MASTER_INFO | 0 | 10000 |
- | DATADIR | /mnt/data/sandboxes/msb_5_5_30/data/ | /mnt/data/sandboxes/msb_5_6_10/data/ |
- | OPTIMIZER_SWITCH | index_merge=on,index_merge_union=on,inde | index_merge=on,index_merge_union=on,inde |
- +---------------------------------------------------+------------------------------------------+------------------------------------------+
- 56 rows in set (0.05 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement