Gsyfuy

Does diversity provide anything that meritocracy does not?

Why do all the books in Game of Thrones library have their covers facing the back of the shelf?

Boss asked me to sign a resignation paper without a date on it along with my new contract

Plausible reason for gold-digging ant

Count repetitions of an array

What game did these black and yellow dice come from?

Why is the "Domain users" group missing from this PowerShell AD query?

Current across a wire with zero potential difference

Possible issue with my W4 and tax return

How can I play a serial killer in a party of good PCs?

What species should be used for storage of human minds?

Why did Luke use his left hand to shoot?

Why does magnet wire need to be insulated?

Cat is tipping over bed-side lamps during the night

Memory usage: #define vs. static const for uint8_t

I have trouble understanding this fallacy: "If A, then B. Therefore if not-B, then not-A."

How to politely refuse in-office gym instructor for steroids and protein

What is the difference between "...", '...', $'...', and $"..." quotes?

Are the positive and negative planes inner or outer planes in the Great Wheel cosmology model?

If angels and devils are the same species, why would their mortal offspring appear physically different?

A fantasy book with seven white haired women on the cover

Why is a temp table a more efficient solution to the Halloween Problem than an eager spool?

Does the ditching switch allow an A320 to float indefinitely?

Equivalent of "illegal" for violating civil law

Redis does not improving performance

Problems flushing Magento Redis Cache on an installation with a separate backend serverMagento, Full Page Cache , Memcache and RedisPoor Magento Performance with AWS EC2Magento 1.8.1 can't connec to Redis server 2.8.19-1Magento Enterprise - Ongoing Redis Connection ErrorsWhy Can't Magento Turn Off The Cache When Redis FailsMagento site is frequently getting CACHE issue and failing to serve CSS, site is getting broken pagePermission issues with Magento MySql hosted on RDS on AWS“Redis 'server' not specified.” in Cm_Cache_Backend_Redis codeRedis sessions and Redis cache failure

2

I'm trying to find the best setup for one really slow site.
For education purpose.

I set with AWS CloudFront like full page cache, not only static files.
Also Varnish and Redis, and performance are good now.

But I'm trying again to install one by and measure one by one and calculate what part giving more.

And I concluded that Redis does not improving at all. I tried with different pages, and nothing better. I also modified AWS Redis instance type to much stronger, and the same like the smallest one.
I checked and keys are stored in database 0 and 1.

Also metrics show that hits are OK

But when I try to test with jmeter, and hit 10 different links with 5 users, MySQL CPU load are go up to 100%.
I understand that main purpose of Redis is to serve cached query results to webserver, instead for every request to contact database server.

This is htop from mysql

Magento is 1.9.3.8
app/etc/modules/Cm_RedisSession.xml is set to true
And this is local.xml file regarding redis:

     <cache>

      <backend>Mage_Cache_Backend_Redis</backend>

      <backend_options>

        <server>xxxx.tapkyx.0001.euc1.cache.amazonaws.com</server>              

        <port>6379</port>

        <persistent>cache-db0</persistent>

        <database>0</database>

        <password></password>

        <force_standalone>0</force_standalone>

        <connect_retries>1</connect_retries>

        <read_timeout>10</read_timeout>

        <automatic_cleaning_factor>0</automatic_cleaning_factor>

        <compress_data>1</compress_data>

        <compress_tags>1</compress_tags>

        <compress_threshold>20480</compress_threshold>

        <compression_lib>gzip</compression_lib>

      </backend_options>

    </cache>



 <session_save>db</session_save>

    <redis_session>

        <host>xxxx.tapkyx.0001.euc1.cache.amazonaws.com</host>            

        <port>6379</port>

        <password></password>

        <timeout>2.5</timeout>

        <persistent>cache-db1</persistent>

        <db>1</db>

        <compression_threshold>2048</compression_threshold>

        <compression_lib>gzip</compression_lib>

        <log_level>4</log_level>

        <max_concurrency>6</max_concurrency>

        <break_after_frontend>5</break_after_frontend>

        <break_after_adminhtml>30</break_after_adminhtml>

        <bot_lifetime>7200</bot_lifetime>

    </redis_session>

