May 2010 - discuss - lists.mariadb.org

[Maria-discuss] OpenSQLCamp EU Call for Papers
by Henrik Ingo 31 May '10

31 May '10

Giuseppe Maxia wanted me to bring to your attention, that the Call for Papers for OpenSQLCamp EU is now open: http://opensqlcamp.org/Events/2010/Call_for_Participation "The European OpenSQLCamp 2010 will take place in parallel to the Free and Open Source Conference 2010 (FrOSCon) on Saturday 21st and Sunday 22nd August at the Fachhochschule Bonn-Rhein-Sieg in St. Augustin, Germany. St. Augustin is located close to Bonn and Cologne. " henrik -- Henrik Ingo Project Manager and COO, Monty Program Ab hingo(a)askmonty.org, skype:henrik.ingo, +358405697354 http://askmonty.org/wiki/index.php/About_Us What's up with MariaDB? http://askmonty.org/wiki/index.php/MariaDB

1 0

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

19 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