maria-discuss team mailing list archive

[Alexandre Almeida <alexandre@xxxxxxxxxx>]

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