This is my current my.cnf setttings. Could anyone take a quick peek and tell me if I set anything awfully wrong?
[mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock skip-locking key_buffer = 128M max_allowed_packet = 1M table_cache = 4196 open_files_limit = 10000 sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 4M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size= 64M query_cache_limit = 4M # Try number of CPU's*2 for thread_concurrency thread_concurrency = 8 max_heap_table_size = 128M tmp_table_size = 128M max_connections = 100 join_buffer_size = 16M [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] key_buffer = 64M sort_buffer_size = 64M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 64M sort_buffer_size = 64M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout On Wed, Apr 21, 2010 at 10:04 AM, Johan Gant <johan.g...@groupgti.com>wrote: > I guess this is a DB list, but I strongly disagree with Johan's suggestion > to avoid using Views or Taxonomy. The advantages far outweigh the > disadvantages in most cases. > > > -----Original Message----- > From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De > Meersman > Sent: 21 April 2010 15:44 > To: shamu...@gmail.com > Cc: mysql@lists.mysql.com > Subject: Re: More CPU or More RAM? > > Switch CMSes, you'll be better off. I have the pain of running Drupal, too. > > Your DB host is probably good enough, unless you're doing insane amounts of > page views. What you need is Drupal optimisations. Here's just a few: > > - drupal keeps both it's sessions and cache in the DB. Change to memcache > - the views module is horrible. Get rid of it and write your own queries > - for pete's sake don't turn on the watchdog module, especially on debug. > That, too goes in your db > - avoid taxonomy - it does evil hiearchical queries > > et cetera ad nauseam :-) > > > On Wed, Apr 21, 2010 at 4:31 PM, shamu...@gmail.com <shamu...@gmail.com > >wrote: > > > I have a 1.5G database which feeds a CMS web application (Drupal). > > > > Right now I am hosting it with a 1.5G RAM VPS and I feel it is too slow. > IO > > and CPU are high. So I am planning to upgrade it to a dedicated serer. > > > > Here are two choice of my server: > > > > 1. Intel Pentium G6950 (Dual Core), 2xSATA Drive (no RAID), 8G RAM > > 2. Intel Xeon X3210 (Quad Core), 2XSATA drive (no RAID), 4G RAM. > > > > I know the best way to do this is to benchmark the two servers, but I > can't > > do that, can only pick one. Could anyone of you tell me which one is > better > > for higher MySQL performance, based on your experience? > > > > Thanks. > > > > > > -- > Bier met grenadyn > Is als mosterd by den wyn > Sy die't drinkt, is eene kwezel > Hy die't drinkt, is ras een ezel > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=shamu...@gmail.com > >
