- discuss - lists.mariadb.org

[Maria-discuss] Please help me clear this simple but critical issue [SELECT INTO OUTFILE LOCAL]
by Cool Guy 20 May '10

20 May '10

MySQL is awesome! I am currently involved in a major server migration and previously, our small database used to be hosted on the same server as the client. So we used to do this : SELECT * INTO OUTFILE .... LOAD DATA INFILE .... Now, we moved the database to a different server and SELECT * INTO OUTFILE .... no longer works, understandable - security reasons I believe. But, interestingly LOAD DATA INFILE .... can be changed to LOAD DATA LOCAL INFILE .... and bam, it works. I am not complaining nor am I expressing disgust towards MySQL. The alternative to that added 2 lines of extra code and a system call form a .sql script. All I wanted to know is why LOAD DATA LOCAL INFILE works and why is there no such thing as SELECT INTO OUTFILE LOCAL? I did my homework, couldn't find a direct answer to my questions above. I couldn't find a feature request @ MySQL either. If someone can clear that up, that had be awesome! I am planning on suggesting MariaDB to our company cos' it is not under Oracle's admin. Does MariaDB already have this "SELECT INTO OUTFILE LOCAL .." feature implemented or is it in the wishlist/to-do list? Thank you, Kiran

3 14

[Maria-discuss] Someone from MariaDB to talk at ODTUG conference?
by Henrik Ingo 11 May '10

11 May '10

Hi all I just had a talk with Sheeri about an upcoming Oracle Developer Tools User Group conference in June in Washington. There will be a 1 day MySQL track on Sunday, plus possibly some other MySQL talks: http://www.odtugkaleidoscope.com/agenda.html Sheeri was asking if someone from Monty Program (or, imho any MariaDB activist) wanted to present. Things to note: - The conference is application developer oriented, so things like optimizer internals or tuning InnoDB buffer size is not interesting. - We don't want to talk about MariaDB per se. We don't want to introduce this crowd to the reality of there being so many MySQL forks. The previous points pretty much rule out everything we presented at the MySQL conference :-) Good topics could be: - Efficient and inefficient SQL queries in MySQL - UDF tutorial and examples The first suggestion is imho good. These Oracle experts need to learn to avoid certain things like most subqueries, and how to work around that. But on the other hand this is a natural topic for someone from us to present, since we could then also mention that correlated subqueries will work creat in MariaDB 5.3, which may even be beta by this point? The second suggestion is an example of something that would be considered very technical topic in this conference. Now the question is who to send there? This is not significant enough that someone from Europe would fly in - heh, most of us would probably not volunteer themselves at this point :-) In US I see Bryan or Daniel as candidates for this, Igor possibly for the UDF kind of talk more than the app developer talk. And, it needn't be a Monty Program employee, let me know if you're interested. Colin, will you pick this up from here? henrik -- email: henrik.ingo(a)avoinelama.fi tel: +358-40-5697354 www: www.avoinelama.fi/~hingo book: www.openlife.cc

1 1

[Maria-discuss] PBXT issues
by Alexandre Almeida 06 May '10

06 May '10

Hi Guys, I am setting an enviroment with MariaDB + PBXT, but, I am pretty much disappointed. Do you know if this time (see below) makes sense? Five hours to create a PBXT table with 10mio records... It's too much!!! See my steps: create table telpbxt like telinno; Query OK, 0 rows affected (0,50 sec) fis-> alter table telpbxt engine = pbxts; Query OK, 0 rows affected, 1 warning (0,07 sec) Records: 0 Duplicates: 0 Warnings: 0 fis-> alter table telpbxt engine = pbxt; Query OK, 0 rows affected (0,26 sec) Records: 0 Duplicates: 0 Warnings: 0 fis-> show create table telpbxt; +--------- +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +--------- +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | telpbxt | CREATE TABLE `telpbxt` ( `cpf` bigint(20) DEFAULT NULL, `nome` varchar(100) DEFAULT NULL, `log` varchar(100) DEFAULT NULL, `endereco` varchar(100) DEFAULT NULL, `comp1` varchar(100) DEFAULT NULL, `comp2` varchar(100) DEFAULT NULL, `bairro` varchar(100) DEFAULT NULL, `cidade` varchar(100) DEFAULT NULL, `cep` varchar(100) DEFAULT NULL, `ddd` varchar(100) DEFAULT NULL, `telefone` varchar(100) DEFAULT NULL, KEY `idx2` (`nome`(10)) ) ENGINE=PBXT DEFAULT CHARSET=latin1 | +--------- +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0,00 sec) fis-> insert into telpbxt select * from tel; Query OK, 10262048 rows affected (5 hours 2 min 22,14 sec) Records: 10262048 Duplicates: 0 Warnings: 0

4 11

[Maria-discuss] bug or not bug? ;-)
by Alexandre Almeida 05 May '10

05 May '10

Guys, everytime I run the following command: show global status like 'created%tmp%tables' the created_tmp_tables is incremented by 1. Is that right? I mean, which relationship between a show global (that will perform a minimum select at information_schema) and a new temporary table? I would appreciate your comments. Alex

2 2

[Maria-discuss] New Maria Docs list
by Daniel Bartholomew 05 May '10

