source: packages/libs/mysql/conf/my.cnf @ 22911

Last change on this file since 22911 was 22911, checked in by florian, 6 years ago

[package] add mysql-server (#7384)

This is a patch to build the mysql server. So far I only have the
kirkwood target to test on, but it works great on that.

There seems to be some contention on whether Openwrt should have a
mysql-server package, but I don't see why it shouldn't at least have
the option. A full LAMP stack is now a reality.

Closes out https://dev.openwrt.org/ticket/7384

Again, I'm still pretty new to this, so any constructive criticism
would be appreciated.

Sorry for the attachment, but I wanted to make sure the whitespace and
lines got preserved.

Signed-off-by: Kyle Anderson <kyle@…>

File size: 1.1 KB
Line 
1[client]
2port            = 3306
3socket          = /var/run/mysqld.sock
4
5[mysqld]
6user            = root
7socket          = /var/run/mysqld.sock
8port            = 3306
9basedir         = /usr
10
11############ Don't put this on the NAND #############
12# Figure out where you are going to put the databases
13# And run mysql_install_db --force
14datadir         = /mnt/data/mysql/
15
16######### This should also not go on the NAND #######
17tmpdir          = /mnt/data/tmp/
18
19skip-external-locking
20
21bind-address            = 127.0.0.1
22
23# Fine Tuning
24key_buffer              = 16M
25max_allowed_packet      = 16M
26thread_stack            = 192K
27thread_cache_size       = 8
28
29# Here you can see queries with especially long duration
30#log_slow_queries       = /var/log/mysql/mysql-slow.log
31#long_query_time = 2
32#log-queries-not-using-indexes
33
34# The following can be used as easy to replay backup logs or for replication.
35#server-id              = 1
36#log_bin                        = /var/log/mysql/mysql-bin.log
37#expire_logs_days       = 10
38#max_binlog_size         = 100M
39#binlog_do_db           = include_database_name
40#binlog_ignore_db       = include_database_name
41
42
43[mysqldump]
44quick
45quote-names
46max_allowed_packet      = 16M
47
48[mysql]
49#no-auto-rehash # faster start of mysql but no tab completition
50
51[isamchk]
52key_buffer              = 16M
53
54
Note: See TracBrowser for help on using the repository browser.