RE: The MySQL and InnoDB FK's

2003-02-28 Thread John Dell
Hi, > > Hi, > > > >I would like to know if is there a way to delete constraints > >without dropping and recreating a table. If there isn't, I would > >like to know when do you plan to implement this important feature. I would also like to see this feature. I have been implementing a

MySQL4 user table not showing GRANT privileges correctly

2002-12-14 Thread John Dell
ANT SELECT ON dbname.* TO test@localhost IDENTIFIED BY 'testpass'; flush privileges; SELECT * FROM USER WHERE User='test'; It will show 'N' in all privilege columns which is wrong. It should show a 'Y' in the select_priv column. I

MySQL4 on Linux with Intel Hyperthreading CPUs?

2002-12-11 Thread John Dell
cause any problems with MySQL or Linux? Any performance reasons to enable/disable hyperthreading? Thanks! John Dell [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists