128GB ram 2x intel xeon E5 2630v3 and still MySQL: Too many connections

xrz

How to tune mysql to support that 128GB ram? thanks

TheLinuxBug

Here, let me Google that for you: http://bfy.tw/5Uvf

Cheers!

cfgguy

OOh they did not give the tune button ??

xrz

i read all over google, but that just not helped, anyone have experience with highly write/read mysql usage tune?

pbgben

It's probably not mysql that's the issue, your code is likely shit.. No offense but yeh.... MySQL can be a bitch to work with under heavy applications. Try running the host as docker, openvz or something of that matter and run a cluster of MySQL server under a load balancer to help with the load.

Kris

https://github.com/major/MySQLTuner-perl

wget --no-check-certificate http://mysqltuner.pl -O mysqltuner.pl

dedicados

rm -rf *

shutdown now

tommy

xrz said: i read all over google

what he said?

you only looking for exact answer :P try experiment before making any changes read MySQL documentation and watch your process closely.

raza19

Increase the # of maximum concurrent connections ?
Tweak the my.cnf file, it shouldn't be a problem.

noaman

@xrz said:
How to tune mysql to supporter's that 128GB ram? thanks

Even if you have 128petabytes of ram...you still are going to ran into this issue....problem bad configurations....

Note:
Configurations of each linux module...is in accordance with resources and demand...

You my have huge resources but the config files are not allowing it to use all of it...

Just post my.cnf and other files...

noaman

@pbgben said:
It's probably not mysql that's the issue, your code is likely shit.. No offense but yeh.... MySQL can be a bitch to work with under heavy applications. Try running the host as docker, openvz or something of that matter and run a cluster of MySQL server under a load balancer to help with the load.

+1

What are you running on it?

zafouhar

@dedicados said:

rm -rf *

shutdown now

Don't forget to run from root directory so that it resolves the issue.

postcd

Try this google phrasse: MySQL: Too many connections my.cnf

And mentioned tool https://github.com/major/MySQLTuner-perl

might be also usefull

Profforg

If you're fine with payed support - shoot me a personal message.

hawkjohn7

upgrade to mariadb

xrz

okay new error that occurs:

"mysqladmin -uroot -proot processlist"

i am gettin a lot of waiting table locks

| 676 | root | localhost | database | Query | 15 | Waiting for table level lock | SELECT * FROM pages ORDER BY page.id DESC LIMIT 0, 30

mysql -uroot -proot

mysql> show engines;

| InnoDB | DEFAULT | Supports transactions, row-level locking, and foreign keys
9 rows in set (0.00 sec)

Falzo

increase innodb caches, tune innodb writeback methods, put mysql temp dir on ramdisk etc.

but first of all: sort your code or app you are using/developing. as mentioned by others above, search for the root cause of your page receiving that much mysql requests...

seeing your other php-related thread I suggest to not put mysql-connections or request into loops with php and things alike...
also have a look into how persistent connections work and so on.