Hi Philip, all
Philip's bug on recovery from a kill -9 during DML reminded me... from
my experience, aborting a DDL query (ALTER TABLE - things like adding
an index usually) can be tricky and more often than not causes hassles.
By abort in this case I mean killing the connection/thread that d
ng an ALTER
TABLE, realising it's 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 --
a lot of joins and query complexity.
MariaDB 5.2 has the OQGRAPH engine integrated.
If you'd like assistance with the schema, or utilising OQGRAPH, we'd
be happy to help.
Regards,
Arjen.
--
Arjen Lentz, Exec.Director @ Open Query (http://openquery.com)
Exceptional Services for MySQL at
terminology in bigtable/hypertable was... Perhaps Mark
has insights 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)
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
hpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help : https://help.launchpad.net/ListHelp
--
Mark Callaghan
mdcal...@gmail.com
--
Arjen Lentz, Exec.Director @ Open Query (http://openquery.com)
R
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
ode is not different from MySQL? :-)
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.Di
e builds currently use them, so
simply 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 MySQ
in a 50M BLOB, then the iblog
should be >150M. But the packet size is all of a query, not just the
one column, and it'll be escaped also. Regular BLOBs (images, etc)
tend to not exceed 10M or so, which is well within the iblog/3 range
for the size values I suggest.
Re
ot;ACID out of the box" is vital - it's
been like that on Windows for years, and Oracle/MySQL has also moved
to that for Unix from 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&quo
hinders adoption - and it can
even trigger people moving away.
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
Hi Peter, all
> From: "Peter Laursen"
>
> 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;
>
> Field Ty
ke a win to me?
Cheers,
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
___
have a replication slave 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.c
Hi Kristian
> From: "Kristian Nielsen"
> 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://o
lient lib code suffers from - as well as allowing for non-blocking
features without trickery.
Cheers,
Arjen.
--
Arjen Lentz, Exec.Director @ Open Query (http://openquery.com)
Remote expertise & maintenance for MySQL/MariaDB server environments.
Follow us at http://openqu
lt @@optimizer_swich
> value
> has:
>
> semijoin=on
> firstmatch=on
> loosescan=on
>
> Philip: if you have any testing planned for "after semi-join optimizations
> are
> enabled by default", now it's time to do them.
>
> BR
> Sergei
> --
>
null_value= 0;
> >was_values= 0;
> > @@ -901,6 +903,8 @@ void Item_maxmin_subselect::no_rows_in_r
> >
> > void Item_singlerow_subselect::no_rows_in_result()
> > {
> > + if (const_item())
> > + return;
> >value= Item_cache::get_cache(new Item
orward to seeing your code contributions.
Regards, Arjen.
(MariaDB captain)
--
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
__
writing negative blog articles, etc).
Perhaps this is not fixable without possibly having 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)
Austra
will be easy to include it into MariaDB.
I will propose merge soon, so let's do not duplicate work if you are
going to look into this patch also.
Ah, excellent!
Cheers,
Arjen.
--
Arjen Lentz, Director @ Open Query (http://openquery.com)
Affordable Training and ProActive Support for
at is easy 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://open
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.
--
Hi Bryan, Monty
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 as the bug tracker at
Monty Program AB to track bugs in MariaDB.
[...]
Any suggestions or comments are
t, now, shall we?
Thanks
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/
OurDelta: free enhanced builds fo
Hi Monty
On 24/06/2009, at 12:01 AM, Michael Widenius wrote:
"Arjen" == Arjen Lentz 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 as the b
Hi all,
Just a heads up, please don't merge in this change from MySQL 5.4.4
See http://openquery.com/blog/type-disappears-mysql-544 for
background, also http://bugs.mysql.com/bug.php?id=17501
Sergei Golubchik is still assigned to that bug, btw ;-)
Cheers,
Arjen.
--
Arjen Lentz, Dir
able.
Then a user just has to explicitly INSTALL PLUGIN once, and otherwise
there's no RAM use at all.
Compiling it in has the advantage of everybody having it enabled,
which make starting to use it a tiny bit easier.
But it may be close to a moot point, in 5.1
Cheers,
Arjen
them as a pluggable and people can INSTALL PLUGIN
if they need the particular component. No need for different builds,
that's just confusing (and a heck of a lot more -unnecessary- work) on
the build end.
Cheers,
Arjen.
--
Arjen Lentz, Director @ Open Query (http://openquery.com)
talls, but not for existing ones so they'd have
them all disabled until manually added.
It's fine if that's what you intended, but it's important to realise
this consequence.
Cheers,
Arjen.
--
Arjen Lentz, Director @ Open Query (http://openquery.com)
Exceptional Serv
Hi Sergei
On 07/08/2009, at 5:31 AM, Sergei Golubchik wrote:
On Aug 06, Arjen Lentz wrote:
On 06/08/2009, at 4:48 PM, Sergei Golubchik wrote:
On Jul 30, Michael Widenius wrote:
I think we should compile all the plugin in (but not enable all by
default), at least for now, to make MariaDB as
versus as a plugin?
Yes, that is what you need to do (as far as I know).
Regards,
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.
ople.
By agreeing to this arrangement, contributors ensure that Sun is able
to continue that.
Do you want that?
"yes" might be a valid choice, on the basis that it might be more
important to get the changes upstream.
But I think the question needs to be asked explicitly. He
nges required or things
to look out for? If you can 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 budg
(any defined), refuse any slave that does not
have a filter profile, to prevent security problems.
Filters could be in a mysql.replfilters table and read into a mem
structure, makes it easy to manage.
Cheers,
Arjen.
--
Arjen Lentz, Exec.Director @ Open Query (http://openquery.com)
Except
Hi Kristian
On 02/10/2009, at 5:22 PM, Kristian Nielsen wrote:
Arjen Lentz 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 which is a) slow
texts.
I don't think you updated those with your changes/additions compared
to the microslow v1 patch you used as a base.
If you can find your 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 h
ual licensing, specifically I don't feel like supporting Sun/
MySQL's continued ability to conduct their sales scam. Now, I see my
contributions to be primarily benefiting MariaDB not MySQL (plus I
doubt significant things will flow upstream - although pigs might fly)
so I can probabl
k fine.
I think they're incomplete and possibly 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 Servic
/launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help : https://help.launchpad.net/ListHelp
- End forwarded message -
--
BR
Sergey
--
Sergey Petrunia, Software Developer
Monty Program AB, http://askmonty.o
Hi Peter
On 14/10/2009, at 6:19 PM, Peter Laursen wrote:
On Wed, Oct 14, 2009 at 01:41, Arjen Lentz
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 requirements
ink it makes sense to offer the user to specify options like
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.
Hi Monty
On 14/10/2009, at 10:57 PM, Michael Widenius wrote:
"Arjen" == Arjen Lentz writes:
Arjen> On 14/10/2009, at 6:41 PM, Sergey Petrunya wrote:
On Wed, Oct 14, 2009 at 12:44:01AM +0200, Peter Laursen wrote:
The billion dollar question is: what options should a config wi
ter.
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.
-
d to have some extra picky eyes to catch this stuff, I love it!
Thanks!
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://ourde
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 defa
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
Hi Kristian, Hakan,
On 04/11/2009, at 10:40 PM, Kristian Nielsen wrote:
Arjen Lentz 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 have been where he
name packaging, except it's a big bundle instead of all separate.
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/
Ou
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.
nly go back to RHEL4!) and Debian 4, we 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 "choi
: https://help.launchpad.net/ListHelp
___
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/ListHel
me of our build 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
e. We
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.
--
A
ry 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".
o use 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.
--
A
we'd 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
but you
can make that process fairly hasslefree/quick.
For ref, Quilt is used by some Linux kernel people who manage
thousands of patches.
Cheers,
Arjen.
--
Arjen Lentz, Exec.Director @ Open Query (http://openquery.com)
Exceptional Services for MySQL at a fixed budget.
Follow our blog at ht
flicts:", etc headers and so on.
For .rpm the issue may be similar, not sure.
Can you (or other from OurDelta) help me with this, or suggest the
best way
forward?
Yep can do.
Regards,
Arjen.
--
Arjen Lentz, Exec.Director @ Open Query (http://openquery.com)
Exceptional Services for My
.
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://ourdelta.org
___
Mailing l
wholly untested. The test is of course also important to guard
against regressions when other bugs around this code get found & fixed
over time.
Thanks
Regards,
Arjen.
--
Arjen Lentz, Exec.Director @ Open Query (http://openquery.com)
Exceptional Services for MySQL at a fixed budget.
Follow
fixes.
Of course we'll contribute those upstream, but you understand the lag
with that going through into distros; and that'd mostly be future
distro versions, not existing/past ones that we build for. So while
the upstream contribution is important on its own, it's not r
which also lists what to tweak. I can do that in
Helsinki or perhaps Serg can do it quickly.
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
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 of
heers,
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
___
Mailing
stency 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://ou
.
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
for people who don't
deal with it in-depth on a daily basis (which is most).
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
.
--
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
70 matches
Mail list logo
