- discuss - lists.mariadb.org

[Maria-discuss] doubt about aria log files
by Roberto Spadim 17 Aug '13

17 Aug '13

hi guys, i have a very big aria log file how could i change it to don't get sooo big? how could i reduce it size? could i delete it? [adm@agra1 sensors]# ls -l total 383008 drwxrwxrwx 2 mysql mysql 4096 Nov 1 2012 1000_sensors drwxrwxrwx 2 mysql mysql 4096 Nov 1 2012 1000_sensors_log -rw-rw---- 1 mysql mysql 362815488 Ago 17 12:19 aria_log.00000024 -rw-rw---- 1 mysql mysql 52 Ago 17 12:17 aria_log_control -rw-rw---- 1 mysql mysql 18874368 Jun 9 2012 ibdata1 -rw-rw---- 1 mysql mysql 5242880 Jun 9 2012 ib_logfile0 -rw-rw---- 1 mysql mysql 5242880 Jun 9 2012 ib_logfile1 -rwxrwxrwx 1 mysql mysql 13 Dez 27 2010 mysql_upgrade_info -rw-rw---- 1 mysql mysql 4 Dez 8 2012 pbxt-lock ... [adm@agra1 sensors]# du -S 26328352 ./1000_sensors_log 1052 ./1000_sensors 388236 . -- Roberto Spadim

1 0

[Maria-discuss] new kind of plugin
by Roberto Spadim 17 Aug '13

17 Aug '13

Hi guys, I was thinking about a new kind of plugin, a field type plugin... i think it's a relative interesting idea... about sintax: ALTER TABLE table ADD field PLUGIN("plugin_name","version","field_type","parameters") NOT NULL/NULL DEFAULT 'something' AUTOINCREMENT, etc.. an example... ALTER TABLE table ADD field PLUGIN("crypt","1","somecrypto","size=255") NOT NULL DEFAULT 'something' internally (to storage engine) this kind of data will be saved as blob (for example), and to client side it will be a blob too when i use: insert into table(field) values ("some text"); and select * from table i will get "some text" but internally (at filesystem) the value is save as a crypto of "some text" --- other idea is compress ADD field PLUGIN("crypt","1","compress","size=255") NOT NULL DEFAULT 'something' internally it will be saved as varchar(255), when i execute insert it will compress the value and when i select it will uncompress the value the parameters for this new field type is: PLUGIN(plugin name, plugin version, plugin field name, parameters) plugin name is the plugin name... plugin version is important to execute alter table, or when using diferent kind of plugin versions we could know what version is being used and execute a automatic alter table for example... plugin field is the type of field in this plugin parameters are parameters for plugin values another idea is a enum with external table... ADD field PLUGIN("external_enum",'1','enum','table=database.table,id=field_id,value=field_value') it will execute a SELECT internally to table "database.table" and return the id/value of that table id is a bigint/int/mediumint/smallint/tinyint value (like enum index) and value is a string value (varchar,char,longtext,text) to storage engine will be used a bigint, for user it will be used as a enum() field ------ thre's more examples with interesting things, like expand opengis, or add others kind of field types, but the main idea is create a plugin interface for field types what you say guys? bye =) -- Roberto Spadim

3 5

[Maria-discuss] MariaDB 10.0.4 Alpha Now Available
by Daniel Bartholomew 16 Aug '13

16 Aug '13

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.4. This is an Alpha release. It includes new features and bug fixes. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.4 Alpha - Release Notes: https://kb.askmonty.org/en/mariadb-1004-release-notes - Changelog: https://kb.askmonty.org/en/mariadb-1004-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.0.4 About MariaDB 10.0: https://kb.askmonty.org/en/what-is-mariadb-100 APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf (my.ini on Windows) file! See http://kb.askmonty.org/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to MariaDB, please see our "contributing" and "donations" pages. We also have merchandise available in a cafepress store. - https://kb.askmonty.org/en/contributing - https://mariadb.org/en/donate/ - http://www.cafepress.com/mariadb We hope you enjoy MariaDB! -- MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] PHP 5.3 and mariadb 5.5.32 pam auth problem.
by Rafał Radecki 16 Aug '13

16 Aug '13

