Magento 1.9 Mysql High CPU load due to "core_session"
$20-50 USD
S-au achitat serviciile după ce au fost prestate
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) |
ID Proiect: #36689400
Detalii despre proiect
16 freelanceri licitează în medie 84$ pentru acest proiect
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. Mai multe
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 Mai multe
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
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 Mai multe
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!
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 Mai multe
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 Mai multe
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, Mai multe
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 Mai multe
