MariaDB No MySQL logs after MariaDB update to 10.0

Daniel J. Lewis · Jul 29, 2015

The usual log at /var/log/mysqld.log contains nothing new since updating to 10.0. Running mycnf returns:

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



[mariadb-10.0]
# 2 variables needed to switch from XtraDB to InnoDB plugins
#plugin-load=ha_innodb
#ignore_builtin_innodb

## MariaDB 10 InnoDB plugin only
#innodb_buffer_pool_load_now=1
#innodb_buffer_pool_dump_now=1
## Disabled settings
performance_schema=OFF
innodb_stats_on_metadata=OFF
innodb_sort_buffer_size=2M
innodb_online_alter_log_max_size=128M
query_cache_strip_comments=0
log_slow_filter =admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk

Is that right, especially that "!" in there?

eva2000 · Jul 29, 2015

weird that ain't right at all ! missing alot of settings

let me check !

did you edit or adjust your /etc/my.cnf prior to the MariaDB 5.5 to 10.x upgrade ?

given the contents at top, i assume you have changed settings in /etc/my.cnf
Code:
#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]
the upgrade menu inserts or adjusts my.cnf settings for MariaDB 10 using anchors of existing settings in /etc/my.cnf. I can imagine if you edited /etc/my.cnf drastically, it could of removed such anchors so the upgrade task didn't have any anchors to reference

Upgrade menu's relevant sections are lines 81 to 100 for inc/mariadb_submenu.inc and and lines 228 to 403 in inc/mariadb_upgrade10.inc

You maybe able to find your pre-upgrade MariaDB 5.5 /etc/my.cnf at /etc/my.cnf-original_before_mariadb55upgrade due to auto backup prior to upgrade in line 255 of inc/mariadb_upgrade10.inc

post the contents of that /etc/my.cnf-original_before_mariadb55upgrade via gist or pastebin link so can see the before upgrade state of your /etc/my.cnf

quicksalad · Jul 30, 2015

just noticed mine got the same issue, no recent logs also.

got 4 files

my.cnf-original_before_mariadb55upgrade
my.cnf-original
my.cnf-newold
my.cnf
Click to expand...

eva2000 · Jul 30, 2015

quicksalad said: ↑

just noticed mine got the same issue, no recent logs also.
Click to expand...

same questions i asked above

quicksalad · Jul 30, 2015

i think I edited prior to 10.0.20, not sure though

eva2000 · Jul 30, 2015

post contents of my.cnf-original_before_mariadb55upgrade in CODE tags, gist or pastebin that is your /etc/my.cnf prior to upgrade

quicksalad · Jul 30, 2015

Here's my.cnf-original_before_mariadb55upgrade

Code:

[mysqld]
#character-set-server=utf8
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

#bind-address=127.0.0.1
# optimized my.cnf for MariaDB 5.5.x
# by eva2000
# vbtechsupport.com

tmpdir=/home/mysqltmp

innodb=ON
#skip-federated
##skip-pbxt
##skip-pbxt_statistics
#skip-archive
#skip-name-resolve
#old_passwords
back_log = 75
max_connections = 300
key_buffer_size = 32M
myisam_sort_buffer_size = 32M
myisam_max_sort_file_size = 2048M
join_buffer_size = 64K
read_buffer_size = 64K
sort_buffer_size = 128K
table_definition_cache = 4096
table_open_cache = 2048
thread_cache_size = 64
wait_timeout = 120
connect_timeout = 10
tmp_table_size = 32M
max_heap_table_size = 32M
max_allowed_packet = 32M
max_seeks_for_key = 1000
group_concat_max_len = 1024
max_length_for_sort_data = 1024
net_buffer_length = 16384
max_connect_errors = 100000
concurrent_insert = 2
read_rnd_buffer_size = 256K
bulk_insert_buffer_size = 8M
query_cache_limit = 512K
query_cache_size = 16M
query_cache_type = 1
query_cache_min_res_unit = 2K
query_prealloc_size = 262144
query_alloc_block_size = 65536
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
default-storage-engine = MyISAM

log_warnings=1
slow_query_log=0
long_query_time=1
slow_query_log_file=/var/lib/mysql/slowq.log
log-error=/var/log/mysqld.log

# innodb settings
##innodb_extra_rsegments = 4
innodb_purge_threads=1
#innodb_doublewrite = 1

