Re: [Maria-developers] Memory barrier problem in InnoDB/XtraDB mutex implementation causing hangs

2015-05-22 Thread Stewart Smith
y incorrect (uses the wrong barriers), but > it happens to generate the correct assembler code on x86 due to its rather > strong memory ordering. > > It is probably still incorrect for some other architectures (eg. multi-core > ARM). What about POWER? It's officiall

Re: [Maria-developers] MDEV-6885 - debs do not build on PPC64 in lp:maria/5.5

2014-11-11 Thread Stewart Smith
many problems with > our debian packaging - all these fixes looks right, and still need > twenty iterations to actually be right. What's the issue with oqgraph building? Is it something boost related? I think I recall some issues with some Boost versions (perhaps only on pp64le) but I cou

Re: [Maria-developers] MariaDB 10.0 on POWER

2014-10-14 Thread Stewart Smith
ally pretty easy to spot using perf on POWER, and my suspicion is that the 10% perf difference is made up of a couple of things like this and shouldn't be tooo hard to claw back. -- Stewart Smith pgpyFlnyChvY9.pgp Description: PGP signature ___ Ma

Re: [Maria-developers] Debian packaging - option to enable feedback plugin

2014-05-20 Thread Stewart Smith
t to participate (depending on installation method). Another solution is to have feedback plugin as package that you just install and it gets enabled (by putting config in /etc/mariadb.d/ or something). -- Stewart Smith pgpz1635kfW6T.pgp Description: PGP signature

Re: [Maria-developers] linking an external library

2013-08-19 Thread Stewart Smith
rg writes: > I want to link an external library for a language extension. After several > hours of trying to tell cmake (^%$@*&) to pick it up for linking the > library would still not be built with. did you remove the CMakeCache.txt file? CMake is garbage like that. --

Re: [Maria-developers] RFC: Compile-time checking for unmatched DBUG_ENTER/LEAVE via unused variable

2013-08-07 Thread Stewart Smith
haven't looked at the produced code). Personally, looks good and I'm tempted to pull it into Percona Server. -- Stewart Smith pgpDSwJn4niGi.pgp Description: PGP signature ___ Mailing list: https://launchpad.net/~maria-developers Post to

Re: [Maria-developers] some bugs in dingqing parallel replication

2013-07-22 Thread Stewart Smith
ounds like a bug we fixed in Percona Server a while ago. filtered replication is kinda awful and when we started to poke at it, it pretty much never worked properly. It may be that this is not specific to this replication patch. -- Stewart Smith pgpRgqk2I7BNH.pgp Description: PGP signature ___

Re: [Maria-developers] More enum values in enum fields

2013-07-16 Thread Stewart Smith
he legacy format, that would be a very clear break in any on-disk compatibility with MySQL. -- Stewart Smith pgpaeGCzt7XsK.pgp Description: PGP signature ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.lau

Re: [Maria-developers] More enum values in enum fields

2013-07-16 Thread Stewart Smith
and easy implement new features, example in json > we can add a new item in object just put ", 'new item':'some value'", > i don Schemaless isn't necessarily a feature - protobuf has the benefit of enforcing a schema (XML would work too... parsing time was a conc

Re: [Maria-developers] More enum values in enum fields

2013-07-16 Thread Stewart Smith
x27;s do it next month, shouldn't take more than a > couple of weeks". > > Still, never happened. Happened in Drizzle, IIRC it was about 6 months of work for the bulk of it. -- Stewart Smith pgpWQvUN1Nuft.pgp Description: PGP signature __

Re: [Maria-developers] More enum values in enum fields

2013-07-16 Thread Stewart Smith
t. > humm i read something about protobuf, but is it human readable? You can outptu it as human readable fairly easily, it's otherwise a compact binary format that's generally much quicker to parse than human readable. k -- Stewart Smith pgpo

Re: [Maria-developers] More enum values in enum fields

