Re: [Maria-discuss] Nosql language with plugins

2020-05-16 Thread Erik Cederstrand
Hi mailing list moderators, Should I unsubscribe from MariaDB mailing lists now, or will you unsubscribe this person? This language is totally unacceptable and in violation the MariaDB CoC. Kind regards, Erik > Den 14. maj 2020 kl. 19.49 skrev Reindl Harald : > > if you once again are respond

Re: [Maria-discuss] ERROR 1071 with mysql_upgrade

2019-07-17 Thread Erik Cederstrand
> Den 17. jul. 2019 kl. 11.48 skrev Erik Cederstrand : > > Thanks, Jocelyn! > >> Den 17. jul. 2019 kl. 11.28 skrev jocelyn fournier >> : >> It seems this table should be in InnoDB format, not MyISAM (same for >> innodb_table_stats). > > I tried

Re: [Maria-discuss] ERROR 1071 with mysql_upgrade

2019-07-17 Thread Erik Cederstrand
Thanks, Jocelyn! > Den 17. jul. 2019 kl. 11.28 skrev jocelyn fournier > : > It seems this table should be in InnoDB format, not MyISAM (same for > innodb_table_stats). I tried altering the engine to InnoDB but was not allowed. Hmm. Then I decided to just drop the table to have mysql_upgrade cr

Re: [Maria-discuss] ERROR 1071 with mysql_upgrade

2019-07-17 Thread Erik Cederstrand
lls this file somewhere. If it doesn't, you can > extract it from mysql_upgrade with strings, I suppose. > > On Jul 16, Erik Cederstrand wrote: >> Hi, >> >> I'm trying to upgrade a MariaDB 10.2 server to 10.4.6 on FreeBSD. >> >> When running the mysql_

[Maria-discuss] ERROR 1071 with mysql_upgrade

2019-07-16 Thread Erik Cederstrand
Hi, I'm trying to upgrade a MariaDB 10.2 server to 10.4.6 on FreeBSD. When running the mysql_update command, it dies with: $ mysql_upgrade Phase 1/7: Checking and upgrading mysql database Processing databases mysql mysql.column_stats OK mysql.columns_priv

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-07 Thread Erik Cederstrand
Hi Reindl, Den 5. maj 2018 kl. 12.42 skrev Reindl Harald : > > get rid of that damned /etc/init.d/mariadb crap > WTF is "ExecStart=/etc/init.d/mariadb start" > > put your service in /etc/systemd/system/mariadb.service and you are done > > no idea what you did not understand in the ExecStart fro

Re: [Maria-discuss] Dynamically rewrite query

2016-04-21 Thread Erik Cederstrand
> Den 20. apr. 2016 kl. 20.15 skrev Sergei Golubchik : > > On Apr 20, Erik Cederstrand wrote: >> >> CREATE TABLE `t1` ( `i` int(11) NOT NULL, `j` int(11) NOT NULL, `l` >> int(11) NOT NULL, `m` int(11) DEFAULT NULL, PRIMARY KEY >> (`i`,`j`,`l`)); >> >

Re: [Maria-discuss] Dynamically rewrite query

2016-04-21 Thread Erik Cederstrand
> Den 20. apr. 2016 kl. 17.07 skrev Guillaume Lefranc : > > You can use MaxScale : > https://mariadb.com/kb/en/mariadb-enterprise/mariadb-maxscale/maxscale-regex-filter-overview/ Ok, thanks. I'll have a look at it. Erik signature.asc Description: Message signed with OpenPGP using GPGMail ___

[Maria-discuss] Dynamically rewrite query

2016-04-20 Thread Erik Cederstrand
Hello list, I'm administering a MariaDB (10.0.23) backend used by some proprietary software. I'm having trouble with one specific slow query. The tables look like this (simplified for clarity): CREATE TABLE `t1` ( `i` int(11) NOT NULL, `j` int(11) NOT NULL, `l` int(11) NOT NULL, `m` int

Re: [Maria-discuss] Monitoring InnoDB tables?

2016-04-13 Thread Erik Cederstrand
Hello Rhys, Thanks for your suggestions! > Den 13. apr. 2016 kl. 09.48 skrev rhys.campb...@swisscom.com: > > Triggers? You mean create a custom logging table in the customer database? I guess I could do something like this on each table: CREATE TRIGGER insert_event AFTER INSERT ON t1 FOR EA

[Maria-discuss] Monitoring InnoDB tables?

2016-04-13 Thread Erik Cederstrand
Hi list, I'm developing a fast data synchronization tool and need to monitor some tables in a customer's MariaDB (10.1) server for changes. I only have access to the server as a MariaDB client (no filesystem access). Ideally, I would keep a connection open and poll every few seconds - AFAIK, it