- Original Message -
From: Rick James rja...@yahoo-inc.com
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
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 |
|
- Original Message -
From: Raphael Bauduin rbli...@gmail.com
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
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=º=Ò=Ó=Ô=Õ=ò=ó=ô=õ
| 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
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
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
aaron.zh...@embracesource.comwrote:
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