Sign Up
Log In
Log In
or
Sign Up
Places
All Projects
Status Monitor
Collapse sidebar
openSUSE
mariadb.30339
my.ini
Overview
Repositories
Revisions
Requests
Users
Attributes
Meta
File my.ini of Package mariadb.30339
# The following options will be passed to all MariaDB clients [client] # Please note that storing the password in this file is not safe. For this # purpose you can, for example, list your password in the [client] section # of the '~/.my.cnf' configuration file with an access mode set to 400 or 600. # password = your_password # port = 3306 # socket = /run/mysql/mysql.sock # The MariaDB server [mysqld] # For security reasons, bind to 127.0.0.1 by default to enable networking # only on the loopback interface. bind-address = 127.0.0.1 # If log-error is not set, mysqld will write to "/var/lib/mysql/$HOSTNAME.err" # which is not beneficial for rotating the log file if it grows in size. log-error = /var/log/mysql/mysqld.log # Enable the slow query log to see queries with especially long duration # slow_query_log=1 # slow_query_log_file = /var/log/mysql/mysqld_slow.log # Operations 'LOAD DATA', 'SELECT ... INTO' and 'LOAD FILE()' will only # work with files in the specified directory secure_file_priv = /var/lib/mysql-files # Remove leading # and set to the amount of RAM for the most important data # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. # innodb_buffer_pool_size = 128M # Remove leading # to turn on a very important data integrity option: logging # changes to the binary log between backups. # log_bin=mysql-bin # binlog_format=mixed # Remove leading # if you want to store your database elsewhere # datadir = /var/lib/mysql # required unique id between 1 and 2^32 - 1 # defaults to 1 if master-host is not set # but will not function as a master if omitted server-id = 1 # These are commonly set, remove the # and set as required. # port = 3306 # socket = /run/mysql/mysql.sock # Remove leading # to set options mainly useful for reporting servers. # The server defaults are faster for transactions and fast SELECTs. # Adjust sizes as needed, experiment to find the optimal values. # join_buffer_size = 128M # sort_buffer_size = 2M # read_rnd_buffer_size = 2M # Configure the MariaDB server to use SSL # ssl-ca=/etc/mysql/ssl/ca-cert.pem # ssl-cert=/etc/mysql/ssl/server-cert.pem # ssl-key=/etc/mysql/ssl/server-key.pem [mysqld_multi] mysqld = /usr/bin/mysqld_safe mysqladmin = /usr/bin/mysqladmin log = /var/log/mysqld_multi.log # If you want to use mysqld_multi uncomment 1 or more mysqld sections # below or add your own ones. # WARNING # -------- # If you uncomment mysqld1 than make absolutely sure, that database mysql, # configured above, is not started. This may result in corrupted data! # # [mysqld1] # port = 3306 # datadir = /var/lib/mysql # pid-file = /var/lib/mysql/mysqld.pid # socket = /var/lib/mysql/mysql.sock # user = mysql # [mysqld2] # port = 3307 # datadir = /var/lib/mysql-databases/mysqld2 # pid-file = /var/lib/mysql-databases/mysqld2/mysql.pid # socket = /var/lib/mysql-databases/mysqld2/mysql.sock # user = mysql # [mysqld3] # port = 3308 # datadir = /var/lib/mysql-databases/mysqld3 # pid-file = /var/lib/mysql-databases/mysqld3/mysql.pid # socket = /var/lib/mysql-databases/mysqld3/mysql.sock # user = mysql # [mysqld6] # port = 3309 # datadir = /var/lib/mysql-databases/mysqld6 # pid-file = /var/lib/mysql-databases/mysqld6/mysql.pid # socket = /var/lib/mysql-databases/mysqld6/mysql.sock # user = mysql !includedir /etc/my.cnf.d
Locations
Projects
Search
Status Monitor
Help
OpenBuildService.org
Documentation
API Documentation
Code of Conduct
Contact
Support
@OBShq
Terms
openSUSE Build Service is sponsored by
The Open Build Service is an
openSUSE project
.
Sign Up
Log In
Places
Places
All Projects
Status Monitor