Lukket

LAMP server optimization (caching, OPCache, MySQL DB) for Wordpress / Buddypress network

LAMP server optimization (caching, OPCache, MySQL DB) for Wordpress / Buddypress network

At peak times there are up to 150 members online at the same time. We want to get to several hundreds.

This platform is based on Wordpress and a Buddyboss / Buddypress plugins. The site is internationalized using WPML and offers the possibility of paid memberships using PMPro and various complementary addons.

GOAL of the assignment is to analyze possible optimization potentials. First and foremost the use of the server possibilities, i.e. analysis of possible bottleneck(s) and tweaking of the corresponding available server parameters for [login to view URL], MySQL server, Apache etc., so that an optimal use of the possibly still free resources can be achieved. E.g. a huge amount of RAM is still free -> mysql query caching possible?

Since the site is highly dynamic (activity feed, comments, groups and forums, messaging between members), complete caching is difficult to implement.

We have already exhausted some possibilities for optimization:

* Caching of some repetitive and "expensive" (i.e. slow) queries using static variables and using Wordpress transients.

* Caching of various HTML widgets that don't need to update themselves all the time

* Deletion of outdated transients, purging and cleaning of old DB entries and logs

* Rewriting of plugins to avoid SQL queries within for loops, for example

* Memcached and OPCache PHP Extensions were installed

* Update to PHP 8 because of JIT still in consideration

* Wordpress Plugin: Query Monitor -> analysis of results

The site is still quite slow, but only during peak times and only "in waves".

It is currently unknown what the bottleneck is, is it PHP or MySQL. In Linux "htop" both are alternating top loaders.

We have ~50GB of RAM, of which only 5GB is in use. Unfortunately the server does NOT have Plesk or the like, only a proprietary interface with the following options:

PHP FPM / CLI:

* implicit_flush

* max_execution_time

* memory_limit

* output_buffering

* output_buffering_value

* realpath_cache_size

* realpath_cache_ttl

* session_gc_maxlifetime

MySQL:

* default_charset

* ft_min_word_len

* innodb_buffer_pool_size

* innodb_ft_min_token_size

* innodb_flush_log_at_trx_commit

* innodb_lock_wait_timeout

* innodb_log_file_size

* max_allowed_packet

* max_connections

* max_heap_table_size

* max_user_connections

* query_cache_enabled

* query_cache_size

PHP OPCache:

* max_accelerated_files

* memory_consumption

* interned_strings_buffer

* validate_timestamps

* revalidate_freq

* enable_cli

* save_comments

* revalidate_path

* validate_root

* consistency_checks

If the analysis results are code optimizations, these may need to be implemented in consultation and depending on the effort involved. At first, analysis + implementation for the parameters of the LAMP settings.

Evner: PHP, MySQL, Apache, Linux, BuddyPress

Se mere: lamp application blackberry php mysql, add mysql db php, buy mysql db zen cart, colleges mysql db, convert mysql db, convert windows1256 encoding utf8 mysql db, country state city javascript mysql db, csv mysql db perl, edit mysql db iphone app, estimate time create small mysql db, flex mysql db, getafreelancer mysql db asp, import csv mysql db script perl php, import mysql db ssh linux, import mysql db wp post, jsp login page linking mysql db, mysql db create documentation, mysql db encoding, mysql db gb good settings fro my cnf, xml sitemap generator für wordpress

Om arbejdsgiveren:
( 0 bedømmelser ) Ludwigsburg, Germany

Projekt ID: #32250427

17 freelancere byder i gennemsnit €37/timen for dette job

(499 bedømmelser)
8.7
tangramua

Sehr geehrter Thomas1147,   Wir haben 20 Jahre Erfahrung in PHP, Linux, Apache, MySQL, BuddyPress, daher können wir dieses Projekt erfolgreich abschließen. Bitte überprüfen Sie unser Profil hier: [login to view URL] Flere

€42 EUR / time
(213 bedømmelser)
8.3
(558 bedømmelser)
7.5
(97 bedømmelser)
6.6
manojmalviya93

Hi As per your requirement, I have expertise in Server Optimization and Linux Server Administration. I can help you with that. I have 10 years of experience in and Webhosting administration also have clear concepts of Flere

€40 EUR / time
(85 bedømmelser)
6.1
linuxwarm

Hi, I have 19 years of experience on server management. I have been managing Linux and Windows sever and providing 24x7 support. I will resolve all of your current problems and provide you these services as an ongoing Flere

€36 EUR / time
(82 bedømmelser)
6.2
(52 bedømmelser)
5.8
jonasrohw9

Guten Tag, Ich bin zertifizierter Linux Administrator und würde Sie gerne bezüglich ihre Implementierung beraten und daraus resultierende, die Einrichtung für Sie vornehmen. Wenn Sie über Details sprechen wollen, könn Flere

€36 EUR / time
(54 bedømmelser)
5.7
abhisaini0188

Hey! I am expert Full stack developer with skills including Laravel, Vue, React, CSS, MySQL, Forum Software and PHP etc. Thanks for positing "LAMP server optimization (caching, OPCache, MySQL DB) for Wordpress / Buddyp Flere

€36 EUR / time
(8 bedømmelser)
5.3
valeriaomeldev

Hello Thomas, I have + 10 years of experience in web development, YES, I am very familiar with WP and Buddypress. Until now I have completed lots of projects successfully. And I have hands on experience about LAMP serv Flere

€40 EUR / time
(2 bedømmelser)
4.7
(3 bedømmelser)
4.7
wordpressexpert

Hi, I will finish these work and optimize your buddypress site, I am buddypress expert developer, my plugin/themes listed on wordpress official site [login to view URL] since 2008: buddypress plugin example: https:/ Flere

€36 EUR / time
(5 bedømmelser)
4.1
dPenXetri1

Hi there, hope you are well. It's Dipendra. I am interested in this project because I have been working on several complex PHP projects for seven long years. Most recently, I have done a project for a client which is a Flere

€36 EUR / time
(5 bedømmelser)
3.5
vctorfranciscos

Good evening. I can help you with her problem. I am an expert server administrator and have already worked on high performance sites.

€36 EUR / time
(4 bedømmelser)
2.6
danilastariy

Hi !, I’ve carefully checked your requirements and really interested in this job. I’m full stack web developer . I’m offering best quality and highest performance at lowest price. I can complete your project on time Flere

€36 EUR / time
(2 bedømmelser)
1.9
rmhernandez

Hi Sir! I'm going to speak from my experience. I have done plenty. Buddyboss is a social community website, so any form of caching may not always be the best option. I suggest you use CDN as well as ensure your server Flere

€40 EUR / time
(1 bedømmelse)
0.8
TexasCows

Hello, Thanks for checking out us, We are Techjuke providing Development and Branding solutions domestically and Internationally through out this platform and many others. We are also expert in Apache, PHP, BuddyPres Flere

€36 EUR / time
(1 bedømmelse)
1.8