You are here

README.txt in DB Maintenance 5

Same filename and directory in other branches
  1. 5.2 README.txt
  2. 6.2 README.txt
  3. 6 README.txt
  4. 7.2 README.txt
  5. 7 README.txt
Database Maintenance Module

Author:
David Kent Norman
http://deekayen.net/

DESCRIPTION
-----------
Runs an OPTIMIZE TABLE query on selected tables for MySQL.
This should probably NOT be used to optimize every table in your
Drupal installation. http://drupal.org/node/91621 is an example
where the table locking during the OPTIMIZE procedure could
interfere with basic functionality of your site. Keep it down
to tables where there is lot of data movement like accesslog,
history, or watchdog. It's probably better to make a separate,
more infrequent cron as part of your regular server management
if you want to optimize your node tables.

DEPENDENCIES
------------
MySQL

INSTALLATION
------------
See INSTALL.txt in this directory.

MORE INFORMATION
----------------
This module is by no means intended to be only for MySQL forever.
If PostgreSQL has an OPTIMIZE TABLE equivalent, it should on the
TODO list for this module.

Other possible TODO list items include some sort of backup dump
saver/emailer/ftp/etc and an option to not execute on EVERY cron run

File

README.txt
View source
  1. Database Maintenance Module
  2. Author:
  3. David Kent Norman
  4. http://deekayen.net/
  5. DESCRIPTION
  6. -----------
  7. Runs an OPTIMIZE TABLE query on selected tables for MySQL.
  8. This should probably NOT be used to optimize every table in your
  9. Drupal installation. http://drupal.org/node/91621 is an example
  10. where the table locking during the OPTIMIZE procedure could
  11. interfere with basic functionality of your site. Keep it down
  12. to tables where there is lot of data movement like accesslog,
  13. history, or watchdog. It's probably better to make a separate,
  14. more infrequent cron as part of your regular server management
  15. if you want to optimize your node tables.
  16. DEPENDENCIES
  17. ------------
  18. MySQL
  19. INSTALLATION
  20. ------------
  21. See INSTALL.txt in this directory.
  22. MORE INFORMATION
  23. ----------------
  24. This module is by no means intended to be only for MySQL forever.
  25. If PostgreSQL has an OPTIMIZE TABLE equivalent, it should on the
  26. TODO list for this module.
  27. Other possible TODO list items include some sort of backup dump
  28. saver/emailer/ftp/etc and an option to not execute on EVERY cron run