Given the following web modelling problems faced by WordPress developer: I have a WordPress site with far over 30,000 posts monthly. Unfortunately,the method of adding and editing posts in MyISAM storage engine is becoming slower for the accumulated a lot of posts. Pages loading quickly for client side, however, when writes or updates are made, the net server consumes up to 100% CPU and takes longer time to finish the tasks(often longer than PHP's 60-second timeout). Analyze the problems faced by the developer to identify an appropriate web storage engine that can support the following requirements: i) faster posts editing ii) less web server processor consumption iii) ACID transaction
Given the following web modelling problems faced by WordPress developer:
I have a WordPress site with far over 30,000 posts monthly. Unfortunately,the method of adding and editing posts in MyISAM storage engine is becoming slower for the accumulated a lot of posts. Pages loading quickly for client side, however, when writes or updates are made, the net server consumes up to 100% CPU and takes longer time to finish the tasks(often longer than PHP's 60-second timeout).
Analyze the problems faced by the developer to identify an appropriate web storage engine that can support the following requirements:
i) faster posts editing
ii) less web server processor consumption
iii) ACID transaction
Elaborate at least 3 reasons to support your answer.
Step by step
Solved in 3 steps