Comments for lf_hash are sparse. Does it implement a well-known algorithm?
https://github.com/mysql/mysql-server/blob/8.0/mysys/lf_hash.cc
https://github.com/mysql/mysql-server/blob/8.0/include/lf.h
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing
Filed https://jira.mariadb.org/browse/MDEV-11101 but I have no idea who
will fix this. All other engines use less than 20M while tokudb uses 161M
including one file in mysql-test that is more than 30M.
Lots of time, network and disk space is being wasted by this.
--
Mark Callaghan
mdcal
aster like brotli, zstd, snappy.
>
> https://quixdb.github.io/squash-benchmark/#results-table
>
>
> ___
> Mailing list: https://launchpad.net/~maria-developers
> Post to : maria-developers@lists.launchpad.net
> Unsubscribe : https://launchpad
.
>
> Regards,
> Sergei
>
> ___
> Mailing list: https://launchpad.net/~maria-developers
> Post to : maria-developers@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~maria-developers
> More help : https://help.launchp
Unsubscribe : https://launchpad.net/~maria-developers
More help : https://help.launchpad.net/ListHelp
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help : https://help.launchpad.net/ListHelp
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers
-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
___
Mailing list: https://launchpad.net
/ListHelp
--
Mark Callaghan
mdcal...@gmail.com
___
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
...@knielsen-hq.orgwrote:
MARK CALLAGHAN mdcal...@gmail.com writes:
Are there other goals for single-thread performance regressions? There
are
many that have nothing to do with replication code although almost every
single-threaded replication hurts replication.
I am planning to do a general
. An exception is
bottlenecks specific to certain use cases.
Could you send me any relevant information my way if you have it around?
Thanks,
Sergey
On Mon, Jan 20, 2014 at 08:00:45AM -0800, MARK CALLAGHAN wrote:
Are there other goals for single-thread performance regressions
___
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
--
Mark Callaghan
mdcal...@gmail.com
-56-single-threaded-read-only.html
On Fri, Nov 22, 2013 at 12:46 PM, Kristian Nielsen kniel...@knielsen-hq.org
wrote:
MARK CALLAGHAN mdcal...@gmail.com writes:
Resources are finite, but it would be great if MariaDB also did something
about single-thread performance regressions. MySQL has
___
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
--
Mark Callaghan
mdcal...@gmail.com
@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help : https://help.launchpad.net/ListHelp
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers
/fdwhandler.html
http://www.postgresql.org/docs/9.3/static/fdw-callbacks.html
http://www.sqlite.org/vtab.html
On Fri, Sep 6, 2013 at 12:10 PM, Thomas Jones-Low
thomas.jones-...@foundationdb.com wrote:
On 8/13/13 6:41 PM, MARK CALLAGHAN wrote:
Do we need a better API or is the current code good
Unsubscribe : https://launchpad.net/~maria-developers
More help : https://help.launchpad.net/ListHelp
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Mutex contention from various plugins
On Tue, Aug 20, 2013 at 9:12 AM, Pavel Ivanov piva...@google.com wrote:
Workaround for which problem?
On Tue, Aug 20, 2013 at 8:17 AM, MARK CALLAGHAN mdcal...@gmail.com
wrote:
Is the workaround to use static rather than dynamic plugins?
On Tue
-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help : https://help.launchpad.net/ListHelp
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria
it isn't a sign that the API is
something people want to use.
Was TokuMX easier to implement than TokuDB?
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
from people who have done serious storage engine work.
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria
API or is the current code good enough? I hope to hear
from people who have done serious storage engine work.
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers
/**ListHelphttps://help.launchpad.net/ListHelp
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More
___
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
--
Mark Callaghan
mdcal...@gmail.com
on it.
___
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
--
Mark Callaghan
mdcal...@gmail.com
statement_stats or integrate with the PS?
http://dev.mysql.com/doc/refman/5.6/en/performance-schema.html
http://marcalff.blogspot.com/2013/04/on-configuring-performance-schema.html
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https
-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help : https://help.launchpad.net/ListHelp
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria
On Fri, Mar 15, 2013 at 3:50 PM, Axel Schwenke a...@askmonty.org wrote:
Hi Mark,
MARK CALLAGHAN wrote:
I didn't see a big change in going from toci=1 to toci=64. I don't
dispute your results, but I am curious about why it made a difference
for you but not for me. My sysbench test had
/ListHelp
--
Mark Callaghan
mdcal...@gmail.com
___
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
Thanks for the analysis. Filed http://bugs.mysql.com/bug.php?id=68575 for
the frequent rotate problem.
On Tue, Mar 5, 2013 at 2:02 AM, Kristian Nielsen
kniel...@knielsen-hq.orgwrote:
MARK CALLAGHAN mdcal...@gmail.com writes:
http://bugs.mysql.com/bug.php?id=68569
This is the classic semi
://bugs.mysql.com/bug.php?id=68569
http://bugs.mysql.com/bug.php?id=68251
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria
that this hash
function is lousy holds in general, rather than is limited to this input.
And given the large number of machines that run MySQL, MariaDB and Percona
Server (and the FB patch) around the world I suspect that we should figure
this out.
--
Mark Callaghan
mdcal...@gmail.com
://launchpad.net/~maria-developers
More help : https://help.launchpad.net/ListHelp
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https
@work | }
--
Mark Callaghan
mdcal...@gmail.com
___
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
checksums that could use
crc32 instructions on Intel HW. Official MySQL then adding something
like that to one of their new releases.
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria
to the released version in 5.5.
You don't need to maintain the 5.3 version.
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria
and waste time reimplementing things
2) storage engines reuse things they shouldn't
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https
at the small example in the comments below the
description to get a feeling what is the behavior.
I can also send you a patch of the current version in case you want to
play with the feature before it is pushed.
Timour
--
Mark Callaghan
mdcal...@gmail.com
--
Mark Callaghan
The semantics are good for us. The potential overhead from the
implementation isn't a concern for our uses. What was the feedback
from the MPAB code review?
On Fri, Jan 20, 2012 at 7:37 AM, MARK CALLAGHAN mdcal...@gmail.com wrote:
OK, will have feedback in a few days.
On Fri, Jan 20, 2012 at 6
:
Hi!
MARK == MARK CALLAGHAN mdcal...@gmail.com writes:
MARK A warning would be excellent. An error would be a problem. Returning
MARK OK is probably not the best result when the examined limit is reached.
Ok, we will try to develop this feature (with a ok + warning) this year.
(Should
/ListHelp
--
Mark Callaghan
mdcal...@gmail.com
___
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
don't want to do: set session
limit_rows_examined=1000; SELECT /* with rows examined limit */ ... ;
set session limit_rows_examined=0;
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria
. Are you interested in implementing this feature
for me? We will sponsor the work. The purpose of the feature is to
prevent queries from taking too long when there isn't a great index
and many rows might be filtered.
--
Mark Callaghan
mdcal...@gmail.com
On Fri, Sep 23, 2011 at 4:32 AM, Kristian Nielsen
kniel...@knielsen-hq.org wrote:
MARK CALLAGHAN mdcal...@gmail.com writes:
As also discussed in the RethinkDB blogs, one needs to be aware of
performance, as some co-routine implementations (eg. POSIX ucontext) are
inefficient. The use of co
On Fri, Sep 23, 2011 at 4:32 AM, Kristian Nielsen
kniel...@knielsen-hq.org wrote:
MARK CALLAGHAN mdcal...@gmail.com writes:
Why does this need to save/restore thread contexts (setcontext, etc)?
I think that if the library is that hard to change then it should be
fixed or a simpler solution
On Mon, Jun 27, 2011 at 8:24 AM, Michael Widenius mo...@askmonty.orgwrote:
Hi!
MARK == MARK CALLAGHAN mdcal...@gmail.com writes:
cut
MARK Can there be a variant that doesn't do #2? My workload doesn't use
MyISAM
MARK and I don't know if #2 is done because of MyISAM. Calling
MARK
On Thu, Jun 23, 2011 at 1:09 AM, Michael Widenius mo...@askmonty.orgwrote:
Hi!
MARK == MARK CALLAGHAN mdcal...@gmail.com writes:
MARK Per the code in set_var.cc:
MARK /*
MARK Perform a 'FLUSH TABLES WITH READ LOCK'.
MARK This is a 3 step process:
MARK - [1
,my_progname,str); /* purecov: inspected */
DBUG_RETURN(0);
}
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria
: https://launchpad.net/~maria-developers
More help : https://help.launchpad.net/ListHelp
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe
OK, that is what I wanted to know.
On Wed, Apr 6, 2011 at 6:16 AM, Kristian Nielsen
kniel...@knielsen-hq.org wrote:
MARK CALLAGHAN mdcal...@gmail.com writes:
Is commit_ordered called before or after the transaction's XID event
has been written to the binlog?
after it has been forced
The Follow Up button has the same behavior.
On Sun, Mar 13, 2011 at 9:21 AM, MARK CALLAGHAN mdcal...@gmail.com wrote:
Go to a worklog, Scroll down, Click on Add a new comment
This takes me back to the top of the page. This is confusing and now I
must scroll down again to reach the comment text
=180 is moved from the RawIdeaBin to another
bin?
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More
Vamsi,
In the innodb-release-locks-early patch, do you remember why you
release the locks only _after_ the sync in prepare(), and not before?
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria-developers
Post
Fixed email address for Vamsi
On Fri, Feb 18, 2011 at 10:57 AM, MARK CALLAGHAN mdcal...@gmail.com wrote:
Vamsi,
In the innodb-release-locks-early patch, do you remember why you
release the locks only _after_ the sync in prepare(), and not before?
--
Mark Callaghan
mdcal...@gmail.com
faster compression and decompression than zlib
* adding compress_ops and compress_ops_ok per table to
information_schema.table_statistics
* adding an option to limit compression to the clustered index and not
compress secondary indexes
--
Mark Callaghan
mdcal...@gmail.com
When will there be a MariaDB branch based on MySQL 5.5? I want to use
that as the basis for the 5.5 version of the Facebook patch.
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria
On Mon, Dec 20, 2010 at 9:17 PM, Arjen Lentz ar...@openquery.com 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
/commits/121478
___
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
--
Mark Callaghan
We discussed this in Istanbul but were vague. Domas has provided more
details on the problem. Fixing this will make high-concurrency results
much better.
http://bugs.mysql.com/bug.php?id=58037thanks=4
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing
Nielsen
kniel...@knielsen-hq.org wrote:
MARK CALLAGHAN mdcal...@gmail.com writes:
Define properly? I suspect you mean that you want us to spend the
time to get our changes into MariaDB.
No, that is not what I meant. I meant write code, tests, etc. like what you
and I want to see in the MySQL
);
thd-proc_info= closing tables;
/* Free tables */
close_thread_tables(thd);
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https
On Fri, Apr 23, 2010 at 2:35 AM, Kristian Nielsen
kniel...@knielsen-hq.org wrote:
MARK CALLAGHAN mdcal...@gmail.com writes:
This is a really long thread so a summary elsewhere would be great for
people like me.
I agree that the discussion has become quite long. I summarised the group
commit
to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help : https://help.launchpad.net/ListHelp
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria-developers
Post
engine. All of those should be fixed first. If I want to use PBXT (and
I do) then I will stop using InnoDB (and I might).
When will we have cross-engine deadlock detection?
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net
that I think you are asking
for. I have written about the performance problems of pagination and a
workaround in http://www.facebook.com/note.php?note_id=206034210932.
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria
On Fri, Feb 26, 2010 at 1:30 AM, Sergei Golubchik s...@askmonty.org wrote:
Hi, MARK!
On Feb 25, MARK CALLAGHAN wrote:
One other comment. I don't think the official releases are in
launchpad. If they were I imagine this would be easier to do. Of
course, anyone could republish the official
On Fri, Feb 26, 2010 at 6:36 AM, Sergei Golubchik s...@askmonty.org wrote:
Hi, MARK!
On Feb 25, MARK CALLAGHAN wrote:
I know this question is more about official MySQL than MariaDB, but it
is also about sharing code we write at Facebook and all of the patches
we publish can be reused
you do
that.
I'm afraid your only option is to replay your changes on a mysql bzr
branch.
I ended up doing that. Thanks for the advice.
https://code.launchpad.net/~mysqlatfacebook/mysqlatfacebook/5.1
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing
3) publish
But there will soon be a release of 5.1.45 or 5.1.46 and I don't want
to repeat the steps above each time that happens. Do I just publish a
large patch for 5.1.44 - 5.1.4X and get on with my work? Is there a
better way?
--
Mark Callaghan
mdcal...@gmail.com
One other comment. I don't think the official releases are in
launchpad. If they were I imagine this would be easier to do. Of
course, anyone could republish the official releases there.
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https
On Mon, Dec 28, 2009 at 9:20 AM, Sergei Golubchik ser...@pisem.net wrote:
Hi, MARK!
On Dec 25, MARK CALLAGHAN wrote:
InnoDB fixed group commit in the InnoDB plugin. This performs as
expected when the binlog is disabled. This does not perform as I
expect when the binlog is enabled
On Tue, Dec 29, 2009 at 11:07 AM, Sergei Golubchik ser...@pisem.net wrote:
Hi, MARK!
On Dec 29, MARK CALLAGHAN wrote:
On Mon, Dec 28, 2009 at 9:20 AM, Sergei Golubchik ser...@pisem.net wrote:
trn1 start transaction; insert t1 select * from t2;
trn1 commit;
trn1 ... xa_prepare
On Tue, Dec 29, 2009 at 11:23 AM, Sergei Golubchik ser...@pisem.net wrote:
Hi, Paul!
On Dec 29, Paul McCullagh wrote:
On Dec 26, 2009, at 3:40 AM, MARK CALLAGHAN wrote:
* InnoDB locks prepare_commit_mutex in the prepare step
What is the purpose of this lock?
As far as I understand
# fsync done here, group commit may amortize that
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria
On Sat, Oct 24, 2009 at 5:30 AM, Michael Widenius mo...@askmonty.org wrote:
Hi!
MARK == MARK CALLAGHAN mdcal...@gmail.com writes:
cut
MARK 703 1425 2593 4379 4176 4110 maria.nostat
MARK 684 1281 2439 4064 3896 3882 maria.stat
MARK oltp-ro run again
On Wed, Oct 21, 2009 at 3:04 PM, Michael Widenius mo...@askmonty.org wrote:
Hi!
MARK == MARK CALLAGHAN mdcal...@gmail.com writes:
MARK This includes results from sysbench for Maria 5.2 with/without
MARK userstat enabled and for several other binaries. The results are
MARK throughput
concurrent connections per account made the
implementation for SHOW USER_STATS much more complex. Do you want to
continue to support that?
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria-developers
Post
numbers. The fix for this should be
included in the launchpad branch Justin created for global group ids
-- https://code.launchpad.net/~jtolmer/mysql-server/global-trx-ids
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net
On Sun, Jun 7, 2009 at 1:42 AM, Michael Wideniusmo...@askmonty.org wrote:
Hi!
MARK == MARK CALLAGHAN mdcal...@gmail.com writes:
MARK On Tue, May 19, 2009 at 1:26 PM, Giuseppe Maxia g.ma...@gmail.com
wrote:
Hi,
I am doing some tests with Maria. Out of the box, without any tuning
://help.launchpad.net/ListHelp
--
Mark Callaghan
mdcal...@gmail.com
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help : https
79 matches
Mail list logo
