Re: [Maria-developers] Ipv6

2010-08-23 Thread Jocelyn Fournier
Hi Sergei, What about INET_ATON / INET_NTOA ipv6 support ? (there's a feature request opened on mysql since jan 2008 : http://bugs.mysql.com/bug.php?id=34037 ) Thanks, Jocelyn Le 23/08/2010 15:47, Sergei Golubchik a écrit : Hi, Dolf! On Aug 23, Dolf Schimmel wrote: My proposal would

Re: [Maria-developers] Ipv6

2010-08-24 Thread Jocelyn Fournier
ange the column type storing my IP values to be able to store 128-bit integers, without changing anything else in the code. Thanks, Jocelyn Le 23/08/2010 18:53, Sergei Golubchik a écrit : Hi, Jocelyn! On Aug 23, Jocelyn Fournier wrote: Hi Sergei, What about INET_ATON / INET_NTOA ipv6 suppo

[Maria-developers] really annoying bug in mysql 5.0/5.1 optimiser, opened for more than 2 years, and still present in MariaDB

2010-08-27 Thread Jocelyn Fournier
p the poor developpers who need to heavily hack there apps with USE INDEX ;) Note I've tested with mariadb 5.2.1-beta, and the bug is still present. Thanks a lot ! Jocelyn Fournier ___ Mailing list: https://launchpad.net/~maria-developers Post

Re: [Maria-developers] really annoying bug in mysql 5.0/5.1 optimiser, opened for more than 2 years, and still present in MariaDB

2010-08-27 Thread Jocelyn Fournier
Thanks a lot Igor ! This will definitly help me to finished to convince my system admins to switch from MySQL to MariaDB ;) Jocelyn Le 27/08/2010 18:04, Igor Babaev a écrit : Jocelyn Fournier wrote: Hi, There's a really annoying bug in the mysql optimiser existing for a really

Re: [Maria-developers] really annoying bug in mysql 5.0/5.1 optimiser, opened for more than 2 years, and still present in MariaDB

2010-09-15 Thread Jocelyn Fournier
Hi Igor, Just curious, is there any bug corresponding to this issue in launchpad ? Thanks ! Jocelyn Le 27/08/10 18:04, Igor Babaev a écrit : Jocelyn Fournier wrote: Hi, There's a really annoying bug in the mysql optimiser existing for a really long time now, and which has a d

Re: [Maria-developers] MariaDB 5.2.3

