- Not Found :
http://yum.mariadb.org/5.5-galera/fedora17-amd64/rpms/MariaDB-5.5.27-fedora17-x86_64-client.rpm
/etc/yum.repos.d/mariadb.repo :
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/5.5-galera/fedora17-amd64
gpgcheck=1
enabled=1
--
Daniel Black, Engineer @ Open Query (http
...@askmonty.org
To: Daniel Black daniel.bl...@openquery.com
Cc: maria-developers@lists.launchpad.net
Sent: Friday, 7 December, 2012 9:35:44 AM
Subject: Re: [Maria-developers] release day of week for security releases
Hi, Daniel!
On Dec 02, Daniel Black wrote:
Thanks for the latest releases with security
@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help : https://help.launchpad.net/ListHelp
--
--
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise maintenance for MySQL/MariaDB server environments
|
--
--
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise maintenance for MySQL/MariaDB server environments.
___
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
--
--
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise maintenance for MySQL/MariaDB server environments
://help.launchpad.net/ListHelp
--
--
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise maintenance for MySQL/MariaDB server environments.
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria
was needed for parallel replication).
How does Galera handle this in its parallel apply threads?
Especially the case below marked on MDEV-6676
T1: DELETE FROM t1 WHERE a=1
T2: INSERT INTO t1 SET a=1
--
--
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise maintenance
to myisam/aria?
It is possible to change to easily change to innodb, an actually transactional
storage engine, for the transaction features you want to use?
--
--
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise maintenance for MySQL/MariaDB server environments
- Original Message -
hi Daniel!
2014-11-25 1:03 GMT-02:00 Daniel Black daniel.bl...@openquery.com:
- Original Message -
hi guys, i use read uncommited sometimes with innodb, that's nice and
work
too scared to ask why. Its nice until the one day it shoots you
and bug
reports I've seen credited to you.
--
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise maintenance for MySQL/MariaDB server environments.
___
Mailing list: https://launchpad.net/~maria-developers
Post
t1 change index invisible session)
#1 likely means changing the .frm format, which would cause backward
compatibility issues.
Are there any upcoming changes to .frm planned?
Any comments or suggestions?
How/why are invisible indexes useful?
--
--
Daniel Black, Engineer @ Open Query
of the MariaDB plugins deserve to be shipped as a
separate package? (apart from current connect and oqgraph)
I'd see a need to split them when extra dependencies creep in to the plugin.
--
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise maintenance for MySQL/MariaDB
directories so that if the user installs/removes/upgrades any of the
MySQL variants they would not mess up their data accidentally and the
installation scripts would help users to dump/migrate/copy/move their
data in the common scenarios.
nice!
--
Daniel Black, Engineer @ Open Query (http
this would. I can
copy/paste a show create table however or use
pt-online-schema-change/pt-archiver without replication with global
binlog_format set to SBR in the mean time and hopefully that covers all the
buggy edge cases that trigger rather abrupt production failures.
--
Daniel Black
- Original Message -
Hi Daniel,
On 12/22/2014 03:30 PM, Daniel Black wrote:
- Original Message -
Hi, Alexander!
On Dec 22, Alexander Barkov wrote:
Hi Sergei, Kristian,
I'm looking at:
MDEV-7268 Column of table cannot be converted from type 'decimal(0
for your detailed examination of this issue.
--
--
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise maintenance for MySQL/MariaDB server environments.
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria
of been mentioned.
Still a little confused as mysqld.service comes from as it doesn't appear to be
./packaging/rpm-oel/mysqld.service
also https://mariadb.atlassian.net/browse/MDEV-5536 is there with a fair bit of
systemd work (but not much in the way of rpm spec changes).
--
--
Daniel Black
Index_prefix_calc() even.
--
--
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise maintenance for MySQL/MariaDB server environments.
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers
If this is the fix the if..return can go much earlier in
collect_statistics_for_index, before Index_prefix_calc() even.
Done.
thanks
--
--
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise maintenance for MySQL/MariaDB server environments
the necessary information for the slave to handle matters correctly?
But, as from above, I'm not sure if that much effort is warranted.
If the new row event just adds the precision of the old decimal it does seem
like a bit too much effort.
Hope this helps,
Likewise.
--
--
Daniel
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mariadb.conf.d/
--
--
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise maintenance for MySQL/MariaDB server environments.
___
Mailing list: https
is implied by --bootstrap
..
While insert probably works for auth_socket as it has no init function on
install, devs is there a reason why you can't install a plugin in bootstrap?
https://mariadb.atlassian.net/browse/MDEV-7781
https://github.com/MariaDB/server/pull/28/files
--
--
Daniel Black
visible to sysadmins than a shared library and a kb page.
Just need to come up with a marketable name.
--
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise maintenance for MySQL/MariaDB server environments.
___
Mailing list
- Original Message -
Daniel Black notificati...@github.com writes:
Thanks for your patch. I agree that these kinds of status information could
be
useful. But I have some parts that are not clear, and I want you to think
about the questions below and answer with your thoughts
-
I'm trying to engineer a fix for this but it seems really tricky. Here
is what I've got so far:
https://github.com/ottok/mariadb-10.0/commit/26fd165625b2e840fbda05ed11e5b7c12f308fca
--
--
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise maintenance for MySQL
deb http://labs.seravo.fi/~otto/mariadb-repo/ mariabd-10.0-sid-amd64/
--
Check out our blog at http://seravo.fi/blog
and follow @ottokekalainen
--
--
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise maintenance for MySQL/MariaDB server environments
recognize it as an internal command.
thank you
--
--
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise maintenance for MySQL/MariaDB server environments.
___
Mailing list: https://launchpad.net/~maria-developers
Post
PREPARE inst_plug; END// CALL
debian_plugin_install('unix_socket', 'auth_socket') // DROP PROCEDURE
debian_plugin_install//
https://github.com/ottok/mariadb-10.0/blob/master/debian/mariadb-server-10.0.postinst#L179
Pull requests appreciated :)
--
--
Daniel Black, Engineer @ Open Query
log I think is a reasonable fit as
log-slow-verbosity=query_plan,explain
gives you a fairly good idea as to which indexes are locked.
--
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise maintenance for MySQL/MariaDB server environments
:
On 09.02.15 15:19, Sergei Golubchik wrote:
On Feb 09, sa...@askmonty.org wrote:
At file:///home/bell/maria/bzr/work-maria-5.5-MDEV-6916-check_view/
--
--
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise maintenance for MySQL/MariaDB server environments
want to disallow it?
corrected:
https://github.com/MariaDB/server/commit/28b173134ee1634a2489d3cef6faf2f3ea1f6ab4
--
--
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise maintenance for MySQL/MariaDB server environments
/openquery/mariadb-server/blob/travis-ci-10.0/.travis.yml
Probably could do something for packaging tests here. Build/test time is
limited to 50 mins so its probably too much of
a stretch to get packaging and content tests in the same package. Build time is
only about 5 mins.
--
Daniel Black
a change. If you made the change you are in
the best position
to describe it.
git log sql/sys_vars.cc
has quite a number of examples including
2ab49689c689b1c1daeb080ea568c268c5256952
cdb8e6ed38ce641a6cb90a4a93bc5ff15f3ba9f2
a978bdda1e2de35c79e432f026869e163657a263
--
--
Daniel Black, Engineer
broken to unusable when 100 categories was exceeded.
--
--
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise maintenance for MySQL/MariaDB server environments.
___
Mailing list: https://launchpad.net/~maria-developers
change. Does MariaDB
have plans to implement the full CREATE/ALTER USER syntax of MySQL
5.7.5/5.7.6?
Yes.
for reference:
https://mariadb.atlassian.net/browse/MDEV-7978
--
--
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise maintenance for MySQL/MariaDB
--
--
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise maintenance for MySQL/MariaDB server environments.
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe
SET utf8, CONVERT TO
CHARACTER
SET latin1 should fail
Eg. run `git merge bc902a2bfc46add0708896c07621e3707f66d95f` in a 10.1 tree.
Single merge:
https://github.com/MariaDB/server/pull/43
--
--
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise maintenance
/server/pull/29
--
--
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise maintenance for MySQL/MariaDB server environments.
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers
No code changes.
For review:
Fixing comments
https://github.com/MariaDB/server/pull/24
And spelling in comments:
https://github.com/MariaDB/server/pull/36
--
--
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise maintenance for MySQL/MariaDB server
For review:
https://github.com/MariaDB/server/pull/29
Simple one, this allows plugins to be removed/installed during bootstrap
(opt_noacl=true) but still enforces access control in normal operation.
--
--
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise
- Original Message -
Daniel Black notificati...@github.com writes:
What do you think of something like
binlog_commit_trigger_count
binlog_commit_trigger_timeout
instead ?
to maintain consistency with binlog_group_commits...
binlog_group_commit_trigger_count
://lists.askmonty.org/cgi-bin/mailman/listinfo/commits
--
--
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise maintenance for MySQL/MariaDB server environments.
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria
--
--
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise maintenance for MySQL/MariaDB server environments.
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe
transactions'
--
--
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise maintenance for MySQL/MariaDB server environments.
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers
This expands out all the query cache info from the flags that wasn't previously
available in the information_schema.query_cache_info table by the
query_cache_info plugin.
https://github.com/MariaDB/server/pull/67
--
--
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote
a real pain to keep this list updated. Something like "we've
checked CVE before and including (CVE-2015-4910) and only the CVEs listed above
affect MariadDB" would be sufficient.
--
Daniel Black, Engineer @ Open Query (http://ope
listed here:
https://mariadb.com/kb/en/mariadb/security/
Its only got the fixed versions rather than which versions vulnerabilities
where introduced. Is this sufficient?
--
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise & mainte
ould be 1. If that path is chosen, I think this variable
> should be deprecated in 10.1 and go away in 10.2 to reduce code complexity.
seconds_behind_master=commit?
I tend to think people using 10.0 haven't seen or cared enough about it to be
worth fixing in 10.0.
--
--
Daniel Black,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
On 23/12/15 00:56, Sergei Golubchik wrote:
> Hi, Ian!
>
> On Dec 22, Ian Gilfillan wrote:
>> Hi
>>
>> I quite often find out about a new feature after release, either
>> by looking through the changelog and commits, or because someone
>> points
On 24/01/17 04:30, SachinSetiya wrote:
> revision-id: ef590faa0e21d25a2dc5153f938135612b17ecbc
> (mariadb-10.1.20-31-gef590fa)
>thd_proc_info(thd, message);
> + DBUG_EXECUTE_IF("should_sleep_for_mdev7409",{
> + my_sleep(50);
> + };);
Shouldn't these
On 25/01/17 00:33, sachin wrote:
> @@ -5824,6 +5826,16 @@ int THD::decide_logging_format(TABLE_LIST *tables)
>table->table->file->ht)
> multi_access_engine= TRUE;
>
> + /*
> + Loop through each table field if it is virtual field check if it is
> deterministic
I came across the following gcc warning (6.3.1)
sql/item_sum.cc: In member function ‘virtual bool
Item_func_group_concat::fix_fields(THD*, Item**)’:
sql/item_sum.cc:3478:5: warning: this ‘if’ clause does not guard...
[-Wmisleading-indentation]
if ((!args[i]->fixed &&
^~
Well done and thank you.
On 24/08/16 06:25, Varun Gupta wrote:
> Hi,
> As GSOC is nearing its end, I have written a blog which contains how can
> aggregate functions be written and executed to get the desired
> results.In the blog I also have added the technical details of this
> project on
>> +#define BINLOG_COMPRESSED_HEADER_LEN 1
>> +#define BINLOG_COMPRESSED_ORIGINAL_LENGTH_MAX_BYTES 4
>> +/**
>> + Compressed Record
>> +Record Header: 1 Byte
>> + 0 Bit: Always 1, mean compressed;
>> + 1-3 Bit: Reversed, compressed algorithm??Always
0,
Folks,
At the MariaDB Developer meetup there was some discussion about the
limits of compatibility especially regarding replication.
I've started a section on this page:
https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-compatibility/
If you can identify what can/cannot work in various
So this is making log-queries-not-using-indexes to take on the same
meaning as min_examined_row_limit for the case of no-index and both seam
to apply?
Is thd->get_examined_row_count() the right comparison value if the
non-indexed table had much fewer rows examined?
Note -
In case anyone is interested.
Code needs to be written to take a random bit of data and push this into
the server somehow. Apart from that it appears reasonably automated.
https://github.com/google/oss-fuzz
___
Mailing list:
nit - its really MDEV-11170
On 12/12/16 12:57, Vicențiu Ciorbaru wrote:
> Hi Sergei!
>
> Can you please review this patch for MDEV-11700? Details presented in
> the commit message. I'm not sure which solution we want.
> Possible solutions:
> A) have the user fix it by first starting the server
On 09/01/17 02:05, Sachin Setiya wrote:
> Hi Daniel!
>
> I was thinking of taking 4557 , but in comment I see you have ported
> the patch for 10.0
> but it was not merged.
It was rather incomplete and really only a quick hack which I didn't finish.
> Are you going to take 4557 , or can I take
On 28/03/17 07:31, Vladislav Vaintroub wrote:
>
>
> On 3/27/2017 6:15 AM, Daniel Black wrote:
>> On 26/03/17 22:11, Michael Widenius wrote:
>>> There is still a lot of work to fix edge cases, but in the current
>>> implementation most major things seams to work
I got referred to another GSoC documentation site:
https://code.timvideos.us/summer-of-code/
I think its a pretty good model of what sort of documentation students
should read as largely it applies to projects in general.
___
Mailing list:
On 03/04/17 20:21, jerome brauge wrote:
> Hello,
>
> When we call a stored procedure in JDBC which emit warnings,
> getWarnings() always returns null.
>
> I don’t really think that the problem is in MariaDB Connector J because
> warning flag in the EOF packet is not set to true.
>
On 10/03/17 16:02, Peter Mclarty wrote:
> Hi
>
> I have some very large tables and I would like to give them a cleanup.
> If I run OPTIMIZE and ANALYZE on a slave does that affect the GTID of
> that slave and cause me to eventually get the dreaded Slave has diverged
> too far from the master
For those that haven't seen it.
https://www.npmjs.com/package/jira-git
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help :
On 29/05/17 06:03, Sumit Lakra wrote:
> I think I am near done with dividing the buffer pool into the number of
> nodes available in a NUMA machine. There is one thing left to do - to
> check for the presence of 'libnuma' library in the server.
Based on
in ColumnStore
mentor: Andrew Hutchings
Sumit Lakra - NUMA GSoC Project Proposal
mentors: Daniel Black and Jan Lindström
Galina Shalygina - Transformation of IN predicate into IN subquery based
on implementation of table value constructor
mentor: Igor Babaev
Please make them welcome and we are looking
With Codership's galera repository showing spelling fixes and test case
changes as the only changes this year, and Percona's galera repository
streaming ahead with improvements, is Percona's galera becoming the new
base?
I did a quick test though and the mtr tests all pass with Percona's
galera
This is an invalid aggregation. The results of a select should only
contain the GROUP BY fields or an aggregate function over any other field.
mysql/mariadb is lax without sql_mode=ONLY_FULL_GROUP_BY set.
The results have chosen a different row for the class_id specified.
The way these rows
On 05/04/18 19:48, Otto Kekäläinen wrote:
> Hello!
>
> Just for the record, I've done some small tweaks to 10.3
Great work so far.
> so that it now
> builds perfectly and passes build tests on all Launchpad architectures
> that I have access to.
Needs a bit more than build tests:
The use of
On 10/04/18 02:04, Otto Kekäläinen wrote:
> Regarding the test that permanently fails on Travis-CI and keeps it
> from being green I filed https://jira.mariadb.org/browse/MDEV-15814
>
>
> If Travis-CI was all green (=this one test fixed or disabled) we could
PR with commit to disable test
I see the tradition of collecting a number of non-upstream patches with
limited descriptions continues:
https://salsa.debian.org/mariadb-team/mariadb-10.3/tree/master/debian/patches
It would be good to see these submitted upstream... some of which are
obsolete by outstanding PRs so confirming
Hi,
I was excited to come across the Galera-4 release notes and blog.
http://galeracluster.com/2019/02/galera-cluster-4-available-for-use-in-the-latest-mariadb-10-4-3-release-candidate/
It was good to see causal read functions that I'd hoped for in
https://jira.mariadb.org/browse/MDEV-10715.
://mariadb.zulipchat.com/#narrow/stream/118759-general/topic/Get.20OSX.20working.20on.2010.2E5.20-.20MDEV-22173
To paraphrase J.F.Kennedy
ask not what your database server community can do for you — ask what you can
do for your database server community.
Keep the community spirit going,
Daniel Black
On Fri, 8 May 2020 14:35:29 -0400
Justin Swanhart wrote:
> You don't have hardware to work on your own supported platform? Or you
> can't figure it out?
>
I didn't have hardware,
However thanks to Etienne Guesnet AIX was having the same fault
and came up with this patch which allows most of
mysql-test/t/xxx.test got changed to mysql-test/main/xxx.test
Use the parts of the merge commit:
https://github.com/MariaDB/server/commit/1c587481966abc7a9ad5309d0a91ca920f7a5657#diff-69f3d6de377352b6ed59388922d5e448
On Mon, Oct 5, 2020 at 4:01 PM Otto Kekäläinen wrote:
>
> Hello!
>
> After
On Thu, Oct 22, 2020 at 8:25 PM Sergei Golubchik wrote:
>
> Hi, Daniel!
>
> On Oct 22, Daniel Black wrote:
> > SHOW CREATE USER; dilignently uses this value in its output
> > generating the SQL:
> >
> >
Apologies,
It was to correct some other broken things.
Can I see a change log of your corrections to understand what went wrong?
Totally agree that it was mostly process error and review that went wrong,
so yes. PR merged. Let's do that. Nice and automated.
Best wishes with the talk.
On Fri,
That works for me.
Pushed first patch with above simple fix.
On Sat, Oct 31, 2020 at 4:45 AM Sergei Golubchik wrote:
>
> Hi, Daniel!
>
> On Oct 26, Daniel Black wrote:
> > On Thu, Oct 22, 2020 at 8:25 PM Sergei Golubchik wrote:
> > >
> > > Hi, Daniel!
>
On Fri, Mar 19, 2021 at 11:24 AM Elena Stepanova wrote:
> Hi Otto,
>
> On 3/18/21 8:50 AM, Otto Kekäläinen wrote:
> > Hello!
> >
> > I noticed there are quite a lot of upgrade test failures on the 10.5
> > branch, which is a stable release and should definitely be all green
> > all the time.
> >
Alexandre,
Are you still interested in implementing MDEV-12151 ?
It's a useful feature, and in my previous email I was just making sure
that if MariaDB partitions suited your needs you could use them.
If you'd still like to implement INSTEAD OF triggers we''d be happy to
help you on the
Opps, meant to send to list too.
On Sat, Sep 25, 2021 at 5:28 PM Daniel Black wrote:
>
> Hi Alexandre,
>
> Given the aws blog is written around that Oracle SE doesn't have
> partitions and EE does, does it still make sense with MariaDB (that
> includes partitions as
Manohar,
Thank you very much for your contribution.
This isn't an area of code I'm particularly familiar with however I'll
find someone who is.
Is this code really only applicable in ORACLE mode? I think its ok if
it isn't the syntax doesn't conflict with non-oracle mode, provide the
default is
On Wed, Jun 15, 2022 at 3:36 PM Martijn Tonies (Upscene Productions) <
m.ton...@upscene.com> wrote:
>
> Here's another one that MariaDB could fix ;)
>
Or anyone that can contribute.
> https://bugs.mysql.com/bug.php?id=11082
Can you please create an issue in our bug tracker. While we'll
c135be62274 Remove duplicate entry
> 84c7cd29c61 Fix Debian packaging for mariabackup
> 5dbc7ae8bb4 MDEV-30203: compat packages - RPM remove mariabackup link
> eb4fa5d750f MDEV-30203: debian - make compat packages
> d4be0b9be73 MDEV-30203: Create mysql symlink packages (RPM) - scripts
> 441879fd4
Sergei Golubchik wrote:
> Hi, Daniel,
>
> On Dec 20, Daniel Black wrote:
> > updated as bb-11.0-danielblack-MDEV-30203-pkgtest-symlink-packages on top
> > of bb-11.0-serg branch
>
> please, rebase again (your three commits adjusting tests to 11.0 will
> disapp
On Fri, Feb 10, 2023 at 6:20 AM Sergei Golubchik wrote:
>
> Hi, Daniel,
>
> On Feb 09, Daniel Black wrote:
> > revision-id: ceb75e9bd9e (mariadb-10.11.1-152-gceb75e9bd9e)
> > parent(s): 526fce28b90
> > author: Daniel Black
> > committer: Daniel Black
>
Is this compatible with passing through additional items like
https://github.com/MariaDB/server/pull/631 ?
As we discussed, there should be some ways to prevent it being used
to brute-force passwords. It'll be suid root, so it cannot be
made executable only by "mysql" user.
I see two
87 matches
Mail list logo
