1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

MySQL calculator tools

Discussion in 'MySQL' started by EdZzy, Nov 27, 2024.

0
  1. #1
    I'm looking for tools to optimize MySQL memory settings, particularly for calculating my.cnf memory usage and tuning parameters like innodb_buffer_pool_size and query_cache_size.

    Do you have any preferred solutions that offer features or insights beyond what mysqlcalculator.com provides?

    Thank you!
     
    EdZzy, Nov 27, 2024 IP
  2. GreenHost.Cloud

    GreenHost.Cloud Active Member

    Messages:
    366
    Likes Received:
    28
    Best Answers:
    3
    Trophy Points:
    73
    #2
    I recommend checking out the Percona Toolkit for deeper insights and more advanced tuning options. Another option is MySQLTuner, which provides valuable recommendations based on your server's performance metrics.
     
    GreenHost.Cloud, Dec 2, 2024 IP
  3. JamesDonny

    JamesDonny Peon

    Messages:
    1
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    1
    #3
    Hey, if you’re looking for something more advanced than mysqlcalculator.com, I’d suggest checking out Releem's MySQL Memory Calculator (https://releem.com/tools/mysql-memory-calculator). It’s a great tool for optimizing memory settings in MySQL and MariaDB. The tool gives detailed suggestions for settings like innodb_buffer_pool_size, query_cache_size, and others. What’s nice is that it factors in things like server traffic, query load, and connection count, which makes it super helpful when tuning your my.cnf file for better performance.
     
    JamesDonny, Dec 4, 2024 IP