2010-11-10 Thread Jocelyn Fournier
Hi Daniel, On the release notes page ( http://kb.askmonty.org/v/mariadb-523-release-notes ) the latest link to the changelog still point to 5.2.2 instead of 5.2.3. Cheers, Jocelyn Le 10/11/10 06:06, Daniel Bartholomew a écrit : All, I've created the download, release notes, and changelo

Re: [Maria-developers] really annoying bug in mysql 5.0/5.1 optimiser, opened for more than 2 years, and still present in MariaDB

2010-11-23 Thread Jocelyn Fournier
Hi, Just FYI, it's created as https://bugs.launchpad.net/maria/+bug/639949 I really hope it could be fixed soon, since it could impact mysql performances for a lot of customers. Thanks and regards, Jocelyn Fournier Le 15/09/2010 18:43, Igor Babaev a écrit : Jocelyn Fournier wrote:

Re: [Maria-developers] MariaDB 5.2.5

2011-03-03 Thread Jocelyn Fournier
Hi, The following paths in the Bug Fixes section of the release note http://kb.askmonty.org/v/mariadb-525-release-notes are wrong : http://kb.askmonty.org/v/mariadb-5.2.5-changelog http://kb.askmonty.org/v/mariadb-5.1.55-changelog Regards, Jocelyn Fournier Le 03/03/2011 18:05, Daniel

Re: [Maria-developers] feedback on proposed fix to MySQL bug 57430

2011-05-19 Thread Jocelyn Fournier
Hi, Will this fix also solve the bug http://bugs.mysql.com/bug.php?id=36817 (and reopened in maria as https://bugs.launchpad.net/maria/+bug/639949 ) ? Thanks and regards, Jocelyn Fournier Le 19/05/2011 16:46, Michael Widenius a écrit : Hi! "Zardosht" == Zardosht Kashe

[Maria-developers] MariaDB & InnoDB native aio disabled

2012-04-24 Thread jocelyn fournier
s to start 120425 3:41:09 Percona XtraDB (http://www.percona.com) 1.1.8-24.1 started; log sequence number 33812411088 (no more line saying Linux native AIO is used) Am I missing something ? Thanks and regards, Jocelyn Fournier -- This message was sent from Launchpad by jocelyn fournier (https://lau

[Maria-developers] MariaDB 10.0.6 using more file descriptors than 5.5 ?

2013-11-20 Thread Jocelyn Fournier
_files_limit was set to about 8100 with 5.5, I raised it to 65535 now to fix this issue). Thanks, Jocelyn Fournier ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://

Re: [Maria-developers] MariaDB 10.0.6 using more file descriptors than 5.5 ?

2013-11-20 Thread Jocelyn Fournier
came from an InnoDB DB it could be an issue if you didnt raise the open_files_limit. Here is an explaination on how TokuDB uses filedescriptors : https://github.com/Tokutek/ft-engine/wiki/TokuDB-Files-and-File-Descriptors Regards. On 20/11/2013 15:19, Jocelyn Fournier wrote: Hi, I&#x

[Maria-developers] get is now a reserved word in mariadb 10 ?

2013-11-21 Thread Jocelyn Fournier
on-reference-reservedwords-5-6.html#ftn.idm47406466381872 ) Is there a specific KB entry for MariaDB 10.0.6 reserved words ? (I only see an entry for 5.5 here : https://mariadb.com/kb/en/reserved-words/ ) Thanks and regards, Jocelyn Fournier

Re: [Maria-developers] Fix for TokuDB and parallel replication

2016-12-05 Thread jocelyn fournier
Hi Kristian! Thanks for the fix, I should be able to give it a try sometimes this week. Jocelyn Le 28/11/2016 à 10:10, Kristian Nielsen a écrit : Parallel replication so far did not work well with TokuDB, as some people who tried it found out. I have now pushed to 10.1 some patches to sol

Re: [Maria-developers] Fix for TokuDB and parallel replication

2016-12-09 Thread jocelyn fournier
59547511552 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.001443' at position 1047219058; GTID position '0-1-482509775' Switching back to conservative mode, and all is working properly. Any idea what could be wrong? Thanks! Jocelyn Fournier Founder M : +3

Re: [Maria-developers] Fix for TokuDB and parallel replication

2016-12-09 Thread jocelyn fournier
ing in the log related to the Slave_SQL_Running stopping by itself, while the Slave_IO_Running is still set to Yes. Jocelyn Fournier Founder M : +33 6 51 21 54 10 https://www.softizy.com Softizy - At your side to Optimize your PHP / MySQL applications Le 09/12/2016 à 12:51, Kristian Nielsen a éc

Re: [Maria-developers] Fix for TokuDB and parallel replication

2016-12-09 Thread jocelyn fournier
A_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: NULL Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_I

Re: [Maria-developers] Fix for TokuDB and parallel replication

2016-12-09 Thread jocelyn fournier
last_update`, NEW.`flag_gen`, NEW.`host`) character_set_client: latin1 collation_connection: latin1_swedish_ci Database Collation: utf8_general_ci 1 row in set (0.00 sec) Jocelyn Fournier Founder M : +33 6 51 21 54 10 https://www.softizy.com Softizy - At your side to Optimize your PHP / MySQL appl

Re: [Maria-developers] Fix for TokuDB and parallel replication

2016-12-09 Thread jocelyn fournier
use the dump to abort. Query (0x0): is an invalid pointer Connection ID (thread ID): 5 Status: NOT_KILLED HTH, Jocelyn Fournier Founder M : +33 6 51 21 54 10 https://www.softizy.com Softizy - At your side to Optimize your PHP / MySQL applications Le 09/12/2016 à 15:16, Kristian Nielsen a écrit

Re: [Maria-developers] RFC: new replication feature "per-engine mysql.gtid_slave pos"

2017-03-08 Thread jocelyn fournier
Hi Kristian! Le 08/03/2017 à 09:58, Kristian Nielsen a écrit : Will Fong writes: But even better woulf be if most users did not have to do anything to get the improved performance. Maybe we could just have a hardcoded list of engines that are suitable for mysql.gtid_slave_pos (eg. innodb, toku

Re: [Maria-developers] cte page

2017-04-27 Thread jocelyn fournier
Hi! Le 27/04/2017 à 18:52, Galina Shalygina a écrit : Hi! I'm so sorry for this, I was in a hurry and chose a wrong address to mail:( All in all, thank you! It is still a raw version and I will improve it. Later I will send you a final version in a normal email:) Sorry for this again, Bes

Re: [Maria-developers] 10.2 and merges (e.g. TokuDB)

2017-07-05 Thread jocelyn fournier
Hi Sergei! Le 05/07/2017 à 15:36, Sergei Golubchik a écrit : Hi, Phil! On Jun 25, Phil Sweeney wrote: Hi Sergei, Appreciate you considering other options. Unfortunately in this case it seems Percona did not release a new 5.6 version in time for this 10.1.25 merge. However, interestingly, t

Re: [Maria-developers] MDEV-14425: Is appending never slower than writing to a preallocated file?

2018-02-02 Thread jocelyn fournier
<12:59:17 Disk are 4 Intel SSD 520 (480GB) in Raid5 configuration on controller DELL PERC H710P (tested several times) I've also tested it with 4GB files, and on a slower system (still Intel SSD disks in Raid5 with

Re: [Maria-developers] Deprecate INT(M) in SHOW?

2018-04-23 Thread jocelyn fournier
> Le 23 avr. 2018 à 15:51, Alexander Barkov a écrit : > > Does anybody see any problems if in 10.4 we fix all metadata statements, > such as: > > - SHOW CREATE TABLE t1 > - DESCRIBE t1 > - SELECT * FROM INFORMATION_SCHEMA.COLUMNS > not to print the default length for non-ZEROFILL columns? >

Re: [Maria-developers] [Commits] 190a29d06: Make Lock Tree's lock waits use externally provided mutexes/conditions

2019-03-12 Thread jocelyn fournier
Hi Sergei! Just wondering why keeping the toku_ prefix after renaming toku_* to toku_external_* since it’s also used by other engine like RockDB? BR, Jocelyn Fournier > Le 12 mars 2019 à 09:52, Sergei Petrunia a écrit : > > revision-id: 190a29d06f4e79d2df4cb513944ac34bd133caa0 (

Re: [Maria-developers] Performance of index intersection

2019-09-20 Thread jocelyn fournier
ticSearch / Algolia because the index merge performance is really poor. If we have this missing feature, it could improve a lot performances of such cases! BR, Jocelyn Fournier ___ Mailing list: https://launchpad.net/~maria-developers Post to : mari

Re: [Maria-developers] Performance of index intersection

2019-10-01 Thread jocelyn fournier
Hi Sergey! Actually fetching min & max value for each keys (key1=1 and key2=2 in your case) should not cost much? Then you can compute the overlap zone (Zone B in your graph) and directly perform a jump on the beginning of Zone B and stop at the end of Zone B instead of EOF, using the index wit

Re: [Maria-developers] How to change max key length for MyISAM?

2021-01-15 Thread jocelyn fournier
Just FYI, I confirm Prestashop (at least since 1.6.1.x) is designed to work much better on InnoDB than MyISAM BR, Jocelyn Fournier > Le 15 janv. 2021 à 10:09, Reindl Harald a écrit : > > > > Am 15.01.21 um 09:01 schrieb Luuk: >> On 14-1-2021 21:45, Reindl Harald wrot

Re: [Maria-developers] MariaDB 10.1 is now on github!

2014-05-25 Thread Jocelyn Fournier
Hi Sergei, Do you plan to integrate GitHub commit on JIRA as well ? Thanks, Jocelyn Le 25/05/2014 22:09, Sergei Golubchik a écrit : Hi! I'm happy to announce that MariaDB-10.1 tree has been completely migrated to github. Since now on we'll use github for the new development in MariaDB. It'

Re: [Maria-developers] [Maria-discuss] PERFORMANCE_SCHEMA to be disabled in 10.0 (10.0.12)

2014-06-03 Thread Jocelyn Fournier
Hi, Never used it on production. From my point of view, it should be disabled by default, but included. The whole purpose of this variable is to have a way to analyze/optimize performances easily, when needed; if it's enable by default, we have a perf hit, so that's counterproductive. I assu

Re: [Maria-developers] [GSoC] self-tuning optimizer

2014-06-11 Thread Jocelyn Fournier
Hi, In this case WHERE a > 6 should have a better chance to trigger a full table scan than a > 21. Jocelyn Le 11/06/2014 09:51, Anshu Avinash a écrit : Hi serg, Yes, I had tried that. I had tried many combinations. I have updated the test however on github code: https://github.com/ignitin

Re: [Maria-developers] [Commits] Rev 4275: MDEV-5867 ALTER TABLE t1 ENGINE=InnoDB keeps bad options when t1 ENGINE is CONNECT

2014-07-08 Thread Jocelyn Fournier
Hi, Why not displaying the ignored options as comments ? Jocelyn Le 08/07/2014 11:34, Sergey Vojtovich a écrit : Hi Sergei, frankly speaking I have no better idea. Let's give your patch a try. Regards, Sergey On Tue, Jul 08, 2014 at 10:43:24AM +0200, Sergei Golubchik wrote: Hi, Sergey!

Re: [Maria-developers] [Commits] Rev 4275: MDEV-5867 ALTER TABLE t1 ENGINE=InnoDB keeps bad options when t1 ENGINE is CONNECT

2014-07-08 Thread Jocelyn Fournier
Hi Sergei, Le 08/07/2014 12:25, Sergei Golubchik a écrit : Hi, Jocelyn! On Jul 08, Jocelyn Fournier wrote: Hi, Why not displaying the ignored options as comments ? Jocelyn Good question. This is easy to do, I've just tried. It might look confusing, though, the table

Re: [Maria-developers] doubt about read uncommited

2014-11-24 Thread jocelyn fournier
Hi Jean, Read uncommited is definitly treated differently on TokuDB (no snapshot read). You have a description of the kind of lock taken on TokuDB depending on the isolation level here : https://github.com/Tokutek/tokudb-engine/wiki/Transactions-and-Concurrency Jocelyn Le 25/11/2014 04:

Re: [Maria-developers] [Commits] 4bff8b0: MDEV-7004 - Merge scalability fixes from 10.0-power

2015-05-02 Thread jocelyn fournier
Hi Sergey, Just to be sure, currently MariaDB doesn't implement any Hardware Transactional Memory Built-in Functions ? If so, is there any plan to evaluate the gain they could offer to MariaDB ? Thanks and regards, Jocelyn Fournier Le 04/12/2014 14:45, s...@mariadb.org a écrit : rev

[Maria-developers] LIMIT optimisations

2010-02-17 Thread Jocelyn Fournier
Hi, Following this discussion in 2007 : http://lists.mysql.com/internals/34287 Is there any plan to implement such an optimisation in MariaDB ? (I think a lot of web app using pagination could take benefit of such an optimisation, although there are some workarounds to avoid big LIMIT for pag

Re: [Maria-developers] LIMIT optimisations

2010-03-10 Thread Jocelyn Fournier
e since usually rows in the data file are in the same order than in this specific index. Thanks, Jocelyn Le 10/03/10 21:12, Michael Widenius a écrit : Hi! Catching up with my old emails... "Jocelyn" == Jocelyn Fournier writes: Jocelyn> Hi, Jocelyn&

Re: [Maria-developers] LIMIT optimisations

2010-03-10 Thread Jocelyn Fournier
to improve the current behaviour (like ICP), if it's not already the case (I've not checked this with MySQL 5.5 / Maria yet) Thanks, Jocelyn Le 11/03/10 01:35, MARK CALLAGHAN a écrit : On Wed, Mar 10, 2010 at 4:01 PM, Jocelyn Fournier wrote: Hi ! On a bulletin board context, tha