Hi,

I’m new to ICE and not very familiar with MySQL.

I have an Ubuntu 9.10-64 notebook and installed infobright-3.3.1-x86_64-ice.deb.

1)
I could not start /etc/init.d/mysqld-ib until I edited it and set
pidfile=/usr/local/infobright…

2) I set up a database with a few tables and pumped data from an oracle db into it with Talend. That worked nicely.

But when I execute some queries, it is not sooo fast. A query against a fact table with 3.000.000 rows and a joined dimension table with 3.100.000 rows (yes, the dimension is larger ) took 140 secs, with 4 group bys and 1 Sum from the fact table (inner joined).

Then I tried to check the knowledge grid. There is a query documented that should return some knowledge grid metada into the *.err logfile:
SELECT COUNT(*) AS roughstats FROM OneOfMyExistingTables;

But it did not return any of the mentioned metadata anywhere. Neither to console nor to the *.err logfile, even though the *err-logfile does contain infos about the mysql-ib-server starting up and so on.

Also the general_sql.log and slow_sql.log get filled but do not contain further info or error messages.

What am I missing here?

TIA

Regards,
Andre

Hi !

Try

Are your tables annotated with engine=brighthouse?

Do you have

in brighthouse.ini?

See http://www.infobright.org/wiki/Query_Execution_Log/ for details.

Huh!

The engine is MyISAM!!

Thanks for pointing me there!

Is it possible to change it to another engine?

For Infobright table engine is brighthouse. As your tables are MyISAM, you need to export them to text file, create Infobright tables and reload them into Infobright tables.

For export,
select *from table_myisam into outfile “/tmp/table_myisam.txt” field terminated by “;”;

Create infobright tables:

Create table tbl_ib
( ......) engine=brighthouse;

load data infile “/tmp/table_myisam.txt” into tbl_ib fields terminated by “;”;

For more details on Load command, you can see: http://www.infobright.org/wiki/Data_Loading/