Hi to all, I’ve a FOG System with 1 Master, 1 database out of server, 110 Storage Nodes on different towns and 17000 computer clients all with a variety of connections from adsl 2MB to 1GB FTTH. I’ve been experiencing a big bottleneck on MySQL myISAM database with 200 on workload average and 3.70GB RAM. I’ve take a decision i migrate the database to InnoDB to test on production, by the moment the work average are nearly to 6 and the memory on 3.50GB more or less. I’ll give you notices on the next friday…, if you have more suggestions I’ll be pleased to study and test it. By the moment it’s working by 2h 30min

@Sebastian-Roth Thankfully, Mariadb has a list of possible issues: https://mariadb.com/kb/en/converting-tables-from-myisam-to-innodb/ We’d need to set some baseline settings in the mysql config, imo.

Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Bottleneck on DATABASE

Solved

FOG Problems

3.6k

S

Sebastian Roth Moderator
last edited by

@EduardoTSeoane Just wanted to see if you are still buried in work…
Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG
1 Reply Last reply
Reply Quote 0
[[undefined-on, S Sebastian Roth, ]]

212

Online

12.1k

Users

17.3k

Topics

155.3k

Posts