innodb_file_per_table = 1
innodb_open_files = 1000
innodb_data_file_path= ibdata1:10M:autoextend
innodb_buffer_pool_size = 48M
#innodb_additional_mem_pool_size = 32M

innodb_log_files_in_group = 2
innodb_log_file_size = 64M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 2
innodb_thread_concurrency = 0
innodb_lock_wait_timeout=50
#innodb_flush_method = O_DIRECT
innodb_support_xa=1

# 200 * # DISKS
innodb_io_capacity = 100
innodb_read_io_threads = 2
innodb_write_io_threads = 2

# mariadb settings
[mariadb]
#thread-handling = pool-of-threads
#thread-pool-size= 20
#mysql --port=3307 --protocol=tcp
#extra-port=3307
#extra-max-connections=1

userstat = 0
key_cache_segments = 1
aria_group_commit = none
aria_group_commit_interval = 0
aria_log_file_size = 32M
aria_log_purge_type = immediate
aria_pagecache_buffer_size = 8M
aria_sort_buffer_size = 8M

[mariadb-5.5]
#ignore_db_dirs=
query_cache_strip_comments=0

innodb_read_ahead = linear
innodb_adaptive_flushing_method = estimate
innodb_flush_neighbor_pages = 1
innodb_stats_update_need_lock = 0
innodb_log_block_size = 512

log_slow_filter =admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk

[mysqld_safe]
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysqld.log
#nice = -5
open-files-limit = 8192

[mysqldump]
quick
max_allowed_packet = 32M

[myisamchk]
key_buffer = 32M
sort_buffer = 16M
read_buffer = 16M
write_buffer = 16M

[mysqlhotcopy]
interactive-timeout

[mariadb-10.0]
# 2 variables needed to switch from XtraDB to InnoDB plugins
#plugin-load=ha_innodb
#ignore_builtin_innodb

## MariaDB 10 InnoDB plugin only
#innodb_buffer_pool_load_now=1
#innodb_buffer_pool_dump_now=1
## Disabled settings
performance_schema=OFF
innodb_stats_on_metadata=OFF
innodb_sort_buffer_size=2M
innodb_online_alter_log_max_size=128M
query_cache_strip_comments=0
log_slow_filter =admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk

quicksalad · Jul 30, 2015

here's my.cnf

Code:

[mysqld]
#character-set-server=utf8
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

#bind-address=127.0.0.1
# optimized my.cnf for MariaDB 5.5.x
# by eva2000
# vbtechsupport.com

tmpdir=/home/mysqltmp

innodb=ON
#skip-federated
###skip-pbxt
###skip-pbxt_statistics
#skip-archive
#skip-name-resolve
#old_passwords
back_log = 75
max_connections = 300
key_buffer_size = 32M
myisam_sort_buffer_size = 32M
myisam_max_sort_file_size = 2048M
join_buffer_size = 64K
read_buffer_size = 64K
sort_buffer_size = 128K
table_definition_cache = 4096
table_open_cache = 2048
thread_cache_size = 64
wait_timeout = 120
connect_timeout = 10
tmp_table_size = 32M
max_heap_table_size = 32M
max_allowed_packet = 32M
max_seeks_for_key = 1000
group_concat_max_len = 1024
max_length_for_sort_data = 1024
net_buffer_length = 16384
max_connect_errors = 100000
concurrent_insert = 2
read_rnd_buffer_size = 256K
bulk_insert_buffer_size = 8M
query_cache_limit = 512K
query_cache_size = 16M
query_cache_type = 1
query_cache_min_res_unit = 2K
query_prealloc_size = 262144
query_alloc_block_size = 65536
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
default-storage-engine = MyISAM

log_warnings=1
slow_query_log=0
long_query_time=1
slow_query_log_file=/var/lib/mysql/slowq.log
log-error=/var/log/mysqld.log

# innodb settings
###innodb_extra_rsegments = 4
innodb_purge_threads=1
##innodb_doublewrite = 1

innodb_file_per_table = 1
innodb_open_files = 1000
innodb_data_file_path= ibdata1:10M:autoextend
innodb_buffer_pool_size = 48M
##innodb_additional_mem_pool_size = 32M

