I am aware of few tips but this article summaries few more good tips and techniques that will optimize MySQL Server performance.
ADVERTISEMENTS
Although this article explains how to tune a MySQL database for use with eZ publish system. But most of things mentioned here will apply to other MySQL based software (such as WordPress or phpbb).
This article has suggestions for optimizing for either read or write operations, and also discusses some other optimization techniques such as DNS and filesystem configuration.
Try out these tips and let me know your experience. If you are aware of any other tuning factors please let me know 😀
🐧 Get the latest tutorials on SysAdmin, Linux/Unix, Open Source & DevOps topics via:
- RSS feed or Weekly email newsletter
- Share to Twitter • Facebook • 1 comment... add one ↓
READ NEXT
30 Best Sources For Linux / *BSD / Unix Documentation On the Web
40 Linux Server Hardening Security Tips [2019 edition]
Linux 25 PHP Security Best Practices For Sys Admins
30 Linux System Monitoring Tools Every SysAdmin Should Know
Top 25 Nginx Web Server Best Security Practices- O'Reilly UG Program books news
Book review: DNS in Action - A Detailed And Practical Guide to Dns Implementation,…
| Category | List of Unix and Linux commands |
|---|---|
| File Management | cat |
| Firewall | CentOS 8 • OpenSUSE • RHEL 8 • Ubuntu 16.04 • Ubuntu 18.04 • Ubuntu 20.04 |
| Network Utilities | dig • host • ip • nmap |
| OpenVPN | CentOS 7 • CentOS 8 • Debian 10 • Debian 8/9 • Ubuntu 18.04 • Ubuntu 20.04 |
| Package Manager | apk • apt |
| Processes Management | bg • chroot • cron • disown • fg • jobs • killall • kill • pidof • pstree • pwdx • time |
| Searching | grep • whereis • which |
| User Information | groups • id • lastcomm • last • lid/libuser-lid • logname • members • users • whoami • who • w |
| WireGuard VPN | CentOS 8 • Debian 10 • Firewall • Ubuntu 20.04 |
can you please explain innodb_buffer_pool_size , it has lots to do with tuning.