Magento 1.9 Mysql High CPU load due to "core_session"

Ditutup Disiarkan 6 bulan lepas Dibayar semasa penghantaran
Ditutup Dibayar semasa penghantaran

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.



| 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) |

Magento Linux PHP MySQL Redis

ID Projek: #36689400

Tentang projek

16 cadangan Projek jarak jauh Aktif 5 bulan lepas

16 pekerja bebas membida secara purata $84 untuk pekerjaan ini


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. Lagi

$50 USD dalam sehari
(398 Ulasan)

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 o Lagi

$50 USD dalam 7 hari
(182 Ulasan)

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 dalam 4 hari
(21 Ulasan)

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 Lagi

$35 USD dalam sehari
(50 Ulasan)

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 dalam sehari
(14 Ulasan)

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_sessio Lagi

$80 USD dalam 2 hari
(18 Ulasan)

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 redu Lagi

$50 USD dalam 3 hari
(24 Ulasan)

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, Lagi

$50 USD dalam sehari
(13 Ulasan)

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 Lagi

$80 USD dalam 7 hari
(0 Ulasan)