innodb_log_files_in_group = 2
innodb_log_file_size = 64M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 2
innodb_thread_concurrency = 0
innodb_lock_wait_timeout=50
#innodb_flush_method = O_DIRECT
innodb_support_xa=1

# 200 * # DISKS
innodb_io_capacity = 100
innodb_read_io_threads = 2
innodb_write_io_threads = 2

# mariadb settings
[mariadb]
#thread-handling = pool-of-threads
#thread-pool-size= 20
#mysql --port=3307 --protocol=tcp
#extra-port=3307
#extra-max-connections=1

userstat = 0
key_cache_segments = 1
aria_group_commit = none
aria_group_commit_interval = 0
aria_log_file_size = 32M
aria_log_purge_type = immediate
aria_pagecache_buffer_size = 8M
aria_sort_buffer_size = 8M

[mariadb-5.5]
#ignore_db_dirs=
query_cache_strip_comments=0

innodb_read_ahead = linear
innodb_adaptive_flushing_method = estimate
innodb_flush_neighbor_pages = 1
innodb_stats_update_need_lock = 0
innodb_log_block_size = 512

log_slow_filter =admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk

[mysqld_safe]
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysqld.log
#nice = -5
open-files-limit = 8192

[mysqldump]
quick
max_allowed_packet = 32M

[myisamchk]
key_buffer = 32M
sort_buffer = 16M
read_buffer = 16M
write_buffer = 16M

[mysqlhotcopy]
interactive-timeout

[mariadb-10.0]
# 2 variables needed to switch from XtraDB to InnoDB plugins
#plugin-load=ha_innodb
#ignore_builtin_innodb

## MariaDB 10 InnoDB plugin only
#innodb_buffer_pool_load_now=1
#innodb_buffer_pool_dump_now=1
## Disabled settings
performance_schema=OFF
innodb_stats_on_metadata=OFF
innodb_sort_buffer_size=2M
innodb_online_alter_log_max_size=128M
query_cache_strip_comments=0
log_slow_filter =admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk


[mariadb-10.0]
# 2 variables needed to switch from XtraDB to InnoDB plugins
#plugin-load=ha_innodb
#ignore_builtin_innodb

## MariaDB 10 InnoDB plugin only
#innodb_buffer_pool_load_now=1
#innodb_buffer_pool_dump_now=1
## Disabled settings
performance_schema=OFF
innodb_stats_on_metadata=OFF
innodb_sort_buffer_size=2M
innodb_online_alter_log_max_size=128M
query_cache_strip_comments=0
log_slow_filter =admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk

quicksalad · Jul 30, 2015

why is that this part was doubled?

Code:

[mariadb-10.0]
# 2 variables needed to switch from XtraDB to InnoDB plugins
#plugin-load=ha_innodb
#ignore_builtin_innodb

## MariaDB 10 InnoDB plugin only
#innodb_buffer_pool_load_now=1
#innodb_buffer_pool_dump_now=1
## Disabled settings
performance_schema=OFF
innodb_stats_on_metadata=OFF
innodb_sort_buffer_size=2M
innodb_online_alter_log_max_size=128M
query_cache_strip_comments=0
log_slow_filter =admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk

eva2000 · Jul 30, 2015

which centmin mod version did you have ? looks like you ran mariadb 10 update when you already had mariadb 10

if you used .08 beta it already was mariadb 10

quicksalad · Jul 30, 2015

eva2000 said: ↑

which centmin mod version did you have ? looks like you ran mariadb 10 update when you already had mariadb 10

if you used .08 beta it already was mariadb 10
Click to expand...

i was running MariaDB 10 prior to using .08, then updated MariaDB to 10.0.20 using .08 beta

rdan · Jul 30, 2015

quicksalad said: ↑

i was running MariaDB 10 prior to using .08, then updated MariaDB to 10.0.20 using .08 beta
Click to expand...

You should just run yum update then

eva2000 · Jul 30, 2015

yup yum update is proper way.. menu option 12 is only for major mysql updates like 5.5 to 10.0 or 10.0 to 10.1

for you at least because you ran mariadb 10.0 before menu option 12 run, you can just copy and replace the backup file /etc/my.cnf-original_before_mariadb55upgrade at /etc/my.cnf and restart mysql
Code:
\cp -a /etc/my.cnf-original_before_mariadb55upgrade /etc/my.cnf
mysqlrestart
@Daniel J. Lewis won't be able to do that if he ran mariadb 5.5 prior to menu option 12 upgrade as /etc/my.cnf-original_before_mariadb55upgrade would be mariadb 5.5 settings only without mariadb 10 ones

