|
|
Variable_name
|
Value
|
| back_log |
50 |
| basedir |
C:\Program Files\mysql\ |
| bdb_cache_size |
8388572 |
| bdb_log_buffer_size |
32768 |
| bdb_home |
C:\Program Files\mysql\Data\ |
| bdb_max_lock |
10000 |
| bdb_logdir |
|
| bdb_shared_data |
OFF |
| bdb_tmpdir |
C:\WINDOWS\TEMP\ |
| bdb_version |
Sleepycat Software: Berkeley DB 3.2.9a: (March 4,... |
| binlog_cache_size |
32768 |
| bulk_insert_buffer_size |
8388608 |
| character_set |
cp1251 |
| character_sets |
latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis... |
| concurrent_insert |
ON |
| connect_timeout |
5 |
| convert_character_set |
|
| datadir |
C:\Program Files\mysql\Data\ |
| default_week_format |
0 |
| delay_key_write |
ON |
| delayed_insert_limit |
100 |
| delayed_insert_timeout |
300 |
| delayed_queue_size |
1000 |
| flush |
OFF |
| flush_time |
1800 |
| ft_boolean_syntax |
+ -><()~*:""&| |
| ft_min_word_len |
4 |
| ft_max_word_len |
254 |
| ft_max_word_len_for_sort |
20 |
| ft_stopword_file |
(built-in) |
| have_bdb |
YES |
| have_crypt |
NO |
| have_innodb |
YES |
| have_isam |
YES |
| have_raid |
NO |
| have_symlink |
YES |
| have_openssl |
NO |
| have_query_cache |
YES |
| init_file |
|
| innodb_additional_mem_pool_size |
1048576 |
| innodb_autoextend_increment |
8 |
| innodb_buffer_pool_size |
8388608 |
| innodb_data_file_path |
ibdata1:10M:autoextend |
| innodb_data_home_dir |
|
| innodb_file_io_threads |
4 |
| innodb_force_recovery |
0 |
| innodb_thread_concurrency |
8 |
| innodb_flush_log_at_trx_commit |
1 |
| innodb_fast_shutdown |
ON |
| innodb_flush_method |
|
| innodb_lock_wait_timeout |
50 |
| innodb_log_arch_dir |
.\ |
| innodb_log_archive |
OFF |
| innodb_log_buffer_size |
1048576 |
| innodb_log_file_size |
5242880 |
| innodb_log_files_in_group |
2 |
| innodb_log_group_home_dir |
.\ |
| innodb_mirrored_log_groups |
1 |
| innodb_max_dirty_pages_pct |
90 |
| innodb_max_purge_lag |
0 |
| innodb_table_locks |
ON |
| interactive_timeout |
28800 |
| join_buffer_size |
131072 |
| key_buffer_size |
8388572 |
| language |
C:\Program Files\mysql\share\english\ |
| large_files_support |
ON |
| license |
GPL |
| local_infile |
ON |
| log |
OFF |
| log_update |
OFF |
| log_bin |
OFF |
| log_slave_updates |
OFF |
| log_slow_queries |
OFF |
| log_warnings |
1 |
| long_query_time |
10 |
| low_priority_updates |
OFF |
| lower_case_file_system |
OFF |
| lower_case_table_names |
1 |
| max_allowed_packet |
1048576 |
| max_binlog_cache_size |
4294967295 |
| max_binlog_size |
1073741824 |
| max_connections |
100 |
| max_connect_errors |
10 |
| max_delayed_threads |
20 |
| max_insert_delayed_threads |
20 |
| max_heap_table_size |
16777216 |
| max_join_size |
4294967295 |
| max_relay_log_size |
0 |
| max_seeks_for_key |
4294967295 |
| max_sort_length |
1024 |
| max_user_connections |
0 |
| max_tmp_tables |
32 |
| max_write_lock_count |
4294967295 |
| myisam_max_extra_sort_file_size |
268435456 |
| myisam_max_sort_file_size |
2147483647 |
| myisam_repair_threads |
1 |
| myisam_recover_options |
OFF |
| myisam_sort_buffer_size |
8388608 |
| net_buffer_length |
16384 |
| net_read_timeout |
30 |
|
Variable_name
|
Value
|
| net_retry_count |
10 |
| net_write_timeout |
60 |
| new |
OFF |
| open_files_limit |
0 |
| pid_file |
C:\Program Files\mysql\Data\home-e5bb5c3451.pid |
| log_error |
.\home-e5bb5c3451.err |
| port |
3306 |
| protocol_version |
10 |
| query_alloc_block_size |
8192 |
| query_cache_limit |
1048576 |
| query_cache_size |
0 |
| query_cache_type |
ON |
| query_cache_wlock_invalidate |
OFF |
| query_prealloc_size |
8192 |
| range_alloc_block_size |
2048 |
| read_buffer_size |
131072 |
| read_only |
OFF |
| read_rnd_buffer_size |
262144 |
| rpl_recovery_rank |
0 |
| server_id |
0 |
| slave_net_timeout |
3600 |
| skip_external_locking |
ON |
| skip_networking |
OFF |
| skip_show_database |
OFF |
| slow_launch_time |
2 |
| sort_buffer_size |
2097116 |
| sql_mode |
0 |
| table_cache |
64 |
| table_type |
MYISAM |
| thread_cache_size |
0 |
| thread_stack |
196608 |
| tx_isolation |
REPEATABLE-READ |
| timezone |
Финляндия (зима) |
| tmp_table_size |
33554432 |
| tmpdir |
C:\WINDOWS\TEMP\ |
| transaction_alloc_block_size |
8192 |
| transaction_prealloc_size |
4096 |
| version |
4.0.24-debug |
| version_comment |
Official MySQL binary |
| version_compile_os |
Win32 |
| wait_timeout |
28800 |
Сервер: localhost
БД: cap
таблица : messages
Версия для печати
Обзор
Структура
SQL
Искать
Вставить
Экспорт
Операции
Очистить
Уничтожить