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.


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.

  • 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 '12 at 21:21
  • I believe wordpress sets the PHP timezone to UTC and saves all timestamps in UTC as well. – T0xicCode Aug 5 '12 at 12:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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