| |
 |
|
 |
网友评论
 |
|
 |
 |
网友：
zyangj
| 时间：2008-01-15 14:57:56 IP地址：125.33.160.★ |
|
|
|
CREATE TABLE IF NOT EXISTS `videos` (
`vid` bigint(20) NOT NULL AUTO_INCREMENT,
`dead` char(1) DEFAULT NULL,
`url` varchar(255) NOT NULL,
`snapUrl` varchar(200) DEFAULT NULL,
`siteUrl` varchar(200) NOT NULL,
`playerUrl` varchar(200) DEFAULT NULL,
`channelUrl` varchar(200) NOT NULL,
`caption` varchar(60) DEFAULT NULL,
`keywords` varchar(60) DEFAULT NULL,
`author` varchar(60) DEFAULT NULL,
`size` varchar(20) DEFAULT NULL,
`duration` varchar(20) DEFAULT NULL,
`visitedCount` int(8) DEFAULT NULL,
`collectionCount` int(8) DEFAULT NULL,
`commentCount` int(8) DEFAULT NULL,
`quotationCount` int(8) DEFAULT NULL,
`embedcodes` mediumtext,
`flv` varchar(512) DEFAULT NULL,
`pubedDays` int(4) DEFAULT NULL,
`currentTime` datetime DEFAULT '1982-12-06 06:30:00',
`createdTime` datetime DEFAULT '1982-12-06 06:30:00',
`description` mediumtext,
PRIMARY KEY (`vid`,`url`),
KEY `video_url` (`url`),
KEY `video_siteUrl` (`siteUrl`),
KEY `video_catagoryName` (`channelUrl`)
) ENGINE=ndbcluster DEFAULT CHARSET=utf8 AUTO_INCREMENT=566581 ;
Blog作者的回复:
mysql> create database cu_test
-> ;
Query OK, 1 row affected (0.30 sec)
mysql> use cu_test;
Database changed
mysql> show tables;
Empty set (0.01 sec)
mysql>
mysql>
mysql> CREATE TABLE IF NOT EXISTS `videos` (
->
-> `vid` bigint(20) NOT NULL AUTO_INCREMENT,
->
-> `dead` char(1) DEFAULT NULL,
->
-> `url` varchar(255) NOT NULL,
->
-> `snapUrl` varchar(200) DEFAULT NULL,
->
-> `siteUrl` varchar(200) NOT NULL,
->
-> `playerUrl` varchar(200) DEFAULT NULL,
->
-> `channelUrl` varchar(200) NOT NULL,
->
-> `caption` varchar(60) DEFAULT NULL,
->
-> `keywords` varchar(60) DEFAULT NULL,
->
-> `author` varchar(60) DEFAULT NULL,
->
-> `size` varchar(20) DEFAULT NULL,
->
-> `duration` varchar(20) DEFAULT NULL,
->
-> `visitedCount` int(8) DEFAULT NULL,
->
-> `collectionCount` int(8) DEFAULT NULL,
->
-> `commentCount` int(8) DEFAULT NULL,
->
-> `quotationCount` int(8) DEFAULT NULL,
->
-> `embedcodes` mediumtext,
->
-> `flv` varchar(512) DEFAULT NULL,
->
-> `pubedDays` int(4) DEFAULT NULL,
->
-> `currentTime` datetime DEFAULT '1982-12-06 06:30:00',
->
-> `createdTime` datetime DEFAULT '1982-12-06 06:30:00',
->
-> `description` mediumtext,
->
-> PRIMARY KEY (`vid`,`url`),
->
-> KEY `video_url` (`url`),
->
-> KEY `video_siteUrl` (`siteUrl`),
->
-> KEY `video_catagoryName` (`channelUrl`)
->
-> ) ENGINE=ndbcluster DEFAULT CHARSET=utf8 AUTO_INCREMENT=566581 ;
Query OK, 0 rows affected (2.21 sec)
mysql> show tables;
+-------------------+
| Tables_in_cu_test |
+-------------------+
| videos |
+-------------------+
1 row in set (0.00 sec)
mysql> create logfile group lg_1
-> add undofile 'undo_1.dat'
-> initial_size 200M
-> undo_buffer_size 200M
-> engine ndb;
ERROR 1525 (HY000): Failed to create LOGFILE GROUP
mysql> show errors;
+-------+------+---------------------------------------------------+
| Level | Code | Message |
+-------+------+---------------------------------------------------+
| Error | 1296 | Got error 1504 'Out of logbuffer memory' from NDB |
| Error | 1525 | Failed to create LOGFILE GROUP |
+-------+------+---------------------------------------------------+
2 rows in set (0.00 sec)
mysql> create logfile group lg_1 add undofile 'undo_1.dat' initial_size 200M undo_buffer_size 25M engine ndb;
Query OK, 0 rows affected (5.78 sec)
|
|
|
|
|
 |
|
 |
|  |
|
 |
|