So questions are, what kind of improvements I can expect with using redis? And why is MySQL CPU overloaded even I call with Jmeter the same 10 pages?
Or what I forgot to do :).

magento-1.9 database redis aws jmeter

share|improve this question

edited 6 hours ago

Muhammad Hasham

1,8411424

asked 13 hours ago

CoyoteKGCoyoteKG

161

add a comment | 

2

I'm trying to find the best setup for one really slow site.
For education purpose.

I set with AWS CloudFront like full page cache, not only static files.
Also Varnish and Redis, and performance are good now.

But I'm trying again to install one by and measure one by one and calculate what part giving more.

And I concluded that Redis does not improving at all. I tried with different pages, and nothing better. I also modified AWS Redis instance type to much stronger, and the same like the smallest one.
I checked and keys are stored in database 0 and 1.

Also metrics show that hits are OK

But when I try to test with jmeter, and hit 10 different links with 5 users, MySQL CPU load are go up to 100%.
I understand that main purpose of Redis is to serve cached query results to webserver, instead for every request to contact database server.

This is htop from mysql

Magento is 1.9.3.8
app/etc/modules/Cm_RedisSession.xml is set to true
And this is local.xml file regarding redis:

     <cache>

      <backend>Mage_Cache_Backend_Redis</backend>

      <backend_options>

        <server>xxxx.tapkyx.0001.euc1.cache.amazonaws.com</server>              

        <port>6379</port>

        <persistent>cache-db0</persistent>

        <database>0</database>

        <password></password>

        <force_standalone>0</force_standalone>

        <connect_retries>1</connect_retries>

        <read_timeout>10</read_timeout>

        <automatic_cleaning_factor>0</automatic_cleaning_factor>

        <compress_data>1</compress_data>

        <compress_tags>1</compress_tags>

        <compress_threshold>20480</compress_threshold>

        <compression_lib>gzip</compression_lib>

      </backend_options>

    </cache>



 <session_save>db</session_save>

    <redis_session>

        <host>xxxx.tapkyx.0001.euc1.cache.amazonaws.com</host>            

        <port>6379</port>

        <password></password>

        <timeout>2.5</timeout>

        <persistent>cache-db1</persistent>

        <db>1</db>

        <compression_threshold>2048</compression_threshold>

        <compression_lib>gzip</compression_lib>

        <log_level>4</log_level>

        <max_concurrency>6</max_concurrency>

        <break_after_frontend>5</break_after_frontend>

        <break_after_adminhtml>30</break_after_adminhtml>

        <bot_lifetime>7200</bot_lifetime>

    </redis_session>

So questions are, what kind of improvements I can expect with using redis? And why is MySQL CPU overloaded even I call with Jmeter the same 10 pages?
Or what I forgot to do :).

magento-1.9 database redis aws jmeter

share|improve this question

edited 6 hours ago

Muhammad Hasham

1,8411424

asked 13 hours ago

CoyoteKGCoyoteKG

161

add a comment | 

I'm trying to find the best setup for one really slow site.
For education purpose.

I set with AWS CloudFront like full page cache, not only static files.
Also Varnish and Redis, and performance are good now.

But I'm trying again to install one by and measure one by one and calculate what part giving more.

And I concluded that Redis does not improving at all. I tried with different pages, and nothing better. I also modified AWS Redis instance type to much stronger, and the same like the smallest one.
I checked and keys are stored in database 0 and 1.

Also metrics show that hits are OK

But when I try to test with jmeter, and hit 10 different links with 5 users, MySQL CPU load are go up to 100%.
I understand that main purpose of Redis is to serve cached query results to webserver, instead for every request to contact database server.

