Nothing from dumping the DB.
On last startup:
131204 17:03:59 [Note] /usr/sbin/mysqld: Normal shutdown
131204 17:03:59 [Note] Event Scheduler: Purging the queue. 0 events
131204 17:03:59 InnoDB: Starting shutdown...
131204 17:03:59 InnoDB: Waiting for 57 pages to be flushed
131204 17:04:00 InnoDB: Shutdown completed; log sequence number 106500245729
131204 17:04:00 [Note] /usr/sbin/mysqld: Shutdown complete
131204 17:04:01 mysqld_safe mysqld from pid file /var/lib/mysql/data/***.pid ended
131204 17:04:02 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql/data
131204 17:04:02 InnoDB: The InnoDB memory heap is disabled
131204 17:04:02 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
131204 17:04:02 InnoDB: Compressed tables use zlib 1.2.3
131204 17:04:02 InnoDB: Using Linux native AIO
131204 17:04:02 InnoDB: Initializing buffer pool, size = 1.3G
131204 17:04:02 InnoDB: Completed initialization of buffer pool
131204 17:04:02 InnoDB: highest supported file format is Barracuda.
131204 17:04:04 InnoDB: Restoring buffer pool pages from ib_lru_dump
131204 17:04:04 InnoDB: Waiting for the background threads to start
131204 17:04:05 Percona XtraDB (
MySQL Performance with Support, Remote DBA, and Consulting Services by Percona) 5.5.34-MariaDB-31.1 started; log sequence number 106500245729
131204 17:04:05 [Note] Plugin 'FEEDBACK' is disabled.
SSL error: Unable to get private key from '/***/***.pem'
131204 17:04:08 [Warning] Failed to setup SSL
131204 17:04:08 [Warning] SSL error: Unable to get private key
131204 17:04:08 [Note] Server socket created on IP: '::'.
131204 17:04:08 [Note] Event Scheduler: Loaded 0 events
131204 17:04:08 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.34-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
131204 17:05:12 InnoDB: Completed reading buffer pool pages (requested: 84645, read: 83133)
I have since fixed the SSL error but not sure why that would have any effect.
mysql --version on server: mysql Ver 15.1 Distrib 5.5.34-MariaDB, for Linux (i686) using readline 5.1
mysql --version on cpanel: mysql Ver 14.14 Distrib 5.5.32, for Linux (x86_64) using readline 5.1
Mysql Server: Server version: 5.5.34-MariaDB-log MariaDB Server
Code:
mysql> show engines;
+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| CSV | YES | CSV storage engine | NO | NO | NO |
| MyISAM | YES | MyISAM storage engine | NO | NO | NO |
| BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO |
| InnoDB | DEFAULT | Percona-XtraDB, Supports transactions, row-level locking, and foreign keys | YES | YES | YES |
| PERFORMANCE_SCHEMA | YES | Performance Schema | NO | NO | NO |
| ARCHIVE | YES | Archive storage engine | NO | NO | NO |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
| FEDERATED | YES | FederatedX pluggable storage engine | YES | NO | YES |
| Aria | YES | Crash-safe tables with MyISAM heritage | NO | NO | NO |
+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
10 rows in set (0.00 sec)
my.cnf - client:
Code:
[mysqld]
innodb_file_per_table=1
default-storage-engine=Innodb
[client]
host="***"
ssl-ca=/***/***.pem
ssl-cert=/***/***.pem
ssl-key=/***/***.pem
my.cnf - server:
Code:
#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]
#
# include all files from the config directory
#
!includedir /etc/my.cnf.d
[mysql]
# CLIENT #
port = 3306
socket = /var/lib/mysql/mysql.sock
ssl-ca=/***/***.pem
ssl-cert=/***/***.pem
ssl-key=/***/***.pem
[mysqld]
# GENERAL #
user = mysql
default_storage_engine = InnoDB
socket = /var/lib/mysql/mysql.sock
pid_file = /var/lib/mysql/mysql.pid
character-set-server = utf8
collation-server = utf8_general_ci
server-id = 1
# MyISAM #
key_buffer_size = 512M
myisam_recover = FORCE,BACKUP
# SAFETY #
max_allowed_packet = 128M
max_connect_errors = 1000000
#skip_name_resolve #Commented out by suggestion of cPanel support to fix #42000 error when accessing phpmyadmin
#sql_mode = STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY
sysdate_is_now = 1
innodb = FORCE
innodb_strict_mode = 1
# DATA STORAGE #
datadir = /var/lib/mysql/data
# BINARY LOGGING #
log_bin = /var/lib/mysql/mysql-bin
expire_logs_days = 1
sync_binlog = 1
max_binlog_size = 128M
binlog_format = MIXED
# CACHES AND LIMITS #
tmp_table_size = 32M
max_heap_table_size = 32M
#query_cache_type = 0
query_cache_size = 32M
max_connections = 64
thread_cache_size = 50
open_files_limit = 65535
table_definition_cache = 8192
table_open_cache = 8192
# INNODB #
innodb_flush_method = O_DIRECT
innodb_log_files_in_group = 2
innodb_log_file_size = 64M
innodb_flush_log_at_trx_commit = 1
innodb_file_per_table = 1
innodb_buffer_pool_size = 1328M
innodb_file_format = Barracuda
innodb_stats_on_metadata = OFF
# XTRADB #
innodb_buffer_pool_restore_at_startup = 600
# LOGGING #
log_error = /var/log/mysql/mysql-error.log
log_queries_not_using_indexes = 0
long_query_time = 5
slow_query_log = 1
slow_query_log_file = /var/log/mysql/mysql-slow.log
# SSL #
ssl-ca=/***/***.pem
ssl-cert=/***/***.pem
ssl-key=/***/***.pem
