- discuss - lists.mariadb.org

Re: [Maria-discuss] Fwd: [Dbmail] MariaDB and dbmail
by Reindl Harald 03 Sep '13

03 Sep '13

if it would be that easy i am only a guy try to help dbmail and not that good in data details and how to reproduce a valid test set, al i can say is that it wasted a lot of hours to figure out why the machines of the dbmail-developer are beahve differently in case of nsetd mime-messages and that it is caused by MariaDB afetr that i searched my archive for the mail below AFAIK i even tried to bring MariaDB/DBMail community together months ago *please* some MariaDB developers could you connect to dbmail/libzdb to sort out this problem because from the original post below and the feedback of dbmail-developer the query is correct with the terminal client so something goes wrong in combination with libzdb IMHO this *must not* happen if MariaDB claims to be a drop-in-replacemnet Am 02.09.2013 00:44, schrieb Roberto Spadim: > Could you send some data to test? > > Em 01/09/2013 18:37, "Reindl Harald" <h.reindl(a)thelounge.net <mailto:h.reindl@thelounge.net>> escreveu: > > please can someone from the MariaDB developers > MariaDB 5.5.32 is running here on test-machines > > this is todays feedback of the dbmail core-developer and beause > more and more distributions including Fedora/OpenSuSE and AFAIK > even RHEL7 switch to MariaDB this is a *serious* problem which is > not what a "drop-in replacement" should do and a show-stopper > rollout Fedora 19 at all in the near future > > > Anyway, MariaDB doesn't even pass the basic unit-tests > > > > Looks like this maybe libzdb related. The ordering of the query > > retrieving mime parts is ok on the console, but *not* when looping > > over the result in libzdb. > > > > MariaDB is *no-go* at this moment. Just what I experienced a year > > ago or so. I'm sorry, but I don't think I'll hold 3.1.4 for that > > not a regression at all. > > -------- Original-Nachricht -------- > Betreff: Re: [Dbmail] MariaDB and dbmail > Datum: Tue, 02 Apr 2013 19:47:15 +0400 > Von: Sergej Pupykin <ml(a)sergej.pp.ru <mailto:ml@sergej.pp.ru>> > An: DBMail mailinglist <dbmail(a)dbmail.org <mailto:dbmail@dbmail.org>> > > At Thu, 20 Sep 2012 10:46:52 +0800, > zamri <myzamri(a)gmail.com <mailto:myzamri@gmail.com>> wrote: > > MariaDB is fully compatible with MySQL. Migration is done. So far so good. Phewww!... > > > > Now I need to do some research on tuning mariadb if needed. > > I found that after migration following SQL returns wrong sorted data: > > SELECT > l.part_key, > l.part_depth, > l.part_order, > l.is_header, > DATE_FORMAT(ph.internal_date,GET_FORMAT(DATETIME,'ISO')), > data > FROM > dbmail_mimeparts p > JOIN dbmail_partlists l ON p.id <http://p.id> = l.part_id > JOIN dbmail_physmessage ph ON ph.id <http://ph.id> = l.physmessage_id > WHERE l.physmessage_id = <ID> > ORDER BY l.part_key,l.part_order ASC; > > however when I run it from command line it works well. > > Probably it does not fail always because of not all emails damaged. > > Not sure if it caused by migration to mariadb, but problem appeared > near same time.

7 16

[Maria-discuss] User Defined Functions - without C
by Roberto Spadim 03 Sep '13

03 Sep '13

Hi guys, could i write user defined functions using python/php/perl or others languages? any development about this? -- Roberto Spadim SPAEmpresarial

2 1

[Maria-discuss] RFC - CREATE PROCEDURE clauses (question about docs from mariadb-discuss)
by Roberto Spadim 02 Sep '13

02 Sep '13

