MySQL Forums
Forum List  »  Spanish

Re: Nuevos storage engines
Posted by: William Chiquito
Date: December 07, 2006 06:09PM

Hola Xavier,

La verdad solidBD se presenta como una alternativa interesante para evaluar al igual que el resto de engines que pronto estarán disponibles para MySQL.

En cuando a lo que comentas que las foreign keys en solidDB no funcionan, aquí está un script donde se muestra que si funcionan.

En estoy usando la versión win-beta5-0040

mysql> select @@version;
+-----------+
| @@version |
+-----------+
| 5.0.27 |
+-----------+
1 row in set (0.23 sec)

mysql> show engines;
+------------+---------+--------------------------------------------------------
--------------------------------------------+
| Engine | Support | Comment
|
+------------+---------+--------------------------------------------------------
--------------------------------------------+
| solidDB | DEFAULT | Fully transactional disk-based engine with multiversion
optimistic/pessimistic concurrency control |
| MyISAM | YES | Default engine as of MySQL 3.23 with great performance
|
| MEMORY | YES | Hash based, stored in memory, useful for temporary tabl
es |
| InnoDB | YES | Supports transactions, row-level locking, and foreign k
eys |
| BerkeleyDB | NO | Supports transactions and page-level locking
|
| BLACKHOLE | NO | /dev/null storage engine (anything you write to it disa
ppears) |
| EXAMPLE | NO | Example storage engine
|
| ARCHIVE | YES | Archive storage engine
|
| CSV | NO | CSV storage engine
|
| ndbcluster | NO | Clustered, fault-tolerant, memory-based tables
|
| FEDERATED | NO | Federated MySQL storage engine
|
| MRG_MYISAM | YES | Collection of identical MyISAM tables
|
| ISAM | NO | Obsolete storage engine
|
+------------+---------+--------------------------------------------------------
--------------------------------------------+
13 rows in set (0.00 sec)

mysql> use test;
Database changed

mysql> CREATE TABLE `a` (
-> `id` int(11) NOT NULL auto_increment,
-> PRIMARY KEY (`id`)
-> ) ENGINE=solidDB DEFAULT CHARSET=latin1;
Query OK, 0 rows affected (0.20 sec)

mysql> insert into a (id) values (1);
Query OK, 1 row affected (0.07 sec)

mysql> insert into a (id) values (2);
Query OK, 1 row affected (0.04 sec)

mysql> insert into a (id) values (3);
Query OK, 1 row affected (0.05 sec)

mysql> CREATE TABLE `b` (
-> `id` int(11) default NULL,
-> KEY `FK_b` (`id`),
-> CONSTRAINT `FK_b` FOREIGN KEY (`id`) REFERENCES `a` (`id`)
-> ) ENGINE=solidDB DEFAULT CHARSET=latin1;
Query OK, 0 rows affected (0.14 sec)

mysql> insert into b (id) values (5);
ERROR 1216 (23000): Cannot add or update a child row: a foreign key constraint f
ails

mysql> insert into b (id) values (1);
Query OK, 1 row affected (0.05 sec)

mysql> select * from a;
+----+
| id |
+----+
| 1 |
| 2 |
| 3 |
+----+
3 rows in set (0.03 sec)

mysql> select * from b;
+------+
| id |
+------+
| 1 |
+------+
1 row in set (0.00 sec)

Options: ReplyQuote


Subject
Views
Written By
Posted
3194
October 25, 2006 05:14AM
2449
November 24, 2006 07:01AM
Re: Nuevos storage engines
2305
December 07, 2006 06:09PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.