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

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 w

Re: [Maria-developers] Performance of index intersection

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

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

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] Deprecate INT(M) in SHOW?

> 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

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

<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 XFS), append is also performin

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

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,

Re: [Maria-developers] cte page

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,

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

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

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

n 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 : jocelyn fournier <jocelyn.fourn...

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

`) 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 applications Le 09/12/2016 à 13:29, jocelyn

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

QL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 0-1-482514272 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic 1 row in set (0.00 sec) HTH, Jocelyn Fournier Founder M

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

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 écrit : joc

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

' Switching back to conservative mode, and all is working properly. Any idea what could be wrong? Thanks! 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 28/11/2016 à 10:10, Kristian Nielsen a écrit : Parallel

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

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

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

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 : revision

Re: [Maria-developers] doubt about read uncommited

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

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

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] [GSoC] self-tuning optimizer

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:

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

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

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

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.

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

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://launchpad.net/~maria

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

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 Kasheffzardo

Re: [Maria-developers] MariaDB 5.2.5

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] really annoying bug in mysql 5.0/5.1 optimiser, opened for more than 2 years, and still present in MariaDB

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: Hi

Re: [Maria-developers] MariaDB 5.2.3

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

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

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 to : maria

Re: [Maria-developers] Ipv6

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 support ? (there's

Re: [Maria-developers] LIMIT optimisations

Hi ! On a bulletin board context, that's quite simple : Let's say we want to display a forum thread containing a lot of posts. To simplify, I have the following table 'posts' which contains : - id_thread - id_post - content - id_author If I want to display a paginated posts list of a given

[Maria-developers] LIMIT optimisations

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