Find Jobs
Hire Freelancers

Magento 1.9 Mysql High CPU load due to "core_session"

$20-50 USD

Imefungwa
Imechapishwa 10 months ago

$20-50 USD

Kulipwa wakati wa kufikishwa
Magento 1.9 running on Nginx, php-fpm, PHP7, FPC, Mysql, Memcache stack Problem: High server load due to Mysql and `core_session` table size increasing rapidly. After increasing Cookie Lifetime to 31536000 i suspect `core_session` table size increased drastically and hence /usr/sbin/mysqld is taking high CPU usage above 100% Someone with similar project experience will be preferred. mysql> SHOW PROCESSLIST; +------+--------------+-----------+---------------------+---------+------+----------+-----------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+--------------+-----------+---------------------+---------+------+----------+-----------------------------------------------------------------+ | 66 | root | localhost | NULL | Sleep | 3687 | | NULL | | 1823 | root | localhost | NULL | Sleep | 2894 | | NULL | | 2915 | root | localhost | NULL | Sleep | 2248 | | NULL | | 5220 | root | localhost | NULL | Query | 0 | init | SHOW PROCESSLIST | | 5884 | mysql_user | localhost | database123 | Query | 0 | updating | DELETE FROM `core_session` WHERE (session_expires < 1685618960) |
Kitambulisho cha mradi: 36689400

Kuhusu mradi

16 mapendekezo
Mradi wa mbali
Inatumika 9 mos ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
16 wafanyakazi huru wana zabuni kwa wastani $84 USD kwa kazi hii
Picha ya Mtumiaji
Hi sir, I can manage share task in job summery with quality features and functions. I am expert self-motivated and hardworking Magento developer and we can ensure complete customer satisfaction and 100% quality work. Let’s chat Thanks
$50 USD ndani ya siku 1
4.9 (398 hakiki)
7.8
7.8
Picha ya Mtumiaji
Greetings, I am a Magento expert with 8 years of experience in the development and design industry and a deep knowledge of industry standards and working culture, so I can be a great fit for this job. Here are some of my skills: Store development and customization from scratch Redesigning or rebuilding the website Bug fixing Marketplace store development: customize Multi-vendor functionality: customize B2B and B2C store development Theme Customizer Plugin customization or creation Marketplace module development Speed optimization work Initiate a small chat so we can discuss this!
$50 USD ndani ya siku 7
4.7 (182 hakiki)
6.9
6.9
Picha ya Mtumiaji
Hello, I understood the project but have few doubts, please text me so i can clear all my questions right away and to confirm my skills and expertise you can have a look to my profile
$100 USD ndani ya siku 4
4.9 (21 hakiki)
5.8
5.8
Picha ya Mtumiaji
Hi, I have 10 years of experience in Linux and Windows ( Shared , Dedicated and VPSs ) with control panels (cPanel, Plesk, Directadmin, CWP and vestacp)and cloud like AWS azure and Gcloud platforms. I can help you to check and fix your load issue with minimal time. Please ping me for further discussion
$35 USD ndani ya siku 1
5.0 (50 hakiki)
5.0
5.0
Picha ya Mtumiaji
Hi, I am a certified magento developer with many years experience, I can finish this task exactly as you descripted ASAP, please let me know if you have any questions, thanks!
$20 USD ndani ya siku 1
4.9 (14 hakiki)
5.1
5.1
Picha ya Mtumiaji
Hi there! My name is Manish and I'm a Linux expert with extensive experience in web hosting services, cloud servers and dedicated servers. I noticed you're experiencing high CPU load due to the size of the `core_session` table increasing rapidly. After increasing Cookie Lifetime to 31536000 i suspect `core_session` table size increased drastically and hence /usr/sbin/mysqld is taking high CPU usage above 100%. I understand your need for speed when it comes to this project. As such, I would be more than happy to assist you with optimizing your Magento 1.9 installation. My services include web hosting services such as WHM/Cpanel, Website Panel, Plesk Panel which allow you to manage all types of servers including dedicated, VPS, shared server, server security, monitoring server setup and management as well as backup management.
$80 USD ndani ya siku 2
5.0 (18 hakiki)
4.2
4.2
Picha ya Mtumiaji
Hello there! My name is M Raheel and I am a seasoned freelancer with over 10 years of experience in the tech industry. I specialize in providing high-quality digital services and I am confident that I can help you reduce the load on your Magento 1.9 server due to core_session table size increasing rapidly. My team and I have the expertise required to analyze your project thoroughly and produce stunning results within the desired deadline. With our adherence to strict deadlines yet high quality delivery, we ensure that you get exactly what you wanted without compromising on quality. Additionally, our analyzation of the project includes an understanding of all aspects such as design concepts, innovation and creativity, as well as highest conversions. We would be delighted to discuss this project further if given the opportunity. Please feel free to contact us if you have any questions or would like to discuss how we can make this project successful together!
$50 USD ndani ya siku 3
4.8 (24 hakiki)
4.2
4.2
Picha ya Mtumiaji
Hi there, I have read your requirement I can help you with this project. I have 8+ years of experience of System admin, Magento 1 & 2, Word Press, AWS, Apache, Ubuntu, Centos, My SQL, Maria db, PHP, Nginx, Debian, WHM, C-panel, Plesk, Postfix, Exim , Mails, Firewall, Google cloud servers, Cloud Servers. Let’s start quick discussion Thank you!
$50 USD ndani ya siku 1
4.8 (13 hakiki)
3.5
3.5
Picha ya Mtumiaji
Hi there! . I understand your project description and problem with high CPU load due to "core_session" table size increasing rapidly. After increasing Cookie Lifetime to 31536000 i suspect `core_session` table size increased drastically causing /usr/sbin/mysqld to take high CPU usage above 100% I would be delighted to help you with this project. With my experience in Magento 1.9 and related technologies such as Nginx, php-fpm, PHP7, FPC, MySql & Memcache i am confident that I can deliver a successful solution within the required timeframe. I look forward to hearing from you soon so we can get started on this amazing opportunity!
$80 USD ndani ya siku 7
0.0 (0 hakiki)
0.0
0.0

Kuhusu mteja

Bedera ya INDIA
Indore, India
5.0
11
Njia ya malipo imethibitishwa
Mwanachama tangu Mac 16, 2012

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.