I blinking hate MySQL

[d000hg]

I've used Navicat on good-sized databases (hundreds of thousands of records) and it worked well. However I find the current incarnation of Workbench is OK - it's basically Query Browser and Administrator munged together in one app, and the front page for managing connections is a bit cruddy, but the DB management stuff is fine and the Query Browser-equivalent bits are superior to Query Browser IMHO.

All this is about the Mac versions, so other platforms may vary.

It seems a decent basic SQL tool with a few bits glued on like editing a table in a form. I miss stuff like autocomplete though... is it 'game_id' or 'id', etc.

I don't like the export though, it seems to insist on exporting everything with fully qualified names (db_name.table_name) and procedures with DEFINERs for the creating user. Makes for a few headaches (maybe there are options I didn't see).

[administrator]

I use SQLYog:
MySQL GUI Tools. MySQL Monitor and Manager

Can't live without it now, more than worth the cost IMO.

[NickFitz]

I've used Navicat for MySQL a couple of times and found it quite good.

Never used it in anger though....

I've used Navicat on good-sized databases (hundreds of thousands of records) and it worked well. However I find the current incarnation of Workbench is OK - it's basically Query Browser and Administrator munged together in one app, and the front page for managing connections is a bit cruddy, but the DB management stuff is fine and the Query Browser-equivalent bits are superior to Query Browser IMHO.

All this is about the Mac versions, so other platforms may vary.

[blacjac]

I've used Navicat for MySQL a couple of times and found it quite good.

Never used it in anger though....

[d000hg]

mySQL workbench is a pile of cack if you ask me, query browser and adminstrator are great tools and as good as any DB tools I use on 'serious' databases.

I got workbench assuming as the 'official' tool it would be decent - it's OK but not a patch on the tools I'm used to like SQLDeveloper. I used to use TOAD with Oracle, I see there is a MySQL version - anyone tried it?

And I know MySQL is a powerful, capable RDBMS for real-world use - it's just making me grumpy!

[Sysman]

Now, I have theory that Oracle bought SUN to get mySQL to hinder its development, when mySQL went good with stored procs Oracle were not slow in buying the DB up. Don't think Oracle ever wanted Java, they wanted mySQL.

Having seen how Oracle bought another database back in the nineties and then whacked the prices up I too think they wanted it more than Java.

[minestrone]

mySQL is a real world DB and can confirm that it can shift its arse when asked to do stored procs on large batch tasks.

Now, I have theory that Oracle bought SUN to get mySQL to hinder its development, when mySQL went good with stored procs Oracle were not slow in buying the DB up. Don't think Oracle ever wanted Java, they wanted mySQL.

mySQL workbench is a pile of cack if you ask me, query browser and adminstrator are great tools and as good as any DB tools I use on 'serious' databases.

[d000hg]

worked for me

(To be precise, I did it in MySQL Workbench, and that's the SQL it generated to do my bidding.)

I meant in a real-world DB where you have foreign keys and actual data in the tables

TBF other RDBMs might be as bad but I don't recall Oracle being such a pig. I'm deducing that MySQL implements dropping the primary key by dropping and recreating the table based on the problems. Can't be arsed with all this dropping/re-creating FKs... let me write the stored procs and someone else can do the DDL!

[NickFitz]

Was that available in 2008?

The blog post is from 2003, so I'd say that's a "Yes"

If it was, and you knew about it, you could have made yourself a pot.

Also available in 2008 was this book on which he's a co-author, so they could have saved themselves a pot by buying it: High Performance MySQL: Optimization, Backups, Replication, and More: Amazon.co.uk: Baron Schwartz, Peter Zaitsev, Vadim Tkachenko, Jeremy D. Zawodny, Arjen Lentz, Derek J. Balling: Books

[BrilloPad]

That's a limitation of the MyISAM storage engine, not of MySQL per se. Also, it can be resolved: Overcoming MySQL's 4GB Limit (by Jeremy Zawodny)

Was that available in 2008?

If it was, and you knew about it, you could have made yourself a pot.

[hyperD]

Nick Fitz on CUK Tech is better than Google!

[NickFitz]

I remember JPM credit department worked on spreadsheets. So when they outgrew that they went to mysql. Shame when they reached the 4gb limit and everything collapsed.

Thats what happens when boys design a system and bobs code it.

That's a limitation of the MyISAM storage engine, not of MySQL per se. Also, it can be resolved: Overcoming MySQL's 4GB Limit (by Jeremy Zawodny)

[NickFitz]

I set up a table:

CREATE  TABLE `test`.`test_for_d000hg` (
  `first` INT NOT NULL AUTO_INCREMENT ,
  `second` INT NOT NULL ,
  PRIMARY KEY (`first`) );

and:

ALTER TABLE `test`.`test_for_d000hg` 
CHANGE COLUMN `first` `first` INT(11) NOT NULL  , 
CHANGE COLUMN `second` `second` INT(11) NOT NULL AUTO_INCREMENT  , 
DROP PRIMARY KEY , 
ADD PRIMARY KEY (`second`) ;

worked for me

(To be precise, I did it in MySQL Workbench, and that's the SQL it generated to do my bidding.)

[BrilloPad]

I remember JPM credit department worked on spreadsheets. So when they outgrew that they went to mysql. Shame when they reached the 4gb limit and everything collapsed.

Thats what happens when boys design a system and bobs code it.

[d000hg]

It won't let me do something as simple as change the primary key on a table. Open source crud.