Innodb Performance Optimization Basics | MySQL Performance Blog. November 1, 2007 by Peter Zaitsev77 Comments Note: There is an updated post on this topic here. Interviewing people for our Job Openings I like to ask them a basic question – if you have a server with 16GB of RAM which will be dedicated for MySQL with large Innodb database using typical Web workload what settings you would adjust and interestingly enough most people fail to come up with anything reasonable. So I decided to publish the answer I would like to hear extending it with basics of Hardware OS And Application optimization. I call this Innodb Performance Optimization Basics so these are general guidelines which work well for wide range of applications, though the optimal settings of course depend on the workload.
Hardware If you have large Innodb database size Memory is paramount. 16G-32G is the cost efficient value these days. From CPU standpoint 2*Dual Core CPUs seems to do very well, while with even just two Quad Core CPUs scalability issues can be observed on many workloads. Converting your Drupal MySQL databas from MyISAM to InnoDB | xde. In Drupal 7 InnoDB will replace MyISAM as the default storage engine for increased scalability and data integrity. Most big sites are already using InnoDB, drupal.org does since some time. InnoDB is generally a better choice for Drupal so why wait for Drupal 7. Lets go ahead and convert our Drupal 6 tables to InnoDB. As always, make sure you have backups of everything before you do this on a production site!
Convert a database to InnoDB Here follows some commands to run on the command line that will make the conversion a breeze. The first command I found on “Ryan’s Tech Notes”, se below. The second command is a Perl one liner to set the search_* tables back to MyISAM. Update 2010-01-03: According to Steve Rude at divx.com the menu_router table should also be MyISAM for best performance.
The last command executes the sql commands that converts the tables to InnoDB. If you are using Drush, and you really should, you can use these commands instead. InnoDB parameters #skip-innodb. MySQL my.cnf configuration for a large Drupal site | 2bits.com, For a large web site with hundreds of thousands of page views per day, it is important to increase certain parameters, such as the query cache, join buffers, key buffer, ..etc.
The following my.cnf file is from an Ubuntu server (Debian derived) with dual CPUs, and 2 GB of RAM. It assumes that you are using MyISAM tables only and not InnoDB. Depending on what modules you have, you may need to adjust some of those parameters, but this is definitely a good start. [client]port = 3306socket = /var/run/mysqld/mysqld.sock [mysqld_safe]socket = /var/run/mysqld/mysqld.socknice = 0 [mysqldump]quickquote-namesmax_allowed_packet = 16M [mysql]#no-auto-rehash # faster start of mysql but no tab completition [isamchk]key_buffer = 16M. Setting up PHP, MySQL, and Apache in Mac OSX Leopard · Reverb is. + New .COMs $7.49/yr plus 18 cents/yr ICANN fee.
Discount based on new one-year registration prices as of 4/8/2011 with sale price reflected in your shopping cart at checkout. Discount applies to new registrations and renewals and cannot be used in conjunction with any other offer or promotion. Domains purchased through this offer will renew at regular price after the initial term has expired. Offer ends May 31, 2012 5:00 pm (MST). † Good for one 1-year registration of any available .COM, .US, .BIZ, .INFO, .NET or .ORG GoDaddy.com is the world's No. 1 ICANN-accredited domain name registrar for .COM, .NET, .ORG, .INFO, .BIZ and .US domain extensions.
Source: RegistrarSTATS.com 1 GoDaddy.com is rated the world's largest hostname provider according to Netcraft®. Installing Drupal on Mac OS X 10.5 Leopard | SysArchitects. I thought I'd write up the steps I took to get Drupal running on a stock Leopard installation. You may wish to save some time and install MAMP instead. Especially if you need GD support (i.e., you're going to have Drupal do image resizing). Update 17-Dec-2007: In fact, I recommend using MAMP instead. Step 1: Enable PHP Uncomment line 114 in /etc/apache2/httpd.conf to enable Leopard's built-in PHP: LoadModule php5_module libexec/apache2/libphp5.so Start Apache 2 by using the Sharing panel in Preferences or at the command line with the following: sudo apachectl start (If Apache was already running, use restart instead of start.)
Place a test document into the default htdocs root to see if php is running. Now going to shows me the info page for PHP 5.2.4. Step 2: Friendly Virtual Hosts in Apache I don't like keeping my websites in /Library/WebServer/Documents. I'd much rather use a nice short URL like to <? Rejoicing. Tuning MySQL for Drupal. Drupal Performance Tuning and Optimization for large web sites |