RE: MySQL 5.5.33 History list not purging?

2014-09-07 Thread Jesper Wisborg Krogh
Hi Brad, -Original Message- From: Brad Heller [mailto:b...@cloudability.com] Sent: Sunday, 7 September 2014 03:07 To: MySQL General List Subject: MySQL 5.5.33 History list not purging? For some reason, the history list isn't purging on one of my masters. This is causing all kinds

Re: Query on some MySQL-internals

2014-09-07 Thread Ajay Garg
Hi Martin. Thanks for the reply. As I had mentioned, we are running both the instances since last 6 years or so, and the records are inserted/deleted on both the instances. So, we did a show table status like 'XX' \G; on both the instances, and following are the outputs (here XX is the

RE: Query on some MySQL-internals

2014-09-07 Thread Martin Gainty
Good Afternoon Ajay Im not seeing any giant deltas between the two metrics except i did notice the elapsed time to run the metric on second instance was 3 times slower Any chance we can do pathping from your present location: 1)pathping SQLServerInstance1 2)pathping SQLServerInstance2 to

table comments

2014-09-07 Thread Martin Mueller
The TABLES table in MySQL's information_schema has a TABLE_COMMENT column. Could one use that for ad hoc and manual annotation of that table? And if so, could one change its length? Or are there better ways of producing table notes that are kept with the database, as opposed to Evernote or

Re: table comments

2014-09-07 Thread shawn l.green
Hello Martin, On 9/7/2014 7:42 PM, Martin Mueller wrote: The TABLES table in MySQL's information_schema has a TABLE_COMMENT column. Could one use that for ad hoc and manual annotation of that table? And if so, could one change its length? Or are there better ways of producing table notes