Hi mariadb-devel guys, could anyone help here in a documentation problem? (maybe not a problem...) *Please answer the BOLD questions* We are talking about CREATE PROCEDURE , about DETERMINISTIC / NO SQL http://dev.mysql.com/doc/refman/5.6/en/create-procedure.html *characteristic*: COMMENT '*string*' | LANGUAGE SQL | *[NOT] DETERMINISTIC* | { CONTAINS SQL | *NO SQL* | READS SQL DATA | MODIFIES SQL DATA } | SQL SECURITY { DEFINER | INVOKER } *--------* *from mariadb-discuss:* *--------* Hi Federico, sorry i read some points and start writing, i will read and write after... i will answer with my experience as an user, not as a mariadb/mysql developer... 2013/9/2 Federico Razzoli <federico_raz(a)yahoo.it> > Hi Roberto > I'll try to be more clear, please read carefully before answering > ok I know what a deterministic expression is - but *what kinds of output must > be deterministic for a procedure to be defined as DETERMINISTIC?* > hummm i don't know, but for procedure, there isn't a deterministic output right? just for funcitons... maybe it's a parser problem, allow deterministic keyword for procedures (must check) i'm thinking about, *why we use deterministic procs, and non deterministic procs?* *this change something important in mysql server? replication, query cache? other performace considerations?* > There are many types of output for a proc: > * OUT params > * SELECTs > * writes on tables > * SET @var > hum.... from what i remember procedure ~= function without return, something like a "void FUNCTION( any parameters )" function ~= a procedure that return values, in other words it must be different from void... that's why i think it's a problem at parser allowing deterministic keyword at procedure, but must check... i don't know if this keyword change something in mysql/mariadb code > For a deterministic proc, do all of these need to be deterministic? > well, for me, procs are always non deterministics since it don't change query cache invalidation and replication (must be done in binary i think) > * I guess the answer isn't easy. > * *yeah, i see, we need a simple answer not a simplified answer* > -- > For "NO SQL" a complete list of SQL statements would be needed. If we use > this as a reference: > http://dev.mysql.com/doc/refman/5.6/en/sql-syntax.html > , even RETURN seems to be a SQL statement, yes, maybe the point isn't the SQL statements list, but other functions that mysql/mariadb server do? i don't know... NO SQL maybe is different from NOSQL (memcache,mongo,etc...) since nosql is newer than mysql procedures the point is *what's NO SQL in CREATE PROCEDURE ?* but of course it can't be true, because it's impossible to write a func > without RETURN. > yeah, maybe we have a problem at docs... let's see if anyone else know about this... maybe we need help from mariadb-devel list, i will include in this email... > > Greetings > Federico > bye =) thanks guys -- Roberto Spadim

1 0

[Maria-discuss] The KB has moved to mariadb.com
by Daniel Bartholomew 02 Sep '13

02 Sep '13

Many people have expressed to me and others working on MariaDB that it would make the most sense for the KB to be located under a MariaDB domain, so I'm happy to report that the KB is now at https://mariadb.com/kb If you've used the KB in the last couple of days, you've probably already noticed this as the change went live over the weekend. We've also updated the colors to match the new look of mariadb.com. We're working on a complete visual refresh to integrate it completely into the look and feel of the new site. But that will come later. For now it's the same KB with slightly different colors under a new domain. All https://kb.askmonty.org/... links should redirect automatically to the correct spot on the new site. Please let me know ASAP via email, IRC, Twitter, G+, or even carrier pigeon if anything isn't working. Thanks! -- Daniel Bartholomew Google+ - http://gplus.to/dbart Twitter - http://twitter.com/daniel_bart 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

2 1

[Maria-discuss] New Question: MariaDB on AIX: am I the first to try to compile?
by AskMonty KB 26 Aug '13

26 Aug '13

Hello, A new question has been asked in "Development" by mamfelt: -------------------------------- Since the current owner of mysql is no longer interested in creating/distributing for and IBM platforms - and, as a joomla user I am accustomed to using mysql as backend I am hoping to package and use mariadb on AIX. So, anyone else who has any (successful) experience with compiling mariadb for/on AIX? If yes, what OS level did you use, and compiler? I am trying with OS 5.3TL7 and AIX 6.1TL7. I will prefer to have it work on AIX 5.3 as that should support AIX 6.1 - but at this point I am just looking for a better starting point. Thanks for reply/comments! -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/mariadb-on-aix-am-i-the-first-to-try-to-compile/

1 0

[Maria-discuss] Idea about a socket betwwen plugins and mysql clients
by Roberto Spadim 26 Aug '13

26 Aug '13

Hi guys, i put a very big and well explained plugin interface for client-plugin comunication using mysql protocol could anyone give comments, ideas or talking if it should be done / or at least some points why it shouldn't? the mdev is at: https://mariadb.atlassian.net/browse/MDEV-4921 thanks! -- Roberto Spadim

1 0

[Maria-discuss] New Question: Hibernate Reverse Engineering wizard with MariaDB
by AskMonty KB 22 Aug '13

22 Aug '13

