Re: mysql replication

2012-08-28 Thread P.R.Karthik
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

mysql replication

2012-08-28 Thread aaron zhang
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

Re: MySQL, UTF8 and collations

2012-08-28 Thread Shawn Green
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

RE: qcache settings and block meaning

2012-08-28 Thread Rick James
> | 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

RE: MySQL, UTF8 and collations

2012-08-28 Thread Rick James
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=Œ=œ

Re: qcache settings and block meaning

2012-08-28 Thread Johan De Meersman
- 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

qcache settings and block meaning

2012-08-28 Thread Raphael Bauduin
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_

Re: MySQL, UTF8 and collations

2012-08-28 Thread Johan De Meersman
- 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,