my.cfg

[mysqld]
innodb_read_io_threads		= 2
innodb_write_io_threads		= 4
innodb_buffer_pool_size		= 1G
innodb_buffer_pool_load_abort =ON
#innodb_buffer_pool_load_at_startup =1
#innodb_buffer_pool_dump_at_shutdown =1
innodb_buffer_pool_instances	= 1
innodb_log_file_size 		= 256M
innodb_log_files_in_group	= 2
innodb_file_per_table		= 1
innodb_log_buffer_size		= 8M
innodb_flush_method		= O_DIRECT
innodb_flush_log_at_trx_commit	= 1
#innodb_buffer_pool_filename	= /root/uhlhosting/backup/innodbbuffer
local-infile			= 0

# LOGGING #
slow_query_log			= ON
slow_query_log_file		= /var/log/mariadb/slow_query.log
long_query_time			= 7
log-queries-not-using-indexes	= 1
pid-file 			= /var/run/mysql/mysqld.pid

# SAFETY CACHES AND LIMITS #
max_allowed_packet=268435456
max_connect-errors		= 10
concurrent_insert		= 2
open_files_limit		= 50000
query_cache_type		= 1
query_cache_limit		= 5M
query_cache_size		= 128M
query_prealloc_size		= 262144
query_alloc_block_size 		= 65535
transaction_alloc_block_size 	= 8192
transaction_prealloc_size 	= 4096

# BUFFER #
net_buffer_length		= 16384
connect_timeout			= 10
wait_timeout			= 20
read_buffer_size		= 1M
read_rnd_buffer_size		= 786432
bulk_insert_buffer_size		= 8M
tmp_table_size			= 256M
max_heap_table_size		= 128M
thread_cache_size		= 384
table_open_cache		= 5000
table_definition_cache		= 2048
max_connections			= 600
max_user_connections		= 1000
max_write_lock_count		= 8
external-locking		= FALSE

[innodb]
long_query_time			= 2

[mysql]
local-infile			= ON

[mysqldump]
quick
max_allowed_packet		= 16M

[isamchk]
key-buffer-size                 = 384M
sort_buffer			= 384M
read_buffer			= 256M
write_buffer			= 256M
myisam-recover                  = FORCE,BACKUP
myisam_sort_buffer_size            = 64M
default-storage-engine          = MyISAM

[myisamchk]
key_buffer 			= 384M
sort_buffer 			= 384M
read_buffer 			= 256M
write_buffer 			= 256M

sort_buffer_size                = 1M
join_buffer_size                = 1M
thread_stack			= 192K