Re: [Maria-developers] pre-allocating binlog to speed up sync_binlog=1

2010-12-22 Thread Arjen Lentz
Hi Mark On 23/12/2010, at 6:19 AM, MARK CALLAGHAN wrote: On Mon, Dec 20, 2010 at 9:17 PM, Arjen Lentz wrote: Hi Mark, all On 21/12/2010, at 12:51 PM, MARK CALLAGHAN wrote: It would be nice if pre-allocated binlog files were possible, but performance results from ext-3 overstates the benefi

Re: [Maria-developers] pre-allocating binlog to speed up sync_binlog=1

2010-12-22 Thread MARK CALLAGHAN
On Mon, Dec 20, 2010 at 9:17 PM, Arjen Lentz wrote: > Hi Mark, all > > On 21/12/2010, at 12:51 PM, MARK CALLAGHAN wrote: >> >> It would be nice if pre-allocated binlog files were possible, but >> performance results from ext-3 overstates the benefit to be had. If >> you care about performance with

Re: [Maria-developers] pre-allocating binlog to speed up sync_binlog=1

2010-12-20 Thread Arjen Lentz
Hi Mark, all On 21/12/2010, at 12:51 PM, MARK CALLAGHAN wrote: It would be nice if pre-allocated binlog files were possible, but performance results from ext-3 overstates the benefit to be had. If you care about performance with the binlog enabled then don't use ext-3: http://www.facebook.com/no

Re: [Maria-developers] pre-allocating binlog to speed up sync_binlog=1

2010-12-20 Thread MARK CALLAGHAN
It would be nice if pre-allocated binlog files were possible, but performance results from ext-3 overstates the benefit to be had. If you care about performance with the binlog enabled then don't use ext-3: http://www.facebook.com/note.php?note_id=194501560932 On Mon, Dec 13, 2010 at 10:08 PM, Ser

Re: [Maria-developers] pre-allocating binlog to speed up sync_binlog=1

2010-12-14 Thread Arjen Lentz
Hi Serg, Kristian, all On 14/12/2010, at 4:08 PM, Sergei Golubchik wrote: On Dec 14, Arjen Lentz wrote: Can we adopt/implement http://forge.mysql.com/worklog/task.php?id=4925 in MariaDB? The benchmark info is in the item, and looks quite interesting. The author tested it using a separate tool

Re: [Maria-developers] pre-allocating binlog to speed up sync_binlog=1

2010-12-14 Thread Kristian Nielsen
Sergei Golubchik writes: > On Dec 14, Arjen Lentz wrote: >> Can we adopt/implement http://forge.mysql.com/worklog/task.php?id=4925 in >> MariaDB? > P.S. These are the changesets: > > final version: > http://lists.mysql.com/commits/113309 > http://lists.mysql.com/commits/113306 > http://l

Re: [Maria-developers] pre-allocating binlog to speed up sync_binlog=1

2010-12-13 Thread Sergei Golubchik
Hi, Arjen! [moving to the public list] On Dec 14, Arjen Lentz wrote: > Hi all > > Can we adopt/implement http://forge.mysql.com/worklog/task.php?id=4925 in > MariaDB? > The benchmark info is in the item, and looks quite interesting. > The author tested it using a separate tool to preallocate the