54" "2015-06-21 18:00:00"
"281" "2015-06-21 17:00:00"
# Not valid SQL
SELECT MAX(mail_out_anon+mail_out_auth),timeslice FROM domaincounters
"max(mail_out_anon+mail_out_auth)" "timeslice"
"588" "2015-06-22 16:00:00&quo
Hi Benoit,
If you provide this as a bunch of CREATE TABLE & INSERT statements it'll be
easier for us to look at your problem.
Couple of things...
When you do..
MariaDB [maildb]> select mail_out_anon,mail_out_auth,timeslice from
domaincounters where domain_id=19 order by timeslice desc limit 2
ref
IX_1
IX_1
8
--
1
100
Using where; Using index
So it's a pretty nonsensical query anyway but why is the ORDER BY making the
table elimination impossible?
Cheers,
Rhys
-Original Message-
From: Sergey Petrunia [mailto:ser...@mariadb.com]
Sent: 22 June 2015 14:16
To: Rhy
RE ((`p2`.`col2` = `p1`.`mcol2`)
AND (`p2`.`source` = 'src'))
ORDER BY `p2`.`col3` DESC
LIMIT 1))
ORDER BY `p1`.`col2`;
Rhys Campbell
Database Administrator
TradingScreen, Inc.
23 York House, 5th
“you have to use GROUP BY for it to work as expected.”
Not in this case you don’t. There’s no value in the SELECT to group by.
From: Maria-discuss
[mailto:maria-discuss-bounces+rhys.campbell=tradingscreen@lists.launchpad.net]
On Behalf Of Guillaume Lefranc
Sent: 19 June 2015 10:03
To: Benoi
Hello Benoit,
It might be useful to supply your table definitions. I did the following test
and I can't find a problem. I am using 10.0.19-MariaDB.
CREATE TABLE t1
(
col1 INT, # have also tried defined as VARCHAR. No problem either.
col2 INT
);
INSERT INTO `t1` (`col1`, `col2`
Yep, MSSQL does that too unless I misunderstand you.
Rhys
-Original Message-
From: Federico Razzoli [mailto:federico_...@yahoo.it]
Sent: 12 June 2015 11:37
To: Geoff Montee; Roberto Spadim; Rhys Campbell
Cc: MariaDB discuss
Subject: RE: [Maria-discuss] ON DELETE/UPDATE/INSERT Triggers
i execute an insert, and a delete
2015-06-11 16:07
GMT-03:00 Geoff Montee :
Hi
Rhys,
On Wed, Jun 10, 2015 at 1:23 AM, Rhys Campbell
wrote:
> " This might be better suited as a feature request on the MariaDB JIRA."
>
> I got chastised for do
" This might be better suited as a feature request on the MariaDB JIRA."
I got chastised for doing that before so I'm trying to play nice! ;-)
-Original Message-
From: Geoff Montee [mailto:geoff.mon...@gmail.com]
Sent: 09 June 2015 20:16
To: Rhys Campbell; MariaDB disc
TABEL deleted_ids
(
Id INT NOT NULL PRIMARY KEY
);
INSERT INTO deleted_ids
DELETE FROM t1
WHERE id < 999
RETURNING id;
Rhys Campbell
Database Administrator
TradingScreen, Inc.
23 York House, 5th Floor
London WC2B 6UJ
Email: rhys.campb...@tradingscreen.com<mailto:rhys
: Sergei Golubchik [mailto:s...@mariadb.org]
Sent: 16 May 2015 09:54
To: Rhys Campbell
Cc: maria-discuss@lists.launchpad.net
Subject: Re: [Maria-discuss] MariaDB 10.1.4 Progress output
Hi, Rhys!
On Apr 20, Rhys Campbell wrote:
> Note the progress output below. I've seen several like this. i
system what are the circumstances in which a query may
not make it to the performance schema?
Rhys Campbell
Database Administrator
TradingScreen, Inc.
23 York House, 5th Floor
London WC2B 6UJ
Email: rhys.campb...@tradingscreen.com<mailto:rhys.campb...@tradingscreen.com>
Follow TradingS
ROW_FORMAT=COMPRESSED I get the same results as
I previously poste, i.e. no difference in db size apart from when using lzma.
Cheers,
Rhys
From: Jan Lindström [mailto:jan.lindst...@mariadb.com]
Sent: 14 May 2015 06:14
To: Rhys Campbell
Cc: maria-discuss@lists.launchpad.net
Subject: Re: [Ma
Hi Jan,
That’s for those answers.
For #1 I was dropping and recreating all tables after each change to
innodb_compression_algorithm.
Cheers,
Rhys
From: Jan Lindström [mailto:jan.lindst...@mariadb.com]
Sent: 14 May 2015 06:14
To: Rhys Campbell
Cc: maria-discuss@lists.launchpad.net
Subject
TokoDB is worth a shot certainly if your working set is disk bound.
Partitioning might also be an option for you.
From: Maria-discuss
[mailto:maria-discuss-bounces+rhys.campbell=tradingscreen@lists.launchpad.net]
On Behalf Of Roberto Spadim
Sent: 13 May 2015 17:39
To: Maria Discuss
Subject:
schema not working?
5. ALTER TABLE ... PAGE_COMPRESSED = 1 doesn't work. Must I always do a
full dump & load to enable page compression?
6. Lzma/9 compression is not that impressive. Is it meant to rival
tokudb? (converting to tokudb results in a db size of ~ 54MB an
You cannot use the tx_read_only in the .cnf file. You must specifiy
transaction_read_only = 1 for it to set the value of tx_read_only on system
startup.
Conversely we do not seem to be able to do...
SET SESSION transaction_read_only = OFF;
Is this intended?
Rhys Campbell
Database
Note the progress output below. I've seen several like this. i.e...
Stage: 1 of 72 'altering table' 350% of stage done. Is this intentional?
[cid:image001.png@01D07B7A.526BD6D0]
Rhys Campbell
Database Administrator
TradingScreen, Inc.
23 York House, 5th Floor
London WC2B 6UJ
Em
ith higher
sequence numbers, it probably means that the slave has diverged due to
executing extra errorneous transactions'"
Errorneous should be erroneous
Rhys Campbell
Database Administrator
TradingScreen, Inc.
23 York House, 5th Floor
London WC2B 6UJ
Email:
rhys
ce number 103721589973
2015-02-17 18:03:37 7f53285f8700 InnoDB: Loading buffer pool(s) from
/log/file/path/...
Rhys Campbell
Database Administrator
TradingScreen, Inc.
23 York House, 5th Floor
London WC2B 6UJ
Email:
rhys.james.campb...@googlemail.com<mailto:rhys.james.campb...@googlema
20 matches
Mail list logo
