Find out with this query:
SELECT table_schema "DB", sum( data_length + index_length ) / 1024 / 1024 / 1024 "Size (GB)" FROM information_schema.TABLES GROUP BY table_schema;
Props to: Prakash Babu
Author Archive for Eric Marden
More than one person has asked me for my Nginx Virtual Host recipe for WordPress Multi-User and BuddyPress, so I’m posting it here. The attached virtual host definition is feature complete and works for me on a number of production sites.
Be sure to change domain.tld to your actual domain name. The wildcard record will allow your site to respond to ANY sudomain request, which may not be something you want.
You’ll also need to change the path to your log files, as well as the path to your public webroot folder. Finally, up the client_max_body_size to match your upload_max_filesize and post_max_size settings in php.ini.
Finally, this assumes you are running your PHP fast cgi process on port 9000.
This is the recipe for WordPress MU / BuddyPress. I’ve also posted one for WordPress (single site) and Drupal.
Download Nginx vhost Recipe for WordPress Mu and BuddyPress
Please post ways to improve this in the comments. I use this on a number of production sites, but there is always more one can do. Thanks to all of the blogs and articles that I ripped off helped me understand Nginx and got me started.
Since more than one person has asked me for my Nginx Virtual Host recipes, I figured I’d post it to my blog. The attached file should be good to go out of the box, but be sure to change domain.tld to your actual domain name. The wildcard record will allow your site to respond to ANY sudomain request, which may not be something you want.
You’ll also need to change the path to your log files, as well as the path to your public webroot folder. Finally, up the client_max_body_size to match your upload_max_filesize and post_max_size settings in php.ini.
Finally, this assumes you are running your PHP fast cgi process on port 9000.
This is the recipe for Drupal. I’ve also posted one for WordPress and WordPress MU / BuddyPress.
Download Nginx vhost for Drupal with imagecache support
Please post ways to improve this in the comments. I use this on a number of production sites, but there is always more one can do. Thanks to all of the blogs and articles that I ripped off helped me understand Nginx and got me started.
Since more than one person has asked me for my Nginx Virtual Host recipe for WordPress sites, I’m posting it here. Be sure to change domain.tld to your actual domain name. The wildcard record will allow your site to respond to ANY sudomain request, which may not be something you want.
You’ll also need to change the path to your log files, as well as the path to your public webroot folder. Finally, up the client_max_body_size to match your upload_max_filesize and post_max_size settings in php.ini.
Finally, this assumes you are running your PHP fast cgi process on port 9000.
This is the recipe for WordPress (single site). I’ve also posted one for Drupal and WordPress MU / BuddyPress.
Download Nginx vhost Recipe for WordPress
Please post ways to improve this in the comments. I use this on a number of production sites, but there is always more one can do. Thanks to all of the blogs and articles that I ripped off helped me understand Nginx and got me started.
The underlying architecture of the WordPress content storage and retrieval systems provide a flexible and powerful way of creating all manner of sites.
This talk is an overview of that capability and stern reminder that its not about the WordPress plugins you install, but the Information Architecture you implement that will make your site a success or not.
comments