Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

mysqltuner

Page 1 of 2
  1. Skin
    Thread

    SOLVED MySQLMyMonLite Error 3167 feature is disabled?

    Hello, I` have transferred ( using cPanel Transfer Tool ) some sites from an old VPS to a new one, in the new VPS I have MySQL 5.7. I`ve...
    Thread by: Skin, Jun 18, 2018, 2 replies, in forum: Database Discussion
  2. celiac101
    Thread

    Making the switch to MariaDB

    So I ran the mysql updater months ago to switch my server to MariaDB 10.1. The issue is that I never made changes to the my.cnf file, so I am not...
    Thread by: celiac101, Apr 16, 2018, 2 replies, in forum: Workarounds and Optimization
  3. fastuning
    Thread

    mysql using about 80% cpu, recomendation?

    hi, my mysql is using about 70-80% every time of cpu and about 5% memory, and many times when high traffic, websites takes too long to load...
    Thread by: fastuning, Feb 18, 2018, 2 replies, in forum: Workarounds and Optimization
  4. Sujoy Dhar
    Thread

    MySQL tuner suggestions question

    I have run the msql tuner and got the below suggestion : General recommendations: /var/lib/mysql/ns533067.ip-149-56-242.net.err is > 32Mb,...
    Thread by: Sujoy Dhar, Jan 19, 2018, 1 replies, in forum: Database Discussion
  5. elis2
    Thread

    Help Optimizing MySQL

    hi me install server cpanel. who uptimize mysql? centos 6.9 64bit ram:10gb ddr4 cori7 6700 plz hellp uptimize my.cnf thank you Best Regards
    Thread by: elis2, Dec 28, 2017, 2 replies, in forum: Workarounds and Optimization
  6. srikanta159
    Thread

    MySql Process taking too much ram

    /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql...
    Thread by: srikanta159, Sep 5, 2017, 1 replies, in forum: Database Discussion
  7. zir4k
    Thread

    Optimizing my.cnf question

    Hi, i have a virtual server with this informations: Processor Information Total processors: 4 Processor #1 Vendor GenuineIntel...
    Thread by: zir4k, Jun 19, 2017, 3 replies, in forum: Workarounds and Optimization
  8. rmzy
    Thread

    Mysql Usage

    please solve the problem The problem of high pressure on the rules without reason She has a vps 1 Core Intel® Xeon® E5-2650L P4 Rum 1 ssd 20 Load...
    Thread by: rmzy, May 4, 2017, 3 replies, in forum: Database Discussion
  9. Wil Huddleston
    Thread

    MySQL + Memory Issues on Cent OS 7

    We have been hosting 30+ WordPress sites on an old VPS with Cent OS 5 and it has been running smooth for years. We recently needed to upgrade a...
    Thread by: Wil Huddleston, Apr 25, 2017, 7 replies, in forum: Workarounds and Optimization
  10. Vs Nu
    Thread

    MySQL Cache Enable

    Hello, Can some one help me with Commands on how to enable cache in the server.The server load is getting high but i have necessary free memory of...
    Thread by: Vs Nu, Apr 19, 2017, 3 replies, in forum: Database Discussion
  11. tank
    Thread

    MYSQL Tuner error 256

    Hey guys doing some optimizing and noticed that I am not getting some weird errors on the mysql tuner. FAIL Execute SQL / return code: 256 [!!]...
    Thread by: tank, Apr 7, 2017, 4 replies, in forum: Workarounds and Optimization
  12. Rakaris Bakaris
    Thread

    Question regarding my.cnf optimization

    Hello! I'm trying to optimize SQL performance, so I need a little help to do the task. The server is virtualized and it has 6 Cores CPU, 8GB RAM....
    Thread by: Rakaris Bakaris, Mar 17, 2017, 1 replies, in forum: Workarounds and Optimization
  13. djsami
    Thread

    Increasing the InnoDB buffer pool

    Hello Optimize InnoDB - WoltLab® innodb_buffer_pool_size 24 gb ? [ATTACH] my.cnf [mysqld] default-storage_engine=InnoDB...
    Thread by: djsami, Jan 24, 2017, 2 replies, in forum: Workarounds and Optimization
  14. Fernis
    Thread

    Server Tuning Help (Apache and MySQL)

    I would appreciate some help in tuning my server to have it be as efficient as possible serving pages as fast as possible while not overloading...
    Thread by: Fernis, Nov 26, 2016, 5 replies, in forum: Workarounds and Optimization
  15. urkeee
    Thread

    Help - optimize mysqltunner to reduce high cpu usage

    Hello, can you please help me to optimize mysql to reduce high cpu usage and sometimes big load? Thanks my.cnf [mysqld] slow-query-log=1...
    Thread by: urkeee, Nov 14, 2016, 5 replies, in forum: Workarounds and Optimization
  16. SpaceCowboy
    Thread

    MysqlTunner optimization help

    Hi, i wonder if someone can help me figure if i can do better, load is a bit high when many users are on and i'f like to know if i can get better...
    Thread by: SpaceCowboy, Nov 12, 2016, 4 replies, in forum: Workarounds and Optimization
  17. Sujoy Dhar
    Thread

    MariaDB Optimization Tips

    Hi I have recently shifted to MarianDB latest version , can you please help me to optimize the MarianDB ? I will helpfull if you provide some...
    Thread by: Sujoy Dhar, Oct 13, 2016, 2 replies, in forum: Workarounds and Optimization
  18. Kurogane
    Thread

    MySQL Optimization

    Hi, I've a problem with mysql i'm getting very but very high CPU usage and i not know how i can solved it top - 22:50:48 up 7 days, 15:34, 4...
    Thread by: Kurogane, Oct 10, 2016, 5 replies, in forum: Workarounds and Optimization
  19. isajk
    Thread

    Warning: Error while sending QUERY packet.

    I did a search on my website and received my results (that 'no results were found') and at the top of the page, this error message: Warning:...
    Thread by: isajk, Sep 28, 2016, 1 replies, in forum: General Discussion
  20. Herchel
    Thread

    Optitmize MySQL Configuration to reduce CPU usage

    Hello, I'm using a Kimsufi server with this configuration: Core i5 4 cores/4 threads and with 16Gb of RAM and HDD 1To. With Ubuntu 14.04.4 LTS...
    Thread by: Herchel, Sep 14, 2016, 3 replies, in forum: Workarounds and Optimization
Showing results 1 to 20 of 35
Page 1 of 2
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice