Tell me more ×
WordPress Answers is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.
up vote 0 down vote favorite

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.

share|improve this question

1 Answer

up vote 0 down vote

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.

share|improve this answer
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'.) – Zack Jul 27 '12 at 21:21
I believe wordpress sets the PHP timezone to UTC and saves all timestamps in UTC as well. – xav0989 Aug 5 '12 at 12:30

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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