Go to:
Gentoo Home
Documentation
Forums
Lists
Bugs
Planet
Store
Wiki
Get Gentoo!
Gentoo's Bugzilla – Attachment 48997 Details for
Bug 78452
MySQL 4.1.9 ebuild
Home
|
New
–
[Ex]
|
Browse
|
Search
|
Privacy Policy
|
[?]
|
Reports
|
Requests
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
my.cnf-4.1
my.cnf-4.1 (text/plain), 3.11 KB, created by
Jasmin Buchert
on 2005-01-19 16:10:59 UTC
(
hide
)
Description:
my.cnf-4.1
Filename:
MIME Type:
Creator:
Jasmin Buchert
Created:
2005-01-19 16:10:59 UTC
Size:
3.11 KB
patch
obsolete
># /etc/mysql/my.cnf: The global mysql configuration file. ># $Header: /var/cvsroot/gentoo-x86/dev-db/mysql/files/my.cnf-4.0.14-r1,v 1.2 2004/07/18 02:47:43 dragonheart Exp $ ># ># This file can be simultaneously placed in three places: ># 1. /etc/mysql/my.cnf to set global options. ># 2. /var/lib/mysql/my.cnf to set server-specific options. ># 3. ~/.my.cnf to set user-specific options. ># ># One can use all long options that the program supports. ># Run the program with --help to get a list of them. ># ># The following values assume you have at least 32M RAM! > >[client] >#password = my_password >port = 3306 >socket = /var/run/mysqld/mysqld.sock > >[safe_mysqld] >err-log = /var/log/mysql/mysql.err > >[mysqld] >skip-innodb >user = mysql >pid-file = /var/run/mysqld/mysqld.pid >socket = /var/run/mysqld/mysqld.sock >log-error = /var/log/mysql/mysqld.err ># If set, mysql logs all queries(general query log). This will be deprecated in ># 5.0. This logs all queries, even error queries and is slow. ># log = /var/log/mysql/mysql.log ># ># If you really need logging, use rather binary logging. Especially when doing ># replication. Read ># file:/usr/share/doc/mysql-*/manual.html.gz#Replication ># You can use PURGE MASTER LOGS TO '$hostname-bin.010' to get rid of old logs ># from $hostname-bin.01 up to $hostname-bin.09 while the slave server is ># running. ># Before doing that, check which logfile slave curently uses by running ># mysql> SHOW SLAVE STATUS ># To list logfiles on master do: ># mysql> SHOW MASTER LOGS ># Then use PURGE for those not needed anymore only! Never remove the files ># manually! ># ># Also consult RESET MASTER and RESET SLAVE commands before doing any changes ># mysql> RESET MASTER - Deletes all binary logs listed in the index ># file, resetting the binlog index file to be empty. ># mysql> RESET SLAVE - Makes the slave forget its replication position in ># the master logs. ># mysql> SET SQL_LOG_BIN=0 - this turns off logging (execute on MASTER only) ># mysql> SET SQL_LOG_BIN=1 - this turns on logging (execute on MASTER only) ># ># log-bin ># binlog-do-db = non_existant ># binlog-ignore-db = database_name ># ># server-id has to unique for each master or slave in your network, ># lets use last number from IP address ># server-id = 207 >basedir = /usr >datadir = /var/lib/mysql >tmpdir = /tmp >language = /usr/share/mysql/english >skip-locking > ># These values should be good for systems with 32M - 64M memory. ># Examples with values for different system configurations are ># located at /usr/share/doc/mysql-*/conf-samples/my-*.cnf. >key_buffer = 16M >max_allowed_packet = 1M >table_cache = 64 >sort_buffer_size = 512K >net_buffer_length = 8K >read_buffer_size = 256K >read_rnd_buffer_size = 512K >myisam_sort_buffer_size = 8M >thread_stack = 192K > ># keep secure by default! >bind-address = 127.0.0.1 >port = 3306 ># this can make it even more secure: >#skip-networking > ># Character set and collation (sort order) for MySQL-4.1 >#default-character-set = latin1 >#default-collation = latin1_swedish_ci > >[mysqldump] >quick >max_allowed_packet = 1M > >[mysql] >#no-auto-rehash # faster start of mysql but no tab completition > >[isamchk] >key_buffer = 16M
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Raw
Actions:
View
Attachments on
bug 78452
:
48801
|
48802
|
48803
|
48804
|
48805
|
48911
| 48997 |
48999
|
49100
|
49372