mysqltuner

Thread

MySQL upgrade degrades performance

I didn't remember that I tried to upgrade a long time ago already to MySQL 5.6 and stupid me just did it again. The problem is that performance is...

Thread by: PatrickVeenstra, Sep 2, 2018, 1 replies, in forum: Database Discussion

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

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

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

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, 2 replies, in forum: Workarounds and Optimization

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

The Community Forums

Interact with an entire community of cPanel & WHM users!

MySQL upgrade degrades performance

SOLVED MySQLMyMonLite Error 3167 feature is disabled?

Making the switch to MariaDB

mysql using about 80% cpu, recomendation?

MySQL tuner suggestions question

Help Optimizing MySQL

MySql Process taking too much ram

Optimizing my.cnf question

Mysql Usage

MySQL + Memory Issues on Cent OS 7

MySQL Cache Enable

MYSQL Tuner error 256

Question regarding my.cnf optimization

Increasing the InnoDB buffer pool

Server Tuning Help (Apache and MySQL)

Help - optimize mysqltunner to reduce high cpu usage

MysqlTunner optimization help

MariaDB Optimization Tips

MySQL Optimization

Warning: Error while sending QUERY packet.

Useful Searches

The Community Forums

Interact with an entire community of cPanel & WHM users!

mysqltuner