#OPTIMIZE CONNECTION BUFFER SIZE UPDATE#

I couldn't increase RAM, also %25 used of ram because a key buffer size is 1GB and it could get full use of ram instant jobs. I couldn't decide which configuration is the best option for now.

The default configuration for PostgreSQL is fairly painstakingly chosen to ensure that it will run on every environment it is installed, meeting the lowest common. By design, the out of the box configuration for PostgreSQL is defined to be a 'Jack of All Trades, Master of None'. My server has 8GB ram (%25 used), 4 core x 2ghz (%10 used) Optimize PostgreSQL Server Performance Through Configuration. I get used to MySQL Tuner and I figure out those variables with that.ДЇinally, I am still getting query package errors. So, I changed to buffer size to 1GB and innodb engine pool size to %25 of it. I have a lot of CRUD jobs scheduled for every minute. Warning -> Error while sending QUERY packet. My app started to run properly and after 1 hour later, it crashed again because of a couple of errors that showed below and I fixed those errors with setting max_allow_package to maximum value in my.cnf for mariadb.

#OPTIMIZE CONNECTION BUFFER SIZE UPDATE#

I changed my configuration to disallow Persistent connections.ДЄfter I update persistent connection disabled. So, I want to fix that issue and I find a solution that I need to set it false and it will close all connections automatically.

So, simplified that, it uses allow persistent connection if you set it true. I faced an issue maximum connection exceed, so I noticed the Code Igniter do not close connection if you do not set pconnect to config to true in database.php. (Totally ~ 1k-2k CRUD works in a minute with 10 tables)

a job average proceed is 100-200 CRUD from DB.

application managed by cronjobs (10 different jobs for every minute).

The DB is mariadb 10.2 and has 10 tables.In generally, stored INT and engine default is InnoDB but in a table, I store a 'mediumtext' column.

a CRUD heavily loaded application in PHP 7.3 which uses CodeIgniter framework.

Optimize connection buffer size