From: Thomas Stegbauer (thomas.stegbauertronicplanet.de)
Date: Wed Jan 21 2004 - 12:23:43 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

hi list,

i am running maxdb 7.50 Build005 on debian 3.0r2 with kernel 2.4.23-xfs.

i created a table

CREATE TABLE "ACCOUNTING"."CISCO3640BR_200310"
(
     "ID" Integer NOT NULL DEFAULT SERIAL (1),
     "SOURCE" Varchar (16) ASCII NOT NULL DEFAULT ' ',
     "DESTINATION" Varchar (16) ASCII NOT NULL DEFAULT ' ',
     "PACKETS" Integer,
     "BYTES" Integer,
     "TIMSTAMP" Timestamp NOT NULL
)

i disabled the log and did not add an primary key and no index.

afterwards i inserted the data from a csv file (about 24mio rows)

the insert took on the test mashine 2hours (it has an slow megatrend
raid5 controller :)

afterwards - still with disabled log - i tried to add an primary key
over the ID field.

ALTER TABLE "ACCOUNTING"."CISCO3640BR_200310" ADD PRIMARY KEY ("ID")

now the sqlstudio is hanging since 5day's. and the machine is doing
nearly nothing.

it does not respond to taskmgr and doesnt accept any commands, but it
redraws from time to time the screen.

any ideas? is this possible to reindex 24mio rows?
and maxdb eats up more space on harddisk, as mysql does.
the table need's currently with maxdb 2.4gb space in harddisk (without
primary key and without any index.)
mysql need's for the data 1.2gb and for index 631mb

is it normal, that maxdb need 3time's more space?

greetings
thomas

--
--
# Thomas Stegbauer
# http://www.keyserver.de:11371/pks/lookup?op=get&search=0xFF837A1A
# Key fingerprint = E469 F5DC 42FB B530 F5CB 99CB CEB2 BFC6 FF83 7A1A

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]