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
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 2 steps