quicksalad · Jul 30, 2015

now I know, thanks @eva2000 and @RoldanLT

Any advise how to make MySQL logs running back again?

Can I delete the doubled lines I posted earlier on my.cnf?

eva2000 · Jul 30, 2015

if you copy back the file like i suggested and restart mysql it should work

quicksalad · Jul 30, 2015

@eva2000
please correct me if I'm wrong
the command copy the variables or contents in /etc/my.cnf-original_before_mariadb55upgrade
to replace /etc/my.cnf ?

eva2000 · Jul 30, 2015

quicksalad said: ↑

@eva2000
please correct me if I'm wrong
the command copy the variables or contents in /etc/my.cnf-original_before_mariadb55upgrade
to replace /etc/my.cnf ?
Click to expand...

yup \ disable alias on cp copy command and replace /etc/my.cnf with /etc/my.cnf-original_before_mariadb55upgrade
Code:
\cp -a /etc/my.cnf-original_before_mariadb55upgrade /etc/my.cnf
then restart mysql
Code:
mysqlrestart

quicksalad · Jul 30, 2015

@eva2000 thank you!

Daniel J. Lewis · Aug 5, 2015

Coming back to this, the only changes I made to my.cnf were value changes, I think.

Code:

[mysqld]
#character-set-server=utf8
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

#bind-address=127.0.0.1
# optimized my.cnf for MariaDB 5.5.x
# by eva2000
# vbtechsupport.com

tmpdir=/home/mysqltmp

#skip-innodb
skip-federated
#skip-pbxt
#skip-pbxt_statistics
skip-archive
#skip-name-resolve
#old_passwords
back_log = 75
max_connections = 100
key_buffer_size = 32M
myisam_sort_buffer_size = 32M
myisam_max_sort_file_size = 1024M
join_buffer_size = 256K
read_buffer_size = 64K
sort_buffer_size = 256K
table_definition_cache = 4096
table_open_cache = 2048
thread_cache_size = 64
wait_timeout = 120
connect_timeout = 10
tmp_table_size = 96M
max_heap_table_size = 96M
max_allowed_packet = 32M
max_seeks_for_key = 1000
group_concat_max_len = 1024
max_length_for_sort_data = 1024
net_buffer_length = 16384
max_connect_errors = 100000
concurrent_insert = 2
read_rnd_buffer_size = 512K
bulk_insert_buffer_size = 8M
query_cache_limit = 512K
query_cache_size = 48M
query_cache_type = 1
query_cache_min_res_unit = 2K
query_prealloc_size = 262144
query_alloc_block_size = 65536
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
default-storage-engine = MyISAM

log_warnings=1
slow_query_log=1
long_query_time=1
slow_query_log_file=/var/lib/mysql/slowq.log
log-error=/var/log/mysqld.log

# innodb settings
#innodb_extra_rsegments = 4
innodb_purge_threads=1
innodb_doublewrite = 1

innodb_file_per_table = 1
innodb_open_files = 1000
innodb_data_file_path= ibdata1:10M:autoextend
innodb_buffer_pool_size = 2100M
innodb_additional_mem_pool_size = 32M

innodb_log_files_in_group = 2
innodb_log_file_size = 64M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 2
innodb_thread_concurrency = 0
innodb_lock_wait_timeout=50
#innodb_flush_method = O_DIRECT
innodb_support_xa=1

# 200 * # DISKS
innodb_io_capacity = 100
innodb_read_io_threads = 2
innodb_write_io_threads = 2

# mariadb settings
[mariadb]
#thread-handling = pool-of-threads
#thread-pool-size= 20
#mysql --port=3307 --protocol=tcp
#extra-port=3307
#extra-max-connections=1

userstat = 0
key_cache_segments = 1
aria_group_commit = none
aria_group_commit_interval = 0
aria_log_file_size = 32M
aria_log_purge_type = immediate
aria_pagecache_buffer_size = 8M
aria_sort_buffer_size = 8M

[mariadb-5.5]
#ignore_db_dirs=
query_cache_strip_comments=0

