- developers - lists.mariadb.org

[Maria-developers] log analyzer
by Roberto Spadim 23 Apr '13

23 Apr '13

Hi guys, I was looking for something that give me the 'prepared statement' of a SQL query for example: statment = SELECT * FROM table WHERE field="value" prepared statement = SELECT * FROM table WHERE field=? why do this? well my idea is build a log analyzer and get commong queries since some programs don't use native prepared statement, reading the slow query log, or query log only will give me many different queries what i want is: 1)read queries log 2)get queries 3)get the 'prepared statement' of the query 4)create a table with prepared statement / unique id (maybe md5 of (database name + prepared statement) ) 5)create statistics using the unique id of prepared statement and check if the same 'kind' of queries are running with a mean time, or have some low and high times (for example) or getting information if some index is being used or not, well here i have many ideas but it's not the 'problem' for now the problem is the item (3), i have a query and i need the 'prepared statement' of this query, even the query was not executed with prepared statements this should work for INSERT, DELETE, UPDATE, SELECT, CREATE TABLE and others queries too (for now SELECT is enought, but in future others kinds of query will be nice) anyone know something that could do this job? maybe part of the mariadb query parser could/should be used? i was thinking about a command that could be executed in mariadb, today we have the EXPLAIN, we could have PARSE or other name? simplifying the problem: read the query, parse it and change constant values with "?" willcard thanks! any help is welcome -- Roberto Spadim

1 2

[Maria-developers] MariaDB 10.0.2-alpha release prep
by Daniel Bartholomew 23 Apr '13

23 Apr '13

I've begun prepping MariaDB 10.0.2-alpha for release. Draft changelog and release notes are here: - https://kb.askmonty.org/en/mariadb-1002-release-notes/ - https://kb.askmonty.org/en/mariadb-1002-changelog/ In the draft release notes I've listed MDEV-26 (Global Transaction ID), and the CONNECT handler. Please let me know of other features or fixes I should highlight ASAP. 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 Monty Program - http://montyprogram.com

2 1

[Maria-developers] ALTER TABLE xxx ENGINE=aria, progress only works in copying stage
by Roberto Spadim 21 Apr '13

21 Apr '13

hi guy, i was changing myisam to aria on some big tables (15gb) and show processlist stop reset the progress at 16% the operation started with 'copying to tmp table', and i saw 1%, 2% ... 16% now the table is doing "repair by sorting" and progress is 0% the point is... could the processlist show, at least, the last progress percentage? without get back to 0%? or maybe a column of current operation progress and another of total process operation? does 'repair by sorting' have progress algoritm implemented? i'm running mariadb 10.0.1 on linux 64bits thanks guys -- Roberto Spadim

1 0

[Maria-developers] performance monitoring
by MARK CALLAGHAN 21 Apr '13

21 Apr '13

After reading this I wonder if there is an opportunity for SkySQL and Percona to offer "performance tuning for performance schema" classes. I don't think performance monitoring should be this hard. What are the plans for MariaDB moving forward -- more user_stats/table_stats/index_stats and maybe statement_stats or integrate with the PS? http://dev.mysql.com/doc/refman/5.6/en/performance-schema.html http://marcalff.blogspot.com/2013/04/on-configuring-performance-schema.html -- Mark Callaghan mdcallag(a)gmail.com

2 1

Re: [Maria-developers] Fwd: gsoc13
by Sergei Golubchik 21 Apr '13

21 Apr '13

Hi, Samarth! On Apr 20, Samarth Mathur wrote: > "See also the authentication plugin examples in plugin/auth/." > > I couldn't locate this folder in the source code (mariadb 10). > Does it not exist there? No, but there are mariadb-10.0 $ ls -dl plugin/auth* drwx------ 3 serg serg 4096 Apr 20 10:13 plugin/auth_dialog drwx------ 3 serg serg 4096 Apr 20 10:13 plugin/auth_examples drwx------ 5 serg serg 4096 Apr 20 10:13 plugin/auth_pam drwx------ 3 serg serg 4096 Apr 20 10:13 plugin/auth_socket make your choice. Regards, Sergei

1 0

[Maria-developers] Aria engine integrity
by Roberto Spadim 21 Apr '13

21 Apr '13

Hi guys, another doubt about mariadb, now about aria... i'm using aria since myisam is a bit unsecure and have a slow recovery/repair process, aria storage is more secure my doubt is... could i use aria engine over a ext2 file system and have a 'security' near a jornaled file system (xfs for example) + myisam? or maybe xfs+aria? what's better? just one repair, from aria engine, or two repairs, one from file system and other from aria? thanks guys -- Roberto Spadim

3 3

[Maria-developers] User question
by Roberto Spadim 19 Apr '13

19 Apr '13

hi guys, i read about multi master replication but didn't found examples there's a wiki or an example of how to setup 2 masters and 1 slave replication? using different databases, like: create database db1; (on slave) create database db2; (on slave) master1 will replicate on db1 and master2 on db2 Thanks! -- Roberto Spadim

3 8

[Maria-developers] Enquire
by MAYANK PANDITA 19 Apr '13

19 Apr '13

I am pursuing B.E. C.S.E. I have experience in C, C++ and SQL. I am keen to work on Regex Enhancements and Roles project. I need to know more about these projects. How can I contact the mentors. -- Mayank Pandita

2 1

[Maria-developers] Fwd: LDAP authentication plugin: GSOC Application
by Ionel Merca 19 Apr '13

19 Apr '13

---------- Forwarded message ---------- From: Ionel Merca <mercaexilonx(a)gmail.com> Date: 2013/4/18 Subject: Re: [Maria-developers] LDAP authentication plugin: GSOC Application To: Sergei Golubchik <serg(a)askmonty.org> Hi, Thank you for the response! I have downloaded the source code from https://downloads.mariadb.org/ the 10.0 Series. I followed these steps : I installed cmake and run cmake . , after that I run make and make install... everything worked ok without any errors, but I don't know how can I run the application. I hope this is not a very stupid question but make run is not working or something like that... Regards, Merca 2013/4/18 Sergei Golubchik <serg(a)askmonty.org> > Hi, Ionel! > > On Apr 18, Ionel Merca wrote: > > Hi, > > > > My name is Merca Ionel and I am a student at Politehnica University of > > Bucharest studying Computer Science in the third year. I am interested in > > the project with ldap authentication. I would like to know how can I > > download the source code and what relevant bugs can I fix to prove that I > > am capable of finishing the job. > > MariaDB is Open Source project, you can download the source code easily. > > No need to fix any bugs, just write a good proposal. Don't forget to > show that you understand how LDAP works, and cover how your LDAP > authentication plugin will be different from using MariaDB PAM > authentication plugin together with pam_ldap.so. > > Regards, > Sergei >

2 1

[Maria-developers] [Gsoc] Regex enhancements Project
by Sudheera Palihakkara 19 Apr '13

19 Apr '13

Hi, I'm Sudheera Palihakkara, an undergraduate of Department of Computer Science and Engineering of University of Moratuwa. I'm interested in "Regex enhancements Project" and I need more information to get a clear picture about the project. Can I know what is the regex implementation used in mariadb is it the Henry Spencer's implementation or any newer implementation? And I want to know that is there any developer documentation on this classes present? I did a bit of search but unable to find. thank you. -- *Sudheera Palihakkara.* Undergraduate Department of *Computer Science and Engineering, *Faculty of Engineering, *University of Moratuwa*, Sri Lanka.

2 1