一次歷盡艱辛的mysql啟動經(jīng)歷

webyuhang

1. 
   
2. [root@testbox-04 mysql]# cat /etc/issue
   
3. CentOS release 5.2 (Final)
   
4. Kernel \r on an \m
   
5. 
   
6. [root@testbox-04 mysql]# uname -r
   
7. 2.6.18-92.1.22.el5
   
8. [root@testbox-04 mysql]# rpm -qa | grep mysql
   
9. mysql-5.0.45-7.el5
   
10. mysql-server-5.0.45-7.el5
    
11. mysql-5.0.45-7.el5
    
12. php-mysql-5.1.6-20.el5_2.1
    
13. mysql-devel-5.0.45-7.el5
    
14. mysql-devel-5.0.45-7.el5
    
15. mysql-test-5.0.45-7.el5
    
16. mysql-bench-5.0.45-7.el5
    
17. [root@testbox-04 mysql]# sestatus -bv | head -n1
    
18. SELinux status:                 enabled
    
19. [root@testbox-04 mysql]# sestatus -bv | grep mysql
    
20. allow_user_mysql_connect               off
    
21. mysqld_disable_trans                   on
    

復(fù)制代碼

my.cnf配置：
為了節(jié)省空間，打擾次序排序的

1. 
   
2. [root@testbox-04 mysql]# grep -v "#" /etc/my.cnf | sort | uniq
   
3. 
   
4. back_log = 50
   
5. bind-address    = 192.168.12.81
   
6. binlog_cache_size = 1M
   
7. bulk_insert_buffer_size = 64M
   
8. [client]
   
9. default_table_type = INNODB
   
10. ft_min_word_len = 4
    
11. innodb_additional_mem_pool_size = 16M
    
12. innodb_buffer_pool_size = 2G
    
13. innodb_data_file_path = ibdata1:500M:autoextend
    
14. innodb_data_home_dir = /var/lib/mysql/ibdata
    
15. innodb_file_io_threads = 4
    
16. innodb_flush_log_at_trx_commit = 1
    
17. innodb_lock_wait_timeout = 120
    
18. innodb_log_buffer_size = 32M
    
19. innodb_log_files_in_group = 3
    
20. innodb_log_file_size = 500M
    
21. innodb_log_group_home_dir=/var/lib/mysql/iblogs
    
22. innodb_max_dirty_pages_pct = 90
    
23. innodb_thread_concurrency = 16
    
24. interactive-timeout
    
25. [isamchk]
    
26. join_buffer_size = 8M
    
27. key_buffer = 512M
    
28. key_buffer_size = 32M
    
29. log_long_format
    
30. max_allowed_packet = 16M
    
31. max_connect_errors = 10
    
32. max_connections = 100
    
33. max_heap_table_size = 64M
    
34. [myisamchk]
    
35. myisam_max_extra_sort_file_size = 10G
    
36. myisam_max_sort_file_size = 10G
    
37. myisam_recover
    
38. myisam_repair_threads = 1
    
39. myisam_sort_buffer_size = 128M
    
40. [mysql]
    
41. [mysqld]
    
42. [mysqld_safe]
    
43. [mysqldump]
    
44. [mysqlhotcopy]
    
45. no-auto-rehash
    
46. open-files-limit = 8192
    
47. port            = 3306
    
48. query_cache_limit = 2M
    
49. query_cache_size = 64M
    
50. quick
    
51. read_buffer = 8M
    
52. read_buffer_size = 2M
    
53. read_rnd_buffer_size = 16M
    
54. server-id = 1
    
55. socket          = /tmp/mysql.sock
    
56. sort_buffer_size = 512M
    
57. sort_buffer_size = 8M
    
58. table_cache = 2048
    
59. thread_cache_size = 8
    
60. thread_concurrency = 8
    
61. thread_stack = 192K
    
62. tmp_table_size = 64M
    
63. transaction_isolation = REPEATABLE-READ
    
64. write_buffer = 8M
    

復(fù)制代碼

錯誤日志1

