Re: Mysql cache issues???

2013-07-15 Thread shawn green
Hello Egoitz, On 7/15/2013 1:35 PM, Egoitz Aurrekoetxea wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 15/07/13 17:27, Reindl Harald wrote: ... snip... i would say my caches are working perfectly (not only the mysql cache, also opcache etc.) since whe have generate times down to 0.00

Re: Mysql cache issues???

2013-07-15 Thread Reindl Harald
Am 15.07.2013 19:35, schrieb Egoitz Aurrekoetxea: > On 15/07/13 17:27, Reindl Harald wrote: >>> I'm not trying to pick on you, Reindl. Your cache may be doing >>> splendidly well. I just didn't want anyone else to see your >>> efficiency rating and derive the wrong formula on their own >> >> i woul

Re: Mysql cache issues???

2013-07-15 Thread Egoitz Aurrekoetxea
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 15/07/13 17:27, Reindl Harald wrote: > > > Am 15.07.2013 16:46, schrieb shawn green: >> Hello Reindl, >> >> On 7/15/2013 10:28 AM, Reindl Harald wrote: >>> Am 15.07.2013 16:00, schrieb Hartmut Holzgraefe: On 15.07.2013 15:31, Egoitz Aurrekoe

Re: Mysql cache issues???

2013-07-15 Thread Reindl Harald
Am 15.07.2013 16:46, schrieb shawn green: > Hello Reindl, > > On 7/15/2013 10:28 AM, Reindl Harald wrote: >> Am 15.07.2013 16:00, schrieb Hartmut Holzgraefe: >>> On 15.07.2013 15:31, Egoitz Aurrekoetxea wrote: Could Mysql cache cause a performance penalty, when invalidating queries of

Re: Mysql cache issues???

2013-07-15 Thread shawn green
Hello Reindl, On 7/15/2013 10:28 AM, Reindl Harald wrote: Am 15.07.2013 16:00, schrieb Hartmut Holzgraefe: On 15.07.2013 15:31, Egoitz Aurrekoetxea wrote: Could Mysql cache cause a performance penalty, when invalidating queries of a big Mysql cache zone? can, and *will* ... see also http:/

Re: Mysql cache issues???

2013-07-15 Thread Reindl Harald
Am 15.07.2013 16:00, schrieb Hartmut Holzgraefe: > On 15.07.2013 15:31, Egoitz Aurrekoetxea wrote: >> Could Mysql cache cause a performance penalty, when invalidating >> queries of a big Mysql cache zone? > > can, and *will* ... see also http://dom.as/tech/query-cache-tuner/ Optimal size for yo

Re: Mysql cache issues???

2013-07-15 Thread Johan De Meersman
- Original Message - > From: "Hartmut Holzgraefe" > Subject: Re: Mysql cache issues??? > > can, and *will* ... see also http://dom.as/tech/query-cache-tuner/ Absolutes are never right. The query cache is a very useful tool, even though it's implementation leaves something to be desired

Re: Mysql cache issues???

2013-07-15 Thread Egoitz Aurrekoetxea
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 15/07/13 15:53, Johan De Meersman wrote: > - Original Message - >> From: "Egoitz Aurrekoetxea" >> >> Could Mysql cache cause a performance penalty, when invalidating >> queries of a big Mysql cache zone?. > > Yep, spot on. I tend to keep

Re: Mysql cache issues???

2013-07-15 Thread Hartmut Holzgraefe
On 15.07.2013 15:31, Egoitz Aurrekoetxea wrote: > Could Mysql cache cause a performance penalty, when invalidating > queries of a big Mysql cache zone? can, and *will* ... see also http://dom.as/tech/query-cache-tuner/ cache is locked while entries are being purged to prevent handing out cached r

Re: Mysql cache issues???

2013-07-15 Thread Johan De Meersman
- Original Message - > From: "Egoitz Aurrekoetxea" > > Could Mysql cache cause a performance penalty, when invalidating > queries of a big Mysql cache zone?. Yep, spot on. I tend to keep 200MB caches for some webservers, and that's already considered fairly large. The qcache does looku

Mysql cache issues???

2013-07-15 Thread Egoitz Aurrekoetxea
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Good afternoon, Could Mysql cache cause a performance penalty, when invalidating queries of a big Mysql cache zone?. I mean... I had a server with 16GB of cache memory and when a big table full update was done... a performance issue was suffered (seem

Re: MySQL crashing.

2013-07-15 Thread Rares Aioanei
On 07/15/2013 07:54 AM, Luis H. Forchesatto wrote: Greetings. I'm receiving the following error log often on my MySQL database server: [SNIP] I suggest you report a bug as suggested. -- Rares Aioanei -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscri

MySQL crashing.

2013-07-15 Thread Luis H. Forchesatto
Greetings. I'm receiving the following error log often on my MySQL database server: 130715 8:40:18InnoDB: Assertion failure in thread 2974165904 in file btr0cur.c line 160 InnoDB: Failing assertion: page_is_comp(get_page) == page_is_comp(page) InnoDB: We intentionally generate a memory trap. Inn