kiccu的部落格

To run a great actions PHP/MySQL server, one has to keep a close-set eye on the restaurant attendant load. A big reading machinery to drastically cut masses is caching. A group that efficaciously employs caching exhibits much better enactment and less period. MySQL includes mechanisms for caching via MySQL's Query Cache. At the aforementioned time, this caching group does not promote implementation if any of the rows in a thumping table are altered, so near is no 'row level' caching in MySQL, lone 'table level' caching.

So how do we do business next to this issue? The solution lies in using one of the caching systems addressable to PHP. One that I have utilised to remarkable self-righteousness is Cache Lite, which, beneath PHP system control, caches accumulation to tight saucer for a length of time as such that by the system of rules.

So lets return a facial expression at Cache Lite and see how it is incorporate into the overall PHP book pattern. First, turn out for and download Cache Lite. Then recoup the files lower than 'Lite' alphabetical listing to a directory nether your webserver's bottom line (e.g. 'Cache/Lite'). After that, you can have in mind to the pattern database in the downloaded corroboration (the data file is named 'examples'), which provides a compatible example, and that message is not repeated here.

Here I will squeeze on cases of use. Take a story board, for first of its kind. Moderator numbers is unbroken in users table, and that array can get broad. Normally the arbitrator hearsay does not correct regularly. In this case, table-level caching reachable in MySQL does not give ceremonial improvements once any changes are made in the users array. Instead, a storage space can be set up near PHP to storage space all the inhibitor news for say 24 hours.

The preceding draw closer complex great, but near is a tradeoff. What if a umpire is other or dropped, or numerous some other info side by side to this inhibitor is varied. In this case, we have to add PHP secret message to take away/refresh the cache, or to produce the storage space timeout fair shortened (say 10 records).

Another barb to keep hold of in mind is near Linux reference book right control, we want to do a 'chmod 777' for the guide that keeps the storage space notes. This will modify PHP to read/write from/to that catalogue.

In summary, PHP can smoothly be powered to deliver ceremony in strict environments. PHP can as well get the better of for the in progress defect of MySQL which is deficit of row-level caching.