Hi All. I have: - one devel application server with php53-mysql-5.3.27-1 MariaDB-compat-5.5.32-1.x86_64 MariaDB-common-5.5.32-1.x86_64 MariaDB-shared-5.5.32-1.x86_64 MariaDB-client-5.5.32-1.x86_64 - one devel database server with MariaDB-compat-5.5.30-1.x86_64 MariaDB-server-5.5.30-1.x86_64 MariaDB-common-5.5.30-1.x86_64 MariaDB-shared-5.5.30-1.x86_64 MariaDB-client-5.5.30-1.x86_64 When I try to make a connection from devel to database server with php mysql_connect function then when I am using: - user with local authentication: connection is ok; - user with pam/ldap authentication I get error "Client does not support authentication protocol requested by server; consider upgrading MariaDB client error 1251" When I use mysql command on application server I can connect to the database server with both users, so only php does not work. Have you got similar issues? Any clues anout how to solve the problem? Best regards, Rafal Radecki.

2 1

[Maria-discuss] New Question: how can i transfer data use cursor
by AskMonty KB 16 Aug '13

16 Aug '13

Hello, A new question has been asked in "MariaDB Documentation" by bhdbing: -------------------------------- in MariaDB the cursor can't be a output datatype, generally in Oracle ,i declare a cursor and use it for transfer data,the sample like: ...rs out sys_refcursor... open rs for select * from %table name%; ... in c#,the cursor rs can be accepted,so i can get the whole data from %table name%. in MariaDB,how can i do this? -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/how-can-i-transfer-data-use-cursor/

1 0

[Maria-discuss] New Question: Timestamps are different
by AskMonty KB 14 Aug '13

14 Aug '13

Hello, A new question has been asked in "Replication, Cluster, & Multi-Master" by confidus: -------------------------------- I am in the very early stages of testing out our Galara cluster with innodb databases. I have a tool that is comparing data against each node on the cluster and I have found that timestamps seem to be the only thing that is inconstant and by exactly 5 hours. I have a record in a Galera cluster that has a field with date time. I took one database and started comparing each table (one by one). I had several thousand records with different timestamps. An example is 2013-07-03 11:13:59, but another server, the date time is 2013-07-03 16:13:59. I would suspect that the times would be synced everywhere exactly the same. If I run a "SELECT NOW();" on all four servers at the same time, I see: +---------------------+ | NOW() | +---------------------+ | 2013-08-13 14:59:51 | +---------------------+ +---------------------+ | NOW() | +---------------------+ | 2013-08-13 14:59:51 | +---------------------+ +---------------------+ | NOW() | +---------------------+ | 2013-08-13 14:59:51 | +---------------------+ +---------------------+ | NOW() | +---------------------+ | 2013-08-13 14:59:51 | +---------------------+ If I run a select @@global.time_zone, @@session.time_zone on all four nodes in the cluster, I also see +--------------------+---------------------+ | @@global.time_zone | @@session.time_zone | +--------------------+---------------------+ | SYSTEM | SYSTEM | +--------------------+---------------------+ And if I enter date on all 4 machines, the time matches just fine. I have checked other non erip databases (some very large databases) and things are correct within those systems. [root@a2 ~]# mysql -u root -p********** -h a2 -e "select * from safeplan_new1.plan_approval where plan_approval_id=3247" +------------------+----------------+------------------+------------------------+------------------+---------------------+----------------------+ | plan_approval_id | plan_master_id | plan_location_id | plan_approval_location | plan_approval_by | plan_approved_on | plan_approval_status | +------------------+----------------+------------------+------------------------+------------------+---------------------+----------------------+ | 3247 | 292 | 0 | 155 | 133 | 2013-07-03 11:13:59 | 1 | +------------------+----------------+------------------+------------------------+------------------+---------------------+----------------------+ [root@a2 ~]# mysql -u root -p********** -h a3 -e "select * from safeplan_new1.plan_approval where plan_approval_id=3247" +------------------+----------------+------------------+------------------------+------------------+---------------------+----------------------+ | plan_approval_id | plan_master_id | plan_location_id | plan_approval_location | plan_approval_by | plan_approved_on | plan_approval_status | +------------------+----------------+------------------+------------------------+------------------+---------------------+----------------------+ | 3247 | 292 | 0 | 155 | 133 | 2013-07-03 16:13:59 | 1 | +------------------+----------------+------------------+------------------------+------------------+---------------------+----------------------+ [root@a2 ~]# mysql -u root -p********** -h a4 -e "select * from safeplan_new1.plan_approval where plan_approval_id=3247" +------------------+----------------+------------------+------------------------+------------------+---------------------+----------------------+ | plan_approval_id | plan_master_id | plan_location_id | plan_approval_location | plan_approval_by | plan_approved_on | plan_approval_status | +------------------+----------------+------------------+------------------------+------------------+---------------------+----------------------+ | 3247 | 292 | 0 | 155 | 133 | 2013-07-03 16:13:59 | 1 | +------------------+----------------+------------------+------------------------+------------------+---------------------+----------------------+ -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/timestamps-are-different/