1. 
   
2. [root@testbox-04 ~]# tail -f /var/log/mysqld.log
   
3. InnoDB: in this failed attempt. InnoDB only wrote those files full of
   
4. InnoDB: zeros, but did not yet use them in any way. But be careful: do not
   
5. InnoDB: remove old data files which contain your precious data!
   
6. 090210 23:25:42 [ERROR] Default storage engine (InnoDB) is not available
   
7. 090210 23:25:42 [ERROR] Aborting
   
8. 
   
9. 090210 23:25:42 [Note] /usr/libexec/mysqld: Shutdown complete
   
10. 
    
11. 090210 23:25:42  mysqld ended
    

復(fù)制代碼

解決錯誤1:
my.cnf 里面打開
innodb_data_home_dir = /var/lib/mysql/ibdata

錯誤日志2:

1. 
   
2. 090210 23:26:59  mysqld started
   
3. InnoDB: Error: auto-extending data file ./ibdata1 is of a different size
   
4. InnoDB: 640 pages (rounded down to MB) than specified in the .cnf file:
   
5. InnoDB: initial 32000 pages, max 0 (relevant if non-zero) pages!
   
6. InnoDB: Could not open or create data files.
   
7. InnoDB: If you tried to add new data files, and it failed here,
   
8. InnoDB: you should now edit innodb_data_file_path in my.cnf back
   
9. InnoDB: to what it was, and remove the new ibdata files InnoDB created
   
10. InnoDB: in this failed attempt. InnoDB only wrote those files full of
    
11. InnoDB: zeros, but did not yet use them in any way. But be careful: do not
    
12. InnoDB: remove old data files which contain your precious data!
    
13. 090210 23:27:00 [ERROR] Can't start server : Bind on unix socket: Permission denied
    
14. 090210 23:27:00 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ?
    
15. 090210 23:27:00 [ERROR] Aborting
    

復(fù)制代碼

解決錯誤日志2
sealert -a /var/log/audit/audit.log
查看到selinux 阻止 mysqld 讀取mysql.sock 文件，
Detailed Description:

SELinux has denied mysqld access to potentially mislabeled file(s) (mysql.sock).
This means that SELinux will not allow mysqld to use these files. It is common
for users to edit files in their home directory or tmp directories and then move
(mv) them to system directories. The problem is that the files end up with the
wrong file context which confined applications are not allowed to access.

Allowing Access:

If you want mysqld to access this files, you need to relabel them using
restorecon -v 'mysql.sock'. You might want to relabel the entire directory using
restorecon -R -v '<Unknown>'.

由于mysql無法啟動，無法產(chǎn)生mysql.sock
所以，暫時取消對mysqld監(jiān)控

setsebool mysqld_disable_trans 1

錯誤日志3

1. 
   
2. 090210 23:29:42  mysqld started
   
3. 090210 23:29:42  InnoDB: Operating system error number 2 in a file operation.
   
4. InnoDB: The error means the system cannot find the path specified.
   
5. InnoDB: If you are installing InnoDB, remember that you must create
   
6. InnoDB: directories yourself, InnoDB does not create them.
   
7. InnoDB: File name /var/lib/mysql/ibdata/ibdata1
   
8. InnoDB: File operation call: 'create'.
   
9. InnoDB: Cannot continue operation.
   
10. 090210 23:29:42  mysqld ended
    

復(fù)制代碼

