Mysql – get size of all databases
Mysql contains size of all tables in information_schema.TABLES table. The following query can be used to get size of all databases on a mysql server: read more
Mysql – display row count and size of tables
Mysql SHOW TABLE STATUS command can be used to display information about all or specified tables in mysql db. Here are some examples: Show status read more
Mysql find current timezone offset
Print current local and global timezone SELECT @@global.time_zone, @@session.time_zone; Here is the outcome @@global.time_zone @@session.time_zone +05:30 +05:30 Find timezone offset using convert_tz select TIMEDIFF(now(), convert_tz(now(), read more
Query to find recently modified posts in WordPress
It can be sometime handy to query recently modified (last month or last few days) posts in wordpress mysql tables. Here are some handy queries: read more
How to delete orphan wordpress wp_postmeta rows
WordPress keeps the post meta values in wp_postmeta table. When a post is deleted, its meta data may become orphan. It is harmless data but read more