Hello, When upgrading from 10.1.16 to 10.1.17 on Debian Jessie i've received the following error:
aptitude upgrade <snip> dpkg: error processing package mariadb-server-10.1 (--configure): subprocess installed post-installation script returned error exit status 1 Processing triggers for libc-bin (2.19-18+deb8u4) ... Errors were encountered while processing: mariadb-server-10.1 E: Sub-process /usr/bin/dpkg returned an error code (1) Failed to perform requested operation on package. Trying to recover: Setting up mariadb-server-10.1 (10.1.17+maria-1~jessie) ... dpkg: error processing package mariadb-server-10.1 (--configure): subprocess installed post-installation script returned error exit status 1 Errors were encountered while processing: mariadb-server-10.1 Current status: 0 updates [-14] <snip> /var/log/syslog mysqld_safe[44689]: ERROR: 1136 Column count doesn't match value count at row 1 Was able to fix by running. /usr/sbin/mysqld --skip-grant --general-log & And running the upgrade again. See attached full logs.
The following packages will be upgraded: galera-3 icinga2 icinga2-bin icinga2-common icinga2-doc libicinga2 libmariadbclient18 libmysqlclient18 mariadb-client-10.1 mariadb-client-core-10.1 mariadb-common mariadb-server-10.1 mariadb-server-core-10.1 mysql-common 14 packages upgraded, 0 newly installed, 0 to remove and 0 not upgraded. Need to get 23.5 MB of archives. After unpacking 1,190 kB will be used. Do you want to continue? [Y/n/?] y Get: 1 http://mirror.i3d.net/pub/mariadb/repo/10.1/debian/ jessie/main galera-3 amd64 25.3.17-jessie [7,403 kB] Get: 2 http://debmon.org/debmon/ debmon-jessie/main icinga2 amd64 2.5.4-1~debmon8+2 [51.4 kB] Get: 3 http://debmon.org/debmon/ debmon-jessie/main icinga2-bin amd64 2.5.4-1~debmon8+2 [91.1 kB] Get: 4 http://debmon.org/debmon/ debmon-jessie/main libicinga2 amd64 2.5.4-1~debmon8+2 [2,694 kB] Get: 5 http://debmon.org/debmon/ debmon-jessie/main icinga2-common all 2.5.4-1~debmon8+2 [89.2 kB] Get: 6 http://debmon.org/debmon/ debmon-jessie/main icinga2-doc all 2.5.4-1~debmon8+2 [280 kB] Get: 7 http://mirror.i3d.net/pub/mariadb/repo/10.1/debian/ jessie/main libmariadbclient18 amd64 10.1.17+maria-1~jessie [588 kB] Get: 8 http://mirror.i3d.net/pub/mariadb/repo/10.1/debian/ jessie/main libmysqlclient18 amd64 10.1.17+maria-1~jessie [2,940 B] Get: 9 http://mirror.i3d.net/pub/mariadb/repo/10.1/debian/ jessie/main mysql-common all 10.1.17+maria-1~jessie [8,542 B] Get: 10 http://mirror.i3d.net/pub/mariadb/repo/10.1/debian/ jessie/main mariadb-common all 10.1.17+maria-1~jessie [3,278 B] Get: 11 http://mirror.i3d.net/pub/mariadb/repo/10.1/debian/ jessie/main mariadb-client-core-10.1 amd64 10.1.17+maria-1~jessie [693 kB] Get: 12 http://mirror.i3d.net/pub/mariadb/repo/10.1/debian/ jessie/main mariadb-client-10.1 amd64 10.1.17+maria-1~jessie [1,107 kB] Get: 13 http://mirror.i3d.net/pub/mariadb/repo/10.1/debian/ jessie/main mariadb-server-core-10.1 amd64 10.1.17+maria-1~jessie [4,389 kB] Get: 14 http://mirror.i3d.net/pub/mariadb/repo/10.1/debian/ jessie/main mariadb-server-10.1 amd64 10.1.17+maria-1~jessie [6,129 kB] Fetched 23.5 MB in 0s (30.8 MB/s) Preconfiguring packages ... (Reading database ... 47559 files and directories currently installed.) Preparing to unpack .../galera-3_25.3.17-jessie_amd64.deb ... Unpacking galera-3 (25.3.17-jessie) over (25.3.15-jessie) ... Preparing to unpack .../libmariadbclient18_10.1.17+maria-1~jessie_amd64.deb ... Unpacking libmariadbclient18 (10.1.17+maria-1~jessie) over (10.1.16+maria-1~jessie) ... Preparing to unpack .../libmysqlclient18_10.1.17+maria-1~jessie_amd64.deb ... Unpacking libmysqlclient18 (10.1.17+maria-1~jessie) over (10.1.16+maria-1~jessie) ... Preparing to unpack .../mysql-common_10.1.17+maria-1~jessie_all.deb ... Unpacking mysql-common (10.1.17+maria-1~jessie) over (10.1.16+maria-1~jessie) ... Preparing to unpack .../mariadb-common_10.1.17+maria-1~jessie_all.deb ... Unpacking mariadb-common (10.1.17+maria-1~jessie) over (10.1.16+maria-1~jessie) ... Preparing to unpack .../mariadb-client-core-10.1_10.1.17+maria-1~jessie_amd64.deb ... Unpacking mariadb-client-core-10.1 (10.1.17+maria-1~jessie) over (10.1.16+maria-1~jessie) ... Preparing to unpack .../mariadb-client-10.1_10.1.17+maria-1~jessie_amd64.deb ... Unpacking mariadb-client-10.1 (10.1.17+maria-1~jessie) over (10.1.16+maria-1~jessie) ... Preparing to unpack .../mariadb-server-core-10.1_10.1.17+maria-1~jessie_amd64.deb ... Unpacking mariadb-server-core-10.1 (10.1.17+maria-1~jessie) over (10.1.16+maria-1~jessie) ... Processing triggers for man-db (2.7.0.2-5) ... Setting up mysql-common (10.1.17+maria-1~jessie) ... Setting up mariadb-common (10.1.17+maria-1~jessie) ... (Reading database ... 47559 files and directories currently installed.) Preparing to unpack .../mariadb-server-10.1_10.1.17+maria-1~jessie_amd64.deb ... Unpacking mariadb-server-10.1 (10.1.17+maria-1~jessie) over (10.1.16+maria-1~jessie) ... Preparing to unpack .../icinga2_2.5.4-1~debmon8+2_amd64.deb ... Unpacking icinga2 (2.5.4-1~debmon8+2) over (2.4.10-1~debmon8+1) ... Preparing to unpack .../icinga2-bin_2.5.4-1~debmon8+2_amd64.deb ... Unpacking icinga2-bin (2.5.4-1~debmon8+2) over (2.4.10-1~debmon8+1) ... Preparing to unpack .../libicinga2_2.5.4-1~debmon8+2_amd64.deb ... Unpacking libicinga2 (2.5.4-1~debmon8+2) over (2.4.10-1~debmon8+1) ... Preparing to unpack .../icinga2-common_2.5.4-1~debmon8+2_all.deb ... Unpacking icinga2-common (2.5.4-1~debmon8+2) over (2.4.10-1~debmon8+1) ... Preparing to unpack .../icinga2-doc_2.5.4-1~debmon8+2_all.deb ... Unpacking icinga2-doc (2.5.4-1~debmon8+2) over (2.4.10-1~debmon8+1) ... Processing triggers for systemd (215-17+deb8u4) ... Processing triggers for man-db (2.7.0.2-5) ... Setting up galera-3 (25.3.17-jessie) ... Setting up icinga2-common (2.5.4-1~debmon8+2) ... Installing new version of config file /etc/icinga2/features-available/gelf.conf ... Installing new version of config file /etc/icinga2/icinga2.conf ... Setting up libicinga2 (2.5.4-1~debmon8+2) ... Setting up icinga2-bin (2.5.4-1~debmon8+2) ... Setting up icinga2 (2.5.4-1~debmon8+2) ... Setting up icinga2-doc (2.5.4-1~debmon8+2) ... Setting up libmysqlclient18 (10.1.17+maria-1~jessie) ... Setting up libmariadbclient18 (10.1.17+maria-1~jessie) ... Setting up mariadb-client-core-10.1 (10.1.17+maria-1~jessie) ... Setting up mariadb-client-10.1 (10.1.17+maria-1~jessie) ... Setting up mariadb-server-core-10.1 (10.1.17+maria-1~jessie) ... Setting up mariadb-server-10.1 (10.1.17+maria-1~jessie) ... dpkg: error processing package mariadb-server-10.1 (--configure): subprocess installed post-installation script returned error exit status 1 Processing triggers for libc-bin (2.19-18+deb8u4) ... Errors were encountered while processing: mariadb-server-10.1 E: Sub-process /usr/bin/dpkg returned an error code (1) Failed to perform requested operation on package. Trying to recover: Setting up mariadb-server-10.1 (10.1.17+maria-1~jessie) ... dpkg: error processing package mariadb-server-10.1 (--configure): subprocess installed post-installation script returned error exit status 1 Errors were encountered while processing: mariadb-server-10.1 Current status: 0 updates [-14].
Sep 1 12:36:39 node438 mysqld[2057]: 2016-09-01 12:36:39 139676569564928 [Note] /usr/sbin/mysqld: Normal shutdown Sep 1 12:36:39 node438 mysqld[2057]: 2016-09-01 12:36:39 139676569831168 [Note] Slave SQL thread exiting, replication stopped in log 'node100-bin.005425' at position 316493939 Sep 1 12:36:39 node438 mysqld[2057]: 2016-09-01 12:36:39 139676569564928 [Note] Event Scheduler: Purging the queue. 0 events Sep 1 12:36:39 node438 mysqld[2057]: 2016-09-01 12:36:39 139676570097408 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013) Sep 1 12:36:39 node438 mysqld[2057]: 2016-09-01 12:36:39 139676570097408 [Note] Slave I/O thread exiting, read up to log 'node100-bin.005436', position 601224429 Sep 1 12:36:39 node438 mysqld[2057]: 2016-09-01 12:36:39 139509970724608 [Note] InnoDB: FTS optimize thread exiting. Sep 1 12:36:39 node438 mysqld[2057]: 2016-09-01 12:36:39 139676569564928 [Note] InnoDB: Starting shutdown... Sep 1 12:36:39 node438 mysqld[2057]: 2016-09-01 12:36:39 139509987510016 [Warning] InnoDB: Dumping buffer pool(s) to /data/mysql/data/ib_buffer_pool Sep 1 12:36:42 node438 mysqld[2057]: 2016-09-01 12:36:42 139509987510016 [Warning] InnoDB: Buffer pool(s) dump completed at 160901 12:36:42 Sep 1 12:37:43 node438 mysqld[2057]: 2016-09-01 12:37:43 139676569564928 [Note] InnoDB: Shutdown completed; log sequence number 392840234947 Sep 1 12:37:50 node438 mysqld[2057]: 2016-09-01 12:37:50 139676569564928 [Note] /usr/sbin/mysqld: Shutdown complete Sep 1 12:41:01 node438 mysqld_safe[44689]: 2016-09-01 12:41:01 140538167474112 [Note] /usr/sbin/mysqld (mysqld 10.1.17-MariaDB-1~jessie) starting as process 44714 ... Sep 1 12:41:01 node438 mysqld_safe[44689]: 2016-09-01 12:41:01 140538167474112 [Note] InnoDB: Using mutexes to ref count buffer pool pages Sep 1 12:41:01 node438 mysqld_safe[44689]: 2016-09-01 12:41:01 140538167474112 [Note] InnoDB: The InnoDB memory heap is disabled Sep 1 12:41:01 node438 mysqld_safe[44689]: 2016-09-01 12:41:01 140538167474112 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins Sep 1 12:41:01 node438 mysqld_safe[44689]: 2016-09-01 12:41:01 140538167474112 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier Sep 1 12:41:01 node438 mysqld_safe[44689]: 2016-09-01 12:41:01 140538167474112 [Note] InnoDB: Compressed tables use zlib 1.2.8 Sep 1 12:41:01 node438 mysqld_safe[44689]: 2016-09-01 12:41:01 140538167474112 [Note] InnoDB: Using Linux native AIO Sep 1 12:41:01 node438 mysqld_safe[44689]: 2016-09-01 12:41:01 140538167474112 [Note] InnoDB: Using SSE crc32 instructions Sep 1 12:41:01 node438 mysqld_safe[44689]: 2016-09-01 12:41:01 140538167474112 [Note] InnoDB: Initializing buffer pool, size = 141.0G Sep 1 12:41:06 node438 mysqld_safe[44689]: 2016-09-01 12:41:06 140538167474112 [Note] InnoDB: Completed initialization of buffer pool Sep 1 12:41:07 node438 mysqld_safe[44689]: 2016-09-01 12:41:07 140538167474112 [Note] InnoDB: Highest supported file format is Barracuda. Sep 1 12:41:10 node438 mysqld_safe[44689]: 2016-09-01 12:41:10 140538167474112 [Note] InnoDB: 128 rollback segment(s) are active. Sep 1 12:41:10 node438 mysqld_safe[44689]: 2016-09-01 12:41:10 140538167474112 [Note] InnoDB: Waiting for purge to start Sep 1 12:41:10 node438 mysqld_safe[44689]: 2016-09-01 12:41:10 140538167474112 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.31-77.0 started; log sequence number 392840234947 Sep 1 12:41:10 node438 mysqld_safe[44689]: 2016-09-01 12:41:10 140371535300352 [Note] InnoDB: Dumping buffer pool(s) not yet started Sep 1 12:41:10 node438 mysqld_safe[44689]: 2016-09-01 12:41:10 7faacb7f8700 InnoDB: Loading buffer pool(s) from /data/mysql/data/ib_buffer_pool Sep 1 12:41:10 node438 mysqld_safe[44689]: ERROR: 1136 Column count doesn't match value count at row 1 Sep 1 12:41:10 node438 mysqld_safe[44689]: 2016-09-01 12:41:10 140538167474112 [ERROR] Aborting Sep 1 12:41:10 node438 mysqld_safe[44689]: Sep 1 12:41:10 node438 mysqld_safe[44689]: 2016-09-01 12:41:10 7faacb7f8700 InnoDB: Buffer pool(s) load completed at 160901 12:41:10 (/data/mysql/data/ib_buffer_pool was empty) Sep 1 12:41:10 node438 mysqld_safe[44689]: 2016-09-01 12:41:10 140371535300352 [Warning] InnoDB: Dumping buffer pool(s) to /data/mysql/data/ib_buffer_pool Sep 1 12:41:10 node438 mysqld_safe[44689]: 2016-09-01 12:41:10 140371535300352 [Warning] InnoDB: Buffer pool(s) dump completed at 160901 12:41:10 Sep 1 12:41:17 node438 mysqld_safe[44689]: Sep 1 12:41:17 node438 mysqld_safe[44689]: Installation of system tables failed! Examine the logs in Sep 1 12:41:17 node438 mysqld_safe[44689]: /data/mysql/data for more information. Sep 1 12:41:17 node438 mysqld_safe[44689]: Sep 1 12:41:17 node438 mysqld_safe[44689]: The problem could be conflicting information in an external Sep 1 12:41:17 node438 mysqld_safe[44689]: my.cnf files. You can ignore these by doing: Sep 1 12:41:17 node438 mysqld_safe[44689]: Sep 1 12:41:17 node438 mysqld_safe[44689]: shell> /usr/bin/scripts/mysql_install_db --defaults-file=~/.my.cnf Sep 1 12:41:17 node438 mysqld_safe[44689]: Sep 1 12:41:17 node438 mysqld_safe[44689]: You can also try to start the mysqld daemon with: Sep 1 12:41:17 node438 mysqld_safe[44689]: Sep 1 12:41:17 node438 mysqld_safe[44689]: shell> /usr/sbin/mysqld --skip-grant --general-log & Sep 1 12:41:17 node438 mysqld_safe[44689]: Sep 1 12:41:17 node438 mysqld_safe[44689]: and use the command line tool /usr/bin/mysql Sep 1 12:41:17 node438 mysqld_safe[44689]: to connect to the mysql database and look at the grant tables: Sep 1 12:41:17 node438 mysqld_safe[44689]: Sep 1 12:41:17 node438 mysqld_safe[44689]: shell> /usr/bin/mysql -u root mysql Sep 1 12:41:17 node438 mysqld_safe[44689]: mysql> show tables; Sep 1 12:41:17 node438 mysqld_safe[44689]: Sep 1 12:41:17 node438 mysqld_safe[44689]: Try 'mysqld --help' if you have problems with paths. Using Sep 1 12:41:17 node438 mysqld_safe[44689]: --general-log gives you a log in /data/mysql/data that may be helpful. Sep 1 12:41:17 node438 mysqld_safe[44689]: Sep 1 12:41:17 node438 mysqld_safe[44689]: The latest information about mysql_install_db is available at Sep 1 12:41:17 node438 mysqld_safe[44689]: https://mariadb.com/kb/en/installing-system-tables-mysql_install_db Sep 1 12:41:17 node438 mysqld_safe[44689]: MariaDB is hosted on launchpad; You can find the latest source and Sep 1 12:41:17 node438 mysqld_safe[44689]: email lists at http://launchpad.net/maria Sep 1 12:41:17 node438 mysqld_safe[44689]: Sep 1 12:41:17 node438 mysqld_safe[44689]: Please check all of the above before submitting a bug report Sep 1 12:41:17 node438 mysqld_safe[44689]: at http://mariadb.org/jira Sep 1 12:41:17 node438 mysqld_safe[44689]: Sep 1 12:41:18 node438 mysqld_safe[45024]: 2016-09-01 12:41:18 139747651045312 [Note] /usr/sbin/mysqld (mysqld 10.1.17-MariaDB-1~jessie) starting as process 45049 ... Sep 1 12:41:18 node438 mysqld_safe[45024]: 2016-09-01 12:41:18 139747651045312 [Note] InnoDB: Using mutexes to ref count buffer pool pages Sep 1 12:41:18 node438 mysqld_safe[45024]: 2016-09-01 12:41:18 139747651045312 [Note] InnoDB: The InnoDB memory heap is disabled Sep 1 12:41:18 node438 mysqld_safe[45024]: 2016-09-01 12:41:18 139747651045312 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins Sep 1 12:41:18 node438 mysqld_safe[45024]: 2016-09-01 12:41:18 139747651045312 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier Sep 1 12:41:18 node438 mysqld_safe[45024]: 2016-09-01 12:41:18 139747651045312 [Note] InnoDB: Compressed tables use zlib 1.2.8 Sep 1 12:41:18 node438 mysqld_safe[45024]: 2016-09-01 12:41:18 139747651045312 [Note] InnoDB: Using Linux native AIO Sep 1 12:41:18 node438 mysqld_safe[45024]: 2016-09-01 12:41:18 139747651045312 [Note] InnoDB: Using SSE crc32 instructions Sep 1 12:41:18 node438 mysqld_safe[45024]: 2016-09-01 12:41:18 139747651045312 [Note] InnoDB: Initializing buffer pool, size = 141.0G Sep 1 12:41:23 node438 mysqld_safe[45024]: 2016-09-01 12:41:23 139747651045312 [Note] InnoDB: Completed initialization of buffer pool Sep 1 12:41:24 node438 mysqld_safe[45024]: 2016-09-01 12:41:24 139747651045312 [Note] InnoDB: Highest supported file format is Barracuda. Sep 1 12:41:27 node438 mysqld_safe[45024]: 2016-09-01 12:41:27 139747651045312 [Note] InnoDB: 128 rollback segment(s) are active. Sep 1 12:41:27 node438 mysqld_safe[45024]: 2016-09-01 12:41:27 139747651045312 [Note] InnoDB: Waiting for purge to start Sep 1 12:41:27 node438 mysqld_safe[45024]: 2016-09-01 12:41:27 139747651045312 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.31-77.0 started; log sequence number 392840236947 Sep 1 12:41:27 node438 mysqld_safe[45024]: 2016-09-01 12:41:27 139581018048256 [Note] InnoDB: Dumping buffer pool(s) not yet started Sep 1 12:41:27 node438 mysqld_safe[45024]: 2016-09-01 12:41:27 7ef2bcff8700 InnoDB: Loading buffer pool(s) from /data/mysql/data/ib_buffer_pool Sep 1 12:41:27 node438 mysqld_safe[45024]: ERROR: 1136 Column count doesn't match value count at row 1 Sep 1 12:41:27 node438 mysqld_safe[45024]: 2016-09-01 12:41:27 139747651045312 [ERROR] Aborting Sep 1 12:41:27 node438 mysqld_safe[45024]: Sep 1 12:41:27 node438 mysqld_safe[45024]: 2016-09-01 12:41:27 7ef2bcff8700 InnoDB: Buffer pool(s) load completed at 160901 12:41:27 Sep 1 12:41:27 node438 mysqld_safe[45024]: 2016-09-01 12:41:27 139581018048256 [Warning] InnoDB: Dumping buffer pool(s) to /data/mysql/data/ib_buffer_pool Sep 1 12:41:27 node438 mysqld_safe[45024]: 2016-09-01 12:41:27 139581018048256 [Warning] InnoDB: Buffer pool(s) dump completed at 160901 12:41:27 Sep 1 12:41:35 node438 mysqld_safe[45024]: Sep 1 12:41:35 node438 mysqld_safe[45024]: Installation of system tables failed! Examine the logs in Sep 1 12:41:35 node438 mysqld_safe[45024]: /data/mysql/data for more information. Sep 1 12:41:35 node438 mysqld_safe[45024]: Sep 1 12:41:35 node438 mysqld_safe[45024]: The problem could be conflicting information in an external Sep 1 12:41:35 node438 mysqld_safe[45024]: my.cnf files. You can ignore these by doing: Sep 1 12:41:35 node438 mysqld_safe[45024]: Sep 1 12:41:35 node438 mysqld_safe[45024]: shell> /usr/bin/scripts/mysql_install_db --defaults-file=~/.my.cnf Sep 1 12:41:35 node438 mysqld_safe[45024]: Sep 1 12:41:35 node438 mysqld_safe[45024]: You can also try to start the mysqld daemon with: Sep 1 12:41:35 node438 mysqld_safe[45024]: Sep 1 12:41:35 node438 mysqld_safe[45024]: shell> /usr/sbin/mysqld --skip-grant --general-log & Sep 1 12:41:35 node438 mysqld_safe[45024]: Sep 1 12:41:35 node438 mysqld_safe[45024]: and use the command line tool /usr/bin/mysql Sep 1 12:41:35 node438 mysqld_safe[45024]: to connect to the mysql database and look at the grant tables: Sep 1 12:41:35 node438 mysqld_safe[45024]: Sep 1 12:41:35 node438 mysqld_safe[45024]: shell> /usr/bin/mysql -u root mysql Sep 1 12:41:35 node438 mysqld_safe[45024]: mysql> show tables; Sep 1 12:41:35 node438 mysqld_safe[45024]: Sep 1 12:41:35 node438 mysqld_safe[45024]: Try 'mysqld --help' if you have problems with paths. Using Sep 1 12:41:35 node438 mysqld_safe[45024]: --general-log gives you a log in /data/mysql/data that may be helpful. Sep 1 12:41:35 node438 mysqld_safe[45024]: Sep 1 12:41:35 node438 mysqld_safe[45024]: The latest information about mysql_install_db is available at Sep 1 12:41:35 node438 mysqld_safe[45024]: https://mariadb.com/kb/en/installing-system-tables-mysql_install_db Sep 1 12:41:35 node438 mysqld_safe[45024]: MariaDB is hosted on launchpad; You can find the latest source and Sep 1 12:41:35 node438 mysqld_safe[45024]: email lists at http://launchpad.net/maria Sep 1 12:41:35 node438 mysqld_safe[45024]: Sep 1 12:41:35 node438 mysqld_safe[45024]: Please check all of the above before submitting a bug report Sep 1 12:41:35 node438 mysqld_safe[45024]: at http://mariadb.org/jira Sep 1 12:41:35 node438 mysqld_safe[45024]:
# Maintained through Puppet [mysqld_safe] socket = /var/run/mysqld/mysqld.sock syslog [mysql] # CLIENT # port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld] server-id = 100000123 skip-name-resolve binlog_format = MIXED innodb_buffer_pool_load_at_startup = ON innodb_buffer_pool_dump_at_shutdown = ON # GENERAL # user = mysql # TokuDB # tokudb_row_format = tokudb_lzma plugin-load-add=ha_tokudb.so tokudb_cache_size =141G default_storage_engine = InnoDB socket = /var/run/mysqld/mysqld.sock pid-file = /tmp/mysql.pid # MyISAM # key_buffer_size = 80M myisam_recover_options = BACKUP,FORCE myisam_sort_buffer_size = 64M # SAFETY # max_allowed_packet = 32M max_connect_errors = 500 sysdate_is_now = 1 innodb = FORCE # DATA STORAGE # datadir = /data/mysql/data tmpdir = /data/mysql/tmp # BINARY LOGGING # log-bin = /data/mysql/binlogs/node438-bin log-bin-index = /data/mysql/binlogs/node438-bin.index expire_logs_days = 3 sync_binlog = 1 # REPLICATION # read_only = 1 skip_slave_start = 1 log_slave_updates = 1 relay-log = /data/mysql/binlogs/node438-relay-bin relay-log-index = /data/mysql/binlogs/node438-relay-bin.index # CACHES AND LIMITS # tmp_table_size = 32M max_heap_table_size = 32M query_cache_type = 0 query_cache_size = 0 max_connections = 2000 query_cache_min_res_unit = 2K connect_timeout = 10 thread_cache_size = 100 open_files_limit = 65535 table_definition_cache = 4096 table_open_cache = 3072 sort_buffer_size = 2M read_buffer_size = 1M max_allowed_packet = 32M thread_stack = 256K # INNODB # innodb_data_home_dir = /data/mysql/data innodb_data_file_path = ibdata1:10M:autoextend innodb_flush_method = O_DIRECT innodb_log_files_in_group = 2 innodb_log_file_size = 512M innodb_log_group_home_dir = /data/mysql/data innodb_flush_log_at_trx_commit = 1 innodb_file_per_table = 1 innodb_buffer_pool_size = 141G innodb_log_buffer_size = 25M innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_file_format = Barracuda innodb_stats_on_metadata = 0 # LOGGING # log_queries_not_using_indexes = 1 slow_query_log = 1 slow_query_log_file = /var/log/mysql/mysql-slow.log long_query_time = 1 [mysqldump] quick quote-names max_allowed_packet = 32M [isamchk] key_buffer_size = 16M
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
