n than the select statement with the same
where clause. The only way to check for a bad plan today is to use
SHOW INNODB STATUS to determine whether the statement locks all rows
in a table.
http://bugs.mysql.com/bug.php?id=14745
http://bugs.mysql.com/bug.php?id=35355
--
Mark Callaghan
mdcal...
Why does UNION ALL use a temp table? Many users are surprised by this.
It would be faster to return rows from each branch of a UNION ALL
query directly to the network.
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria
On Sun, Aug 2, 2009 at 6:10 PM, Arjen Lentz wrote:
> Hi Mark
>
> On 01/08/2009, at 3:15 AM, MARK CALLAGHAN wrote:
>>
>> Why does UNION ALL use a temp table? Many users are surprised by this.
>> It would be faster to return rows from each branch of a UNION ALL
>&
I describe how read/write is done for sockets in mysqld.
http://www.facebook.com/note.php?note_id=122655300932
Can someone explain the history of this code?
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria-discuss
ibutor agreements around! "
>> http://askmonty.org/wiki/index.php/MCA_FAQ
>
> We've made some adjustments, but yes, apparently it is one of the best
> contributor agreements around, the community seems to think. That's
> why we u
sql.com/doc/internals/en/licensing-notice.html
>>>
Because this is a GPL protocol, any product which uses it to connect
to a MySQL server, or to emulate a MySQL server, or to interpose
between any client and server which uses the protocol, or for any
similar purpose, is also bound by the GPL.
evaluate the
agreement. That takes time and money.
But Monty Program accepts code under MCA or BSD, so this isn't an issue for me.
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp
On Wed, Mar 10, 2010 at 12:29 PM, Michael Widenius wrote:
>
> Hi!
>
>>>>>> "Stewart" == Stewart Smith writes:
>
> Stewart> On Fri, Aug 14, 2009 at 10:28:35AM -0700, MARK CALLAGHAN wrote:
>>> I describe how read/write is done for sockets
contributions and the MariaDB trademarks?
I don't question your intent but I don't see how MPAB cannot be sold
or would not have value.
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp
As described in
http://mysqlha.blogspot.com/2010/07/building-mariadb-with-innodb-plugin.html
I did some of the QA checks that I do for any new code that I might
use. I have yet to find buildbot results for valgrind and the InnoDB
plugin or XtraDB. Are they not run for buildbot?
--
Mark Callaghan
There are no results for innodb_plugin.* in
http://buildbot.askmonty.org/buildbot/builders/work-amd64-valgrind/builds/636/steps/test/logs/stdio
On Sun, Jul 25, 2010 at 1:06 AM, Kristian Nielsen
wrote:
> MARK CALLAGHAN writes:
>
>> As described in
>> http://mysqlha.blogspot.co
:
> MARK CALLAGHAN writes:
>
>> There are no results for innodb_plugin.* in
>> http://buildbot.askmonty.org/buildbot/builders/work-amd64-valgrind/builds/636/steps/test/logs/stdio
>
> No, we do not run tests for the innodb_plugin in Buildbot. We run them for
> XtraDB (which sh
SQLCOM_SHOW_USER_BINLOG_STATUS:
> SQLCOM_UNLOCK_DB:
> SQLCOM_STOP_USER_BINLOG_DB:
>
> (as well as some "USER" variants like SQLCOM_START_USER_BINLOG_USER:,
> which should probably abandoned.)
>
> They should probably be changed to something like:
>
> SQLCOM_START_DB_BI
just granted a row lock or other lock
then we want it to run right away. But that might cause X+1 threads to
be running in the thread pool when the limit is X. The difference
between X and X+1 is small. But this could lead to 2*X threads
running. What is the limit?
--
Mark Callaghan
mdc
sed for an index other than the one for which
records_in_range was called and return a large value without doing
index lookups for all but the hinted index.
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria-discu
quot;select * from foobar FORCE INDEX (x1)
where j = 1 and k = 1", packet_length=60) at sql_parse.cc:1321
On Wed, Jan 19, 2011 at 4:15 PM, MARK CALLAGHAN wrote:
> We suspect that our servers do too much extra disk IO in
> ha_innobase::records_in_range to determine selectivity for in
g" on both kb.askmonty.org and askmonty.org
After logging into kb.askmonty.org I get "403 ERROR: Access denied" on
everything including:
http://kb.askmonty.org/v/plans-for-56
http://kb.askmonty.org/v/legal
http://kb.askmonty.org/v/about
--
Mark Cal
s, and avoid compatibility
problems with the client library in MySQL 5.1. Note that this is an
incompatible change between 5.5.10 and earlier 5.5 versions, so client
programs that use the 5.5 client library should be recompiled against
the 5.5.10 client library.
>>>
--
Mark Callagh
ication needs to run many queries in parallel.
>
> - Kristian.
>
> ___
> Mailing list: https://launchpad.net/~maria-discuss
> Post to : maria-discuss@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~maria-discuss
> More h
Will dynamic columns always require the position (column_nr argument)? I
prefer an interface in which that is not required.
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss
The current interface requires a name and a number.
On Mon, Apr 18, 2011 at 3:01 PM, Paul McCullagh wrote:
> Do you mean use a name, instead of a number?
>
> On Apr 18, 2011, at 4:32 AM, MARK CALLAGHAN wrote:
>
> Will dynamic columns always require the position (column_nr argume
column names. If there were a function that
encoded all name-value pairs as JSON, then the client could do
something like this and be able to decode the result:
select column_json(dynamic_column_name) from t where ...
--
Mark Callaghan
mdcal...@gmail.com
dynamic column for
some number of rows. They can select the column but probably won't
know how to decode the name:value pairs stored in it.
Apparently Jakob has code for this. So I don't have much more to add
for this thread.
--
Mark Callaghan
mdcal...@gmail.com
__
I think I want a function that converts the blob into a JSON formatted
set of key-value pairs.
On Wed, Dec 7, 2011 at 9:19 PM, MARK CALLAGHAN wrote:
> On Fri, Dec 2, 2011 at 5:23 AM, Michael Widenius wrote:
>> MARK> How do you fetch all name-value pairs from a dynamic column
More notes on how to get the most (or not) out of MySQL 5.6 during
benchmarks.
http://mysqlha.blogspot.com/2013/04/mysql-56-incomplete-guide-to-avoiding.html
On Wed, Apr 3, 2013 at 6:24 AM, Colin Charles wrote:
> Hi!
>
> Mark Callaghan asks this on Facebook:
> While testing sin
t 14GB from experiments).
>
> Regards,
> Monty
>
> ___
> Mailing list: https://launchpad.net/~maria-discuss
> Post to : maria-discuss@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help : https://help.l
sacrifice a single query than lose the
> whole server.
>
> Jeremy
>
>
> On Wed, Jun 5, 2013 at 3:44 PM, MARK CALLAGHAN wrote:
>
>> On many occasions I have worked with DBAs who really, really wanted a
>> limit on the max on-disk size for implicit and explicit temp table
behavior when the filesystem is full during temp table writes and 2) maybe
a global limit on the amount of disk space that can be used by temp tables.
Per-session limits might not prevent concurrent sessions from causing a
problem.
--
Mark Callaghan
mdcal...@gmail.com
___
st
> MariaDB | t: +6-012-204-3201 | Skype: colincharles
>
>
> ___
> Mailing list: https://launchpad.net/~maria-discuss
> Post to : maria-discuss@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help :
ome full of unearned opinions. Too much
marketing like that will limit your community.
Given Justin's list of problems he encountered, it looks like he earned his
opinion.
On Thu, Sep 26, 2013 at 1:20 AM, Colin Charles wrote:
> Mark,
>
> On 26 Sep 2013, at 16:06, MARK CALLAGHAN wrote:
&
rto Spadim
>
> _______
> Mailing list: https://launchpad.net/~maria-discuss
> Post to : maria-discuss@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help : https://help.launchpad.net/ListHelp
>
>
Regards,
> >
> > Jeremy
> >
> >
> >
> >
> >
> >
> >
> > ___
> > Mailing list: https://launchpad.net/~maria-discuss
> > Post to : maria-discuss@lists.launchpad.net
> > Unsubscribe :
to have?
> >
> Regards,
> Sergei
>
> ___
> Mailing list: https://launchpad.net/~maria-discuss
> Post to : maria-discuss@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help : https:/
Do you have any plans for MDL in MariaDB 10+ that might do something better
for workloads that need to do some DDL concurrent with some long-running
SELECT statements?
https://www.facebook.com/MySQLatFacebook/posts/10151939557456696
--
Mark Callaghan
mdcal...@gmail.com
t; Post to : maria-discuss@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help : https://help.launchpad.net/ListHelp
>
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria-disc
Does the support for virtual columns allow an index to be created on an
attribute in a JSON object stored in a BLOB column?
http://falseisnotnull.wordpress.com/2014/04/25/descending-indexes-in-mariadb
https://mariadb.com/kb/en/virtual-columns/
--
Mark Callaghan
mdcal...@gmail.com
ria-discuss@lists.launchpad.net
> > Unsubscribe : https://launchpad.net/~maria-discuss
> > More help : https://help.launchpad.net/ListHelp
>
> --
> --
> Daniel Black, Engineer @ Open Query (http://openquery.com.au)
> Remote expertise & maintenance for MySQL/MariaDB server
ww.google.com/url?q=http%3A%2F%2Fwww.facebook.com%2Fskysql&sa=D&sntz=1&usg=AFrqEzc4Kk2TUyZinWuhXhn5uMDEfa-TRw>
>> [image: LinkedIn]
>> <http://www.google.com/url?q=http%3A%2F%2Fwww.linkedin.com%2Fcompany%2F1214250&sa=D&sntz=1&usg=AFrqEzezWUya7565tGaMEx0
iately a reason why
> atomic writes would not be possible.
>
>
>
> Do you think this can boost performances for huge TokuDB tables ?
>
>
>
> Atomic will boost performance but only if database is stored on device
> that supports atomic writes.
>
> R: Jan
>
>
g installation
> to give users an option to enable or disable the plugin. With the plugin
> being automatically disabled in non-interactive installations.
>
> Regards,
> Sergei
>
> ___
> Mailing list: https://launchpad.net
t is very compact
> - most of the imported data ends up in the 'data.value' column, and most
> values are zlib-compressed, with also deduplication
> The resulting ibdata is only 70GB.
>
> Is this write amplification only caused by indexes & doublewrite ?
>
> Thanks,
&g
https://www.reddit.com/r/IAmA/comments/47k1si/we_are_rocksdb_developers_ask_us_anything/d0dhd70
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe
rles, http://bytebot.net/blog/
> twitter: @bytebot | skype: colincharles
> "First they ignore you, then they laugh at you, then they fight you, then
> you win." -- Mohandas Gandhi
>
>
> ___
> Mailing list: https://launchpad
__
>> Mailing list: https://launchpad.net/~maria-discuss
>> Post to : maria-discuss@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~maria-discuss
>> More help : https://help.launchpad.net/ListHelp
>>
>
>
MyRocks is coming to MariaDB. I think this is great news for MyRocks and
the MariaDB community. Thank you.
https://jira.mariadb.org/browse/MDEV-9658
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria-discuss
Post to
then
> you win." -- Mohandas Gandhi
>
>
> ___
> Mailing list: https://launchpad.net/~maria-discuss
> Post to : maria-discuss@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help : https:
thing change umlauts?
>>
>> as charsets where introdcued with MySQL 5.0 it was a simple script
>> just to add the correct charset information that it is *not* UTF8 to
>> 5000 tables with not a single char damaged and since we are located
>> in austria üöäß are very common
>>
>
>
MyRocks now supports group commit and XA -
https://github.com/facebook/mysql-5.6/issues/25
On Wed, Oct 12, 2016 at 9:25 AM, MARK CALLAGHAN wrote:
> 0) Sergei and Justin - I prefer to avoid the "Monty says" game either for
> or against. We are trying to establish a community he
xternal storage. Personally, I don't
> like large transactions, and believe that they should be avoided. However,
> some people do use them, and the mysql server should be able to support
> them without crashing, perhaps with degraded performance.
>
> On Wed, Oct 12, 2016 at
has been fixed (would be nice to see some current bench tests).
>
> rr
>
>
> ___
> Mailing list: https://launchpad.net/~maria-discuss
> Post to : maria-discuss@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~maria-discuss
, 2016 at 2:51 PM, MARK CALLAGHAN wrote:
> If your workload is insert-only and you are happy with TokuDB then please
> don't try to migrate. But most workloads have reads concurrent with writes.
> Add that to insert benchmark and TokuDB becomes unhappy. Why do we always
> get result
nchpad.net/ListHelp
>>
>>
>
> ___
> Mailing list: https://launchpad.net/~maria-discuss
> Post to : maria-discuss@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help : https://help.launchpad.net/ListHe
On Thu, Oct 13, 2016 at 4:00 PM, Sergei Golubchik wrote:
> Hi, Ricky!
>
> On Oct 13, Ricky B wrote:
> > Thanks for the write up Colin.
> >
> > I had known about TokuDB potentially being dropped due to lack of
> > developers and support. Understandable, but a real shame. At least
> rocksdb
> > has
With upstream (5.6 and 5.7) MySQL when I use cmake
-DCMAKE_INSTALL_PREFIX=$X, then after I install the build, mysqld searches
in $X/etc for my.cnf. That is not true for MariaDB Server 10.2. Why can't
this match upstream?
--
Mark Callaghan
mdcal...@gmai
t;
> It certainly can. It just doesn't. Because we merge from 5.6 into
> MariaDB feature by feature, and nobody has requested this particular
> feature so far. At least I couldn't find it in Jira.
>
> Regards,
> Sergei
> Chief Architect
the datadir
> was originally created on Windows under MySQL 3.x, got moved in prduction
> for some years to MacOS, later to Linux and now is running MariaDB 10.1
> just fine with the same datadirs and the help of "mysql_upgrade" over the
> years
>
> Am 05.04.2017 um 16
Why do you need to shout about this?
On Wed, Apr 5, 2017 at 10:04 AM, Reindl Harald
wrote:
>
>
> Am 05.04.2017 um 18:57 schrieb MARK CALLAGHAN:
>
>> It is different from upstream MySQL in many ways as that page explains.
>>
>
> bla - if it woul dbe just a recom
I look forward to trying it out.
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https
Rocks tables? I'm planning to convert a few TokuDB tables
> to test MyRocks in production...
>
I am not aware of a tool for that.
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria
On Wed, May 24, 2017 at 12:35 PM, Heinz Wiesinger
wrote:
> On Wednesday, 24 May 2017 18:29:26 CEST MARK CALLAGHAN wrote:
> > On Wed, May 24, 2017 at 12:35 AM, jocelyn fournier <
> >
> > jocelyn.fourn...@gmail.com> wrote:
> > > Hi Mark!
> > >
> &g
B is much bigger than RAM
> (128 GB), RAM should be big enough to contain the active working set.
>
> Julien
>
> ___
> Mailing list: https://launchpad.net/~maria-discuss
> Post to : maria-discuss@lists.launchpad.net
> Unsubscribe
t; ___
> Mailing list: https://launchpad.net/~maria-discuss
> Post to : maria-discuss@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help : https://help.launchpad.net/ListHelp
>
>
--
Mark Callaghan
Yes, please share the my.cnf.
___
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp
message (x
> > 1000's) is happening across all releases in the Sysbench R/W phase.
> >
> > Here is the Sysbench command that drives the workload against MariaDB -
> >
> > sysbench --test=lua/oltp.lua --oltp_tables_count=128
> --oltp-table-size=85937
> > --
wrong.
I think you mentioned something about running sysbench on s390. I would
love to read more about that.
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Do MariaDB 10.2 binaries use glibc malloc or get built with one of tcmalloc
or jemalloc? Sorry for being lazy, as I have yet to install it.
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria
On Tue, Jun 20, 2017 at 9:36 AM, Sergei Golubchik wrote:
> Hi, MARK!
>
> On Jun 20, MARK CALLAGHAN wrote:
> > Do MariaDB 10.2 binaries use glibc malloc or get built with one of
> tcmalloc
> > or jemalloc? Sorry for being lazy, as I have yet to install it.
>
> gli
ow path is
delete one row at a time. In this case, truncate is doing delete one row at
a time for MyRocks in MariaDB but drop/recreate in FB MySQL.
https://groups.google.com/forum/#!topic/myrocks-dev/dhweTwN-9xg
--
Mark Callaghan
mdcal...@gmail.com
___
Ma
/github.com/facebook/rocksdb/issues , any other places?
>
>
> Thanks!
>
> Jocelyn
>
>
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscri
or.
>
> Thanks
> Guillaume
>
> Le dim. 9 juil. 2017 à 22:34, Sergey Petrunia a
> écrit :
>
>> Hello,
>>
>> On Fri, Jun 30, 2017 at 08:58:08AM -0700, MARK CALLAGHAN wrote:
>> > This started as a question on a MyRocks list. MyRocks comes from
>>
, then they fight you, then
> you win." -- Mohandas Gandhi
>
>
> ___
> Mailing list: https://launchpad.net/~maria-discuss
> Post to : maria-discuss@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~maria-discuss
> More
71 matches
Mail list logo