Thanks but it's not going to work for my use case.
Rhys
Sent from my Samsung Galaxy smartphone.
Original message
From: Justin Swanhart greenl...@gmail.com
Date: 09/07/2015 18:20 (GMT+01:00)
To: Campbell Rhys, INI-TPD-QPM rhys.campb...@swisscom.com
Cc:
Hello All,
I've been playing with mysqlbinlog today. I'm Looking at performing backups of
the binary logs.
The MariaDBhttps://mariadb.com/kb/en/mariadb/mysqlbinlog-options/ mysqlbinlog
lags behind the MySQLhttps://mariadb.com/kb/en/mariadb/mysqlbinlog-options/
version in the sense it's
: Maria-discuss
[mailto:maria-discuss-bounces+rhys.campbell=swisscom@lists.launchpad.net]
On Behalf Of Roberto Spadim
Sent: Wednesday, September 23, 2015 4:06 AM
To: Maria Discuss
Subject: [Maria-discuss] doubt about merge table (1+) with same structure
Hi again guys :)
i'm with a new problem
command either
but it does seem to function...
CREATE TABLESPACE rhys ADD DATAFILE 'rhys.ibd' ENGINE = InnoDB; (MariaDB
10.0.20)
Cheers,
Rhys
-Original Message-
From: Maria-discuss
[mailto:maria-discuss-bounces+rhys.campbell=swisscom@lists.launchpad.net]
On Behalf Of Colin
Hi All,
I'm doing some stuff with the performance_Schema and have a quick question
about event types.
These appear in the events_statements_summary_by_account_by_event_name table
(and others) and look like...
statement/com/Ping
statement/sql/select
statement/sql/insert
statement/sql/commit
Hi All,
This weekend I had to repair a replication problem on one of our clusters. I've
attempted to get to the root cause but not sure where I can go from here.
Replication broke on Friday night because of foreign key errors. I initially
retrieved the correct row, restarted replication, which
+rhys.campbell=swisscom@lists.launchpad.net]
On Behalf Of azu...@pobox.sk
Sent: Thursday, February 11, 2016 3:44 PM
To: maria-discuss@lists.launchpad.net
Subject: [Maria-discuss] Performance issues after upgrading to 10.0
Hi,
we upgraded MariaDB 5.5 to 10.0 on one server last night and are now
There’s a foreign key on this table you’re trying to create. There’s something
up with the definition of that, different engines or perhaps a data type.
Rhys
From: Maria-discuss
[mailto:maria-discuss-bounces+rhys.campbell=swisscom@lists.launchpad.net]
On Behalf Of Lukas Lehner
Sent
Just a quick idea... Perhaps you can include an additional field in the unique
index containing the length on the string. So
Str,str_len
'a',1
'a ', 2
Unq index on (str, str_len).
Rhys
-Original Message-
From: Maria-discuss
[mailto:maria-discuss-bounces+rhys.campbell
-
From: Maria-discuss
[mailto:maria-discuss-bounces+rhys.campbell=swisscom@lists.launchpad.net]
On Behalf Of Erik Cederstrand
Sent: Wednesday, April 13, 2016 9:25 AM
To: maria-discuss@lists.launchpad.net
Subject: [Maria-discuss] Monitoring InnoDB tables?
Hi list,
I'm developing a fast data
Triggers?
Yes. I ran a system like this using triggers for all insert/update/delete
records replicating data between MySQL and MSSQL. A PHP script was used to copy
the changes between systems. Sounds a little nuts but it worked very well for a
smallish (< 10GB) dataset.
Performance_schema ->
Hi All,
For the following statement...
ALTER ONLINE TABLE dom_audit_event ENGINE=INNODB, ALGORITHM=INPLACE;
I can still see that MariaDB is still using the value of tmpdir. We have this
set to tmpfs on some of our servers and this causes some ALTER statements on
big tables to fail. It was my
3 AM, Sergei Golubchik <s...@mariadb.org> wrote:
>
> Hi, Rhys.Campbell!
>
>> On May 04, rhys.campb...@swisscom.com wrote:
>> Hi All,
>>
>> For the following statement...
>>
>> ALTER ONLINE TABLE dom_audit_event ENGINE=INNODB, ALGORITHM=INPLACE
Message-
From: Sergei Golubchik [mailto:s...@mariadb.org]
Sent: Tuesday, July 26, 2016 5:38 PM
To: Campbell Rhys, INI-ON-FIT-TSO-QPM <rhys.campb...@swisscom.com>
Cc: maria-discuss@lists.launchpad.net
Subject: Re: [Maria-discuss] Finicky syntax with RETURNING?
Hi, Rhys.Campbell!
On
-bounces+rhys.campbell=swisscom@lists.launchpad.net]
On Behalf Of Karthick Subramanian
Sent: 09 February 2017 13:44
To: Maria Discuss <maria-discuss@lists.launchpad.net>
Subject: [Maria-discuss] ROLE and DEFAULT DATABASE
Hi,
Can anyone assist me on this below:
I have a database called appdb.
of DCC capability).
Cheers,
Rhys
From: Maria-discuss
[mailto:maria-discuss-bounces+rhys.campbell=swisscom@lists.launchpad.net]
On Behalf Of Karthick Subramanian
Sent: Wednesday, September 07, 2016 6:59 PM
To: Maria Discuss <maria-discuss@lists.launchpad.net>
Subject: [Maria-discus
Hi All,
Do we have any estimation of the release of 10.0.28?
Regards,
Rhys
___
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help :
[mailto:maria-discuss-bounces+rhys.campbell=swisscom@lists.launchpad.net]
On Behalf Of Lukas Lehner
Sent: Monday, October 24, 2016 3:18 PM
To: Maria Discuss <maria-discuss@lists.launchpad.net>
Subject: [Maria-discuss] workaround for MDEV-9688
Hi
https://jira.mariadb.org/browse/MDE
Hello All,
I recently upgraded to MariaDB 10.0.28 and I am having sporadic issues with
semi-sync replicating timeouts. Lots of these are logged
[ERROR] Read semi-sync reply network error: (errno: 1159)
[ERROR] Semi-sync master failed on net_flush() before waiting for slave reply
Is anyone
Perhaps the CONNECT engine is worth a shot?
https://mariadb.com/kb/en/mariadb/connect-table-types-overview/
-Original Message-
From: Maria-discuss
[mailto:maria-discuss-bounces+rhys.campbell=swisscom@lists.launchpad.net]
On Behalf Of Roberto Spadim
Sent: Thursday, December 08
AND Date_format(entry_time, '%H') < 24 )) ) )
This asks for all days and all hours from 0-23 (excluding 24). You could
simplify this a lot. Might help the parser out.
Rhys
From: Maria-discuss
[mailto:maria-discuss-bounces+rhys.campbell=swisscom@lists.launchpad.net]
On Behalf
Hello All,
I've been using the userstats plugin do debug an application issue and I think
there's a bug in the collection of statistics, or at least a case of bad
wording...
https://mariadb.com/kb/en/mariadb/user-statistics/
DENIED_CONNECTIONS - The number of connections denied to this user.
-bounces+rhys.campbell=swisscom@lists.launchpad.net]
On Behalf Of Karthick Subramanian
Sent: 07 June 2017 11:09
To: Maria Discuss <maria-discuss@lists.launchpad.net>
Subject: [Maria-discuss] Time Zone help
All,
I am facing some strange issue, I believe its due to my ignorant, would
appr
You're not making a lot of sense here. Please explain the "ambiguity". That's a
fairly complex query so you should include as text.
"Does not work" <- In the image. It helps if you include error message.
From: Maria-discuss
[mailto:maria-discuss-bounces
dData4w.`4w ACOS`,
AdData1w.`1w ACOS`, AdData4w.`4w CPC`, AdData1w.`1w CPC`, AdData4w.`4w Bid`,
AdData1w.`1w Bid`
Obviously I don’t have the table structure and data to profile this but this
look like this is going to be a killer query.
Cheers,
Rhys
From: Maria-discuss
[mailto:maria-discus
://www.youdidwhatwithtsql.com/innodbbufferpage-queries/2041/
-Original Message-
From: Maria-discuss
[mailto:maria-discuss-bounces+rhys.campbell=swisscom@lists.launchpad.net]
On Behalf Of Michael Caplan
Sent: 15 June 2018 14:48
To: Maria Discuss
Subject: [Maria-discuss] Chewing Through
rking with MySQL/MariaDB.
As I recall the documentation does warn you not to change the mysql table to
another other engine. Has anyone else tried?
Rhys
-Original Message-
From: Maria-discuss
[mailto:maria-discuss-bounces+rhys.campbell<mailto:maria-discuss-bounces%2Brhys
It's failing to allocate memory the innodb buffer pool. Check your memory usage
/ total ram / add more ram
-Original Message-
From: Maria-discuss
[mailto:maria-discuss-bounces+rhys.campbell=swisscom@lists.launchpad.net]
On Behalf Of Turritopsis Dohrnii Teo En Ming
Sent: 22 October
ia-discuss-bounces+rhys.campbell=swisscom@lists.launchpad.net]
On Behalf Of marki
Sent: 16 November 2018 17:44
To: maria-discuss@lists.launchpad.net
Subject: [Maria-discuss] 100% CPU on simple queries when join_buffer_size is
large
Hey,
Server version: 10.0.35-MariaDB SLE 12 SP1 here
I have
t set
the definer to some other account."
https://mariadb.com/kb/en/library/create-view/
The user can probably just remove this stuff if the defaults will work for them.
Rhys
From: Maria-discuss
[mailto:maria-discuss-bounces+rhys.campbell=swisscom@lists.launchpad.net]
On Behalf Of Th
/
From: Maria-discuss
[mailto:maria-discuss-bounces+rhys.campbell=swisscom@lists.launchpad.net]
On Behalf Of Conor Murphy
Sent: 11 December 2018 01:27
To: maria-discuss@lists.launchpad.net
Subject: Re: [Maria-discuss] Large query performance degrade after converting
table from MyISAM
Try an index on (proxid, time). I would look at the EXPLAIN from the MYISAM
table for why.
Have you tuned your config for innodb at all? i.e. innodb cache, open files etc.
Rhys
From: Maria-discuss
[mailto:maria-discuss-bounces+rhys.campbell=swisscom@lists.launchpad.net]
On Behalf
Innodb indexes FK's automatically. You don't want to drop these indexes.
From your log it looks like something went wrong with one of these index drops.
You could look inside the frm file to see if one of the old ones is still
define.
You probably want to restore form backups or look at
In general I advise avoiding all replication filtering where possible. For
whatever advantage it supposedly gives it very often just causes other problems.
Checkout pt-table-checkum for verifying your slaves…
https://www.percona.com/doc/percona-toolkit/LATEST/pt-table-checksum.html
Also have a
The "system user" identifies internal tasks spawned by the server. See here...
https://stackoverflow.com/questions/10330159/mysql-system-user
Never tried to create a user called this so no idea if it's reserved... but not
really a good idea anyway.
Rhys
-Original Message-
From:
First step check your error log.
Rhys
From: Maria-discuss
On
Behalf Of mingming1 yu
Sent: 03 June 2019 11:13
To: maria-discuss@lists.launchpad.net
Subject: [Maria-discuss] mariadb 10.3.15 doesn't work
Hi Expert,
I encounter below issue with mariadb 10.3.15, any suggestions?
BTW, it works
Perhaps you can use one of the file_summary_*/other tables in the
performance_schema to identify the query causing this?
R
-Original Message-
From: Maria-discuss
On
Behalf Of Sergei Golubchik
Sent: 07 August 2019 13:42
To: Kevin DG
Cc: maria-discuss@lists.launchpad.net
Subject: Re:
Might be worth having a look at TokuDB https://mariadb.com/kb/en/library/tokudb/
From: Maria-discuss
On
Behalf Of JCA
Sent: 07 October 2019 21:03
To: Kenneth Penza
Cc: Mailing-List mariadb
Subject: Re: [Maria-discuss] Performance tuning sought for MariaDB
On Mon, Oct 7, 2019 at 12:12 PM
The innodb_buffer_pool_size is just one memory setting of many. MariaDB will
allocate additional memory for other things.
Here's a good place to start…
https://mariadb.com/kb/en/mariadb-memory-allocation/
From: Maria-discuss
On
Behalf Of ragul rangarajan
Sent: 09 November 2021 15:34
To:
Hello All,
I'm back working with MariaDB again after a break of some years. While InnoDB
Online-DDL had appeared when I was working with it, it was still sometimes a
challenge to manage schema changes for very large tables.
https://mariadb.com/kb/en/innodb-online-ddl-overview/
Can anyone
40 matches
Mail list logo