History Bug

[cyc]

Im alter table from GUI (F6)

Change all fields type from double(8,3) to double(8,2) Press button AlterTabe

Table changed but action not logged in history!

My ver. SQLyog 5.02 Free

CREATE TABLE `prices` (

`gid` smallint(5) unsigned NOT NULL default '1',

`week_day` tinyint(1) NOT NULL default '0',

`h0` double(8,3) NOT NULL default '0.000',

`input0` double(8,3) NOT NULL default '0.000',

`output0` double(8,3) NOT NULL default '0.000',

`h1` double(8,3) NOT NULL default '0.000',

`input1` double(8,3) NOT NULL default '0.000',

`output1` double(8,3) NOT NULL default '0.000',

`h2` double(8,3) NOT NULL default '0.000',

`input2` double(8,3) NOT NULL default '0.000',

`output2` double(8,3) NOT NULL default '0.000',

`h3` double(8,3) NOT NULL default '0.000',

`input3` double(8,3) NOT NULL default '0.000',

`output3` double(8,3) NOT NULL default '0.000',

`h4` double(8,3) NOT NULL default '0.000',

`input4` double(8,3) NOT NULL default '0.000',

`output4` double(8,3) NOT NULL default '0.000',

`h5` double(8,3) NOT NULL default '0.000',

`input5` double(8,3) NOT NULL default '0.000',

`output5` double(8,3) NOT NULL default '0.000',

`h6` double(8,3) NOT NULL default '0.000',

`input6` double(8,3) NOT NULL default '0.000',

`output6` double(8,3) NOT NULL default '0.000',

`h7` double(8,3) NOT NULL default '0.000',

`input7` double(8,3) NOT NULL default '0.000',

`output7` double(8,3) NOT NULL default '0.000',

`h8` double(8,3) NOT NULL default '0.000',

`input8` double(8,3) NOT NULL default '0.000',

`output8` double(8,3) NOT NULL default '0.000',

`h9` double(8,3) NOT NULL default '0.000',

`input9` double(8,3) NOT NULL default '0.000',

`output9` double(8,3) NOT NULL default '0.000',

`h10` double(8,3) NOT NULL default '0.000',

`input10` double(8,3) NOT NULL default '0.000',

`output10` double(8,3) NOT NULL default '0.000',

`h11` double(8,3) NOT NULL default '0.000',

`input11` double(8,3) NOT NULL default '0.000',

`output11` double(8,3) NOT NULL default '0.000',

`h12` double(8,3) NOT NULL default '0.000',

`input12` double(8,3) NOT NULL default '0.000',

`output12` double(8,3) NOT NULL default '0.000',

`h13` double(8,3) NOT NULL default '0.000',

`input13` double(8,3) NOT NULL default '0.000',

`output13` double(8,3) NOT NULL default '0.000',

`h14` double(8,3) NOT NULL default '0.000',

`input14` double(8,3) NOT NULL default '0.000',

`output14` double(8,3) NOT NULL default '0.000',

`h15` double(8,3) NOT NULL default '0.000',

`input15` double(8,3) NOT NULL default '0.000',

`output15` double(8,3) NOT NULL default '0.000',

`h16` double(8,3) NOT NULL default '0.000',

`input16` double(8,3) NOT NULL default '0.000',

`output16` double(8,3) NOT NULL default '0.000',

`h17` double(8,3) NOT NULL default '0.000',

`input17` double(8,3) NOT NULL default '0.000',

`output17` double(8,3) NOT NULL default '0.000',

`h18` double(8,3) NOT NULL default '0.000',

`input18` double(8,3) NOT NULL default '0.000',

`output18` double(8,3) NOT NULL default '0.000',

`h19` double(8,3) NOT NULL default '0.000',

`input19` double(8,3) NOT NULL default '0.000',

`output19` double(8,3) NOT NULL default '0.000',

`h20` double(8,3) NOT NULL default '0.000',

`input20` double(8,3) NOT NULL default '0.000',

`output20` double(8,3) NOT NULL default '0.000',

`h21` double(8,3) NOT NULL default '0.000',

`input21` double(8,3) NOT NULL default '0.000',

`output21` double(8,3) NOT NULL default '0.000',

`h22` double(8,3) NOT NULL default '0.000',

`input22` double(8,3) NOT NULL default '0.000',

`output22` double(8,3) NOT NULL default '0.000',

`h23` double(8,3) NOT NULL default '0.000',

`input23` double(8,3) NOT NULL default '0.000',

`output23` double(8,3) NOT NULL default '0.000',

`floor` bigint(6) NOT NULL default '0',

`last_change` datetime NOT NULL default '0000-00-00 00:00:00'

) ENGINE=MyISAM DEFAULT CHARSET=cp1251

[Ritesh]

SQLyog logs queries that are less then 4KB. The size of the query is more then 4KB and thus not logged.

[peterlaursen]

The ALTER TABLE statement is too big!

Statements bigger than 4 KB are not logged to HISTORY. the reaon is that HISTORY is kept in memory. And to avoid memory use 'build up' this limit was introduced (I think with 4.07 or around that time). Statements kan be MB's, GB's in size …

The 4K limit is not configurable.

I feel like to repeat my request that HISTROY is spooled to a file and not kept in memory! <_< . Also a statement like

Code:

ALTER TABLE blabla (abbreviated by SQLyog)

in HISTORY would be nice!

I saved the CREATE statement. It is 3,67 KB. ALTER syntax takes a little more. So I guess you just exceeded the limit!

EDIT: I can add that actually it was some af my data that gave cause for this. I have a database with very big photographs (48 bit TIFF-format – each file is around 35 M:cool:. When inserting a lot of those pics history took all available memory. Next system began to swap and everything became incredible slow!

[peterlaursen]

But there is a FAQ to write here, I guess.

Nice work if you can get it! :huh:

EDIT: I see Ritesh was here too!

[peterlaursen]

FAQ: http://www.webyog.com/faq/28_89_en.html

[Author]

Posts