2013-07-09 Thread Stewart Smith
this though. It appears there's some code in MariaDB to construct server data structures from a SQL statement though, so perhaps that's more usable. -- Stewart Smith pgpYbrwEa6brw.pgp Description: PGP signature ___ Mailing list: h

Re: [Maria-developers] More enum values in enum fields

2013-07-09 Thread Stewart Smith
Roberto Spadim writes: > humm interesting, does mariadb have the same bugs of mysql? or it's updated > like drizzle? Same limitations as MySQL due to FRM file format. -- Stewart Smith pgpCLC5Ocnmjg.pgp Description: PGP signature ___ M

Re: [Maria-developers] More enum values in enum fields

2013-07-09 Thread Stewart Smith
ept in memory, and going to that many is going to mean a *big* chunk of memory that will be always used. It's much better to do the join and be done with it, it'll end up being a lot more efficient. -- Stewart Smith pgpEsXGcVUL9Q.pgp Description: PGP signature ___

Re: [Maria-developers] I_S plugin doubts

2013-06-12 Thread Stewart Smith
. If it's greater than max_heap_table_size it'll be converted to MyISAM/Maria. -- Stewart Smith pgpyXmRXcwKPo.pgp Description: PGP signature ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscrib

Re: [Maria-developers] I_S plugin doubts

2013-06-12 Thread Stewart Smith
les are first materialised into a MEMORY or MyISAM (or, with MariaDB, possibly Aria) table and then the queries run on them. There is no INFORMATION_SCHEMA storage engine. -- Stewart Smith pgphRmHaVJtpo.pgp Description: PGP signature ___ Mailing list:

Re: [Maria-developers] An invalid memory access bug in HandlerSocket

2013-05-09 Thread Stewart Smith
t not being a giant hole into your database server. -- Stewart Smith pgp2UARLQ5VUk.pgp Description: PGP signature ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchp

Re: [Maria-developers] Aria engine integrity

2013-04-20 Thread Stewart Smith
ecovery time for the database. -- Stewart Smith pgptnNk0rmDe2.pgp Description: PGP signature ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-deve

Re: [Maria-developers] what pros/cons of storing binary log in an InnoDB table?

2013-01-28 Thread Stewart Smith
te buffer. I could never reconcile myself with this. Mind you, it performs really quite well due to the reduced fsync()s and (at least in Drizzle code) was rather trivial to implement. Big bang for buck :) -- Stewart Smith pgp5gG0zbzgFF.pgp Description: P

Re: [Maria-developers] 答复: 答复: 答复: MDEV-520: consider parallel replication patch from taobao patches

