[Maria-discuss] 'Reverse Replication" Rollback Strategy

2019-09-04 Thread Webert de Souza Lima
Hello, I'm currently working on migrating a Galera 10.3 cluster (A) to Amazon RDS. (B) In order to minimize impacts and downtime, the plan is to have a standard MySQL Slave on RDS (B) to sync data, then do the switch to it and stop the replication A->B. The main concern is a catastrophic scenario

Re: [Maria-discuss] MariaDB + RocksDB: MemTables Compactation

2018-09-24 Thread Juan Telleria Ruiz de Aguirre
Thank you for noting that there is no kSnappyCompression Vladislab. Thank you! After some research, I finally ended up with the following my.ini file, in case you find it useful: #

Re: [Maria-discuss] MariaDB + RocksDB: MemTables Compactation

2018-09-10 Thread Juan Telleria Ruiz de Aguirre
I will introduce the following configuration settings to my.ini Configuration File in order to use Bloom Filters, and enable compression. Any further suggestion? Thank you! rocksdb_default_cf_options="block_based_table_factory={filter_policy=bloomfilter:10:false;};prefix_extractor=capped:4};leve

[Maria-discuss] MariaDB + RocksDB: MemTables Compactation

2018-09-03 Thread Juan Telleria Ruiz de Aguirre
Dear MariaDB Developers, I have an issue with RocksDB, as it takes a lot of Memory after performing a Bulk Load, taking almost 30GB of RAM Memory after data ingestion. My question is: ¿How can I flush RocksDB Compactation MemTables after the Data Bulk Load? ¿Is there any FLUSH TABLES ROCKSDB comm

[Maria-discuss] Upgrade error: mariadb 10.1.16 to 10.1.17

2016-09-01 Thread Erik de Waard
Hello, When upgrading from 10.1.16 to 10.1.17 on Debian Jessie i've received the following error: aptitude upgrade dpkg: error processing package mariadb-server-10.1 (--configure): subprocess installed post-installation script returned error exit status 1 Processing triggers for libc-bin (2.19-

Re: [Maria-discuss] mariadb still uses indexes with high average value group size.

2016-01-09 Thread dE
ats on the KB page. Some of these slides could be re-used for the documentation I think : https://www.slideshare.net/mobile/SergeyPetrunya/mariadb-engine-independent-table-statistics-including-histograms dE wrote > Humm.. thanks for clarifying that! > > On 01/04/16 03:20, Ser

Re: [Maria-discuss] mariadb still uses indexes with high average value group size.

2016-01-03 Thread dE
Humm.. thanks for clarifying that! On 01/04/16 03:20, Sergei Golubchik wrote: Hi, dE! On Jan 02, dE wrote: Hi! I was playing around with indexes after we faced problems with mariadb choosing the wrong index because of high average value group size. So I created a table with 4 text

[Maria-discuss] mariadb prefers using indexes despite low cardinality

2016-01-02 Thread dE
Hi! Taking the example as provided in my last mail: I created a table with 4 text columns and indexed the 4th column with a prefix length of 1. To trigger high no. of index scans I used the following where clause -- f4 like 'klas9dufa9us09df8a8%' Explain shows mariadb still chooses to us

[Maria-discuss] mariadb still uses indexes with high average value group size.

2016-01-02 Thread dE
Hi! I was playing around with indexes after we faced problems with mariadb choosing the wrong index because of high average value group size. So I created a table with 4 text columns and indexed the 4th column with a prefix length of 1. Following are the stats in brief -- The index has

Re: [Maria-discuss] Default privileges for anon. user.

2015-02-25 Thread dE
On 02/26/15 09:46, dE wrote: Hi! I've realized that by default MariaDB allow full access to a database for anon. users. $ mysql --user asdfasdf test MariaDB [test]> insert into test (sr) values (1); Query OK, 1 row affected (0.12 sec) I tried to revoke but -- Revoke all on test.t

[Maria-discuss] Default privileges for anon. user.

2015-02-25 Thread dE
Hi! I've realized that by default MariaDB allow full access to a database for anon. users. $ mysql --user asdfasdf test MariaDB [test]> insert into test (sr) values (1); Query OK, 1 row affected (0.12 sec) I tried to revoke but -- Revoke all on test.test from ''@''; ERROR 1141 (42000): There