This is htop from mysql

Magento is 1.9.3.8
app/etc/modules/Cm_RedisSession.xml is set to true
And this is local.xml file regarding redis:

     <cache>

      <backend>Mage_Cache_Backend_Redis</backend>

      <backend_options>

        <server>xxxx.tapkyx.0001.euc1.cache.amazonaws.com</server>              

        <port>6379</port>

        <persistent>cache-db0</persistent>

        <database>0</database>

        <password></password>

        <force_standalone>0</force_standalone>

        <connect_retries>1</connect_retries>

        <read_timeout>10</read_timeout>

        <automatic_cleaning_factor>0</automatic_cleaning_factor>

        <compress_data>1</compress_data>

        <compress_tags>1</compress_tags>

        <compress_threshold>20480</compress_threshold>

        <compression_lib>gzip</compression_lib>

      </backend_options>

    </cache>



 <session_save>db</session_save>

    <redis_session>

        <host>xxxx.tapkyx.0001.euc1.cache.amazonaws.com</host>            

        <port>6379</port>

        <password></password>

        <timeout>2.5</timeout>

        <persistent>cache-db1</persistent>

        <db>1</db>

        <compression_threshold>2048</compression_threshold>

        <compression_lib>gzip</compression_lib>

        <log_level>4</log_level>

        <max_concurrency>6</max_concurrency>

        <break_after_frontend>5</break_after_frontend>

        <break_after_adminhtml>30</break_after_adminhtml>

        <bot_lifetime>7200</bot_lifetime>

    </redis_session>

So questions are, what kind of improvements I can expect with using redis? And why is MySQL CPU overloaded even I call with Jmeter the same 10 pages?
Or what I forgot to do :).

magento-1.9 database redis aws jmeter

share|improve this question

edited 6 hours ago

Muhammad Hasham

1,8411424

asked 13 hours ago

CoyoteKGCoyoteKG

161

     <cache>

      <backend>Mage_Cache_Backend_Redis</backend>

      <backend_options>

        <server>xxxx.tapkyx.0001.euc1.cache.amazonaws.com</server>              

        <port>6379</port>

        <persistent>cache-db0</persistent>

        <database>0</database>

        <password></password>

        <force_standalone>0</force_standalone>

        <connect_retries>1</connect_retries>

        <read_timeout>10</read_timeout>

        <automatic_cleaning_factor>0</automatic_cleaning_factor>

        <compress_data>1</compress_data>

        <compress_tags>1</compress_tags>

        <compress_threshold>20480</compress_threshold>

        <compression_lib>gzip</compression_lib>

      </backend_options>

    </cache>



 <session_save>db</session_save>

    <redis_session>

        <host>xxxx.tapkyx.0001.euc1.cache.amazonaws.com</host>            

        <port>6379</port>

        <password></password>

        <timeout>2.5</timeout>

        <persistent>cache-db1</persistent>

        <db>1</db>

        <compression_threshold>2048</compression_threshold>

        <compression_lib>gzip</compression_lib>

        <log_level>4</log_level>

        <max_concurrency>6</max_concurrency>

        <break_after_frontend>5</break_after_frontend>

        <break_after_adminhtml>30</break_after_adminhtml>

        <bot_lifetime>7200</bot_lifetime>

    </redis_session>

share|improve this question

edited 6 hours ago

Muhammad Hasham

1,8411424

asked 13 hours ago

CoyoteKGCoyoteKG

161

share|improve this question

edited 6 hours ago

Muhammad Hasham

1,8411424

asked 13 hours ago

CoyoteKGCoyoteKG

161

edited 6 hours ago

Muhammad Hasham

1,8411424

edited 6 hours ago

Muhammad Hasham

1,8411424

asked 13 hours ago

CoyoteKGCoyoteKG

161

asked 13 hours ago

CoyoteKGCoyoteKG

161