[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
default-character-set = utf8

[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
tmp_table_size = 2K
bind-address = 127.0.0.1
port = 3306
max_connections = 9
max_allowed_packet = 2M
character-set-server  = utf8
collation-server = utf8_general_ci
table_open_cache = 2048
sort_buffer_size = 4M
join_buffer_size = 3M
tmp_table_size = 16M
max_heap_table_size = 16M
skip-name-resolve
sql_mode = STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_IN_DATE
sysdate_is_now = 1
default-storage-engine = InnoDB
skip-networking
low-priority-updates
feedback = ON
skip-archive
skip-blackhole
skip-federated
skip-partition
innodb_buffer_pool_size = 512M
innodb_additional_mem_pool_size = 64M
innodb_log_files_in_group = 2
innodb_log_file_size = 5M
innodb_log_buffer_size = 32M
innodb_flush_log_at_trx_commit = 0
innodb_flush_method = O_DIRECT
innodb = FORCE
innodb_strict_mode = 1
innodb_buffer_pool_instances = 1
innodb_file_per_table
innodb_file_format = Barracuda
innodb_use_sys_malloc = 0
innodb_thread_concurrency = 8
general_log_file = /var/log/mysql/mysql.log
general_log = 1
log_error = /var/log/mysql/error.log
slow-query-log-file = /var/log/mysql/slow.log
slow-query-log = 1
long_query_time = 5
log-queries-not-using-indexes
server-id = 1
log_bin = /var/log/mysql/mysql-bin.log
expire_logs_days = 10
max_binlog_size = 100M
skip-external-locking
key_buffer_size = 384M
read_buffer_size = 2M
myisam_sort_buffer_size = 1536M
concurrent_insert = ALWAYS
open_files_limit = 6144
query_cache_type = ON
query_cache_size = 8M
query_cache_limit = 1M
query_cache_min_res_unit = 4096
thread_cache_size = 8
thread_concurrency = 8

[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
syslog

[mysqldump]
quick
quote-names
max_allowed_packet = 16M

[isamchk]
key_buffer = 16M

[OK] Slow queries: 0% (0/90)

[OK] Slow queries: 2% (2/90)

/usr/sbin/mysqld, Version: 5.5.39-MariaDB-1~wheezy-log (mariadb.org binary distribution). started with:
Tcp port: 0  Unix socket: /var/run/mysqld/mysqld.sock
Time                 Id Command    Argument
# Time: 140906 21:11:50
# User@Host: debian-sys-maint[debian-sys-maint] @ localhost []
# Thread_id: 5  Schema:   QC_hit: No
# Query_time: 0.000573  Lock_time: 0.000211  Rows_sent: 1  Rows_examined: 7
SET timestamp=1410023510;
SELECT count(*) FROM mysql.user WHERE user='root' and password='';
# User@Host: debian-sys-maint[debian-sys-maint] @ localhost []
# Thread_id: 6  Schema:   QC_hit: No
# Query_time: 0.031293  Lock_time: 0.000312  Rows_sent: 23  Rows_examined: 189
SET timestamp=1410023510;
select concat('select count(*) into @discard from `',
                    TABLE_SCHEMA, '`.`', TABLE_NAME, '`') 
      from information_schema.TABLES where ENGINE='MyISAM';

# Time: 140906 21:29:32
# User@Host: dyvniy[dyvniy] @ localhost []
# Thread_id: 30  Schema: dyvniy_forum  QC_hit: No
# Query_time: 0.013617  Lock_time: 0.012417  Rows_sent: 7  Rows_examined: 16
use dyvniy_forum;
SET timestamp=1410024572;
SELECT f.*, ft.mark_time FROM (phpbbex_forums f) LEFT JOIN phpbbex_forums_track ft ON (ft.user_id = 68 AND ft.forum_id = f.forum_id) ORDER BY f.left_id;
# User@Host: dyvniy[dyvniy] @ localhost []
# Thread_id: 30  Schema: dyvniy_forum  QC_hit: No
# Query_time: 0.001351  Lock_time: 0.000191  Rows_sent: 6  Rows_examined: 131
SET timestamp=1410024572;
SELECT topic_id, topic_title, topic_last_post_id, forum_id FROM phpbbex_topics WHERE topic_last_post_id IN (381,137,389,394,392,396);
# User@Host: dyvniy[dyvniy] @ localhost []
# Thread_id: 30  Schema: dyvniy_forum  QC_hit: No
# Query_time: 0.001023  Lock_time: 0.000247  Rows_sent: 1  Rows_examined: 4
SET timestamp=1410024572;
SELECT s.session_user_id AS user_id, s.session_viewonline, u.username, u.user_type, u.user_colour
		FROM phpbbex_sessions s
		LEFT JOIN phpbbex_users u ON s.session_user_id = u.user_id
		WHERE s.session_time >= 1410023670 AND s.session_user_id <> 1
		GROUP BY s.session_user_id
		ORDER BY u.username_clean;