Re: [Maria-developers] Documentation about GTID

2013-05-06 Thread Arjen Lentz
an upgrade process break, which is even less desirable. But if there is another viable route, please consider. thanks Regards, Arjen. -- Arjen Lentz, Exec.Director @ Open Query (http://openquery.com) Australian peace of mind for your MySQL/MariaDB infrastructure. Follow us at http://openquery.com/blog

Re: [Maria-developers] External replication proceeding

2013-01-06 Thread Arjen Lentz
) -- Arjen Lentz, Exec.Director @ Open Query (http://openquery.com) Australian peace of mind for your MySQL/MariaDB infrastructure. Follow us at http://openquery.com/blog/ http://twitter.com/openquery ___ Mailing list: https://launchpad.net/~maria-developers

Re: [Maria-developers] Please review: [Commits] Rev 3538: Fix bug lp:1008773 in file:///home/tsk/mprog/src/5.3-lpb1008773/

2012-06-17 Thread Arjen Lentz
/blog ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp -- Arjen Lentz, Exec.Director

Re: [Maria-developers] FYI: @@optimizer_switch default changed to havesemijoin switched ON.

2011-11-07 Thread Arjen Lentz
Program AB, http://askmonty.org Blog: http://s.petrunia.net/blog -- Arjen Lentz, Exec.Director @ Open Query (http://openquery.com) Remote expertise maintenance for MySQL/MariaDB server environments. Follow us at http://openquery.com/blog/ http://twitter.com/openquery

[Maria-developers] TCP CRCs - relevant for client/server including replication communications

2011-07-05 Thread Arjen Lentz
copying a transaction perfectly except it has wrong data...) Regards, Arjen. -- Arjen Lentz, Exec.Director @ Open Query (http://openquery.com) Remote expertise maintenance for MySQL/MariaDB server environments. Follow us at http://openquery.com/blog/ http://twitter.com/openquery

Re: [Maria-developers] TCP CRCs - relevant for client/server including replication communications

2011-07-05 Thread Arjen Lentz
Hi Kristian From: Kristian Nielsen kniel...@knielsen-hq.org http://kb.askmonty.org/en/binlog-event-checksums Checksums are in MariaDB 5.3. It's also in the MariaDB 5.2 replication preview. Off by default? Cheers, Arjen. -- Arjen Lentz, Exec.Director @ Open Query (http://openquery.com

Re: [Maria-developers] forwarded message from Kristian Köhntopp

2011-06-20 Thread Arjen Lentz
, Arjen. -- Arjen Lentz, Exec.Director @ Open Query (http://openquery.com) Remote expertise maintenance for MySQL/MariaDB server environments. Follow us at http://openquery.com/blog/ http://twitter.com/openquery ___ Mailing list: https://launchpad.net

Re: [Maria-developers] [Maria-discuss] Reqeust for SHOW FULL FIELDS FROM and virtual tables in MariaDB

2011-06-02 Thread Arjen Lentz
Hi Peter, all From: Peter Laursen peter_laur...@webyog.com Refer http://kb.askmonty.org/v/virtual-columns - the example CREATE TABLE table1 ( a INT NOT NULL, b VARCHAR(32), c INT AS (a MOD 10) virtual, d VARCHAR(5) AS (LEFT(b,5)) persistent); now SHOW FULL FIELDS FROM table1;

Re: [Maria-developers] Default parameter settings / Windows MSI installer

2011-04-07 Thread Arjen Lentz
5.5. This was a longer overdue change of default, and the only reason it wasn't done before was the old MySQL AB does not own InnoDB political situation (but for some reason it was ok on Windows, anyway ;-) Regards, Arjen. -- Arjen Lentz, Exec.Director @ Open Query (http://openquery.com

Re: [Maria-developers] Bundle more relevant cnf files in MariaDB package

2011-03-27 Thread Arjen Lentz
deleting the files is not sufficient. I'll see if I can find those dependencies, and create a modified tree for merging. Cheers, Arjen. -- Arjen Lentz, Exec.Director @ Open Query (http://openquery.com) Remote expertise maintenance for MySQL/MariaDB server environments. Follow us at http

Re: [Maria-developers] Windows installer MWL#55 finished.

2011-02-01 Thread Arjen Lentz
? :-) And also there seems to be no 64 bit .zip? Could it have its own account? MSSQL probably ties in with lots of other things, mysqld is pretty self-contained and just needs network access and its local directory tree. Regards, Arjen. -- Arjen Lentz, Exec.Director @ Open Query (http

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

2010-12-20 Thread Arjen Lentz
] 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 binlog, but it should be straightforward

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

Re: [Maria-developers] 64 table join limit

2010-08-08 Thread Arjen Lentz
on this too. I'm for it, it solves a real need that people are already trying to solve (with desperately bad design decisions ;-). Regards, Arjen. -- Arjen Lentz, Exec.Director @ Open Query (http://openquery.com) Exceptional Services for MySQL at a fixed budget. Follow our blog at http

Re: [Maria-developers] How MySQL/MariaDB handles aborted DDL

2010-07-07 Thread Arjen Lentz
going to take a long time (forgot to set a large myisam_sort_buffer_size on a MyISAM table, for instance) and wants to abort, fix up the settings and try again (or wait until a more appropriate time later). Cheers, Arjen. - Original Message - From: Arjen Lentz ar...@openquery.com

Re: [Maria-developers] Updated (by Psergey): Push conditions down into non-mergeable VIEWs when possible (119)

2010-05-24 Thread Arjen Lentz
. -- Arjen Lentz, Exec.Director @ Open Query (http://openquery.com) Exceptional Services for MySQL at a fixed budget. Follow our blog at http://openquery.com/blog/ OurDelta: packages for MySQL and MariaDB @ http://ourdelta.org ___ Mailing list: https

Re: [Maria-developers] Summary of discussion about MariaDB future and release plans

2010-05-12 Thread Arjen Lentz
. Ehm what are you suggestion we use for versioning method? Regards, Arjen. -- Arjen Lentz, Exec.Director @ Open Query (http://openquery.com) Exceptional Services for MySQL at a fixed budget. Follow our blog at http://openquery.com/blog/ OurDelta: packages for MySQL and MariaDB @ http

Re: [Maria-developers] Summary of discussion about MariaDB future and release plans

2010-05-11 Thread Arjen Lentz
into there. The consistency and reliability will be regarded as more important. Regards, Arjen. -- Arjen Lentz, Exec.Director @ Open Query (http://openquery.com) Exceptional Services for MySQL at a fixed budget. Follow our blog at http://openquery.com/blog/ OurDelta: packages for MySQL and MariaDB @ http

Re: [Maria-developers] oqgraph in mariadb - integration work

2010-03-31 Thread Arjen Lentz
Hi Serg On 01/04/2010, at 12:55 AM, Sergei Golubchik wrote: On Mar 31, Arjen Lentz wrote: On 31/03/2010, at 11:22 PM, Kristian Nielsen wrote: So my preference would be to make it a built-in/regular as it will make adopton and subsequent use much easier. Understand, unfortunately I am out

Re: [Maria-developers] New (by Igor): Partitioned Key Cache for MyISAM (85)

2010-02-14 Thread Arjen Lentz
in a production environment - I prefer to not have to guess how well a cache is doing ;-) Please - FIRST figure out a way to make stats for multiple key cache visible - implement that for the current multi keycaches - then add the partitioned key cache feature Thanks! Regards, Arjen. -- Arjen Lentz

Re: [Maria-developers] New (by Igor): Partitioned Key Cache for MyISAM (85)

2010-02-14 Thread Arjen Lentz
get an INFORMATION_SCHEMA.KEYCACHE Or is it PERFORMANCE_SCHEMA ? Anyway that's good, will that also show the multiple keycaches (current implementation) ? That would be great! Regards, Arjen. -- Arjen Lentz, Exec.Director @ Open Query (http://openquery.com) Exceptional Services for MySQL

[Maria-developers] 2PC between two engines + binlog

2009-12-21 Thread Arjen Lentz
it should work so presumptions *may* be made (I know this sentence appears kinda contradictory, hope it makes sense anyhow ;-). Thus it's important for us to know what happens, so that we can tell people don't do this now, please track bug #, or please try this. Thanks Cheers, Arjen. -- Arjen

Re: [Maria-developers] bzr commit into MariaDB 5.1, with Maria 1.5:maria branch (knielsen:2785)

2009-12-14 Thread Arjen Lentz
platforms, and then deal with the why/what. Cheers, Arjen. -- Arjen Lentz, Exec.Director @ Open Query (http://openquery.com) Exceptional Services for MySQL at a fixed budget. Follow our blog at http://openquery.com/blog/ OurDelta: packages for MySQL and MariaDB @ http://ourdelta.org

Re: [Maria-developers] bzr commit into MariaDB 5.1, with Maria 1.5:maria branch (knielsen:2785)

2009-12-14 Thread Arjen Lentz
can investigate that and that way perhaps be able to declare the issue obsolete! Which other external libraries are currently still embedded into the source tree? For each, let's identify why, and in any case try to remove them. If that works out, major win! Cheers, Arjen. -- Arjen Lentz

Re: [Maria-developers] bzr commit into MariaDB 5.1, with Maria 1.5:maria branch (knielsen:2785)

2009-12-13 Thread Arjen Lentz
probably need to accept that it's a necessary evil. For Drizzle it'd be an external dep, however Drizzle is not supported on that many platforms... and on some it's significant hassle getting all the deps in place. So that's choices have consequences in action. Cheers, Arjen. -- Arjen

Re: [Maria-developers] bzr commit into MariaDB 5.1, with Maria 1.5:maria branch (knielsen:2785)

2009-12-13 Thread Arjen Lentz
___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp -- Arjen Lentz, Exec.Director @ Open

[Maria-developers] storage engine typecode problem?

2009-11-08 Thread Arjen Lentz
Hi Kristian Getting this in MariaDB 5.1.39 builds: 091109 4:41:43 [Warning] Storage engine 'FEDERATED' has conflicting typecode. Assigning value 42. First thought it was caused by something I was doing with OQGRAPH, but the above doesn't have graph. Cheers, Arjen. -- Arjen Lentz

Re: [Maria-developers] request for comment: OQGRAPH in 5.1 packages

2009-11-04 Thread Arjen Lentz
Hi Kristian, Hakan, On 04/11/2009, at 10:40 PM, Kristian Nielsen wrote: Arjen Lentz ar...@openquery.com writes: packages before they will try things. If 5.1 binaries had had PBXT plugin sitting there, lots more people would have tried it earlier, filed bugreports and feedback, and Paul would

Re: [Maria-developers] Additional info about engines

2009-11-02 Thread Arjen Lentz
version is vital for people to be able to do bug reports or even check on features. And the maturity indicator can be useful. Cheers, Arjen. -- Arjen Lentz, Exec.Director @ Open Query (http://openquery.com) Exceptional Services for MySQL at a fixed budget. Follow our blog at http://openquery.com

[Maria-developers] request for comment: OQGRAPH in 5.1 packages

2009-10-30 Thread Arjen Lentz
Hi all, fellow Maria captains in particular (but naturally anybody here can comment) We'd like to include the plugin for OQGRAPH engine in the 5.1 packages we're just about to build. It would not be pulled in like the xtradb/pbxt engines, but be compiled separately and not loaded in by

Re: [Maria-developers] Packaging: Ubuntu debs have binaries stripped?

2009-10-15 Thread Arjen Lentz
! Cheers, Arjen. -- Arjen Lentz, Exec.Director @ Open Query (http://openquery.com) Exceptional Services for MySQL at a fixed budget. Follow our blog at http://openquery.com/blog/ OurDelta: enhanced builds for MySQL @ http://ourdelta.org ___ Mailing list

Re: [Maria-developers] Windows installer kick-off

2009-10-14 Thread Arjen Lentz
Hi Peter On 14/10/2009, at 6:19 PM, Peter Laursen wrote: On Wed, Oct 14, 2009 at 01:41, Arjen Lentz ar...@openquery.com wrote: On 14/10/2009, at 8:44 AM, Peter Laursen wrote: The billion dollar question is: what options should a config wizard (ideally) provide? . base configuration (memory

Re: [Maria-developers] Windows installer kick-off

2009-10-14 Thread Arjen Lentz
query_cache_size - there's hardly anybody who could come up with a meaningful value at install time. Most users won't know, those who know exactly will probably prefer to edit the config file over using installer's GUI. Exactly. Cheers, Arjen. -- Arjen Lentz, Exec.Director @ Open Query (http

Re: [Maria-developers] Windows installer kick-off

2009-10-14 Thread Arjen Lentz
. It would be very nice to get more information about the above. I have never seen the above problem and don't know of any reason why a reboot would help. Having to reboot is also a serious annoyance to people, so I'd prefer this to not be necessary. Cheers, Arjen. -- Arjen Lentz

Re: [Maria-developers] bzr commit into MariaDB 5.1, with Maria 1.5:maria branch (knielsen:2763)

2009-10-13 Thread Arjen Lentz
the default that's shown is wrong in the text. Just compare the option lists and the defaults with the text, that's all. Cheers, Arjen. -- Arjen Lentz, Exec.Director @ Open Query (http://openquery.com) Exceptional Services for MySQL at a fixed budget. Follow our blog at http://openquery.com

Re: [Maria-developers] bzr commit into MariaDB 5.1, with Maria 1.5:maria branch (knielsen:2763)

2009-10-08 Thread Arjen Lentz
original commit for this you might want to go over that clean chunk again to make sure it's complete and consistent. I didn't have the time to find it in the history and it's rather more difficult to spot potential issues in the big source. Cheers, Arjen. -- Arjen Lentz, Exec.Director @ Open

Re: [Maria-developers] bzr commit into MariaDB 5.1, with Maria 1.5:maria branch (knielsen:2763)

2009-10-08 Thread Arjen Lentz
to be primarily benefiting MariaDB not MySQL (plus I doubt significant things will flow upstream - although pigs might fly) so I can probably live with signing an MP MCA. Cheers, Arjen. -- Arjen Lentz, Exec.Director @ Open Query (http://openquery.com) Exceptional Services for MySQL at a fixed

Re: [Maria-developers] WL40: Notes/questions

2009-10-02 Thread Arjen Lentz
Hi Kristian On 02/10/2009, at 5:22 PM, Kristian Nielsen wrote: Arjen Lentz ar...@openquery.com writes: Current - the binlog options prevent things from getting logged locally, which is bad for point-in-time recovery. - the replicate options work on the slave end, so they still get transmitted

Re: [Maria-developers] Information for release notes

2009-09-27 Thread Arjen Lentz
organise the info in such a way that that's clear and easy (smart grouping, for starters), that'd be fab! Cheers, Arjen. -- Arjen Lentz, Exec.Director @ Open Query (http://openquery.com) Exceptional Services for MySQL at a fixed budget. Follow our blog at http://openquery.com/blog/ OurDelta

Re: [Maria-developers] Federated code - IRC message

2009-08-10 Thread Arjen Lentz
, Monty -- Arjen Lentz, Director @ Open Query (http://openquery.com) Exceptional Services for MySQL at a fixed budget. Follow our blog at http://openquery.com/blog/ OurDelta: free enhanced builds for MySQL @ http://ourdelta.org ___ Mailing list: https

Re: [Maria-developers] Bug tracker for MariaDB

2009-06-23 Thread Arjen Lentz
Hi Monty On 24/06/2009, at 12:01 AM, Michael Widenius wrote: Arjen == Arjen Lentz ar...@openquery.com writes: Arjen On 19/06/2009, at 11:22 AM, Bryan Alsdorf wrote: Arjen Lentz wrote: Hi Bryan, On 19/06/2009, at 8:01 AM, Bryan Alsdorf wrote: I am in the process of setting up Eventum

Re: [Maria-developers] Bug tracker for MariaDB

2009-06-18 Thread Arjen Lentz
to look over. I would very very strongly suggest to use the bug tracking facilities at Launchpad. They're neatly linked to branches, allow people to follow, do linking to upstream bugtrackers, etc. OurDelta and Percona also use it, which again provides neat integration. Cheers, Arjen. -- Arjen

Re: [Maria-developers] Tungsten Replicator and MariaDB

2009-06-11 Thread Arjen Lentz
for MariaDB users to find. Files or announcements/links? ourdelta.org could do some of it. Cheers, Arjen. -- Arjen Lentz, Director @ Open Query (http://openquery.com) Affordable Training and ProActive Support for MySQL related technologies Follow our blog at http://openquery.com/blog