Server Details -------------- 1) Script to start mysqld #!/bin/sh # $Id: svctool.in,v 2.422 2018-11-06 09:45:48+05:30 Cprogrammer Exp mbhangui $ # generated on x86_64-pc-linux-gnu on Sat Nov 10 01:04:47 IST 2018 # /usr/sbin/svctool --mysql="3306" --servicedir="/service" --mysqlPrefix="/usr" --databasedir="/var/indimail/mysqldb" --config="/etc/indimail/indimail.cnf" --default-domain="indimail.org" socket_dir=`dirname $(grep socket /etc/indimail/indimail.cnf 2>/dev/null| head -1 | cut -d= -f2) 2>/dev/null` if [ -z "$socket_dir" ] ; then socket_dir=/var/run/mysqld fi if [ ! -d $socket_dir ] ; then /bin/mkdir $socket_dir /bin/chown mysql:mysql $socket_dir fi MYSQL_BASE=/usr DATABASE=/var/indimail/mysqldb PIDFILE=$socket_dir/mysqld.3306.pid ulimit -u 8192 -n 8192 exec /usr/bin/softlimit -o 8192 \ /usr/bin/setuidgid mysql $MYSQL_BASE/sbin/mysqld --defaults-file=/etc/indimail/indimail.cnf \ --port=3306 --basedir=$MYSQL_BASE \ --datadir=$DATABASE/data \ --memlock \ --ssl \ --require-secure-transport \ --skip-external-locking \ --skip-name-resolve \ --delay-key-write=all \ --sql-mode="NO_ENGINE_SUBSTITUTION,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,STRICT_TRANS_TABLES" \ --explicit-defaults-for-timestamp=TRUE \ --general-log=1 \ --general-log-file=$DATABASE/logs/general-log \ --slow-query-log=1 \ --slow-query-log-file=$DATABASE/logs/slowquery-log \ --log-queries-not-using-indexes \ --log-error-verbosity=3 \ --pid-file=$PIDFILE 2>&1 2) mysql defaults file [client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld] # # * Basic Settings # # # * IMPORTANT # If you make changes to these settings and your system uses apparmor, you may # also need to also adjust /etc/apparmor.d/usr.sbin.mysqld. # #sql_mode="NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,STRICT_ALL_TABLES" sql_mode="NO_ENGINE_SUBSTITUTION,STRICT_ALL_TABLES" require-secure-transport = ON explicit-defaults-for-timestamp=TRUE user = mysql socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/indimail/mysqldb/data character-set-client-handshake = FALSE character-set-server = utf8mb4 collation-server = utf8mb4_unicode_ci local-infile=1 [inlookup] socket = /var/run/mysqld/mysqld.sock #The number of seconds the server waits for activity on an #interactive connection before closing it. An interactive client is #defined as a client that uses the 'CLIENT_INTERACTIVE' option to connect interactive_timeout=28880 #The number of seconds to wait for more data from a connection #before aborting the read. This timeout applies only to TCP/IP #connections, not to connections made via Unix socket files, named #pipes, or shared memory. net_read_timeout=5 #The number of seconds to wait for a block to be written to a #connection before aborting the write. This timeout applies only to #TCP/IP connections, not to connections made via Unix socket files, #named pipes, or shared memory. net_write_timeout=5 #The number of seconds the server waits for activity on a #non-interactive connection before closing it. This timeout applies #only to TCP/IP and Unix socket file connections, not to #connections made via named pipes, or shared memory. wait_timeout=28800