admin's blog

I have described 3 different ways to "solve" the problem above:

Table of Contents

1. 1 Preparation for Exercises
2. 2 Topic 2
3. 3 Topic 3
4. 4 Query Tuning

Hello earl86

can you please set Debug = 4 in the mpm.conf and send us the output?

Hello poorx7,

The got TERM signal means that the process was hanging too long somewhere and the next start of mpm killed this one.

Hello Jon,

Great you are happy with MyEnv!

A little Information: We plan to release MyEnv 1.0.2 soon (this week?).

Hi Geoff,

The mysqldump was done with –master-data(=1) which explicitly set’s binary log file and binary log position.

Hi Wlad,

Please find the numbers here:

MySQL Version

Version % 4.0 0.2% 4.1 2.7% 5.0 62.4% 5.1 29.6% 5.2 (MariaDB) 1.7% 5.5 3.5% 100.0%

Please do NOT compare the numbers with the numbers above. They have a slightly different base but the result should not change significantly…

Hi cypherinfo,

Indeed, that would be interesting…

Unfortunately we do not have these numbers. CMS is nothing we have directly to do with and it seems like CMS do not typically have problems with their (MySQL) databases.

Seufzg!

I thought this question would pop up…! I try if I find some time to gather them…

Possibly in the 4^th graph the values are not too correct. I do not know for example where MySQL packages distributed with the SuSE distribution count and where MySQL Packages FOR the SuSE distribution count. Windows on the 4^th graph is completely missing so they are counted in the MySQL% packages…

Hi rhousand,

Pros of DRBD are mostly data consistency and reliability. DRBD is a sync replication and you only have your data in one place. The Cons are Performance and Complexity.

Hi Phil,

This looks like you are using a 32-bit MySQL Binary:

Hi Normann,

Yes, why not? Great idea!

Something like: If Qcache_free_blocks is bigger than 10% of Qcache_total_blocks then do a flush.

Hi Krishna,

I got you and fully agree with you!

Hi Sergei,

OK I will do so… The problem with maria-developers@ is just that there is so much traffic I can oversee something which concerns me…