Is OPTIMIZE TABLE sql command corrupting MyISAM tables?

2002-02-28 Thread Marek Kustka
Has anyone reported such problem with MySQL 3.23.47 ? I can report an example. Marek - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

SELECT LAST_INSERTID() very sloooow

2002-01-25 Thread Marek Kustka
Hi all, following query SELECT LAST_INSERT_ID() as auto_num FROM xrenders; fills our whole slow query log (500 kB a day). AUTO_INCREMENT field is int(11) type, primary key; table is of type MyISAM. We do the same operation on another similar table of the same db which is much larger without

Re: SELECT LAST_INSERTID() very sloooow

2002-01-25 Thread Marek Kustka
Fred van Engen wrote: On Fri, Jan 25, 2002 at 02:22:12PM +0100, Marek Kustka wrote: following query SELECT LAST_INSERT_ID() as auto_num FROM xrenders; fills our whole slow query log (500 kB a day). Just do 'select last_insert_id() as auto_num'. The id isn't kept per table anyway

Embedded MySQL server the outside world

2001-12-12 Thread Marek Kustka
Hi folks, does embedded server tcp-listen to the outside world i.e. it could be used by another app or perhaps been accessed by the same app using ODBC? OR is MySQL C API the only way to control it? Thanks, Marek - Before