解決錯誤3：
rm -rf /var/lib/mysql/ibdata/*
rm -rf /var/lib/mysql/iblogs/*

錯誤日志4：

1. 
   
2. 090210 23:52:21  mysqld started
   
3. 090210 23:52:22  InnoDB: Started; log sequence number 0 43656
   
4. 090210 23:52:23 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
   
5. 090210 23:52:23  mysqld ended
   

復(fù)制代碼

解決方法4：
[root@testbox-04 /]# /usr/bin/mysql_install_db
Installing MySQL system tables...
OK
Filling help tables...
OK

錯誤日志5:

1. 
   
2. 090211 00:00:34  mysqld started
   
3. 090211  0:00:35  InnoDB: Started; log sequence number 0 43656
   
4. /usr/libexec/mysqld: File './mysql-bin.000008' not found (Errcode: 13)
   
5. 090211  0:00:35 [ERROR] Failed to open log (file './mysql-bin.000008', errno 13)
   
6. 090211  0:00:35 [ERROR] Could not open log file
   
7. 090211  0:00:35 [ERROR] Can't init tc log
   
8. 090211  0:00:35 [ERROR] Aborting
   

復(fù)制代碼

解決錯誤5：
感覺到是讀取bin-log錯誤，為什么開啟會讀bin-log
而且，我的/var/lib/mysql下  mysql-bin.000008文件是存在的
先注釋掉my.cnf  log-bin

錯誤日志6:

1. 
   
2. 090211 00:23:19  mysqld started
   
3. /usr/libexec/mysqld: File '/var/lib/mysql/testbox-04-slow.log' not found (Errcode: 13)
   
4. 090211  0:23:19 [ERROR] Could not use /var/lib/mysql/testbox-04-slow.log for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.
   
5. 090211  0:23:20  InnoDB: Started; log sequence number 0 43656
   

復(fù)制代碼

解決錯誤6：
#log_slow_queries
#long_query_time = 2
以上2行增加注釋;

錯誤日志7：

1. 
   
2. 090211 00:02:51  mysqld started
   
3. 090211  0:02:52  InnoDB: Started; log sequence number 0 43656
   
4. 090211  0:02:52 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
   
5. 090211  0:02:52 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
   
6. 090211  0:02:52 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
   
7. 090211 00:02:52  mysqld ended
   

復(fù)制代碼

解決錯誤方法6：
/usr/bin/mysql_install_db  --user=mysql


哈哈：起來了

[root@testbox-04 mysql]# service mysqld start
Starting MySQL:                                            [  OK  ]
[root@testbox-04 mysql]#



上面的前提是注釋掉了selinux對mysql的mysql.sock監(jiān)控
現(xiàn)在把監(jiān)控加進去，在做如下測試。
還是起不來，看這個樣子是selinux嚴格的權(quán)限禁止 原生目錄/var/lib/mysql下的sock文件產(chǎn)生
那更改/etc/my.cnf

1. 
   
2. [root@testbox-04 mysql]# grep -v "#" /etc/my.cnf |grep -i sock
   
3. socket          = /var/lib/mysql/mysql.sock
   
4. socket          = /var/lib/mysql/mysql.sock
   
5. 改到/var/lib/mysql下吧
   
6. 
   
7. 重新加監(jiān)控進去
   
8. [root@testbox-04 mysql]# setsebool mysqld_disable_trans 0
   
9. 
   
10. [root@testbox-04 mysql]# ls -lZ |grep sock
    
11. srwxrwxrwx  mysql mysql user_u:object_r:mysqld_var_run_t mysql.sock
    
12. 
    
13. 090211 00:42:48  mysqld started
    
14. 090211  0:42:49  InnoDB: Started; log sequence number 0 43656
    
15. 090211  0:42:49 [Note] /usr/libexec/mysqld: ready for connections.
    
16. Version: '5.0.45'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
    

復(fù)制代碼

以上雖然是小問題，可能大家都會遇到到，希望對大家有所幫助！

huifeideluotuo

呵呵，樓主辛苦了！

楓影誰用了

暈。。你這等于重裝。。。。是一個空白的DB。

webyuhang

原帖由 楓影誰用了 于 2009-2-11 16:55 發(fā)表
暈。。你這等于重裝。。。。是一個空白的DB。

啊，忘記說了，新裝的服務(wù)器
新裝的mysql

zcm211

看得頭大了 @_@

liheng

樓主好樣的,selinux真是讓人又愛又恨啦

ruochen

原帖由 liheng 于 2009-12-15 20:25 發(fā)表
樓主好樣的,selinux真是讓人又愛又恨啦

LZ解決問題過程的方法還是很不錯的