Re: Binlog errors

[Henry Wong]

I could be wrong.. but this is a guess..

event_type: 15 is update_rows_event which is used in mysql 5.1 and  
later..


if mysqlbinlogs is an older version.. most likely it will produce an  
error

because it does not recognize event_type 15 and is bombing out.

try it.


http://dev.mysql.com/doc/refman/5.1/en/mysqlbinlog.html


On Jun 27, 2007, at 11:36 AM, John Mancuso wrote:

Ext3 fs on an emc SAN. Rhel 4 box with 4 cpus and tons of memory. I  
have

no problems with other types of files- only binlogs. I am using mostly
innodb tables.

It is a high load server but that's no excuse to corrupt all the  
binlogs



John Mancuso
Linux Administrator/MySQL DBA
IT Infrastructure
American Home Mortgage
w: 631-622-6382
c: 516-652-2475

-Original Message-
From: Michael Dykman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 27, 2007 11:33 AM
To: John Mancuso
Subject: Re: Binlog errors

Not that any ideas are jumping out at me but what file system are you
employing here?  and what types of MySQL tables are you using?  I note
from the listing above that you seem to be taking extremely high  
volumn

(>1G in barely over 3 hours on a couple occasions).  It seems a bit
spooky to me that the majority of your logs are capped at a level just
over 1 Gig (2^30 = 1073741824).

MyISAM has been known to spontaneously corrupt it's data files under
extremely high load although I have not heard of this happening at the
binlog level.

 - michael dykman

On 6/27/07, John Mancuso <[EMAIL PROTECTED]> wrote:

This seems to be a frequent occurrence:

[EMAIL PROTECTED] dblog]# mysqlbinlog mysql.25
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
ERROR: Error in Log_event::read_log_event(): 'Found invalid event in
binary log', data_len: 94, event_type: 15 Could not read entry at
offset 4:Error in log format or read error

This is happening to all my binlogs (other servers as well) all the
time. There is nothing wrong with the drive- I have other data on
there that never gets corrupted.

[EMAIL PROTECTED] dblog]# ll
total 4676748
drwx--  2 mysql mysql  16384 May 29 11:50 lost+found
-rw-rw  1 mysql mysql 1073746319 Jun 24 00:43 mysql.20
-rw-rw  1 mysql mysql 1073784914 Jun 24 03:50 mysql.21
-rw-rw  1 mysql mysql 1073754672 Jun 24 06:57 mysql.22
-rw-rw  1 mysql mysql 1073743683 Jun 26 10:24 mysql.23
-rw-rw  1 mysql mysql  111863423 Jun 26 11:41 mysql.24
-rw-rw  1 mysql mysql  377289867 Jun 27 10:53 mysql.25
-rw-rw  1 mysql mysql120 Jun 26 23:00 mysql.index
-rw-rw  1 mysql mysql  12418 Jun 26 23:47 mysql-slow.log
-rw-rw  1 mysql mysql117 Jun 13 17:08 relay.01
-rw-rw  1 mysql mysql 20 Jun 13 17:08 relay.index
-rw-r--r--  1 root  root  55 Jun 27 10:53 test.txt


What is going on here?

John Mancuso
Linux Administrator/MySQL DBA
IT Infrastructure
American Home Mortgage
w: 631-622-6382
c: 516-652-2475





--
 - michael dykman
 - [EMAIL PROTECTED]

 - All models are wrong.  Some models are useful.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Making ORDER BY RAND() more random [resend]

[Henry Wong]

change the seed on the random function.

http://dev.mysql.com/doc/mysql/en/mathematical-functions.html

On Mon, 2005-10-03 at 08:33 -0700, Graham Anderson wrote:
> is there a way to make  ORDER BY RAND()  at bit more spontaneous ?
> 
> I am using it in a php statement:
> $sql = "SELECT media.id,
>   artist.name as artist,
>   artist.spanish as bio,
>   artist.purchaseLink,
>   artist.picture,
>   media.spanish as trackName,
>   media.path,
>   media.quality,
>   mediaType.id as mediaType
>   FROM artist, media, playlistItems, mediaType
>   WHERE playlistItems.playlist_id = $myID
>   AND playlistItems.media_id = media.id
>   AND media.artist_id = artist.id
>   AND media.mediaType_id = mediaType.id
>  ORDER BY RAND() LIMIT 0, 30";
> 
> 
> the result seems to be pretty predictable 
> is there a way to improve RAND() or is there something better ?
> Should I be using php to randomize the found set instead ?
> 
> 
> many thanks
> g
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> 
> 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Limit of 1000 rows?

[Henry Wong]

It sound like you are exporting from Mysql Command Center which limit
records to 1000 by default

You can export the data from command line or increase the limit.

On Fri, 2005-01-14 at 16:49, Michael Loftis wrote:
> --On Friday, January 14, 2005 14:39 -0700 Steve Grosz 
> <[EMAIL PROTECTED]> wrote:
> 
> > I had tried to load a group of records from a Excel spreadsheet, and for
> > the most part it seems to have worked.
> >
> > The problem is that I know there were more than 1000 rows of data to be
> > input, and it stopped at 1000 exactly.
> >
> > Am I missing something to allow more than 1000 rows to be input?
> >
> > Steve
> 
> 
> This is extremely vague.  How exactly are you loading the data, excel 
> doesn't talk to MySQL directly, are you using MyODBC/ODBC drivers?
> 
> Are you exporting the excel to CSV then importing that, if so how?  Did you 
> notice any errors during the import process?  What type of data is it, very 
> large fields/columns?  some distributions only allow a 1MB max packet size, 
> which equates to BLOBs of no more than 1MB, and single row sizes of no more 
> than 1MB, and depending on how oyu do the import can mean no mor ethan 1MB 
> total data in a single batch.
-- 
Henry Wong <[EMAIL PROTECTED]>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: {Scanned} RE: random record

[Henry Wong]

pls unsubscribe me from this maillist. thanks.
- Original Message - 
From: "Andy Eastham" <[EMAIL PROTECTED]>
To: "Mysql List" <[EMAIL PROTECTED]>
Sent: Monday, September 15, 2003 8:54 PM
Subject: {Scanned} RE: random record


> 39?
> 
> > -Original Message-
> > From: tuncay bas [mailto:[EMAIL PROTECTED]
> > Sent: 15 September 2003 13:32
> > To: mysql
> > Subject: random record
> > 
> > 
> > hi,
> > 
> > why its mysql database over random record use?
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> 
>