Description:
I created a falcon table, ran some tests, stopped the server, and started the server, and get this:
patg@govinda:~/mysql-build/mysql-5.1-falcon> 060623 11:22:33 [Warning] Storage engine 'Fal has conflicting typecode. Assigning value 32.
060623 11:22:33 [Note] /home/patg/mysql-build/mysql-5.1-falcon/sql/mysqld: ready for connens.
Version: '5.1.12-beta-log' socket: '/tmp/falcon.sock' port: 5555 Source distribution
060623 11:22:33 [Note] SCHEDULER: Manager thread booting
060623 11:22:33 [Note] SCHEDULER: Loaded 0 events
060623 11:22:33 [Note] SCHEDULER: Suspending operations
How to repeat:
patg@govinda:~/mysql-build/mysql-5.1-falcon> mysql -u root -S /tmp/falcon.sock test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 5.1.12-beta-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> 060623 11:23:45 [ERROR] Activity on /home/patg/mysql-build/mysql-5.1-falcon/mysql-test/var/master-data/test.ndb: 1083 fetches, 57 reads, 1 writes
mysql> 060623 11:24:15 [ERROR] Activity on /home/patg/mysql-build/mysql-5.1-falcon/mysql-test/var/master-data/test.ndb: 0 fetches, 0 reads, 7 writes
060623 11:24:45 [ERROR] Activity on /home/patg/mysql-build/mysql-5.1-falcon/mysql-test/var/master-data/test.ndb: 0 fetches, 0 reads, 35 writes
060623 11:25:15 [ERROR] Activity on /home/patg/mysql-build/mysql-5.1-falcon/mysql-test/var/master-data/test.ndb: 0 fetches, 0 reads, 2 writes
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| t1 |
| ti |
| tj |
+----------------+
3 rows in set (0.00 sec)
mysql> show create table t1;
+-------+----------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+----------------------------------------------------------------------------------------+
| t1 | CREATE TABLE `t1` (
`s1` int(11) DEFAULT NULL
) ENGINE=Falcon DEFAULT CHARSET=latin1 |
+-------+----------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> show create table ti;
+-------+----------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+----------------------------------------------------------------------------------------+
| ti | CREATE TABLE `ti` (
`s1` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
+-------+----------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> show create table tj;
+-------+----------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+----------------------------------------------------------------------------------------+
| tj | CREATE TABLE `tj` (
`s1` int(11) DEFAULT NULL
) ENGINE=Falcon DEFAULT CHARSET=latin1 |
+-------+----------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql>
Description: I created a falcon table, ran some tests, stopped the server, and started the server, and get this: patg@govinda:~/mysql-build/mysql-5.1-falcon> 060623 11:22:33 [Warning] Storage engine 'Fal has conflicting typecode. Assigning value 32. 060623 11:22:33 [Note] /home/patg/mysql-build/mysql-5.1-falcon/sql/mysqld: ready for connens. Version: '5.1.12-beta-log' socket: '/tmp/falcon.sock' port: 5555 Source distribution 060623 11:22:33 [Note] SCHEDULER: Manager thread booting 060623 11:22:33 [Note] SCHEDULER: Loaded 0 events 060623 11:22:33 [Note] SCHEDULER: Suspending operations How to repeat: patg@govinda:~/mysql-build/mysql-5.1-falcon> mysql -u root -S /tmp/falcon.sock test Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 5.1.12-beta-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> 060623 11:23:45 [ERROR] Activity on /home/patg/mysql-build/mysql-5.1-falcon/mysql-test/var/master-data/test.ndb: 1083 fetches, 57 reads, 1 writes mysql> 060623 11:24:15 [ERROR] Activity on /home/patg/mysql-build/mysql-5.1-falcon/mysql-test/var/master-data/test.ndb: 0 fetches, 0 reads, 7 writes 060623 11:24:45 [ERROR] Activity on /home/patg/mysql-build/mysql-5.1-falcon/mysql-test/var/master-data/test.ndb: 0 fetches, 0 reads, 35 writes 060623 11:25:15 [ERROR] Activity on /home/patg/mysql-build/mysql-5.1-falcon/mysql-test/var/master-data/test.ndb: 0 fetches, 0 reads, 2 writes mysql> show tables; +----------------+ | Tables_in_test | +----------------+ | t1 | | ti | | tj | +----------------+ 3 rows in set (0.00 sec) mysql> show create table t1; +-------+----------------------------------------------------------------------------------------+ | Table | Create Table | +-------+----------------------------------------------------------------------------------------+ | t1 | CREATE TABLE `t1` ( `s1` int(11) DEFAULT NULL ) ENGINE=Falcon DEFAULT CHARSET=latin1 | +-------+----------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> show create table ti; +-------+----------------------------------------------------------------------------------------+ | Table | Create Table | +-------+----------------------------------------------------------------------------------------+ | ti | CREATE TABLE `ti` ( `s1` int(11) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 | +-------+----------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> show create table tj; +-------+----------------------------------------------------------------------------------------+ | Table | Create Table | +-------+----------------------------------------------------------------------------------------+ | tj | CREATE TABLE `tj` ( `s1` int(11) DEFAULT NULL ) ENGINE=Falcon DEFAULT CHARSET=latin1 | +-------+----------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql>