Hello,
which join_buffer_size and sort_buffer_ sizes are you using in Maria-DB (in my case 10.3.36) for Cacti 1.2.23?
Thank You
join_buffer_size and sort_buffer_size for cacti 1.2.23
Moderators: Developers, Moderators
-
TheWitness
- Developer
- Posts: 17047
- Joined: Tue May 14, 2002 5:08 pm
- Location: MI, USA
- Contact:
Re: join_buffer_size and sort_buffer_size for cacti 1.2.23
Depends on your system size. If you are just doing Cacti, 256M is fine for both. If you have some huge tables and your server has a lot of memory, then you can increase things. On one of my production boxes I have both in the 500M range. They used to be higher, but my server would swap when some odd Analytics queries were written by rookies breaking my Cacti.
True understanding begins only when we realize how little we truly understand...
Life is an adventure, let yours begin with Cacti!
Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages
For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Life is an adventure, let yours begin with Cacti!
Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages
For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Who is online
Users browsing this forum: No registered users and 1 guest