yang /etc/my.cnf udah saya rubah2 terus karena ga ada efeknya..
[root@server ~]# cat /etc/my.cnf; cat /etc/my.cnf.d/server.cnf
# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /var/lib/mysql/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
#default-storage-engine = myisam
#skip-innodb
#port = 3306
#socket = /var/lib/mysql/mysql.sock
#skip-external-locking
#skip-name-resolve
max_connections = 2000
#query_cache_type = 1
#query_cache_limit = 256K
#query_cache_min_res_unit = 2k
#query_cache_size = 268435456
#
# These groups are read by MariaDB server.
# Use it for options that only the server (but not clients) should see
#
# See the examples of server my.cnf files in /usr/share/mysql/
#
# this is read by the standalone daemon and embedded servers
[server]
# this is only for the mysqld standalone daemon
[mysqld]
max-allowed-packet=256M
performance-schema=on
default-storage-engine=myisam
skip-innodb
#OpenVZ AIO bug fix
innodb-use-native-aio=0
# this is only for embedded server
[embedded]
# This group is only read by MariaDB servers, not by MySQL.
# If you use the same .cnf file for MySQL and MariaDB,
# you can put MariaDB-only options here
[mariadb]
# This group is only read by MariaDB-10.0 servers.
# If you use the same .cnf file for MariaDB of different versions,
# use this group for options that older servers don't understand
[mariadb-10.0]