Re: Mysql Monitoring with Graphite

2013-02-21 Thread Johan De Meersman
- Original Message - > From: "Adarsh Sharma" > > Anyone has any idea about this. Unless someone else here is using Graphite (I've never even heard of it, tbh) I think this may be something for the Graphite support channels, instead. -- Unhappiness is discouraged and will be corrected

Re: Mysql Monitoring with Graphite

2013-02-21 Thread Adarsh Sharma
Anyone has any idea about this. On Thu, Feb 21, 2013 at 7:42 PM, Adarsh Sharma wrote: > Hi all, > > I need to set up mysql monitoring graphs in Graphite. I am able to monitor > > basic system metrics after runnning example-client.py that comes with > graphite installation. > > when i m looking f

Re: replication fails after upgrade to 5.6

2013-02-21 Thread Reindl Harald
and where did anybody say the opposite in this thread? Am 21.02.2013 22:25, schrieb Rick James: > It is safer to have the Slave be a newer version. > >> -Original Message- >> From: Reindl Harald [mailto:h.rei...@thelounge.net] >> Sent: Thursday, February 21, 2013 10:30 AM >> To: mysql@lis

RE: replication fails after upgrade to 5.6

2013-02-21 Thread Rick James
It is safer to have the Slave be a newer version. > -Original Message- > From: Reindl Harald [mailto:h.rei...@thelounge.net] > Sent: Thursday, February 21, 2013 10:30 AM > To: mysql@lists.mysql.com > Subject: Re: replication fails after upgrade to 5.6 > > > > Am 21.02.2013 19:11, schrie

RE: MyISAM table size vs actual data, and performance

2013-02-21 Thread Rick James
* Smells like some huge LONGTEXTs were INSERTed, then DELETEd. Perhaps just a single one of nearly 500M. * Yes, there is an impact on full table scans -- it has to step over the empty spots. Or maybe not -- one big cow chip of 500MB would be easy to leap over. * OPTIMIZE TABLE is the primary

RE: MySQL 5.1: incorrect arithmetic calculation

2013-02-21 Thread Rick James
They are both right. It is a matter of how many decimal places you want to display: mysql> SELECT 365 * 1.67 * ( 1 - 0.10); +--+ | 365 * 1.67 * ( 1 - 0.10) | +--+ | 548.5950 | +--+ 1 row in set (0.00 sec) my

Re: replication fails after upgrade to 5.6

2013-02-21 Thread Reindl Harald
Am 21.02.2013 19:11, schrieb Mike Franon: > Is the only way to really fix this is to upgrade master? I thought > you can replicate from master -> slave if version is higher on slave, > just not the other way around? normally no but take a look at the changelogs of myslq in the last years 80 ou

Re: replication fails after upgrade to 5.6

2013-02-21 Thread Mike Franon
Unfortunately that is not possible at the moment, I have 6 slaves off the one master, also I want to test it as much as possible before upgrading the master. Is the only way to really fix this is to upgrade master? I thought you can replicate from master -> slave if version is higher on slave, ju

Re: replication fails after upgrade to 5.6

2013-02-21 Thread Reindl Harald
update the master ASAP in a short timeframe too and re-init replication if needed normally both should have exactly the same version the slaves must be updated first because otherwise a master may write instructions in the binlog the older slave does not undersatdn at all, but as said normally bo

Re: replication fails after upgrade to 5.6

2013-02-21 Thread Mike Franon
So I created a new test box on AWS, and just did one upgrade from 5.0.96 to 5.1, like I did before and replication will not work from a master with 5.0.96 to a slave with 5.1.68 I keep getting Error 1062, Duplicate Entry for key I get no errors when I do a mysql_upgrade, all comes back ok. I was

Mysql Monitoring with Graphite

2013-02-21 Thread Adarsh Sharma
Hi all, I need to set up mysql monitoring graphs in Graphite. I am able to monitor basic system metrics after runnning example-client.py that comes with graphite installation. when i m looking for mysql plugin for graphite , i find MySQLPerfCollector.py but when i am running it after installing