Hello, A new question has been asked in "MariaDB Documentation" by JohnD: -------------------------------- (Sorry, couldn't find a good place for this query - perhaps there ought to be a folder "MariaDB and ORMs"?) I'm trying to use the Hibernate Reverse Engineering wizard with MariaDB. It's just a very simple example, but I am stuck. I don't see any errors, but it doesn't work as described. Here's what I've got so far: * Windows 7 x64, Eclipse Juno, MariaDB v5.5.3, Hibernate v4.2.3 * I've got an example with Hibernate running using annotations and the same instance of MariaDB, no problem * Now I want to create the classes from the tables, so I'm trying to use the reverse engineering wizard. * I've set up a simple DB and a couple of tables * I've set up a hibernate.cfg.xml file using the same values as my working annotation example * Now I use the wizard (in Eclipse) to "New/Hibernate Reverse Engineering File (reveng.xml)" ** First page ok, second page "Configure Table filters" is where I'm stuck ** I select the correct Console configuration (generated as part of creating the config file) and then press the "Refresh" button ** At this point I should see my two tables in the "Database schema:" column. But it's empty. ** I briefly see "Pending..." - then nothing. ** I can't see any errors. So, how to move forwards? Can I turn on some logging? Where is the error? What logs to check? The Eclipse console window shows a bunch of stuff, all info, no errors and the last three lines are like this: * 2013-08-22 11:34:38,189 DEBUG Worker-33 org.hibernate.connection.DriverManagerConnectionProvider - opening new JDBC connection * 2013-08-22 11:34:38,198 DEBUG Worker-33 org.hibernate.connection.DriverManagerConnectionProvider - created connection to: jdbc:mysql://localhost:3306/omthibernate, Isolation Level: 4 * 2013-08-22 11:34:38,199 INFO Worker-33 org.hibernate.connection.DriverManagerConnectionProvider - cleaning up connection pool: jdbc:mysql://localhost:3306/omthibernate In case it helps, here is the hibernate config (I've tried a lot of variations): {{{ <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"> <hibernate-configuration> <session-factory name="xxx"> <property name="hibernate.connection.driver_class">org.mariadb.jdbc.Driver</property> <property name="hibernate.connection.password">password</property> <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/omthibernate</property> <property name="hibernate.connection.username">user</property> <property name="hibernate.dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property> </session-factory> </hibernate-configuration> }}} -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/hibernate-reverse-engineering-wizard-with-mariadb/

1 0

[Maria-discuss] More secure Kill command
by Roberto Spadim 21 Aug '13

21 Aug '13

hi guys, i hit a problem in this exact second... some programs are running and i want to kill only one big query well i executed kill 17143 ok.. but when i execute this command, the query was done, and starting a second query... in other words... i killed the wrong query could we add a hash information to kill, to make it more secure and precise? for example... kill 17143 md5 "123456789......." where md5 = id + start time of query + others informations to make it relative unique maybe it exists and i don't know... any other idea how to solve this? thanks -- Roberto Spadim

5 19

[Maria-discuss] NoSQL at mysql client
by Roberto Spadim 19 Aug '13

19 Aug '13

Hi guys, i was reading some time ago about memcache (i use it for a long time ~5years or more) and the handler socket plugin Why we don't implement it at mariadb client? instead of a second library to add nosql, why not implement a built in lib? for example... (pseudo functions...) mysql_connect ... (connect to database and have permission handling...) mysql_select_db ... select the schema being used mysql_query ... execute a query command (SQL QUERIES) mysql_fetch ... get a row mysql_num_rows .. get number of rows now the nosql... mariadb_handler_socket_openindex( handler socket parameters ) mariadb_handler_socket_query mariadb_handler_socket_fetch mariadb_handler_socket_close mariadb_memcache_get mariadb_memcache_set ... this make mariadb a sql/nonsql database with a single user/permission schema, and a nice language set (SQL, handler socket, memcache, redis, drizzle, hadoop, mongodb or others...) in this case we can use the mysql protocol, but instead of sending a QUERY command, we send a "MARIADB" command, and a new parameter telling what mariadb command it is, this can be used with mysql/mariadb/percona, when used with others database probably the database will report a wrong command message but we can contact mysql to reserve a command id to "others uses", and have compatibility with any mysql fork... but the point is... instead of many connections (3-> mariadb, handler socket write, handler socket read, or 2 -> mariadb, memcached) we have only one 1-> mariadb comments are wellcome, any idea why not implement this instead of many different protocol libs? -- Roberto Spadim

2 4

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

18 Aug '13

well just to document this thread mail list i found the answer , (thanks federico) https://kb.askmonty.org/en/aria-faq/ aria_log_file_size - *Description:* Limit for Aria transaction log size - *Commandline:* --aria-log-file-size=# - *Scope:* Global - *Dynamic:* Yes - *Data Type:* numeric - *Default Value:* 1073741824

1 0