:
Oggetto: Re: [Maria-discuss] MariaDB Server 10.3 notes
A: "Rich Prohaska"
Cc: "Maria Discuss"
Data: Lunedì 17 ottobre 2016, 17:10
With
hyper-v becoming free, the arrival of the Linux subsystem,
and docker for windows 10; there isn't much of an excuse
to proclaim
With hyper-v becoming free, the arrival of the Linux subsystem, and docker
for windows 10; there isn't much of an excuse to proclaim you are unable to
use the Linux binaries. The Redis and Postgres devs are already rejoicing.
___
Mailing list: https://lau
I was a software developer at Tokutek working on TokuDB. If I wanted to
continue working on TokuDB, Tokutek had to make money to pay for the
expenses of running a company. Supporting TokuDB on Windows led to
absolutely no business, so why would I want to waste time supporting it?
We would jump th
2016-10-16 11:38 GMT-02:00 Justin Swanhart :
> Doesn't the Bing team port rocks? Obviously there is interest in support for
> Windows in Redmond, but apparently not for TokuDB.
> The market decides. It has been demonstrated that TokuDB isn't precisely
> general purpose, so the desire to port it
But those people can't use Galera, pt, Xtrabackup... If we care about Windows,
that software should be ported first, because it's general purpose.
Federico
Dom 16/10/16, Tim Callaghan ha scritto:
Oggetto: Re: [Maria-discuss] MariaDB S
Doesn't the Bing team port rocks? Obviously there is interest in support for
Windows in Redmond, but apparently not for TokuDB.
The market decides. It has been demonstrated that TokuDB isn't precisely
general purpose, so the desire to port it is lesser.
Plenty of people run Windows and MySQL
I was just adding context. I agree that Windows is very uninteresting in a
production context, but not having a version of TokuDB for Windows
certainly excluded people (academic and professional) from trying it out on
their laptops.
On Sat, Oct 15, 2016 at 1:10 PM, Reindl Harald
wrote:
>
>
> Am
could you get rid of
* top posting
* convert a plaintext thread to html
* reply all?
Am 16.10.2016 um 04:09 schrieb Roberto Spadim:
There're financial software running windows withoutproblems
that is all nice - but the whole point of a database server which is
reachable over network is that
There're financial software running windows without problems
Em sábado, 15 de outubro de 2016, Reindl Harald
escreveu:
>
>
> Am 15.10.2016 um 17:22 schrieb Tim Callaghan:
>
>> Every time the topic of getting TokuDB to run on Windows the developers
>> could not have run out of the room any faster
Am 15.10.2016 um 23:18 schrieb Igor Babaev:
On 10/15/2016 10:10 AM, Reindl Harald wrote:
Am 15.10.2016 um 17:22 schrieb Tim Callaghan:
Every time the topic of getting TokuDB to run on Windows the developers
could not have run out of the room any faster. :)
frankly what is the purpose of r
On 10/15/2016 10:10 AM, Reindl Harald wrote:
>
>
> Am 15.10.2016 um 17:22 schrieb Tim Callaghan:
>> Every time the topic of getting TokuDB to run on Windows the developers
>> could not have run out of the room any faster. :)
>
> frankly what is the purpose of running MySQL/MariaDB on Windows?
>
eindl Harald ha scritto:
Oggetto: Re: [Maria-discuss] MariaDB Server 10.3 notes
A: maria-discuss@lists.launchpad.net
Data: Sabato 15 ottobre 2016, 19:10
Am 15.10.2016 um 17:22 schrieb Tim
Callaghan:
> Every time the topic of
getting TokuDB to run on Windows the developers
> could n
A lot of things don't run on Windows: Galera, Percona Toolkit, Xtrabackup...
Is this really a problem for MySQL users?
Federico
Sab 15/10/16, Reindl Harald ha scritto:
Oggetto: Re: [Maria-discuss] MariaDB Server 10.3 notes
A: maria-di
Am 15.10.2016 um 17:22 schrieb Tim Callaghan:
Every time the topic of getting TokuDB to run on Windows the developers
could not have run out of the room any faster. :)
frankly what is the purpose of running MySQL/MariaDB on Windows?
who does that in production?
for development?
seriously?
d
Every time the topic of getting TokuDB to run on Windows the developers
could not have run out of the room any faster. :)
-Tim
On Thu, Oct 13, 2016 at 7:49 AM, Peter Laursen
wrote:
> I think Sergei G. told me once that TokuDB would not compile with Visual
> Studio and that MariaDB would only t
Making Percona/MariaDB/MySQL better at sharding, and supporting complex
queries (with MPP capability, window functions, CTE,etc.) would really
compete with an enterprise DB, with RedShift, and with Fabric. Shard-Query
can greatly outperform both the enterprise MySQL Infobright (and MC
ColumnStore)
i read opnions about why choose mysql, and the common point is 'mysql runs
simple queries really fast' i think that's the main feature of mysql
2016-10-14 11:25 GMT-03:00 Reindl Harald :
>
>
> Am 14.10.2016 um 15:21 schrieb Richard Bensley:
>
>> Me and many others had hope that TokuDB would be th
Am 14.10.2016 um 15:21 schrieb Richard Bensley:
Me and many others had hope that TokuDB would be the death of InnoDB in
MariaDB, and the catalyst to a truly amazing open source database.
please fix that "many others" above by saying "some others" - if we
would like a "truly amazing open sour
>
> On Friday, 14 October 2016, Roberto Spadim wrote:
>
>> I don't think (most) guys must migrate from other RDBM, normally they
>> select mysql/mariadb/webscale/etcetc before starting the project, a
>> migration "in the middle" of a project is costly.
>> I agree, there's many open issue at jira/m
On Friday, 14 October 2016, Roberto Spadim wrote:
> I don't think (most) guys must migrate from other RDBM, normally they
> select mysql/mariadb/webscale/etcetc before starting the project, a
> migration "in the middle" of a project is costly.
> I agree, there's many open issue at jira/mysql bug
I don't think (most) guys must migrate from other RDBM, normally they
select mysql/mariadb/webscale/etcetc before starting the project, a
migration "in the middle" of a project is costly.
I agree, there's many open issue at jira/mysql bug report/percona/etc/etc
and others issue tracker systems that
Is anyone surprised by the lack of TokuDB support? Percona is primarily an
Oracle MySQL fork . The InnoDB changes in MySQL 8 represent something
entirely different. Good, but different.
I don't think I am being too speculative when I say, I am sure Oracle are
in no hurry to make MySQL a serious co
Hi all!
On 10/14/2016 11:10 AM, jocelyn fournier wrote:
Hi!
Regarding the TokuDB bugs, they are so far fixed quite quickly by
Percona.
I want to clarify the source of the question (FUD) about Percona not
fixing TokuDB bugs, and hopefully bring it to an end. It apparently
comes from me, sayi
Hi!
Regarding the TokuDB bugs, they are so far fixed quite quickly by
Percona. For example
https://bugs.launchpad.net/percona-server/+bug/1607300 was investigated
and fixed in less than 10 days, and George answered the same day of the
bug report.
And hopefully, the latest remaining patch fr
Hi, MARK!
On Oct 13, MARK CALLAGHAN wrote:
> On Thu, Oct 13, 2016 at 4:00 PM, Sergei Golubchik wrote:
> >
> > There is development and support for TokuDB. The main reason for
> > dropping it could be RocksDB based engine covering all TokuDB use
> > cases, but better. I mean, *if* RocksDB will be
Hi, Pavel!
On Oct 13, Pavel Ivanov wrote:
> > For example, in MariaDB one can use InnoDB
> > for system tables too. Always could, even in 5.5, it's not a new
> > feature. There is no code that limits system tables to a specific
> > storage engine.
>
> This is not true even in MariaDB 10.2:
> http
There is development and support for TokuDB by Percona.
2016-10-14 6:43 GMT+03:00 MARK CALLAGHAN :
>
> 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
hilarious kkk, IMO, a dot net / mono virtual machine could be nice, it can
'compile' php,python,c++/cli,and many others languages to cli (dot net
bytecode) this make things easier
what i think could be useful? a handlersocket like nosql interface, and a
sql interface, that's all a user need to cre
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
> For example, in MariaDB one can use InnoDB
> for system tables too. Always could, even in 5.5, it's not a new
> feature. There is no code that limits system tables to a specific
> storage engine.
This is not true even in MariaDB 10.2:
https://github.com/MariaDB/server/blob/10.2/storage/innobase/
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 a backup tool and some fun snapshot features.
There is development and su
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 a backup tool and some fun snapshot features.
What I really want to know is, what's the future of transactional DDL in
Ma
Wouldn't it be ironic for MariaDB to support java but not MySQL?
Sent from my iPhone
> On Oct 13, 2016, at 3:59 PM, Justin Swanhart wrote:
>
> That is it.
>
> Sent from my iPhone
>
>> On Oct 13, 2016, at 1:17 PM, Roberto Spadim wrote:
>>
>> you are talking about this?
>> https://launchpad
That is it.
Sent from my iPhone
> On Oct 13, 2016, at 1:17 PM, Roberto Spadim wrote:
>
> you are talking about this?
> https://launchpad.net/mysql-wl820/trunk/5.1.33-wl820
>
___
Mailing list: https://launchpad.net/~maria-discuss
Post to : mari
you are talking about this?
https://launchpad.net/mysql-wl820/trunk/5.1.33-wl820
___
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help : http
> 2- I am sure that a lot of people would implement procedures libraries if
>> they could use something like JavaScript or PHP. If we could use Python,
>> stuff like NumPy and SciPy could be used.
>
>
Run a language inside database is something very interesting, normally it's
done with daemon plugi
Antony's work includes a client library change that lets perl/Java/or whatever
run SQL on the THD. The parser was made reentrant, you connect with null
credential and get current THD.
Sent from my iPhone
> On Oct 13, 2016, at 1:01 PM, Andrew Hutchings wrote:
>
>
>
>> On 13/10/16 16:53, Vla
On 13/10/16 16:53, Vladislav Vaintroub wrote:
On 13.10.2016 17:26, Andrew Hutchings wrote:
Whilst I agree it would be a nice feature and something I've heard for
years, the implementation would likely be more complex than it seems.
For starters you have to consider the possibility of a proce
Cheers
Federico
Mer 12/10/16, Sergei Golubchik mailto:s...@mariadb.org>> ha scritto:
Oggetto: Re: [Maria-discuss] MariaDB Server 10.3 notes
A: "Justin Swanhart" mailto:greenl...@gmail.com>>
Cc: "Ma
eeded anymore if external languages are available (arrays in SQL).
Cheers
Federico
Mer 12/10/16, Sergei Golubchik ha scritto:
Oggetto: Re: [Maria-discuss] MariaDB Server 10.3 notes
A: "Justin Swanhart"
Cc: "Maria Discuss"
Data:
t;> estimate the cost of features that the community can develop for you, plus
>> the cost of features that won't be really needed anymore if external
>> languages are available (arrays in SQL).
>>
>> Cheers
>> Federico
>>
>>
>>
>>
>> -
L).
Cheers
Federico
Mer 12/10/16, Sergei Golubchik ha scritto:
Oggetto: Re: [Maria-discuss] MariaDB Server 10.3 notes
A: "Justin Swanhart"
Cc: "Maria Discuss"
Data: Mercoledì 12 ottobre 2016, 14:15
Hi, Justin!
Very good questions,
RocksDB runs on Windows. An external contributor keeps the build from
breaking and uses it on Windows.
On Thu, Oct 13, 2016 at 3:00 AM, Peter Laursen
wrote:
> I have a few questions
>
> 1) will RocksDB be available on Windows? ToduDB isn't (because it does not
> compile on Visual Studio I think)
.. so +1 for Rocks as compared to Toku: cross-platform support.
-- Peter
On Thu, Oct 13, 2016 at 1:49 PM, Peter Laursen
wrote:
> I think Sergei G. told me once that TokuDB would not compile with Visual
> Studio and that MariaDB would only try to fix it in MariaDB if Toku people
> wanted to coll
I think Sergei G. told me once that TokuDB would not compile with Visual
Studio and that MariaDB would only try to fix it in MariaDB if Toku people
wanted to collaborate on this (what they did not). it probably was before
TokuDB was swalloed by Percona .
-- Peter
On Thu, Oct 13, 2016 at 1:36 PM,
On 13.10.2016 12:00, Peter Laursen wrote:
I have a few questions
1) will RocksDB be available on Windows? ToduDB isn't (because it does
not compile on Visual Studio I think).
Personally, I plan to make this happen . At least RocksDB works on
Windows, the port seems to be done by competent pe
Now I remember that the name of the storage engine, I referred, was PBXT.
-- Peter
On Thu, Oct 13, 2016 at 12:00 PM, Peter Laursen
wrote:
> I have a few questions
>
> 1) will RocksDB be available on Windows? ToduDB isn't (because it does not
> compile on Visual Studio I think).
>
> 2) How larg
I have a few questions
1) will RocksDB be available on Windows? ToduDB isn't (because it does not
compile on Visual Studio I think).
2) How large a set of configuraton options will RocksDB have? InnoDB now
has100+ I guess, and that is a mess IMO. I liked the simplicity of the now
dead Primebase (
Golubchik ha scritto:
Oggetto: Re: [Maria-discuss] MariaDB Server 10.3 notes
A: "Justin Swanhart"
Cc: "Maria Discuss"
Data: Mercoledì 12 ottobre 2016, 14:15
Hi, Justin!
Very good questions,
thanks!
Some answers below:
On Oct 12, Justin Swanhart
wrote:
&g
just some ideas...
--
at first time i read plugable parser, and i was thinking that it could
allow nosql (handler socket/memcahce) protocol inside mysql "session"
(connect + auth + allow communicate with server), removing the sql
parser/optimizer without loosing mysql_connect() authentication/secu
Mariadb should understand the comparison between Myrocks and Tokudb, and
let their current users decide what should be in the product. It is their
product and their responsibility. Unfortunately, I am no longer working on
database software as my primary focus, so I can not make any significant
c
And if I sound annoyed when talking about TokuDB performance, I am a bit. I
wish someone else documented the performance problems it has. The problems
are known but not much has been shared to explain them. That has been left
to me as I am promoting the other write-optimized storage engine for MyS
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 results for insert-only iibench but not for insert+query iibench? My
cl
Rich - we have read-free replication although I am not sure on the status
of it -- whether it is done or work-in-progress.
https://github.com/facebook/mysql-5.6/wiki/Read-Free-Replication
On Wed, Oct 12, 2016 at 1:18 PM, Rich Prohaska wrote:
> Hello All,
> Back in the day, I was one of the Tokud
Hello All,
Back in the day, I was one of the Tokudb developers @ Tokutek. Two of the
features that I worked on were read free replication (RFR) and online
schema change for Tokudb.
RFR has some nice slave performance benefits by the replacing read modify
write algorithm with a write algorithm. T
> I am not surprised that there are so few performance results published for
> TokuDB. And when they are published they are almost always for trivial
> workloads -- like insert-only insert benchmark. Try adding queries concurrent
> with the inserts.
True but one can see also in your own comment
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 here. He is one of ma
"Monty says it is trivial" is the oldest running joke in the community. I
heard it in my first talk I attended, about adding data types to MySQL, a talk
given by Brian Aker. :)
But ok. I'll try to be nicer. I really think community is important, and
nobody should be a pariah, or a punching b
0) Sergei and Justin - I prefer to avoid the "Monty says" game either for
or against. We are trying to establish a community here. He is one of many.
His reputation (good or bad) shouldn't be a stick that is deployed to win
arguments.
1) RocksDB has persistent snapshots. That would make flashback
Am 12.10.2016 um 17:34 schrieb Justin Swanhart:
When upgrading from 5.0 -> 5.1 the sort order of some german characters
was modified, which meant indexes had to be rebuilt (they are in sorted
order after all). The mysql_upgrade would suggest a table rebuild
(ALTER TABLE xyz ENGINE=INNODB) or d
Hi,
When upgrading from 5.0 -> 5.1 the sort order of some german characters was
modified, which meant indexes had to be rebuilt (they are in sorted order
after all). The mysql_upgrade would suggest a table rebuild (ALTER TABLE
xyz ENGINE=INNODB) or dump/restore for every affected table. I was a
Am 12.10.2016 um 15:53 schrieb Justin Swanhart:
Also having to dump/restore to go from 10.2 to 10.3 tables is a PITA
it's a simple no-go and the answer to "should i use postgre or
mysql/mariadb" is always "stay away from postgre, while it got better
you need to dump your data and import them
Hi Sergei!
I moved this back to the mailing list, because of your .FRM explanation,
and also because I'd like to explain rasters. A GIS raster is an array of
data represented as a raster image. Rasters have "layers" and each layer
can have a different measurement in it. It is most commonly used
Also having to dump/restore to go from 10.2 to 10.3 tables is a PITA.
Remember how awful it was to migrate all those BDB tables to InnoDB? Or
even just how frustrating it was when UTF8_GENERAL_CI changed the umlaut?
On Wed, Oct 12, 2016 at 9:43 AM, Reinis Rozitis wrote:
> The main reason to dro
The main reason to drop TokuDB would be it being redundant. If MyRocks
and TokuDB would cover, basically, the same use case and MyRocks
would've done it better - then nobody would need TokuDB, right?
But you're saying that they have different use cases and even on the
common use case, MyRocks
On 10/11/16, 12:58 PM, "Maria-discuss on behalf of Colin Charles"
wrote:
>* With MyRocks coming, ...
what an unfortunate name for a database.
tom
___
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Hi, Reinis!
On Oct 12, Reinis Rozitis wrote:
> > * With MyRocks coming, should we drop TokuDB (and maybe even
> > deprecate in 10.2?) - bugs that MariaDB Corporation reports to
> > Percona don't seem to get fixed.
>
> This would be sad if that happened.
>
> Of course I can't say anything about i
Hi, Justin!
Very good questions, thanks!
Some answers below:
On Oct 12, Justin Swanhart wrote:
>
> > * InnoDB: InnoDB native partitioning - so MySQL 8 InnoDB? But Monty
> > says there's next to no changes in InnoDB 8... Instant add column.
> > New InnoDB deadlock detection (8.0). New INFORMATIO
* With MyRocks coming, should we drop TokuDB (and maybe even deprecate in
10.2?) - bugs that MariaDB Corporation reports to Percona don't seem to
get fixed. Peter says that bugs are fixed for customers... and there is
ongoing development to make it better
It is certainly disheartening that Per
Questions comments are inline:
> * InnoDB: InnoDB native partitioning - so MySQL 8 InnoDB? But Monty says
there's next to no changes in InnoDB 8...
Instant add column. New InnoDB deadlock detection (8.0). New
INFORMATION_SCHEMA table (8.0). Dedicated
tablespace for temporary tables (in 5.7 and m
Hi, all!
Thanks, Colin!
Just for the sake of everyone who wasn't present there, I want to remind
that these were discussions and plans, not promises. Nothing of this
(written below) is guaranteed to happen, although certain items have a
high probability of being done as planned.
On Oct 12, Colin
71 matches
Mail list logo
