- Original Message -
> From: "Rick James"
>
> There is a section on German Sharp-s in
> http://mysql.rjweb.org/doc.php/charcoll
> I agree with "dirty".
Yes, seen it, but thank you. I'm not having character set issues, everything is
nicely UTF8. I'm merely running into the scheiße bug,
Hi,
I have a mysql server running with the query cache size being 128M
(134217728 bytes).
Here are the qcache variables values:
| Qcache_free_blocks| 13758|
| Qcache_free_memory| 46945512 |
| Qcache_hits | 56418967 |
| Qcache_
- Original Message -
> From: "Raphael Bauduin"
>
> And the query_cache_min_res_unit is 4096 .
>
> I'm not sure what the meaning of a block is. For the query cache size
What you calculated is the *average* block size, which is fairly useless :-)
The query cache is not formatted into f
utf8 : utf8_general_ciO=o=Ò=Ó=Ô=Õ=Ö=ò=ó=ô=õ=öoe oz
utf8 : utf8_general_mysql500_ci O=o=Ò=Ó=Ô=Õ=Ö=ò=ó=ô=õ=öoe oz
utf8 : utf8_danish_ci O=o=º=Ò=Ó=Ô=Õ=ò=ó=ô=õ oe=Œ=œ oz
utf8 : utf8_swedish_ciO=o=º=Ò=Ó=Ô=Õ=ò=ó=ô=õ oe=Œ=œ
> | Qcache_hits | 56418967 |
> | Qcache_inserts| 48601636 |
That's a low hit rate. Perhaps you should simply turn off the Query cache?
> | Qcache_free_memory| 46945512 |
That's a big fraction of the total. Either the QC is unn
On 8/28/2012 4:49 AM, Johan De Meersman wrote:
...
Guess I'll be fixing it manually (well, sed is my friend) in a mysqldump before
syncing up the second node after it's been upgraded.
There is another method you can use that doesn't require
dump+sed+restore. Convert the column from it's cur
Hi all
i use mysql database,when i use mysql replication ,the slave host do not
replication,i check the error message,i found error message,it is 'row is
too large', i do not understand why,please tell and help me ,thanks
Hi ,
Can you paste the complete error log.
Regards,
KarthiK.P.R
On Wed, Aug 29, 2012 at 7:04 AM, aaron zhang
wrote:
> Hi all
>
> i use mysql database,when i use mysql replication ,the slave host do not
> replication,i check the error message,i found error message,it is 'row is
> too large', i