innodb_read_ahead = linear
innodb_adaptive_flushing_method = estimate
innodb_flush_neighbor_pages = 1
innodb_stats_update_need_lock = 0
innodb_log_block_size = 512

log_slow_filter =admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk

[mysqld_safe]
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysqld.log
#nice = -5
open-files-limit = 8192

[mysqldump]
quick
max_allowed_packet = 32M

[myisamchk]
key_buffer = 32M
sort_buffer = 16M
read_buffer = 16M
write_buffer = 16M

[mysqlhotcopy]
interactive-timeout

eva2000 · Aug 5, 2015

do what quicksalad did and copy the backed up pre-upgrade my.cnf to /etc/my.cnf via command

type in SSH

Code:

\cp -a /etc/my.cnf-original_before_mariadb55upgrade /etc/my.cnf

then manually apply all the MariaDB 10 changes again to /etc/my.cnf and see what the resulting /etc/my.cnf looks like - if good restart mysql server

type in SSH

Code:

sed -i 's/skip-pbxt/#skip-pbxt/g' /etc/my.cnf
sed -i 's/innodb_use_purge_thread = 4/innodb_purge_threads=1/g' /etc/my.cnf
sed -i 's/innodb_extra_rsegments/#innodb_extra_rsegments/g' /etc/my.cnf
sed -i 's/innodb_adaptive_checkpoint/innodb_adaptive_flushing_method/g' /etc/my.cnf
sed -i 's/innodb_additional_mem_pool_size/#innodb_additional_mem_pool_size/g' /etc/my.cnf
sed -i 's/skip-innodb/innodb=ON/g' /etc/my.cnf
echo "" >> /etc/my.cnf
echo "" >> /etc/my.cnf
echo "[mariadb-10.0]" >> /etc/my.cnf
echo "# 2 variables needed to switch from XtraDB to InnoDB plugins" >> /etc/my.cnf
echo "#plugin-load=ha_innodb" >> /etc/my.cnf
echo "#ignore_builtin_innodb" >> /etc/my.cnf
echo "" >> /etc/my.cnf
echo "## MariaDB 10 InnoDB plugin only" >> /etc/my.cnf
echo "#innodb_buffer_pool_load_now=1" >> /etc/my.cnf
echo "#innodb_buffer_pool_dump_now=1" >> /etc/my.cnf
echo "## Disabled settings" >> /etc/my.cnf
echo "performance_schema=OFF" >> /etc/my.cnf
echo "innodb_stats_on_metadata=OFF" >> /etc/my.cnf
echo "innodb_sort_buffer_size=2M" >> /etc/my.cnf
echo "innodb_online_alter_log_max_size=128M" >> /etc/my.cnf
echo "query_cache_strip_comments=0" >> /etc/my.cnf
echo "log_slow_filter =admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk" >> /etc/my.cnf

Log in / Register

Forums

Learn about Centmin Mod LEMP Stack today

MariaDB No MySQL logs after MariaDB update to 10.0

Daniel J. Lewis Award-winning podcaster and consultant

eva2000 Administrator Staff Member

quicksalad Member

eva2000 Administrator Staff Member

quicksalad Member

eva2000 Administrator Staff Member

quicksalad Member

quicksalad Member

quicksalad Member

eva2000 Administrator Staff Member

quicksalad Member

rdan Well-Known Member

eva2000 Administrator Staff Member

quicksalad Member

eva2000 Administrator Staff Member

quicksalad Member

eva2000 Administrator Staff Member

quicksalad Member

Daniel J. Lewis Award-winning podcaster and consultant

eva2000 Administrator Staff Member

.

Log in / Register

Useful Searches

Learn about Centmin Mod LEMP Stack today

MariaDB No MySQL logs after MariaDB update to 10.0

Daniel J. Lewis Award-winning podcaster and consultant

eva2000 Administrator Staff Member

quicksalad Member

eva2000 Administrator Staff Member

quicksalad Member

eva2000 Administrator Staff Member

quicksalad Member

quicksalad Member

quicksalad Member

eva2000 Administrator Staff Member

quicksalad Member

rdan Well-Known Member

eva2000 Administrator Staff Member

quicksalad Member

eva2000 Administrator Staff Member

quicksalad Member

eva2000 Administrator Staff Member

quicksalad Member

Daniel J. Lewis Award-winning podcaster and consultant

eva2000 Administrator Staff Member

.