Sponsor:

Server and Web Integrator
Link:
Kloxo-MR logo
6.5.0 or 7.0.0
Click for "How to install"
Donation/Sponsorship:
Kloxo-MR is open-source.
Donate and or Sponsorship always welcome.
Click to:
Click Here
Please login or register. 2024-06-18, 07:10:49

Author Topic: [TIPS] Disable MySQL innodb log  (Read 9517 times)

0 Members and 1 Guest are viewing this topic.

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
[TIPS] Disable MySQL innodb log
« on: 2013-09-23, 14:09:14 »
I have a problem in our share-hosting. MySQL (using MariaDB) not able to stop and start. What a problem is?.

Symptoms:
1. using 'innodb' as 'storage-engine' in 1 or more database
2. have 'log-bin=mysql-bin' inside '/etc/my.cnf' and or '/etc/my.cnf.d/my.cnf'
3. many files named as 'mysql-bin.*' inside '/var/lib/mysql'
4. this 'mysql-bin' files eat disk usage --> in my server until disk usage until 100%

Solutions:
1. Change 'log-bin=mysql-bin' to '#log-bin=mysql-bin'
2. restart mysql with 'sh /script/restart-mysql'
3. delete all 'mysql-bin' files with 'rm -rf /var/lib/mysql/mysql-bin.*'

-------
Note:
- log-bin only needed for 'replications' purpose
« Last Edit: 1970-01-01, 01:00:00 by Guest »
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: [TIPS] Disable MySQL innodb log
« Reply #1 on: 2013-09-23, 14:14:21 »
Alternatively:
1. Still enable log-bin with 'log-bin=mysql-bin'
2. Limiting log-bin with 'expire_logs_days=10' (for 10 days) and 'max_binlog_size=100M' (for max size 100M)
« Last Edit: 1970-01-01, 01:00:00 by Guest »
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline Spacedust

  • Super Grand Master
  • ****
  • Posts: 4,050
  • Karma: +1/-0
    • View Profile
Re: [TIPS] Disable MySQL innodb log
« Reply #2 on: 2013-10-05, 04:02:45 »
I've never used log bin ;)

Make sure to use innodb_file_per_table. This will help a lot in case of InnoDB crash and won't trash your InnoDB with previously removed databases !
« Last Edit: 1970-01-01, 01:00:00 by Guest »

 


MRatWork Affiliates:    BIGRAF(R) Inc.    House of LMAR    EFARgrafix

Page created in 0.055 seconds with 18 queries.

web stats analysis