Re: [Maria-discuss] Good GUI

2011-08-30 Thread Alexandre Almeida
You can pick SQLyog from WEByog. It's really nice. Alexandre Em 30/08/2011, às 15:58, m...@rpzdesign.com escreveu: > Hello: > > I have been using Navicat to administer my Oracle/Sun based MySQL servers for > years. (www.navicat.com) > > Now I am switched over to MariaDB 2.8 using ARIA engine.

Re: [Maria-discuss] MariaDB and Sun CoolThread

2011-04-04 Thread Alexandre Almeida
maybe running 4 copies of mysqld with each instance locked down to 12 CoolThread CPUs will help. On Sun, Apr 3, 2011 at 11:07 PM, Kristian Nielsen wrote: Alexandre Almeida writes: As far as I can see MariaDB stay locked/running on a single virtual CPU and MariaDB doesn't take adva

[Maria-discuss] MariaDB and Sun CoolThread

2011-04-01 Thread Alexandre Almeida
Hi all, I am installing MariaDB on a server Sun/Oracle T5140 with CoolThread/ CMT technology. This server has two physical Sparc CPU with 48 1165MHZ virtual processors each. However, it's look like that MariaDB is performing much better on my MacBook Pro when compared against this server

Re: [Maria-discuss] (no subject)

2010-06-15 Thread Alexandre Almeida
what is this? <> Em 15/06/2010, às 19:11, Justin Swanhart escreveu: http://wafejqh.wifethen.ru -- -- Justin Swanhart, Consultant, Percona Inc. Bay Area, USA (PDT, GMT -7) +1 888 401 3401 | Justin x503 | 24x7 Help x911 Our Services: http://www.percona.com/services.html Our Blog: http://www.

Re: [Maria-discuss] PBXT issues

2010-05-06 Thread Alexandre Almeida
Paul, Do you any clue why I get this during select? | 69305170 | 1 | | 69306030 |

Re: [Maria-discuss] PBXT issues

2010-05-06 Thread Alexandre Almeida
Paul, I was wondering. Can you say that PBXT works much better with fixed length rows? Alex <> Em 06/05/2010, às 03:32, Paul McCullagh escreveu: Hi Monty, On May 5, 2010, at 7:02 PM, Michael Widenius wrote: "Paul" == Paul McCullagh writes: Paul> PBXT can help you out with this.

Re: [Maria-discuss] bug or not bug? ;-)

2010-05-05 Thread Alexandre Almeida
are implemented. On Wednesday, May 05, 2010, at 11:41AM, "Alexandre Almeida" > wrote: Guys, everytime I run the following command: show global status like 'created%tmp%tables' the created_tmp_tables is incremented by 1. Is that righ

[Maria-discuss] bug or not bug? ;-)

2010-05-05 Thread Alexandre Almeida
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) a

Re: [Maria-discuss] PBXT issues

2010-05-05 Thread Alexandre Almeida
ze = 19/624/1019 Avg row len set for tab = not specified Rows fixed length = NO Maximum fixed size = 16384 ... Paste the output in an e-mail, and I will show you what to use for the AVG_ROW_LENGTH. Best regards, Paul On May 4, 2010, at 8:55 PM, Alexandre Almeida wrote: Hi Guys, I

Re: [Maria-discuss] PBXT issues

2010-05-04 Thread Alexandre Almeida
Alex <> Em 04/05/2010, às 20:30, Arjen Lentz escreveu: Hi Alexandre On 05/05/2010, at 4:55 AM, Alexandre Almeida wrote: 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 crea

[Maria-discuss] PBXT issues

2010-05-04 Thread Alexandre Almeida
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

[Maria-discuss] Problems with Foreign Key

2010-03-30 Thread Alexandre Almeida
Hi all, Any idea why I am getting this error: A) ERROR ALTER TABLE login-> ADD CONSTRAINT fk_db_perfil FOREIGN KEY (id_perfil)-> REFERENCES db_perfil (id_perfil)-> ON DELETE NO ACTION-> ON UPDATE NO ACTION;ERROR 1005 (HY000): Can't create table 'dbhomo_aa.#sql-c1f

Re: [Maria-discuss] problems with innodb

2010-03-11 Thread Alexandre Almeida
Folks, I aware about it. The line I am using --with-plugins=max Thanks! Obrigado!! AA <> Em 11/03/2010, às 10:22, Brian Evans escreveu: On 3/11/2010 7:37 AM, Alexandre Almeida wrote: Hi guys, I am building MariaDB from source and it doesn't come

[Maria-discuss] problems with innodb

2010-03-11 Thread Alexandre Almeida
Hi guys, I am building MariaDB from source and it doesn't come with innodb. I have tried the parameters: all and innobase. Is there anything else I can pass on command line to get innodb running at my MariaDB? Many thanks, Alex <> ___

Re: [Maria-discuss] MariaDB 5.1.42 has been released

2010-02-18 Thread Alexandre Almeida
an Kuecuekyilmaz escreveu: Hola, On 18.02.2010, at 13:18, Alexandre Almeida wrote: Hi guys, I have download it for the next DBA class next week. I am not using mysql at DBA class anymore. I am a MAC user, so, I have to download the sources and compile it. I just did th

Re: [Maria-discuss] MariaDB 5.1.42 has been released

2010-02-18 Thread Alexandre Almeida
Hi guys, I have download it for the next DBA class next week. I am not using mysql at DBA class anymore. I am a MAC user, so, I have to download the sources and compile it. I just did the basics such as: configure --prefix=/usr/local/mariadb-5.1.42 --with-plugins=ma

Re: [Maria-discuss] Replication and auto-increment

2010-01-27 Thread Alexandre Almeida
at 7:18 AM, Alexandre Almeida wrote: Allow me to share how we are handling this issue. We have a customer that develop and sell a system that control employees in & out. They have many customers with multiple plants & sites. To avoid the related issue, we did a simple workaround, we add a

Re: [Maria-discuss] Replication and auto-increment

2010-01-27 Thread Alexandre Almeida
Brian, Allow me to share how we are handling this issue. We have a customer that develop and sell a system that control employees in & out. They have many customers with multiple plants & sites. To avoid the related issue, we did a simple workaround, we add a new column at each table. T

Re: [Maria-discuss] Default Database Engine

2009-11-29 Thread Alexandre Almeida
.html "To create a Maria table you must specify the engine when using the CREATE TABLE statement" askmonty.org states that "MariaDB is a community developed branch of the MySQL database that uses the Maria engine by default". I guess not yet. ...beats me. :-) Jim Grill

Re: [Maria-discuss] Default Database Engine

2009-11-28 Thread Alexandre Almeida
same here.Mac OSX, CentOS 5, Fedora 10 the default se still myISAM.Alex Em 28/11/2009, às 14:32, Richard Dunn escreveu:I have compiled and installed mariadb-5.1.39 on Mac OS X 10.6.2 and installed a 64-bit binary on CentOS 5.  In both cases, MyISAM is still the default database engine.  I would ha