0

The only thing I have MySQL around for is Wordpress. Some MySQL features, I gather, require you to import the system timezone database into special tables in the mysql database. (Which seems like a silly way to do things, but never mind.) Does Wordpress make use of any of those features?

The MySQL global time zone is set to 'SYSTEM', and the server runs in UTC.

1 Answer 1

0

Wordpress only uses the tables it creates upon installation. Technically WP wouldn't have a problem with removing tables that are not in the created tables. However, messing with the tables in the mysql database is not necessarily the best for MySQL itself. Also, if you are trying to optimize MySQL by removing tables and databases, you might want to look at alternative data storage.

2
  • The MySQL documentation makes it sound like various time-related SQL functions use these tables implicitly, but perhaps only if you set the database timezone to something other than 'SYSTEM'. The question is really 'what are Wordpress's expectations of MySQL regarding time stamps'? Also, what alternative data storage options exist? (I would be delighted to get rid of MySQL, but my options on this particular hosting provider are MySQL and 'anything PHP can do using flat files and no cron jobs'.)
    – zwol
    Jul 27, 2012 at 21:21
  • I believe wordpress sets the PHP timezone to UTC and saves all timestamps in UTC as well.
    – T0xicCode
    Aug 5, 2012 at 12:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.