MYSQL服务详细信息说明

MYSQL各种参数信息查询

• mysqladmin variables -uroot -proot > mysql.info

显示MYSQL各种参数信息

[root@localhost doc]# head -n100 mysql.info
+-----------------------------------------+-------------------------------------------------------------------------------------------+
| Variable_name                           | Value                                                                                     |
+-----------------------------------------+-------------------------------------------------------------------------------------------+
| auto_increment_increment                | 1                                                                                         |
| auto_increment_offset                   | 1                                                                                         |
| autocommit                              | ON                                                                                        |
| automatic_sp_privileges                 | ON                                                                                        |
| back_log                                | 50                                                                                        |
| basedir                                 | /usr/                                                                                     |
| big_tables                              | OFF                                                                                       |
| binlog_cache_size                       | 32768                                                                                     |
| binlog_direct_non_transactional_updates | OFF                                                                                       |
| binlog_format                           | STATEMENT                                                                                 |
| bulk_insert_buffer_size                 | 8388608                                                                                   |
| character_set_client                    | utf8                                                                                      |
| character_set_connection                | utf8                                                                                      |
| character_set_database                  | utf8                                                                                      |
| character_set_filesystem                | binary                                                                                    |
| character_set_results                   | utf8                                                                                      |
| character_set_server                    | utf8                                                                                      |
| character_set_system                    | utf8                                                                                      |
| character_sets_dir                      | /usr/share/mysql/charsets/                                                                |
| collation_connection                    | utf8_general_ci                                                                           |
| collation_database                      | utf8_general_ci                                                                           |
| collation_server                        | utf8_general_ci                                                                           |

 

MYSQL配置文件位置  (安装时默认自动添加my.cnf配置文件)

•          /etc/my.cnf

MYSQL配置文件存放位置   (配置文件误删除时候可从以下位置拷贝)

•         /usr/share/doc/mysql-server-5.1.61

               文件列表
                    my-huge.cnf                       
                    my-innodb-heavy-4G.cnf
                    my-large.cnf          
                    my-medium.cnf         
                    my-small.cnf         
                执行如下操作 为MYSQL添加系统配置文件
                    #cp /usr/share/mysql/my-medium.cnf /etc/my.cnf
  MYSQL服务启动脚本位置

         执行如下操作可以启动MYSQL

•         #/usr/bin/mysql

•         #/etc/init.d/mysqld restart

•         #service mysqld restart

   MYSQL安装主目录

•         /usr/share/mysql

       
   MYSQL数据以及日志目录

•         /var/lib/mysql/

            文件列表
            ibdata1                                                                       
            ib_logfile0                                                                
            ib_logfile1                                                                   
            test            //数据库文件 test数据库(空库)                                 
            mysql           //数据库文件 mysql授权表等信息                                                
            mysql-bin.000001   //二进制日志文件                                                        
            mysql-bin.index    //二进制日志文件                                                        
            localhost.localdomain.err // MYSQL错误信息日志

•       /var/log/mysqld.log // MYSQL日常日志
  

  MYSQL其他信息目录

•           /usr/lib/mysql

           
                libmysqlclient_r.so.16 -> libmysqlclient_r.so.16.0.0
                libmysqlclient_r.so.16.0.0                           //很重要的文件
                libmysqlclient.so.16 -> libmysqlclient.so.16.0.0    
                libmysqlclient.so.16.0.0                             //很重要的文件
                mysqlbug                                            
                mysql_config

 

===========================参考资料====================================

http://dev.mysql.com/doc/refman/5.1/zh/installing.html#starting-server

=====================================================================