infobright 3.52导入性能

〇〇

IEE

〇〇

mysql> load data infile '/user1/app/ren.csv' into table ren fields terminated by ',' lines terminated by '\n';
Query OK, 1242612226 rows affected, 1 warning (2 hours 49 min 18.12 sec)
Records: 1242612226  Deleted: 0  Skipped: 0  Warnings: 0

mysql> commit;
Query OK, 0 rows affected (0.46 sec)

mysql>
mysql> show warnings;
+-------+------+------------------------------------------------------------------------------------+
| Level | Code | Message                                                                            |
+-------+------+------------------------------------------------------------------------------------+
| Note  | 1105 | Query contains syntax that is unsupported in Infobright and which will be ignored. |
+-------+------+------------------------------------------------------------------------------------+
1 row in set (0.18 sec)

mysql> select floor(id/1E16),count(*) from rki.hu group by floor(id/1E16) order by 1;
select floor(id/1E16),count(*) from rki.ren group by floor(id/1E16) order by 1;

+----------------+----------+
| floor(id/1E16) | count(*) |
+----------------+----------+
+----------------+----------+
31 rows in set (3 min 8.44 sec)

mysql> select floor(id/1E16),count(*) from rki.ren group by floor(id/1E16) order by 1;
+----------------+----------+
| floor(id/1E16) | count(*) |
+----------------+----------+
+----------------+----------+
31 rows in set (8 min 55.98 sec)

TO_TO_RO

原帖由 〇〇 于 2011-2-12 15:41 发表
[root@redflag11012601 ~]# mkfifo --mode=0666 /user1/pipehu.csv
[root@redflag11012601 ~]# gzip --stdout -d /user1/app/hu.csv.gz > /user1/pipehu.csv &
[1] 10990
[root@redflag11012601 ~]# mysql-ib
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.1.40 build number (revision)=IB_3.5.2_r11794_12019(iee_eval - commercial)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use rk;
Database changed
mysql> set autocommit=off;
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql> set @BH_DATAFORMAT='txt_variable';
Query OK, 0 rows affected (0.00 sec)

mysql> load data infile '/user1/pipehu.csv' into table hu fields terminated by ',' lines terminated by '\n';
Query OK, 351233699 rows affected, 1 warning (1 hour 18 min 4.56 sec)
Records: 351233699  Deleted: 0  Skipped: 0  Warnings: 0

mysql> commit;
Query OK, 0 rows affected (0.01 sec)

mysql> load data infile '/user1/app/ren.csv' into table ren fields terminated by ',' lines terminated by '\n';

OO大神，我看您这是用IEE，我也下载了一个IEE 也生成了license ，但是总启动不了的说，提示license不生效。。。请教一下 你是怎么弄的？

TO_TO_RO

[root@rhel ]# /etc/init.d/mysqld-ib start
Starting MySQL........[FAILED]

110214 17:10:28 mysqld_safe mysqld from pid file /usr/local/infobright-3.5.2-x86_64/data/ZJCRNOPCOL1.pid ended
110215 13:10:04 mysqld_safe Starting mysqld daemon with databases from /usr/local/infobright-3.5.2-x86_64/data
110215 13:10:05 [Warning] options --log-slow-admin-statements, --log-queries-not-using-indexes and --log-slow-slave-statements have
no effect if --log_slow_queries is not set
Loading configuration for Infobright instance ...
Option: AllowMySQLQueryPath, value: 1.
Option: AutoConfigure, value: 0.
Option: CacheFolder, value: /usr/local/infobright-3.5.2-x86_64/cache.
Option: ControlMessages, value: 0.
Option: InternalMessages, value: 0.
Option: KNFolder, value: BH_RSI_Repository.
Option: KNLevel, value: 99.
Option: LicenseFile, value: <unknown>.
Option: LoaderMainHeapSize, value: 800.
Option: PushDown, value: 1.
Option: ServerMainHeapSize, value: 10000.
Option: UseMySQLImportExportDefaults, value: 0.
Infobright instance configuration loaded.
110215 13:10:05 [ERROR] Error: License verification failed!
110215 13:10:05 [ERROR] You are not licensed to run this version of the IEE.
110215 13:10:05 [ERROR] Plugin 'BRIGHTHOUSE' init function returned error.
110215 13:10:05 [ERROR] Plugin 'BRIGHTHOUSE' registration as a STORAGE ENGINE failed.
110215 13:10:05 [ERROR] Unknown/unsupported table type: brighthouse
110215 13:10:05 [ERROR] Aborting

110215 13:10:05 [Note] /usr/local/infobright-3.5.2-x86_64/bin/mysqld: Shutdown complete

110215 13:10:05 mysqld_safe mysqld from pid file /usr/local/infobright-3.5.2-x86_64/data/ZJCRNOPCOL1.pid ended



错误信息贴上

〇〇

你把lic文件复制到/usr/local/infobright

TO_TO_RO

问题解决了  是lic文件格式问题。。。我用二进制方式传上去的，还有问题。。。。