VARIABLE_NAME | VARIABLE_VALUE |
MAX_PREPARED_STMT_COUNT | 16382 |
LOG_BIN | OFF |
HAVE_CRYPT | NO |
PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_LONG_SIZE | 10000 |
INNODB_VERSION | 1.0.6 |
LOG | OFF |
FT_MIN_WORD_LEN | 4 |
PERFORMANCE_SCHEMA_MAX_COND_INSTANCES | 1000 |
LC_MESSAGES | en_US |
PERFORMANCE_SCHEMA_MAX_THREAD_CLASSES | 50 |
SYNC_FRM | ON |
PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES | 1000 |
DELAYED_INSERT_TIMEOUT | 300 |
PERFORMANCE_SCHEMA_MAX_MUTEX_INSTANCES | 1000 |
MAX_HEAP_TABLE_SIZE | 16777216 |
PERFORMANCE_SCHEMA_MAX_RWLOCK_INSTANCES | 1000 |
MULTI_RANGE_COUNT | 256 |
PERFORMANCE_SCHEMA_MAX_RWLOCK_CLASSES | 20 |
BASEDIR | C:/Program Files/MySQL/MySQL Server 5.5/ |
PERFORMANCE_SCHEMA_MAX_MUTEX_CLASSES | 200 |
UPDATABLE_VIEWS_WITH_LIMIT | YES |
PERFORMANCE_SCHEMA | OFF |
SLOW_LAUNCH_TIME | 2 |
BINLOG_CACHE_SIZE | 32768 |
RANGE_ALLOC_BLOCK_SIZE | 4096 |
AUTOMATIC_SP_PRIVILEGES | ON |
RELAY_LOG_INDEX | |
BACK_LOG | 50 |
SQL_QUOTE_SHOW_CREATE | ON |
CHARACTER_SET_CONNECTION | latin5 |
PERFORMANCE_SCHEMA_MAX_FILE_CLASSES | 50 |
QUERY_CACHE_WLOCK_INVALIDATE | OFF |
WAIT_TIMEOUT | 28800 |
CHARACTER_SET_RESULTS | latin5 |
PERFORMANCE_SCHEMA_MAX_TABLE_HANDLES | 100000 |
FT_MAX_WORD_LEN | 84 |
DELAYED_INSERT_LIMIT | 100 |
BINLOG_DIRECT_NON_TRANSACTIONAL_UPDATES | OFF |
REPORT_HOST | |
THREAD_STACK | 196608 |
MYISAM_SORT_BUFFER_SIZE | 36700160 |
COMPLETION_TYPE | NO_CHAIN |
INNODB_OLD_BLOCKS_PCT | 37 |
DELAYED_QUEUE_SIZE | 1000 |
LARGE_FILES_SUPPORT | OFF |
EVENT_SCHEDULER | OFF |
PID_FILE | C:\ProgramData\MySQL\MySQL Server 5.5\Data\sinan.pid |
INNODB_USE_SYS_MALLOC | ON |
NET_BUFFER_LENGTH | 16384 |
LOWER_CASE_TABLE_NAMES | 1 |
SKIP_SHOW_DATABASE | OFF |
CHARACTER_SET_FILESYSTEM | binary |
GROUP_CONCAT_MAX_LEN | 1024 |
INTERACTIVE_TIMEOUT | 28800 |
INNODB_LOG_BUFFER_SIZE | 1048576 |
CHARACTER_SETS_DIR | C:\Program Files\MySQL\MySQL Server 5.5\share\charsets\ |
HAVE_GEOMETRY | YES |
FLUSH | OFF |
INNODB_MAX_PURGE_LAG | 0 |
SERVER_ID | 0 |
MYISAM_MAX_SORT_FILE_SIZE | 107374182400 |
FT_QUERY_EXPANSION_LIMIT | 20 |
MYISAM_RECOVER_OPTIONS | OFF |
CONCURRENT_INSERT | AUTO |
SQL_NOTES | ON |
LC_MESSAGES_DIR | C:\Program Files\MySQL\MySQL Server 5.5\share\ |
LOW_PRIORITY_UPDATES | OFF |
KEY_CACHE_AGE_THRESHOLD | 300 |
REPORT_PASSWORD | |
FT_BOOLEAN_SYNTAX | + -><()~*:""&| |
MAX_INSERT_DELAYED_THREADS | 20 |
AUTO_INCREMENT_OFFSET | 1 |
HAVE_COMPRESS | YES |
JOIN_BUFFER_SIZE | 131072 |
TRANSACTION_ALLOC_BLOCK_SIZE | 8192 |
CONNECT_TIMEOUT | 10 |
THREAD_CACHE_SIZE | 8 |
SQL_LOW_PRIORITY_UPDATES | OFF |
INNODB_DOUBLEWRITE | ON |
INIT_FILE | |
LARGE_PAGES | OFF |
LARGE_PAGE_SIZE | 0 |
DEFAULT_WEEK_FORMAT | 0 |
INIT_SLAVE | |
LOG_OUTPUT | FILE |
MAX_BINLOG_SIZE | 1073741824 |
INNODB_IO_CAPACITY | 200 |
MAX_ERROR_COUNT | 64 |
PROTOCOL_VERSION | 10 |
SLOW_QUERY_LOG | OFF |
HAVE_SYMLINK | YES |
LOG_WARNINGS | 1 |
TIME_ZONE | SYSTEM |
INNODB_TABLE_LOCKS | ON |
NET_RETRY_COUNT | 10 |
INNODB_AUTOEXTEND_INCREMENT | 8 |
LOWER_CASE_FILE_SYSTEM | ON |
MYISAM_DATA_POINTER_SIZE | 6 |
VERSION_COMPILE_OS | Win32 |
INNODB_THREAD_SLEEP_DELAY | 10000 |
NAMED_PIPE | OFF |
SQL_AUTO_IS_NULL | OFF |
LOG_QUERIES_NOT_USING_INDEXES | OFF |
SLAVE_TRANSACTION_RETRIES | 10 |
NET_WRITE_TIMEOUT | 60 |
HAVE_INNODB | YES |
FT_STOPWORD_FILE | (built-in) |
SYNC_RELAY_LOG_INFO | 0 |
DELAY_KEY_WRITE | ON |
INNODB_REPLICATION_DELAY | 0 |
OPTIMIZER_SEARCH_DEPTH | 62 |
QUERY_CACHE_MIN_RES_UNIT | 4096 |
LONG_QUERY_TIME | 10.000000 |
INNODB_STATS_ON_METADATA | ON |
BULK_INSERT_BUFFER_SIZE | 8388608 |
INNODB_ROLLBACK_ON_TIMEOUT | OFF |
MYISAM_REPAIR_THREADS | 1 |
PROFILING_HISTORY_SIZE | 15 |
MAX_LENGTH_FOR_SORT_DATA | 1024 |
INNODB_CHANGE_BUFFERING | inserts |
READ_BUFFER_SIZE | 65536 |
READ_RND_BUFFER_SIZE | 262144 |
TABLE_OPEN_CACHE | 256 |
INNODB_FILE_FORMAT | Antelope |
CHARACTER_SET_SERVER | latin5 |
BIG_TABLES | OFF |
OLD_ALTER_TABLE | OFF |
SQL_SELECT_LIMIT | 18446744073709551615 |
QUERY_PREALLOC_SIZE | 8192 |
DATE_FORMAT | %Y-%m-%d |
MAX_CONNECT_ERRORS | 10 |
READ_ONLY | OFF |
MAX_SORT_LENGTH | 1024 |
MAX_CONNECTIONS | 100 |
INNODB_DATA_FILE_PATH | ibdata1:10M:autoextend |
COLLATION_SERVER | latin5_turkish_ci |
OLD_PASSWORDS | OFF |
FLUSH_TIME | 1800 |
PROFILING | OFF |
REPORT_USER | |
INNODB_STRICT_MODE | OFF |
OPEN_FILES_LIMIT | 2670 |
KEY_CACHE_DIVISION_LIMIT | 100 |
MAX_SEEKS_FOR_KEY | 4294967295 |
GENERAL_LOG_FILE | C:\ProgramData\MySQL\MySQL Server 5.5\Data\sinan.log |
SQL_MAX_JOIN_SIZE | 18446744073709551615 |
PERFORMANCE_SCHEMA_MAX_COND_CLASSES | 80 |
SQL_BIG_SELECTS | ON |
AUTO_INCREMENT_INCREMENT | 1 |
QUERY_CACHE_SIZE | 0 |
TMPDIR | C:\Windows\TEMP |
SQL_LOG_BIN | ON |
EXPIRE_LOGS_DAYS | 0 |
BINLOG_FORMAT | STATEMENT |
HAVE_PARTITIONING | YES |
LOCK_WAIT_TIMEOUT | 31536000 |
FOREIGN_KEY_CHECKS | ON |
HOSTNAME | sinan |
RELAY_LOG_INFO_FILE | relay-log.info |
QUERY_ALLOC_BLOCK_SIZE | 8192 |
INNODB_AUTOINC_LOCK_MODE | 1 |
MIN_EXAMINED_ROW_LIMIT | 0 |
INNODB_COMMIT_CONCURRENCY | 0 |
PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_SIZE | 10 |
INNODB_MIRRORED_LOG_GROUPS | 1 |
SSL_CAPATH | |
UNIQUE_CHECKS | ON |
VERSION_COMMENT | MySQL Community Server (GPL) |
VERSION | 5.5.3-m3-community |
SLAVE_TYPE_CONVERSIONS | |
INNODB_SUPPORT_XA | ON |
INNODB_FLUSH_METHOD | |
INNODB_SYNC_SPIN_LOOPS | 30 |
SYSTEM_TIME_ZONE | GTB Yaz Saati |
COLLATION_CONNECTION | latin5_turkish_ci |
OPTIMIZER_PRUNE_LEVEL | 1 |
INNODB_ADAPTIVE_FLUSHING | ON |
MAX_WRITE_LOCK_COUNT | 4294967295 |
INNODB_ADAPTIVE_HASH_INDEX | ON |
TIMED_MUTEXES | OFF |
SKIP_NETWORKING | OFF |
QUERY_CACHE_LIMIT | 1048576 |
DIV_PRECISION_INCREMENT | 4 |
INIT_CONNECT | |
DATADIR | C:\ProgramData\MySQL\MySQL Server 5.5\Data\ |
CHARACTER_SET_DATABASE | latin5 |
INNODB_DATA_HOME_DIR | |
HAVE_SSL | DISABLED |
INNODB_READ_IO_THREADS | 4 |
VERSION_COMPILE_MACHINE | x86 |
INNODB_WRITE_IO_THREADS | 4 |
TABLE_DEFINITION_CACHE | 400 |
TIME_FORMAT | %H:%i:%s |
INNODB_FORCE_RECOVERY | 0 |
OLD | OFF |
INNODB_LOG_FILES_IN_GROUP | 2 |
TMP_TABLE_SIZE | 18874368 |
THREAD_HANDLING | one-thread-per-connection |
HAVE_DYNAMIC_LOADING | YES |
QUERY_CACHE_TYPE | ON |
SYNC_BINLOG | 0 |
SQL_BIG_TABLES | OFF |
RELAY_LOG_SPACE_LIMIT | 0 |
ENGINE_CONDITION_PUSHDOWN | ON |
INNODB_OPEN_FILES | 300 |
MAX_SP_RECURSION_DEPTH | 0 |
INNODB_FILE_FORMAT_CHECK | Barracuda |
REPORT_PORT | 3306 |
INNODB_READ_AHEAD_THRESHOLD | 56 |
SSL_CIPHER | |
AUTOCOMMIT | ON |
SLAVE_EXEC_MODE | STRICT |
KEY_BUFFER_SIZE | 26214400 |
NEW | OFF |
HAVE_NDBCLUSTER | NO |
SQL_MODE | STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
MAX_USER_CONNECTIONS | 0 |
INNODB_LOG_GROUP_HOME_DIR | .\ |
INNODB_FAST_SHUTDOWN | 1 |
SECURE_FILE_PRIV | |
SSL_CA | |
KEEP_FILES_ON_CREATE | OFF |
INNODB_THREAD_CONCURRENCY | 8 |
SQL_BUFFER_RESULT | OFF |
SLAVE_NET_TIMEOUT | 3600 |
KEY_CACHE_BLOCK_SIZE | 1024 |
INNODB_STATS_SAMPLE_PAGES | 8 |
HAVE_CSV | YES |
LOCAL_INFILE | ON |
STORAGE_ENGINE | InnoDB |
HAVE_RTREE_KEYS | YES |
PRELOAD_BUFFER_SIZE | 32768 |
HAVE_PROFILING | YES |
SLAVE_COMPRESSED_PROTOCOL | OFF |
SHARED_MEMORY_BASE_NAME | MYSQL |
TX_ISOLATION | REPEATABLE-READ |
MYISAM_MMAP_SIZE | 4294967295 |
LOG_ERROR | C:\ProgramData\MySQL\MySQL Server 5.5\Data\sinan.err |
PERFORMANCE_SCHEMA_MAX_FILE_HANDLES | 32768 |
GENERAL_LOG | OFF |
RELAY_LOG_RECOVERY | OFF |
SORT_BUFFER_SIZE | 262144 |
MAX_DELAYED_THREADS | 20 |
IGNORE_BUILTIN_INNODB | OFF |
DATETIME_FORMAT | %Y-%m-%d %H:%i:%s |
SHARED_MEMORY | OFF |
INNODB_FLUSH_LOG_AT_TRX_COMMIT | 1 |
TRANSACTION_PREALLOC_SIZE | 4096 |
MAX_RELAY_LOG_SIZE | 0 |
RELAY_LOG | |
LICENSE | GPL |
HAVE_QUERY_CACHE | YES |
SQL_WARNINGS | OFF |
SYNC_RELAY_LOG | 0 |
PORT | 3306 |
LC_TIME_NAMES | en_US |
PLUGIN_DIR | C:\Program Files\MySQL\MySQL Server 5.5\lib/plugin |
LOG_SLOW_QUERIES | OFF |
LOG_BIN_TRUST_FUNCTION_CREATORS | OFF |
MAX_TMP_TABLES | 32 |
NET_READ_TIMEOUT | 30 |
SQL_LOG_OFF | OFF |
HAVE_OPENSSL | DISABLED |
SLOW_QUERY_LOG_FILE | C:\ProgramData\MySQL\MySQL Server 5.5\Data\sinan-slow.log |
CHARACTER_SET_SYSTEM | utf8 |
SQL_SLAVE_SKIP_COUNTER | 0 |
PERFORMANCE_SCHEMA_MAX_FILE_INSTANCES | 10000 |
SECURE_AUTH | OFF |
INNODB_SPIN_WAIT_DELAY | 6 |
MYISAM_STATS_METHOD | nulls_unequal |
MAX_ALLOWED_PACKET | 1048576 |
DEFAULT_STORAGE_ENGINE | InnoDB |
MAX_BINLOG_CACHE_SIZE | 18446744073709547520 |
INNODB_LOCK_WAIT_TIMEOUT | 50 |
INNODB_CHECKSUMS | ON |
INNODB_OLD_BLOCKS_TIME | 0 |
INNODB_LOCKS_UNSAFE_FOR_BINLOG | OFF |
RPL_RECOVERY_RANK | 0 |
MYISAM_USE_MMAP | OFF |
INNODB_LOG_FILE_SIZE | 25165824 |
INNODB_CONCURRENCY_TICKETS | 500 |
OPTIMIZER_SWITCH | index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on |
SQL_SAFE_UPDATES | OFF |
LOG_SLAVE_UPDATES | OFF |
MAX_JOIN_SIZE | 18446744073709551615 |
SYNC_MASTER_INFO | 0 |
INNODB_BUFFER_POOL_SIZE | 49283072 |
INNODB_FILE_PER_TABLE | OFF |
SSL_CERT | |
SSL_KEY | |
SOCKET | MySQL |
CHARACTER_SET_CLIENT | latin5 |
SLAVE_SKIP_ERRORS | OFF |
SKIP_EXTERNAL_LOCKING | ON |
SLAVE_LOAD_TMPDIR | C:\Windows\TEMP |
RELAY_LOG_PURGE | ON |
INNODB_ADDITIONAL_MEM_POOL_SIZE | 2097152 |
COLLATION_DATABASE | latin5_turkish_ci |
INNODB_MAX_DIRTY_PAGES_PCT | 75 |
PERFORMANCE_SCHEMA_MAX_TABLE_INSTANCES | 50000 |