Database Reference
In-Depth Information
To do this automatically, set up a scheduled event that runs the
DELETE
statement peri‐
odically (see
Recipe 9.8
).
With respect to disk space consumed by web logging activity, be aware that if you have
query logging enabled for the MySQL server, each request will be written to the
httpdlog
table and also to the query log. Thus, you may find disk space disappearing more quickly
than you expect, so it's a good idea to have some kind of logfile rotation or expiration
set up. For some ideas, see
Recipe 22.4
.