# The files must end with '.cnf', otherwise they'll be ignored.ġ40725 10:33:07 Using unique option prefix myisam-recover instead of myisam- recover-options is deprecated and will be removed in a future release. # * IMPORTANT: Additional settings that can override those from this file! #no-auto-rehash # faster start of mysql but no tab completition # For generating SSL certificates I recommend the OpenSSL GUI "tinyca". # Read the manual, too, if you want chroot! # of RAM but beware of setting memory usage too high #innodb_log_group_home_dir = /var/lib/mysql #innodb_data_file_path = ibdata1:2000M ibdata2:10M:autoextend # Read the manual for more InnoDB related options. # InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/. #binlog_ignore_db = include_database_name # note: if you are setting up a replication slave, see README.Debian about # The following can be used as easy to replay backup logs or for replication. #log_slow_queries = /var/log/mysql/mysql-slow.log # Here you can see queries with especially long duration # Error log - should be very few entries. #general_log_file = /var/log/mysql/mysql.log # As of 5.1 you can enable the log at runtime! # Be aware that this log type is a performance killer. # Both location gets rotated by the cronjob. ![]() ![]() # Try number of CPU's*2 for thread_concurrency # localhost which is more compatible and is not less secure. # Instead of skip-networking the default is now to listen only on # The following values assume you have at least 32M ram # Here is entries for some specific programs # Remember to edit /etc/mysql/debian.cnf when changing the socket location. # It has been reported that passwords should be enclosed with ticks/quotes # This will be passed to all mysql clients # -print-defaults to see which it would actually understand and use. ![]() # Run program with -help to get a list of available options and with # One can use all long options that the program supports. ![]() # - "~/.my.cnf" to set user-specific options. # - "/etc/mysql/my.cnf" to set global options, _log_file_size to 25 % of buffer pool sizeĬonfiguration -> my.cnf # The MySQL database server configuration file. Mysql server is not starting after modifying configurations key_buffer = 16MĪfter change -> innodb_buffer_pool_size = 384M
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |