- discuss - lists.mariadb.org

[Maria-discuss] New Question: Swap usage won't decrease
by AskMonty KB 28 Jun '16

28 Jun '16

Hello, A new question has been asked in "MariaDB FAQ" by alexandraarreaza. Please answer it at http://mariadb.com/kb/en/swap-usage-wont-decrease/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- We have a 5 DB nodes Galera Cluster in Production (MariaDB 10.0). About a week ago a DB import was performed over an existing DB (Its size ~30G) and during this process, all DB nodes started complaining about swap usage and haven't stopped complaining since then (e.g: One of them would be using 814 MB out of 4095 MB). I have read a good few articles about MySQL and swapping issues (this is a good one: https://blog.jcole.us/2010/09/28/mysql-swap-insanity-and-the-numa-architect…) and also about swapping in MariaDB (https://mariadb.com/kb/en/mariadb/configuring-swappiness/) but still can't find out a way of solving this problem without restarting MySQL. We have NUMA architecture with 2 nodes and 96G of RAM. Our buffer pool size is 70G and it is set to use 12 innodb_buffer_pool_instances. 1) Is there any fix to this situation besides restarting MySQL? 2) Is there a way of tuning our cluster to avoid swapping in the future? Thanks. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/swap-usage-wont-decrease/

1 0

[Maria-discuss] columnstore
by Roberto Spadim 28 Jun '16

28 Jun '16

Hi guys! anyone testing columnstore? i will test in a SCADA system this week, news and problems i will report here -- Roberto Spadim

2 2

[Maria-discuss] No Response From MariaDB Support Admin
by Tom Jay 28 Jun '16

28 Jun '16

Hello, I emailed support-admin(a)mariadb.com about a problem with the mariadb.com website. I have not yet received a response. Is there anyone else I can contact with my query? Thanks. Tom

2 1

[Maria-discuss] New Question: Problem Connector ODBC between MariaDB and ACCESS
by AskMonty KB 27 Jun '16

27 Jun '16

Hello, A new question has been asked in "MariaDB Connector/ODBC" by jlpierrey_52563. Please answer it at http://mariadb.com/kb/en/problem-connector-odbc-between-mariadb-and-access/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello, I have a problem with the connection between ACCESS (2010), running with W7, and a MariaDB installed on a Synology NAS (DS212J). Test of DSN is OK. Import and link tables from NAS towards ACCESS are OK. But export from ACCESS is impossible: alert message says: " "ODBC l'appel a échoué (the call failed) [ma-2.0.10][5.5.49-MariaDB]You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '#O),'C_UFR' INTEGER('#O),'U_SECRETARIAT' VARCHAR,'U-2SECRETARIAT' VAR at line 1 (#1064)" I thank you Complementary Infos: The pb is the same with 1.0.6 2.0.10 2.0.11 releases of mariadb connector (32 and 64 bits) C_UFR, U_SECRETARIAT ant U_2SECRETARIAT are the three first fields of the table i try to export. Setting of the NAS: • Serveur : Localhost via UNIX socket • Type de serveur : MariaDB • Version du serveur : 5.5.49-MariaDB - Source distribution • Version du protocole : 10 • Jeu de caractères du serveur : UTF-8 Unicode (utf8) Serveur Web: • nginx/1.9.11 • Version du client de base de données : libmysql - mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ • Extension PHP : mysqli curl mbstring • Version de PHP : 5.6.21 -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/problem-connector-odbc-between-mariadb-and-access/

1 0

[Maria-discuss] New Question: MariaDB Backup using CommVault MYSQL iDataAgent
by AskMonty KB 27 Jun '16

27 Jun '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/mariadb-backup-using-commvault-mysql-idataagent/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Commvault idatagent supports mariadb but i want to know which backup utility scripts are used by idataagent to backup the database. Also does it Backup all storage engines or not? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-backup-using-commvault-mysql-idataagent/

1 0

[Maria-discuss] New Question: MONyog Monitoring when password changed
by AskMonty KB 27 Jun '16

27 Jun '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/monyog-monitoring-when-password-changed/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is it possible to get an alert whenever the user with which we are monitoring changes password in the mariadb database ?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/monyog-monitoring-when-password-changed/

1 0

[Maria-discuss] New Question: Snchronizing MONyog on two servers
by AskMonty KB 27 Jun '16

27 Jun '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/snchronizing-monyog-on-two-servers/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is it possible to monitor MariaDB database from two servers where MONyog is installed and keep them synchronized. By Synchronization i mean if i add a new monitor on one server then that monitor should automatically be added on the second server?? This is important as if one server where monitoring is done goes down MONyog wil stop monitoring the database. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/snchronizing-monyog-on-two-servers/

1 0

[Maria-discuss] Reg .Net with Entity Framework (ORM)
by Karthick Subramanian 27 Jun '16

27 Jun '16

Hi All, We would like to check whether any of you using .Net with Entity Framework to access Maria DB. If yes, 1. What connector is being used 2. What challenges are facing 3. Any other points that I need to take care while workign with .Net Entity Framework with MariaDB Regards, Karthick

3 2

[Maria-discuss] Include TokuDB Hot Backup in the bundled plugin list
by jocelyn fournier 26 Jun '16

26 Jun '16

Hi, In MariaDB, TokuDB is bundled as a plugin, but it's not the case for the Hot Backup plugin (https://github.com/percona/tokudb-backup-plugin) I have to compile it manually against the server source code to have it working properly. Would it be possible to include it in the bundled plugins ? Thanks! Jocelyn -- Jocelyn Fournier Founder M : +33 6 51 21 54 10 https://www.softizy.com Softizy - At your side to Optimize your PHP / MySQL applications

2 1

[Maria-discuss] New Question: Enabling SSL in mariaDB running on Synology NAS
by AskMonty KB 26 Jun '16

26 Jun '16

Hello, A new question has been asked in "Secure Connections" by og_117488504109613889882. Please answer it at http://mariadb.com/kb/en/enabling-ssl-in-mariadb-running-on-synology-nas/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I am having problems with enabling SSL in MariaDB running on Synology NAS (DSM version 6.0) using self signed certificates. I have modified the my.cnf file to point to certificate files and the DB seems to be loading the .cnf file ok, the ssl variables are listing the corect location of the cert files (verified over phpmyadmin) however it still says that ssl is diabled (variable have_ssl=disabled) and the DB is refusing incoming ssl connections. This is my first time working with Synology NAS so I have no idea what to try, so any help or suggestion is most welcome. Thank you in advance. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/enabling-ssl-in-mariadb-running-on-synology-nas/

1 0