由 linuxsky 在 10-14-2002 08:54 发表:
mysql的日志文件存放在哪里?
我在/var/log/里看不到
然后在/var/lib/mysql下也没看到
我要如何看到我的mysql的所有连接的记录？
我是用rpm的包装的mysql
由 linuxsky 在 10-14-2002 09:06 发表:
我的mysql常常会连接很慢
我用这个命令看的结果．看看有没有问题
[root@yh-app root]# mysqladmin variables | more
+---------------------------------+-------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------+
| Variable_name | Value
|
+---------------------------------+-------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------+
| back_log | 50
|
| basedir | /
|
| binlog_cache_size | 32768
|
| character_set | latin1
|
| character_sets | latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 s
we7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 |
| concurrent_insert | ON
|
| connect_timeout | 5
|
| datadir | /var/lib/mysql/
|
| delay_key_write | ON
|
| delayed_insert_limit | 100
|
| delayed_insert_timeout | 300
|
| delayed_queue_size | 1000
|
| flush | OFF
|
| flush_time | 0
|
| have_bdb | NO
|
| have_gemini | NO
|
| have_innodb | NO
|
| have_isam | YES
|
| have_raid | NO
|
| have_openssl | NO
|
| init_file |
|
| interactive_timeout | 28800
|
| join_buffer_size | 131072
|
| key_buffer_size | 8388600
--More--
| language | /usr/share/mysql/english/
|
| large_files_support | ON
|
| locked_in_memory | OFF
|
| log | OFF
|
| log_update | OFF
|
| log_bin | OFF
|
| log_slave_updates | OFF
|
| log_long_queries | OFF
|
| long_query_time | 10
|
| low_priority_updates | OFF
|
| lower_case_table_names | 0
|
| max_allowed_packet | 1048576
|
| max_binlog_cache_size | 4294967295
|
| max_binlog_size | 1073741824
|
| max_connections | 2000
|
| max_connect_errors | 10
|
| max_delayed_threads | 20
|
| max_heap_table_size | 16777216
|
| max_join_size | 4294967295
|
| max_sort_length | 1024
|
| max_user_connections | 0
|
| max_tmp_tables | 32
|
| max_write_lock_count | 4294967295
|
| myisam_max_extra_sort_file_size | 256
|
| myisam_max_sort_file_size | 2047
|
| myisam_recover_options | 0
|
--More--
| myisam_sort_buffer_size | 8388608
|
| net_buffer_length | 16384
|
| net_read_timeout | 30
|
| net_retry_count | 10
|
| net_write_timeout | 60
|
| open_files_limit | 0
|
| pid_file | /var/lib/mysql/yh-app.pid
|
| port | 3306
|
| protocol_version | 10
|
| record_buffer | 131072
|
| record_rnd_buffer | 131072