Filed as https://github.com/facebook/mysql-5.6/issues/676
On Sun, Aug 06, 2017 at 06:40:41PM +, Guillaume Lefranc wrote:
>
> Yes, it was partitioned as mentioned in the other issue (Actually same
> structure as the one described for the LOAD DATA)
>
BR
Sergei
--
Sergei Petrunia, Software D
On Fri, Aug 04, 2017 at 01:41:42PM +, Guillaume Lefranc wrote:
> I might be able to try again, though I moved to a different database at
> this point.
> But the phenomenon I observed was very high IO for several hours, and the
> table was still not dropped and recreated.
> if TRUNCATE TABLE jus
Hello,
On Fri, Jun 30, 2017 at 08:58:08AM -0700, MARK CALLAGHAN wrote:
> This started as a question on a MyRocks list. MyRocks comes from MariaDB in
> this case and the code that determines whether the truncate table fast path
> is used looks different in MariaDB than in FB MySQL. By "fast path" f
Hello,
On Thu, Apr 06, 2017 at 01:51:09PM -0500, Sales wrote:
> We are noticing many dependent subqueries not working as well as they did on
> Mariadb 5.5, we’re having to add a force index.
>
> Relatively simple example:
>
> explain update Product_Master pm set Total_Inventory = (select
> sum
On Wed, Feb 01, 2017 at 05:25:37PM +0800, Colin Charles wrote:
>
> > On 1 Feb 2017, at 16:40, Ian Gilfillan wrote:
> >
> > Can someone clarify the status of Cassandra in CentOS7? It appears to have
> > been available in 6, but not in 7.
> >
>
> I think the CassandraSE is deprecated. It probab
Hi Reindl,
On Sat, Jan 21, 2017 at 04:28:35PM +0100, Reindl Harald wrote:
> main.analyze_format_json w4 [ fail ]
> Test ended at 2017-01-21 16:23:31
>
> CURRENT_TEST: main.analyze_format_json
> --- /usr/share/mysql-test/r/analyze_format_json.result 2017-01-17
> 20:38:20.0
On Thu, Feb 11, 2016 at 03:43:54PM +0100, azu...@pobox.sk wrote:
> Hi,
>
> we upgraded MariaDB 5.5 to 10.0 on one server last night and are now
> dealing with severe performance issues. Here is one case where it's
> notable:
>
> Query - SELECT b.*, p.category_id FROM brands b JOIN products p
> US
On Mon, Jun 22, 2015 at 01:33:20PM +, Rhys Campbell wrote:
> Ah. That makes a lot of sense, but...
>
>
> Ot.col2 doesn't refer to the PK of the underlying table but it is at the head
> of a unique index (multiple columns)
>
So, the outer query is:
t1 p
LEFT OUTER JOIN t2 ot
On Mon, Jun 22, 2015 at 11:24:39AM +, Rhys Campbell wrote:
> Hello All,
>
> I had an interesting problem presented to me this morning. A seemingly simple
> query was running for ages and filling up /tmp causing MariaDB to crash. Now,
> this isn't perhaps the best designed database but the qu
Hi James,
This looks like a different problem from MDEV-6041 or MDEV-6081.
I've tried to create a dataset to repeat the problem, but I didn't succeed.
Is it possible for you to upload the dataset that shows the problem? If you
don't want to share it publicly, it is possible to upload it to wher
Hi,
For the record:
Analyzing this, I've found https://mariadb.atlassian.net/browse/MDEV-6041 and
https://mariadb.atlassian.net/browse/MDEV-6081.
Both are now fixed in MariaDB 10.0.
On Mon, Mar 31, 2014 at 09:33:17AM +0100, James Qian Wang wrote:
> Here is the table structures and query:
>
> C
11 matches
Mail list logo
