Managing your MySQL Database Systems » Manipulating data.

ID #1073

I execute a query but it is not written to HISTORY.

 

You experience that when you execute a query it is not written to HISTORY. The query itself executes correctly.


The reason is that your query is too big to be logged to HISTORY. Queries exceeding 4 KB in size are not logged. The reason is that HISTORY is kept in memory. And to avoid memory use 'build up' this limit was introduced with a previous SQLyog version.

The 4 KB limit is not configurable.

Statements can be MB's, GB's in size so it has been necessary to introduce this limit. For instance a single LONGTEXT or LONGBLOB variable can be as big as 4 GB.

 

Tags: -

Related entries:

Last update: 2006-01-17 11:13
Author: Peter Laursen
Revision: 1.0

Digg it! Print this record Send to a friend Show this as PDF file
Propose a translation for Propose a translation for
Please rate this entry:

Average rating: 0 out of 5 (0 Votes )

completely useless 1 2 3 4 5 most valuable

You can comment on this entry