Tamamlanmış

Optimize MySQL (mariaDB 10.3) according to server capacity -- 2

Server:

Processor : Intel 2x Xeon Silver 4214 - 24c/ 48t - 2.2GHz/ 3.2GHz

Memory : 96GB DDR4 ECC 2400MHz

Storage : 2x960GB SSD NVMe Soft RAID

------------------------------------------------------

Instaled in the server:

WHM cPanel v88.0.11

CENTOS 7.8

Apache + cpNginx (plugin) - [login to view URL]

------------------------------------------------------

Use:

MariaDB 10.3

PHP fcgi 7.3

------------------------------------------------------

The problem:

With more traffic, some websites become very slow because mysql lost the capability to proces all requests, is like an botllenek in some part. All this websites are creates with this script: [login to view URL]

All this websites use the same DB.

Total size of DB: +5GB

Largest table: 2.3GB - 11.066.800 rows

But some others websites (like wordpress site) still run very well.

------------------------------------------------------

my actual [login to view URL]

[mysqld]

log-error=/var/lib/mysql/[login to view URL]

performance-schema=0

innodb_file_per_table=1

local-infile=0

key_buffer_size = 256M

max_allowed_packet=268435456

#innodb_buffer_pool_size=134217728

max_connections = 1000

max_user_connections = 500

wait_timeout = 28800

connect_timeout = 10

table_open_cache=6000

join_buffer_size = 1M

open_files_limit=10000

tmp_table_size = 64M

max_heap_table_size = 64M

read_buffer_size = 64M

concurrent_insert = 2

max_connect_errors = 10

net_buffer_length = 16384

#read_rnd_buffer_size = 786432M

myisam_sort_buffer_size = 64M

bulk_insert_buffer_size = 8M

thread_cache_size = 384

query_cache_limit = 7M

query_cache_size = 128M

query_cache_type = 1

query_prealloc_size = 262144

query_alloc_block_size = 65536

transaction_alloc_block_size = 8192

transaction_prealloc_size = 4096

max_write_lock_count = 32

#open_files_limit=40000

#skip-networking

innodb_buffer_pool_size=12G

innodb_thread_concurrency=32

performance-schema=0

default-storage-engine=MyISAM

[mysqldump]

quick

max_allowed_packet = 16M

[mysql]

no-auto-rehash

[myisamchk]

key_buffer = 384M

sort_buffer = 384M

read_buffer = 256M

write_buffer = 256M

-------------------------------------------------------------

I need an mariaBD expert to optimize the [login to view URL], or make some others recomandations.

Maybe the problem is not only in mysql, and also come from the php configuration, but I need to start from some point, and have an good mysql config, is an good point to start.

Beceriler: PHP, Apache, Nginx, MySQL, MariaDB

Daha fazlasını gör: mariadb kb server variables, mariadb 10.3 my cnf example, mysql performance tuning max connections, mariadb myisam config, key_buffer_size mariadb, etc/mysql/mariadb conf d 50-server cnf, mariadb best settings, mysql memory optimization, optimize mysql queries, optimize mysql load servers, optimize mysql databases, optimize mysql requests, optimize mysql query software, optimize mysql apache, optimize mysql thousands concurrent users, optimize mysql traffic website, optimize mysql queries script, optimize mysql server, optimize mysql server traffic, ubuntu server optimize mysql web server

İşveren Hakkında:
( 2 değerlendirme ) brasov, Serbia

Proje NO: #26326505

Seçilen:

pdq

hello and thank you for inviting me to bid to the project. i would like to try to solve your issue. you will pay only after result lets chat

%selectedBids___i_period_sub_7% gün içinde 120%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(164 Değerlendirme)
6.2

Bu iş için 13 freelancer ortalamada $110 teklif veriyor

kuldeepvk

Hi, I will check server and optimise server for fast and improved performance . Let's discuss. Thank you

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(331 Değerlendirme)
7.0
(257 Değerlendirme)
6.6
numerichost

Hi, I will implement all Server side optimization including MySQL (mariaDB 10.3) to increase Server performance. I have more than 10 Years of expertise as Server Admin. Let's discuss. Thanks !

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(111 Değerlendirme)
5.8
sarrvareddy

Hello!! I am a senior system administartor and server engineer and expert in mariaDB with over 10 years of experience. I can check the issue with mariaDB/PHP configuration and fix the issue. Please initiate the cha Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(46 Değerlendirme)
4.9
anirbandutta999

Hello..I am an experienced cloud server engineer ...I can help you fix the issue with database and optimize it to handle large amount of query at the same time .......Let me know in chat

$100 USD in 2 gün içinde
(26 Değerlendirme)
4.4
nickdevops

Hello my name is Nikos and Im working on the Linux server administration field for the past 6 years. Over these years I worked for two web hosting companies as a Senior Administrator managing their servers & providing Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(11 Değerlendirme)
3.8
AndreiAngelica

Hello, I am an expert in Backend Development and I can fulfill your project requirements. I can optimize the code from both mysql and php config files. There's need of this, because the mysql and php aren't created to Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(12 Değerlendirme)
3.6
natapataykina02

Hi, there! I've read all of your requirements carefully, and much concerned about it. As a programmer looking for a job, I think I can help you. When you reach me I'll be very happy. Please contact me over chat so Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(10 Değerlendirme)
4.1
aman619aggarwal

With Respect, I can optimize your MariDB as much as possible with available resources and traffic pattern. Profile: Expert Database admin having 10+ year of experience in Database Designing, Configuration, Querie Daha Fazla

$75 USD in 2 gün içinde
(9 Değerlendirme)
3.8
ArchnaAdmin

Hi, I will optimise complete server and will ake the server to load faster. I do have more than 8 years of expertise in web hosting, server setup, server configuration, etc Thank you.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(2 Değerlendirme)
2.0
edigeabdikarim

Hi I have read your job carefully. I am sure that I can definitely help you in this job. I'm a professional MySQL, MariaDB Developer and can deliver optimum services with all your requirements. I am an individual free Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(2 Değerlendirme)
1.2
chandrashekhar01

Hi, I have experience in Linux system admin and aws services. I can optimise mysql value for best performance. Pulease discuss to start. Thank you

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0