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
Dear All,
Here is another query (table structures are the same as my previous email):
EXPLAIN EXTENDED SELECT
IFNULL(CONCAT(t.sender, '|', t.msg), 'unknown') AS terminate,
c.cid
FROM `c_extra` x FORCE INDEX (`last_update`)
INNER JOIN `c` c USING (`cid`)
LEFT JOIN s_traces t ON(c.cid =
Hi All,
Here is the table structures and query:
CREATE TABLE `c` (
`cid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`c_outcome` int(10) DEFAULT NULL,
KEY `c_outcome` (`c_outcome`),
PRIMARY KEY (`cid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED
KEY_BLOCK_SIZE=8
CREATE TABL
Am 24.03.2014 10:01, schrieb James Qian Wang:
> I have a query which shows type REF when explained in MySQL 5.5/5.6.
>
> However, the same query shows type INDEX in MariaDB 10.0.9
>
> I.e. the query is a lot slower in MariaDB.
>
> Any one has the similar experience please?
>
> Please drop me
Hi All,
I have a query which shows type REF when explained in MySQL 5.5/5.6.
However, the same query shows type INDEX in MariaDB 10.0.9
I.e. the query is a lot slower in MariaDB.
Any one has the similar experience please?
Please drop me a line.
--
James Qian Wang
6 matches
Mail list logo
