最新亚洲精品国偷自产在线,亚洲最大AV网站在线观看,午夜亚洲国产精品福利

笨笨的mysql在linux下安裝

1、

cd /data/
2

tar -xzf mysql-5.0.37-linux-i686.tar.gz
3

cd ./mysql-5.0.37-linux-i686
4

cat ./INSTALL-BINARY

參考以下說明：

shell> groupadd mysql
2

shell> useradd -g mysql mysql
3

shell> cd /usr/local
4

shell> gunzip < /PATH/TO/MYSQL-VERSION-OS.tar.gz | tar xvf -
5

shell> ln -s FULL-PATH-TO-MYSQL-VERSION-OS mysql
6

shell> cd mysql
7

shell> scripts/mysql_install_db --user=mysql
8

shell> chown -R root .
9

shell> chown -R mysql data
10

shell> chgrp -R mysql .
11

shell> bin/mysqld_safe --user=mysql &

2、

vi /etc/rc.local

su - root -c 'cd /data/mysql-5.0.37-linux-i686/; ./bin/mysqld_safe --user=mysql &'

不懂怎么ln，就直接把30多G的數據庫文件拷貝到data目錄下，耗費了好多時間。

第二種替代方案，安裝mysql到服務，不在/etc/rc.local中啟動。

cp /data/mysql-5.0.37-linux-i686/support-files/mysql.server /etc/init.d/mysql
2

vi /etc/init.d/mysql

basedir=/data/mysql-5.0.37-linux-i686

chkconfig mysql on

用setup查看一下，然后重啟，可以用

service mysql stop
2

service mysql start

測試一下。

2008-06-16 add...
但是不能正常配置/my.cnf，根據support-files/my-innodb-heavy-4G.cnf去掉注釋后，逐行查找修改如下：

[client]
3

port = 3306
4

socket = /tmp/mysql.sock
5

[mysqld]
7

port = 3306
8

socket = /tmp/mysql.sock
9

default-character-set=gbk
10

default-storage-engine=INNODB
11

back_log = 50
12

max_connections = 100
13

max_connect_errors = 10
14

table_cache = 2048
15

max_allowed_packet = 16M
16

binlog_cache_size = 1M
17

max_heap_table_size = 64M
18

sort_buffer_size = 8M
19

join_buffer_size = 8M
20

thread_cache_size = 8
21

thread_concurrency = 8
22

query_cache_size = 64M
23

query_cache_limit = 2M
24

ft_min_word_len = 4
25

default_table_type = MYISAM
26

thread_stack = 192K
27

transaction_isolation = REPEATABLE-READ
28

tmp_table_size = 64M
29

#log-bin=mysql-bin
30

#log_slow_queries
31

#long_query_time = 2
32

#log_long_format
33

server-id = 1
34

key_buffer_size = 32M
35

read_buffer_size = 2M
36

read_rnd_buffer_size = 16M
37

bulk_insert_buffer_size = 64M
38

myisam_sort_buffer_size = 128M
39

myisam_max_sort_file_size = 10G
40

myisam_max_extra_sort_file_size = 10G
41

myisam_repair_threads = 1
42

myisam_recover
43

skip-bdb
44

#innodb_additional_mem_pool_size = 16M
45

#innodb_buffer_pool_size = 2G
46

#innodb_data_file_path = ibdata1:10M:autoextend
47

#innodb_file_io_threads = 4
48

#innodb_thread_concurrency = 16
49

#innodb_flush_log_at_trx_commit = 1
50

#innodb_log_buffer_size = 8M
51

#innodb_log_file_size = 256M
52

#innodb_log_files_in_group = 3
53

#innodb_max_dirty_pages_pct = 90
54

#innodb_lock_wait_timeout = 120
55

[mysqldump]
57

quick
58

max_allowed_packet = 16M
59

[mysql]
61

no-auto-rehash
62

[isamchk]
64

key_buffer = 512M
65

sort_buffer_size = 512M
66

read_buffer = 8M
67

write_buffer = 8M
68

[myisamchk]
70

key_buffer = 512M
71

sort_buffer_size = 512M
72

read_buffer = 8M
73

write_buffer = 8M
74

[mysqlhotcopy]
76

interactive-timeout
77

[mysqld_safe]
78

open-files-limit = 8192

這里要注意兩個地方，一個就是log配置，一個就是innodb配置。
1、#log-bin=mysql-bin，注釋后，不會再出現下面的錯誤，但不能查詢
Starting MySQL/etc/init.d/mysql: line 151: kill: (****) - 沒有那個進程
2、注釋掉innodb后，就可以正常查詢了。

