Step 1) Switch from MyISAM to InnoDB (e.g. XtraDB) Step 2) /etc/mysql/my.cnf defaultstorageengine = InnoDB innodblogfilesize = 128M innodbbufferpoolsize = 8G innodbfilepertable = 1 innodbopenfiles = 400…
Step 1) Switch from MyISAM to InnoDB (e.g. XtraDB) Step 2) /etc/mysql/my.cnf
default_storage_engine = InnoDB
innodb_log_file_size = 128M
innodb_buffer_pool_size = 8G
innodb_file_per_table = 1
innodb_open_files = 400
innodb_io_capacity = 400
innodb_flush_method = O_DIRECT
innodb_flush_log_at_trx_commit = 2
innodb_thread_concurrency = 8These settings are optimized for 12GB RAM Enjoy the speed of your Mysql **PERCONA
Was this worth your time?
Continue reading
I spent the last few months building the Azure and Microsoft 365 foundation for a large enterprise. The shape of the work is the useful part anyway. The brief was not "set up Azure." The brief was "build the thing…
Read article
Creating virtual machines in Proxmox manually can be time-consuming, especially when deploying multiple instances or standardizing configurations across environments. This comprehensive guide walks you through…
Read article
Introduction Securing your server is a critical aspect of maintaining a robust and reliable online presence. Bitninja, a comprehensive security solution, provides an effective way to protect your server from various…
Read article