Good questions - I have a few more :)
A) why does it seem to use fixed-size storage units. (The files)
B) what happens when they ar full?
C) can it auto-create new files as demand grows?
D) can you safely add new files when there is data in them already?
Regards,
Sander
> -----Original Message-----
> From: Peter Zaitsev [mailto:[EMAIL PROTECTED]]
> Sent: 22 February 2001 19:52
> To: [EMAIL PROTECTED]
> Subject: Innobase
>
>
> Hello mysql,
>
> Today I got a chance to compile mysql 3.23.34 with innobase, so
> althought it's not out yet I'll give some of my comments
>
> The version I'm speaking about got from work.mysql.com
>
> 1) It does not even configure then trying to configure
> --with-innobase-db the problem is autoconf is not called in innobase
> directory so configure script is not created
> 2) innobase_data_home_dir used as prefix, so if we'll not end it
> with "/" we'll have files prefixed by directory name created in
> upper level directory. This may be expected behavior but if so it
> should be described in the manual.
> 3) Data files somehow are created with "x" attribute which I think
> is not quite right
> drwxr-xr-x 19 root root 366 Feb 22 21:32 ..
> -rwxrwx--x 1 root root 1073741824 Feb 22 21:36 ibdata1
> -rwxrwx--x 1 root root 1073741824 Feb 22 21:08 ibdata2
> -rwxrwx--x 1 root root 1073741824 Feb 22 21:09 ibdata3
> -rwxrwx--x 1 root root 1073741824 Feb 22 21:09 ibdata4
> 4) Currently ATIS test fails with innobase table:
> Retrieving data
> Warning: Query 'select
> city.city_name,state.state_name,city.city_code from state,city
> where city.state_code=state.state_code' returned 1 rows when it
> should have returned 11 rows
> Got error: when executing select
> flight.flight_code,aircraft.aircraft_type from flight,aircraft
> where flight.aircraft_code=aircraft.aircraft_code
> got 0 instead of 579 ***
>
> 5) Then started first time mysql creates innobase datafiles long
> during startup which I think should be also mentioned in the manual -
> I thought it's hanged up.
>
> 6) There is currently a serious lack of documentation - is there any
> additional information about innobase tables ? For example how does
> tables distributed over data files (I'e if putting them on different
> disks will improve perfomance) Other thing is what should I do if I
> somehow lose one file - will I be able to recover data at least
> partitially ? What is idea ? Is it better to make small files or one
> big file if you OS supports this ? How may I backup table ? Only
> with mysqldump ?
> 7) Currently No check repair tools are provided which would be real
> showstopper for production usage even if the tables will be quite
> stable - what should I do if I have file system dammage so I need to
> check the things up. Here we have even more problems as many tables
> share one file so we probably can't just check them one by one.
> 8) As I understand innobase works with large files self mannaging
> usage in them - so Is it planned to support RAW devices with innobase
> ?
>
>
>
> --
> Best regards,
> Peter mailto:[EMAIL PROTECTED]
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php