enabling sync_binglog

Hi all, I tried with 5.1.23-rc why it is very slow while enable sync_binlog? It is normal and fast with 5.0. Thanks, Saravanan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

maximum insert records per query?

Hi, Currently in my production environment, mysql only allow max 50.000 records per insert. Is it possible to increase the number of records inserted during insert into query? How to do it? TIA Regards, Willy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

RE: improving random record selection

From: Scott Haneda [mailto:[EMAIL PROTECTED] Sent: Saturday, May 17, 2008 5:32 PM To: mysql@lists.mysql.com Subject: improving random record selection I posted this a month or so ago, and was helped a little, but I am now back. Currently I use select x, y, z from images where (condition) order

RE: improving random record selection

-Original Message- From: Rob Wultsch [mailto:[EMAIL PROTECTED] Sent: Saturday, May 17, 2008 6:47 PM To: Scott Haneda Cc: mysql@lists.mysql.com Subject: Re: improving random record selection On Sat, May 17, 2008 at 2:32 PM, Scott Haneda [EMAIL PROTECTED] wrote: $sql =

Re: improving random record selection

On Mon, May 19, 2008 at 7:24 AM, Jerry Schwartz [EMAIL PROTECTED] wrote: I might not understand what this is doing, but I think it will preferentially sample the ids that are at the end of a gap. What don't you understand about the query or the way I described it? You say you want a flat

Re: purge binary logs on master

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sun, May 18, 2008 at 01:02:32PM +0530, Ananda Kumar wrote: I want to purge bin logs which are older than 4 days. I want to keep 4 days of bin logs so that in the event of any data issue, i can restore it from bin logs. So, i tired to use PURGE

RE: improving random record selection

-Original Message- From: Rob Wultsch [mailto:[EMAIL PROTECTED] Sent: Monday, May 19, 2008 11:20 AM To: Jerry Schwartz Cc: Scott Haneda; mysql@lists.mysql.com Subject: Re: improving random record selection On Mon, May 19, 2008 at 7:24 AM, Jerry Schwartz [EMAIL PROTECTED] wrote: I might

mysqldump and auto_increment

Is there a set of flags for mysqldump that will include the auto_increment specifier for columns, but leave out the AUTO_INCREMENT=x saved values? I want to compare the schema of two versions of a database, without considering the data. In my opinion, the saved auto increment counter is part of

Re: mysqldump and auto_increment

You can import your data into a test database,then export the data using statement select ... into ... then You can complare the two. On Tue, May 20, 2008 at 9:14 AM, Dan Lipsitt [EMAIL PROTECTED] wrote: Is there a set of flags for mysqldump that will include the auto_increment specifier for

Re: purge binary logs on master

You can add this condition in the configuration file if you didn't find other way to solve this. expire_logs_per_day = 4 On Tue, May 20, 2008 at 12:14 AM, Todd Lyons [EMAIL PROTECTED] wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sun, May 18, 2008 at 01:02:32PM +0530, Ananda Kumar

Re: maximum insert records per query?

To make the parameter max_allowed_packet larger. On Mon, May 19, 2008 at 12:17 PM, sangprabv [EMAIL PROTECTED] wrote: Hi, Currently in my production environment, mysql only allow max 50.000 records per insert. Is it possible to increase the number of records inserted during insert into

Re: migration from 4.0 to 5.0

You are right. Mysql 4.0 don't have a concept charset. 2008/5/16 MarisRuskulis [EMAIL PROTECTED]: Found partial sollution! Need to specify mysql_query(SET NAMES 'latin1'); for connection charset. MarisRuskulis wrote: Hello! I'm trying to migrate database from mysql 4.0 to 5.0 (latin1).