2013-01-10 Thread Stewart Smith
or all replication up to that point to be committed, and then do the MyISAM operation. (as there's no reason why other replication couldn't be applied at the same time... after all, MyISAM isn't crash safe so would never be consistent with InnoDB txns). -- Stewart Smith pgptrrWThqpI3

Re: [Maria-developers] FYI: More ha_cassandra benchmark data

2012-09-23 Thread Stewart Smith
NDB, both strategies saw performance improvement. -- Stewart Smith pgp2LHNSUj8YM.pgp Description: PGP signature ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://lau

Re: [Maria-developers] Thoughts on Global Transaction ID, parallel slave, and multi-source replication

2012-08-10 Thread Stewart Smith
Kristian Nielsen writes: > Stewart Smith writes: > >> Idea: if txn touches more than one database, record as metadata the >> position of other db, so slave just has to wait for at least that id to >> be applied in other database before applying this txn in this >

Re: [Maria-developers] Thoughts on Global Transaction ID, parallel slave, and multi-source replication

2012-08-10 Thread Stewart Smith
Kristian Nielsen writes: > Stewart Smith writes: > >> Kristian Nielsen writes: >>> https://mariadb.atlassian.net/browse/TODO-171 >> >> this seems to be private, and I can't view even having created a JIRA >> account. > > Oops :-( Very sorr

Re: [Maria-developers] Thoughts on Global Transaction ID, parallel slave, and multi-source replication

2012-08-10 Thread Stewart Smith
Sergei Golubchik writes: > On Aug 10, Stewart Smith wrote: >> >> > Suppose we instead make the decision on the _master_ on how to split >> > up the replication stream for parallel apply. Instead of a single >> > server-id for the master, we can have multipl

Re: [Maria-developers] Thoughts on Global Transaction ID, parallel slave, and multi-source replication

2012-08-09 Thread Stewart Smith
der (though sequences may be > interleaved differently) - so changing masters is simpler, all servers in the > hierarchy have the same view. How would this work with a cross database transaction that depends on previous transactions in both database?

Re: [Maria-developers] Streamlining Buildbot builds

2012-08-07 Thread Stewart Smith
his isn't necessarily the case, different GCC versions etc do catch different things. Every time somebody suggests building on a subset, we find another issue like this (early) soo... I wonder if you tempt fate the same way we do :) -- Stewart Smith pgpyRUclz

Re: [Maria-developers] Feature request: Add support for a syntax check for SQL scripts

2011-10-13 Thread Stewart Smith
ck the SQL syntax but also if all mentioned tables, columns etc. > exists in the given database. This (of course) won't always work. ALTER TABLE ADD COLUMN and then mention that column. As an alternative, maybe start up a local server and load data in it to te

Re: [Maria-developers] mysql improvement idea - field type "file"

2011-05-20 Thread Stewart Smith
tores blobs sep from main table, gives http interface. -- Stewart Smith ___ 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

Re: [Maria-developers] Documentation for Percona patch for row-based replication of pk-less tables

2011-01-12 Thread Stewart Smith
this year entitled "Fixed in Drizzle" and it's going to require a bunch of research as we didn't always keep a singular comprehensive list (especially non user-visible things). -- Stewart Smith ___ Mailing list: https://launchpad.net/

[Maria-developers] [PATCH] Make innodb_bug57255.test 10-20 times faster

2010-12-06 Thread Stewart Smith
Real simple patch, makes the test run much faster if using a real storage device without libeatmydata. patch should be appliable (just change the path) revno: 2477 committer: Stewart Smith branch nick: update-innobase timestamp: Tue

Re: [Maria-developers] Handling size_t -> int conversions

2010-08-18 Thread Stewart Smith
way things go. Better to be able to bisect back to the problem then go "somewhere in this 600kb diff". -- Stewart Smith ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe

Re: [Maria-developers] what can go wrong with this code?

2010-06-04 Thread Stewart Smith
o the client? > Commit or rollback was done before a response was sent to the client. One thing this means is that you have to do stupid things managing memory with BLOBS... but that's just excessive memory usage rather than errors. -- Stewart Smith

Re: [Maria-developers] [Bug 314570] Re: update is not changing internal auto increment value

2010-06-04 Thread Stewart Smith
epends on what the correct behaviour of auto_increment columns is meant to be. For comparison, it looks as though NDB has taken the "MyISAM is correct" path and done the update (I read source, didn't actually try it :) To me, updating the aut

Re: [Maria-developers] Ideas for improving MariaDB/MySQL replication

2010-05-14 Thread Stewart Smith
ts for DDL (i.e. anybody that isn't you, at the same version). -- Stewart Smith ___ 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

Re: [Maria-developers] [Drizzle-discuss] Learning Storage Engine API

2010-04-19 Thread Stewart Smith
serve as examples of how to (or not to) write bits... -- Stewart Smith ___ 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

Re: [Maria-developers] Learning Storage Engine API

2010-04-19 Thread Stewart Smith
plexity... For basic DML, you can check out CSV for probably the most basic yet functional implementation. -- Stewart Smith ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe

Re: [Maria-developers] LOCK_plugin in pbxt_init()

2010-03-02 Thread Stewart Smith
r alive" at most: a) connects to socket b) runs "SELECT 1;" and none of them actually check the storage engine you're using is okay. -- Stewart Smith ___ Mailing list: https://launchpad.net/~maria-developers Post to :

Re: [Maria-developers] request for advice on managing a mysql patch in bzr

2010-02-28 Thread Stewart Smith
to quilt, but with the added bonus of each "patch" is revision controlled. It also has the benefit of each rebase on a new version uses bzr merge algorithms, so it should mean less work. Check out "Maintaining a series of patches against software from tarb

Re: [Maria-developers] "Diff too large for email" problem

2010-02-16 Thread Stewart Smith
sh to launchpad and link the branch with the task being worked on (we use blueprints on launchpad, which has a specific field for this). you could also use 'bzr send' type things in the commit mails, so you could even apply the commit mails and merges

Re: [Maria-developers] Storage Engine API changes

2009-07-08 Thread Stewart Smith
at introduces cursors needs > architecture work and prototyping. I fear we will end up with > 3 disparate storage engine APIs in Drizzle, MySQL and MariaDB. The current aim is to remove things that obviously aren't related to a cursor and move them up. e.g. create table is

Re: [Maria-developers] Storage Engine API changes

2009-07-08 Thread Stewart Smith
ameters should take care of the only retreiving/setting certain columns. Although that still leaves optimiser things... which is another project altogether :) -- Stewart Smith ___ Mailing list: https://launchpad.net/~maria-developers Post to : m

Re: [Maria-developers] Storage Engine API changes

2009-07-08 Thread Stewart Smith
On Wed, Jul 08, 2009 at 03:53:15AM -0400, Peter Benjamin Volk wrote: > Stewart Smith wrote: > > The idea being to move the handler to be a cursor on a table, with > > actions not pertaining that to reside in StorageEngine (e.g. DDL). > > > That sounds like an interesting

[Maria-developers] Storage Engine API changes

2009-07-08 Thread Stewart Smith
n the same way? -- Stewart Smith ___ 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

Re: [Maria-developers] Bug tracker for MariaDB

2009-07-06 Thread Stewart Smith
could be useful here too - linking back to MySQL bug tracker or Drizzle bug tracker (launchpad). -- Stewart Smith ___ 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

Re: [Maria-developers] [Merge] lp:~maria-captains/maria/maria-xtradb into lp:maria

2009-07-06 Thread Stewart Smith
atomics for xtradb by default. We have some headers in drizzle so we get atomic ops through the SunStudio provided way as well (or gcc). may want to look it up for better Solaris perf. -- Stewart Smith ___ Mailing list: https://launchpad.net/~maria-develo

[Maria-developers] Cmake changes

2009-05-16 Thread Stewart Smith
Antony mentioned on IRC about CMake changes that let you not use config.js and other nasty things when building on Win32 (and Win64). These are all just in the MySQL Cluster branch - namely 7.0. Who knows when this gets back into any mainline branch though... -- Stewart Smith

Re: [Maria-developers] ptr_compare replace with memcmp and associated performance

2009-05-11 Thread Stewart Smith
he gcc builtin. -- Stewart Smith ___ 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

Re: [Maria-developers] MariaDB + PBXT

2009-05-11 Thread Stewart Smith
and merged over the pbxt files that already exist (in the MariaDB and > Drizzle/PBXT trees)? That may not be the best... probably lots of conflicts on files and having to work out which is right (and conflicts on directory paths too). best to extract patches you want, commit upst

Re: [Maria-developers] MariaDB + PBXT

2009-05-10 Thread Stewart Smith
automatically tests a PBXT commit against current Drizzle and MariaDB. Hope this helps -- Stewart Smith ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~

[Maria-developers] ptr_compare replace with memcmp and associated performance

2009-05-08 Thread Stewart Smith
f seconds\n", do_test (repetitions, speed_loop)); printf ("Testing loop32 "); fflush (stdout); printf (" done, %10.3f seconds\n", do_test (repetitions, speed_loop32)); printf ("Testing loop64 "); fflush (stdout); printf (" done, %10.3f second