05 May '10

All, I've created a new "Maria Docs" Launchpad team and mailing list for documentation-related discussions (including things like documentation for current and upcoming releases of MariaDB, planning and discussion of the askmonty.org knowledgebase, and so on). The group is open to everyone. https://launchpad.net/~maria-docs Thanks! -- Daniel Bartholomew Monty Program - http://askmonty.org

1 0

[Maria-discuss] MariaDB shutdowns silently
by Joshua Partogi 23 Apr '10

23 Apr '10

Dear all, I am currently running MariaDB in production and I often found it would shutdown itself silently after inactivity. The application itself is using Ruby on Rails. I have disabled the max_timeout settings in my.cnf but the problem still occurs. Is there anything else I should watch out for to prevent this issue continuing to occur? Thank you very much for your assistance. Kind regards, Joshua -- http://twitter.com/scrum8

6 8

[Maria-discuss] What is the future of MariaDB
by Joshua Partogi 20 Apr '10

20 Apr '10

All, Many people were feeling uncertain whether to use MySQL when Sun was bought by Oracle. I was one of those people and that is why I chose MariaDB for my product now. But I need to know what is the plan for MariaDB in the future? Would there be any chance that MariaDB will be sold to another company just like MySQL got sold to Sun? Or would MariaDB always be a community owned? Kind regards, Joshua -- http://twitter.com/projexion

5 4

Re: [Maria-discuss] Fwd: MySQL Open Space
by Kristian Nielsen 09 Apr '10

09 Apr '10

Henrik Ingo <hingo(a)askmonty.org> writes: > Didn't you have something about Buildbot you wanted to do? Maybe even have > someone from Drizzle join - depending on what you had planned to talk about. I have not planned anything. But I'm happy to do a session going through various aspects of Buildbot if there is an interest. - Kristian. > ---------- Forwarded Message ---------- > > Subject: MySQL Open Space > Date: Friday 09 April 2010 > From: Colin Charles <byte(a)bytebot.net> > To: "Sheeri K. Cabral" <awfief(a)gmail.com>, Brian Aker <brian(a)tangent.org>, > Henrik Ingo <hingo(a)askmonty.org>, Giuseppe Maxia <giuseppe(a)mysql.com>, Peter > Zaitsev <pz(a)percona.com>, Arjen Lentz <arjen(a)openquery.com> > > Hi! > > You know there is a MySQL open space on the schedule for the > conference, in the same room that the MySQL Camp was held last year > > For the space to be properly utilised, I was wondering if people would > like to run side sessions there. > > Its on Tuesday (http://en.oreilly.com/mysql2010/public/schedule/detail/12348 > ), Wednesday (http://en.oreilly.com/mysql2010/public/schedule/detail/12349 > ) and also on Thursday (but possibly in a different room). > > http://forge.mysql.com/wiki/MySQL_Conference_Open_Space_2010 > > That should help, I think *grin* > > Please feel free to pass it around and see if we get lots of side > content. Things that weren't accepted. Things that require more than a > BoF. > > Cheers, > -c

2 1

[Maria-discuss] Generic Linux Build requirements
by Brian Evans 06 Apr '10

06 Apr '10

http://askmonty.org/wiki/index.php/Building_MariaDB:Generic_Linux says: * gcc 2.95.2 or later However, according to [1] , Gentoo claims that GCC 4.3 is required due the use of c++ templates in the server. [2] also states that GCC-4 is absolutely required with a failing build log. [1] http://bugs.gentoo.org/show_bug.cgi?id=307251#c5 [2] http://bugs.gentoo.org/show_bug.cgi?id=284946

3 4

[Maria-discuss] MariaDB 5.1.44 has been released
by Colin Charles 06 Apr '10

06 Apr '10

Dear MariaDB users, MariaDB 5.1.44, a new branch of the MySQL database which includes all major open source storage engines, myriad bug fixes, and many community patches, has been released. This release is based on MySQL 5.1.44. In includes performance improvements with Maria temporary tables, removal of mutexes and the aim of removing compiler errors is being achieved quite well! For an overview of what's new in MariaDB 5.1.44, please see: http://askmonty.org/wiki/Manual:MariaDB_5.1.44_Release_Notes For information on installing MariaDB 5.1.44 on new servers or upgrading to MariaDB 5.1.44 from previous releases, please see: http://askmonty.org/wiki/Manual:Installation MariaDB is available in source and binary form for a variety of platforms and is available from the download pages at: http://askmonty.org/wiki/MariaDB:Download:MariaDB_5.1.44 It is also our pleasure to announce that we have a partnership with Webyog to offer their tools for trial and at a discounted rate if purchased within 30 days. Find out more at: http://askmonty.org/downloads/links/webyog http://askmonty.org/wiki/MariaDB:Download#Software_Partner_Downloads We welcome and appreciate your feedback, bug reports, bug fixes, patches, and participation on our mailing list. Find out more at: http://askmonty.org/wiki/MariaDB#How_can_I_participate_in_the_development_o… Enjoy! -- Colin Charles, http://bytebot.net/blog/ "First they ignore you, then they laugh at you, then they fight you, then you win." -- Mohandas Gandhi

4 3