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.Gant@stripped>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: vegivamp@stripped [mailto:vegivamp@stripped] On Behalf Of Johan De
> Meersman
> Sent: 21 April 2010 15:44
> To: shamubro@stripped
> Cc: mysql@stripped
> 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, shamubro@stripped <shamubro@stripped
> >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=1
>
>