1 0

[Maria-discuss] New Question: flush host
by AskMonty KB 14 Aug '13

14 Aug '13

Hello, A new question has been asked in "FLUSH commands" by h725: -------------------------------- i have looking for info how to 'read' info which are the hosts that hit the max_connect_errors. I have found there was a patch of Jeremy Cole, but i have not found anything for Mariadb. Is there a way to know which hosts increase the max_connect_errors?? any from SHOW or information_schema? thanks a lot -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/flush-host/

1 0

[Maria-discuss] New Question: use trigger for create table
by AskMonty KB 14 Aug '13

14 Aug '13

Hello, A new question has been asked in "MariaDB Documentation" by bhdbing: -------------------------------- as the title,does this db can do this? i want change my db from ORACLE to MariaDB,some problem appeared. and how to use sqlstring? in ORACLE use sql='%some sentences%'; and executed immediate, how it does in MariaDB? so my email:bhdbing@163.com,Thank you for your help! -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/use-trigger-for-create-table/

1 0

[Maria-discuss] Question about MariaDB Non-blocking Client
by Mike Gibson 07 Aug '13

07 Aug '13

Greetings, I'm using the MariaDB Non-blocking API to write a C++ client, but I've hit a wall regarding connection checking. I've been referencing the binding from node-mariasql ( https://github.com/mscdex/node-mariasql/blob/master/src/binding.cc). My app parses a config and creates new objects for each query, where each object has a MYSQL struct and MYSQL *pointer. Then, for each I set state to STATE_CONNECT and call doWork(). This works fine, when I can connect right away. The problem I'm experiencing is if I have a connection and kill the server (/etc/init.d/mysql stop) and then start it back (/etc/init.d/mysql start), I can never get clean reconnects. It's usually a mixture of errcode 2058, 2003, 2013. I'm really confused how to gracefully manage connections. Before I was using the official MySQL C++ connector, and it provides a connection->isConnected() method. I'm wondering how I can get something similar with MariaDB's client, as I need the non-blocking interface. Given: MYSQL mysql, *mysqlHandle; Look at the mysql_real_connect_start() or cont() functions. I provide MYSQL struct and on connect I get a copy of the struct stored in *mysqlHandle. It's not clear to me what the purpose of the copy is at this point as I still use the initial struct to call query(). In the case that I can detect a disconnection, how do I properly clean up the connection and attempt reconnect? Do I mysql_close(&mysql) and/or mysql_close(mysqlHandle), shutdown/close the file descriptor, mysql_init() a new handle and go through mysql_real_connect_start/cont()? Does it even make sense for each object to have its own MYSQL struct that I mysql_init(), or would it be better to have layer on top that mysql_init()s a single MYSQL struct, connects, and passes the returned *mysqlHandle to each query? Thanks for providing the async client, any help is appreciated.

2 2

[Maria-discuss] New Question: Web Applications do not receive all data in Galera Cluster
by AskMonty KB 07 Aug '13

07 Aug '13

Hello, A new question has been asked in "Replication" by confidus: -------------------------------- Hello, I have a real strange issue. I have a web application that appears to not show the correct records. I am using a load balancer for a web farm for a billing system. I am also using a load balancer for the Galera cluster. When a trouble ticket is generated, sometimes that ticket is not available on all the web servers, but when I look at each individual MariaDB server, I see the record. Data commits are synced and all looks good from the cluster side of things. I can perform a mysqldump to another database and point the billing system to that database and all is good. If I reboot each MariaDB server one by one, things start working again. It almost seems like there is some caching where the database cluster at times only shows records that were generated by that web server. I did check that all the web servers in the farm are using the same load balanced ip address for the MariaDB farm and they are. I have replicated this on two different web applications (A CRM & Billing system) both on different web farms. -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/web-applications-do-not-receive-all-data-in-galer…

1 0