Magento Performance slow even with one user only on EC2 instance and RDS -


i have magento website, on dedicated server. not happy ttfb (around 2.5s home page). have 3000 visitors per day, 15 000 pages /day. have 30 000 products, 1 store, 1 language, 1 currency.

i thought make try ec2/rds amazon, copied website on new ec2 instance (web server) + 1 rds mysql testing purpose. started small 1 (t2.small), same rds. setup nginx+php5-fpm, , imported magento (files + db)

i surprised, around 5s ttfb!! 1 user (myself!). accessing home page, never went somewhere else. have same poor ttfb when access cms page displays newsletter form (+ header , footer), no products @ displayed.

i migrated better rds (db.r3.large, 2cpu,15gb,110gb ssd), 5s. still lot.

i upgraded ec2 instance (c3.2xlarge, 8cpu 15gb) 3.5s, still more current dedicated server, 1 user only.

i know there options making magento code better, point more why ec2 instance 1 user connected performing less current prod server (which 8cpu 8gb only, half size, , has everything, db while ec2 config has 2 servers!)

my nginx vhosts have been configured same prod server (but nginx.conf might differ).

same redis. btw on ec2 noticed 0 difference or without redis (same ttfb), assume redis makes difference when there lot of users, , lot of files cached. (i'm sure redis working, because can see keys added, , var/cache folder remains empty once enabled) haven't tryed optimize mysql config, i'm assuming aws/rds has default enough.

out of monitoring can read (last 1 hour):

  • rds: readiops peak: 1.5 - writeiops peak @ 1.15 - cpu: max 0.80%
  • ec2 : cpu max: 1.5 %

everything sleeping or i'm wondering if miss important, maybe can't expect better ttfb because ec2 shared (and not reserved)? aws adds latency somewhere because of that?

edit 1:

i upgraded rds db.r3.2xlarge (8cpus, 64gb), it's 3.1s display home page (2.8s newsletter cms page). still more server...

edit 2:

i upgraded rds ssd provisionned iops instead of general purpose. it's 3.0s. no enhancement...

can confirm size of servers huge website (1 user accessing home page only!!) ?

edit 3:

now have 0.8s :-) amazing aoe_profile found bottleneck being cmsmart_megamenu. have more 100 categories , strange. 127 queries per category!! more 10 000 queries (with every page)! 127 queries /cat identical, 1 repeated 127 times:

select main_table.* admin_menutop main_table (category_id = '356')

actually, not change topic, more important help. not looking fixing issue (that topic). still wonder why ec2 performs less, keep module in place on ec2 server until understand why performs worse less-powerfull current prod server (both having db-cpu-consumming module).

can because on prod server have several visitors connected , mysql caching performs better? while on ec2 cache removed when active connections closed has hit db?

this type of hints i'm looking :-)

thansk

i'm having same issue wih admin_menutop table (i'm using cmsmart_megamenu too), newrelic told me hundreds of queries per categories too.

you said bottleneck, didn't mention fix :). can please share me?


Comments

Post a Comment

Popular posts from this blog

java - pagination of xlsx file to XSSFworkbook using apache POI -

right in code, reading xlsx file, xssfworkbook, , writing database. but, when size of xlsx file increases, causes outofmemory error. can not increase server size, or divide xlsx file pieces. tried loading workbook using file (instead of inputstream), didn't either. i looking way read 10k rows @ time (instead of entire file @ once) , iteratively write workbook , database. is there way apache poi? poi contains called "eventmodel" designed purpose. it's mentioned in faq : the ss eventmodel package api reading excel files without loading whole spreadsheet memory. require more knowledge on part of user, reduces memory consumption more tenfold. based on awt event model in combination sax. if need read-only access, best way it. however, may want double check first if issue somewhere else. check out this item : i think poi using memory! can do? 1 comes quite lot, reason isn't might think. so, first thing check - what's source of prob...
Read more

Unlimited choices in BASH case statement -

consider simple bash snippet: case $option in 1) image=${options[0]%.tar} ;; 2) image=${options[1]%.tar} ;; 3) image=${options[2]%.tar} ;; 4) image=${options[3]%.tar} ;; *) echo "invalid option" exit 1 esac in real script numbers goes 30. makes pretty long. can somehow specify cases variable? something this: case $option in $i) image=${options[$(($i-1))]%.tar} any pointer appreciated. you can match against multiple patterns in single clause: case $option in 1|2|3: echo "$option one, 2 or three" ;; esac if still typing you, can use simple pattern matching: case $option in # following matches # - single-digit numbers 0-9 # - two-digit numbers starting either 1 or 2 # - number 30 [0-9]|[12][0-9]|30) image=${options[$(($option-1))]%.tar} ;; *) echo "invalid option" 1>&2 exit 1 esac
Read more

apache - How do I stop my index.php being run twice for every user -

we've got webapp initial html served using apache , php. i noticed index.php being run twice every request. seems caused / effected rewrite rules in our .htaccess - rewritecond %{http_host} ^(www\.|hotels\.)ourdomain\.com$ [nc,or] rewritecond %{server_name} ^(www\.|hotels\.)ourdomain\.com$ [nc] rewriterule (.*) http://ourdomain.com/$1 [r=301] rewriterule ^hotels/([^/]+)/?\??(.*)$ ?d=$1&$2 [qsa] the final rule moving parameter url path query string. i.e. http://ourdomain.com/hotels/vegas?someparam=1 becomes http://ourdomain.com?d=vegas&someparam=1 if go directly query string version index.php run once. if use url redirected, index.php run twice (i'm checking adding error_log('end of index.php') file). so example going http://ourdomain.com/hotels/paris hits file twice http://ourdomain.com?d=paris hits once. i've seen this question , had @ blog mentioned , , can't find empty string url's (i've tried using yslow process). ...
Read more