Re: ERROR in syntax...

2014/09/06 09:06 -0700, Don Wieland Can anyone tell me why this query is generating an ERROR: Which error? The first "IF" statement is not properly ended? it isn't. (A series of equality tests against the same variable is done more conveniently with "CASE ... END CASE".) --

RE: converting numeric to date-time?

2014/09/04 08:40 -0700, Jan Steinman > From: "Ed Mierzwa (emierzwa)" > > > FROM_UNIXTIME(1409304102.153) /*your epoch column here*/ I don't think the OP has a Unix timestamp. The number looks suspeciously like concatenation of date digits, "140930" at the beginning looks like Septem

Re: MySQL 5.5.33 History list not purging?

Good point. We'll try that out. I noticed our ibdata file is gigantic now, likely due to the alter table migration we ran. What's the relationship here, do you think? *Brad Heller *| Director of Engineering | Cloudability.com | 541-231-1514 | Skype: brad.heller | @bradhe

Re: MySQL 5.5.33 History list not purging?

Am 06.09.2014 um 19:07 schrieb Brad Heller: > For some reason, the history list isn't purging on one of my masters. This > is causing all kinds of weird issues/behavior with reads so why do you not just try to update first? 5.5.39 is recent and contains *a lot* of bufixes look at the changelogs

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 of weird issues/behavior with reads. Here's the last 8 or so hours of history list length: http://i.imgur.com/Q4DEeVi.png Here are my innodb%purge% settings. mysql> show variables where Variable_name

ERROR in syntax...

Can anyone tell me why this query is generating an ERROR: DROP TRIGGER rtsadven_development.content_assets_after_insert_subtypes; CREATE TRIGGER `rtsadven_development`.`content_assets_after_insert_subtypes` AFTER INSERT ON `rtsadven_development`.`content_assets` FOR EACH ROW BEGIN IF N

RE: Query on some MySQL-internals

> Date: Sat, 6 Sep 2014 14:26:22 +0530 > Subject: Query on some MySQL-internals > From: ajaygargn...@gmail.com > To: mysql@lists.mysql.com > > Hi all. > > > We are facing a very strange scenario. > > We have two mysql-instances running on the same machine, and they had > been running functi

Re: Истинно Говорю Вам: БАЛАНС! [ 1164728870 ]

 БАЛАНС - ЭФФЕКТИВНОЕ РЕШЕНИЕ ДЛЯ УМНОГО УЧЕТА "http://djv-com.net/?attachment_id=381"; * Ищем Партнеров: Беспроводная Система Комплексного Учета Энергоресурсов. Сбытовые компании: электричества, воды, тепла и газа. Производители средств измерений: электричества, воды, тепла и газа. Управляющие

Strange observation in "OPTIMIZE TABLE" command in InnoDB

Sorry, forgot to specify the engine. The table runs on InnoDB backend. Also, changed the subject to be more specific. On Sat, Sep 6, 2014 at 2:26 PM, Ajay Garg wrote: > Hi all. > > > We are facing a very strange scenario. > > We have two mysql-instances running on the same machine, and they had

Query on some MySQL-internals

Hi all. We are facing a very strange scenario. We have two mysql-instances running on the same machine, and they had been running functionally fine since about 6 years or so (catering to millions of records per day). However, since last few days, we were experiencing some elongated slowness on