參考：
1、http://www.zftown.com/blog/?action=show&id=228
2、http://www.aslibra.com/blog/index.php?go=category_15
3、http://bbs.chinaunix.net/viewthread.php?tid=16141

2008-8-29 add...

Linux的data掛載點，空間奇怪消失。修改配置文件如下：

[client]
3

port = 3306
4

socket = /tmp/mysql.sock
5

[mysqld]
7

port = 3306
8

socket = /tmp/mysql.sock
9

default-character-set=gbk
10

default-storage-engine=INNODB
11

back_log = 50
12

max_connections = 100
13

max_connect_errors = 10
14

table_cache = 2048
15

max_allowed_packet = 16M
16

binlog_cache_size = 1M
17

max_heap_table_size = 64M
18

sort_buffer_size = 8M
19

join_buffer_size = 8M
20

thread_cache_size = 8
21

thread_concurrency = 8
22

query_cache_size = 64M
23

query_cache_limit = 2M
24

ft_min_word_len = 4
25

#default_table_type = MYISAM
26

default_table_type = innodb
27

thread_stack = 192K
28

transaction_isolation = REPEATABLE-READ
29

tmp_table_size = 64M
30

log-bin=mysql-bin
31

log_slow_queries
32

long_query_time = 2
33

log_long_format
34

server-id = 1
35

key_buffer_size = 32M
36

read_buffer_size = 2M
37

read_rnd_buffer_size = 16M
38

bulk_insert_buffer_size = 64M
39

myisam_sort_buffer_size = 128M
40

myisam_max_sort_file_size = 10G
41

myisam_max_extra_sort_file_size = 10G
42

myisam_repair_threads = 1
43

myisam_recover
44

skip-bdb
45

# Data files must be able to hold your data and indexes.
47

# Make sure that you have enough free disk space.
48

innodb_data_file_path = ibdata1:50M:autoextend
49

# Set buffer pool size to 50-80% of your computer's memory
51

innodb_buffer_pool_size = 2G
52

innodb_additional_mem_pool_size = 16M
53

# Set the log file size to about 25% of the buffer pool size
55

#innodb_log_file_size = 256M
57

#innodb_log_files_in_group = 3
58

innodb_flush_log_at_trx_commit = 1
59

innodb_file_io_threads = 4
61

innodb_thread_concurrency = 16
62

innodb_max_dirty_pages_pct = 90
64

innodb_lock_wait_timeout = 120
65

innodb_log_buffer_size = 8M
66

[mysqldump]
68

quick
69

max_allowed_packet = 16M
70

[mysql]
72

no-auto-rehash
73

[isamchk]
75

key_buffer = 512M
76

sort_buffer_size = 512M
77

read_buffer = 8M
78

write_buffer = 8M
79

[myisamchk]
81

key_buffer = 512M
82

sort_buffer_size = 512M
83

read_buffer = 8M
84

write_buffer = 8M
85

[mysqlhotcopy]
87

interactive-timeout
88

[mysqld_safe]
89

open-files-limit = 8192

參考：
1、http://hi.baidu.com/ryanxxx/blog/item/719d54ed970dda4a78f055b1.html
2、http://hosting.skif.net/docs/mysql/server-administration.html
清理Mysql日志
3、http://hi.baidu.com/lipengbin/blog/item/6fc58d8fbf116efc503d92ae.html

另：周期清除mysql bin log
http://blog.chinaunix.net/u/21041/showart.php?id=687580

udb服務器down了,因為var目錄滿了.因為/var/log/mysql目錄占用了40G的空間.

查看/etc/mysql/my.cnf ,發現

expire-logs-days = 20

把expire-logs-days 設成3,然后在mysql命令行執行

PURGE MASTER LOGS TO 'mysql-bin.000930';

即可刪除930之前的binlog

用這個語句可以清除3天前的binlog,

PURGE MASTER LOGS BEFORE DATE_SUB( NOW( ), INTERVAL 3 DAY);

所以另外還有個方法定期刪除binlog:

在contab設置:

0 1 * * * `mysql -uroot -e 'PURGE MASTER LOGS BEFORE DATE_SUB( NOW( ), INTERVAL 3 DAY);'`

posted on 2008-06-10 19:33 rox 閱讀(921) 評論(1) 編輯收藏所屬分類: Mysql

常用鏈接

留言簿(3)

隨筆分類(30)

隨筆檔案(47)

一些達人！

優秀個人

優秀資源

搜索

最新評論

閱讀排行榜

評論排行榜


只有注冊用戶登錄后才能發表評論。




網站導航: 博客園 IT新聞 Chat2DB C++博客博問管理
相關文章: 笨笨的mysql在linux下安裝 mysql 5.X 遷移linux上，表名大小寫敏感問題！ MySql中集合運算非常規實現