Jump to content


Photo

deleting data from multiple tables


  • Please log in to reply
26 replies to this topic

#21 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 28 October 2006 - 04:52 PM

Didn't mean to subvert the intention to convert to InnoDB, but you get much more than just ACID compliance.  Indexing is very different, queries are different, and so on -- these are huge performance issues if you don't know how to handle them (e.g. COUNT(*) being an excellent example).  As for InnoDB itself, it's possible your server isn't set up to load InnoDB, you'll have to restart it without --skip-innodb, as mentioned earlier.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#22 witham

witham
  • Members
  • PipPipPip
  • Advanced Member
  • 86 posts

Posted 28 October 2006 - 04:59 PM

The version is MySQL client version: 5.0.24a

When I run
SQL query:

SHOW INNODB STATUS

MySQL said: Documentation
#1235 - Cannot call SHOW INNODB STATUS because skip-innodb is defined

which confirms your earlier comment:

When I alter the table with the command "alter man engine=innodb" I get

Your SQL query has been executed successfully (Query took 0.7944 sec)

But the engine is still showing disabled on the engine tab and when I go ino operations for the table it still shows storage as myisam?
I now can't even remember where I found the ini file to comment out skip innodb!

#23 gmwebs

gmwebs
  • Members
  • PipPipPip
  • Advanced Member
  • 174 posts
  • LocationLondon

Posted 28 October 2006 - 05:07 PM

The file is my.ini found in C:\Program Files\MySQL\MySQL Server 5.0. The InnoDB conversion will not work until you can get rid of skip-innodb.

#24 witham

witham
  • Members
  • PipPipPip
  • Advanced Member
  • 86 posts

Posted 28 October 2006 - 05:20 PM

I am using xaamp so I do not have a independant mysql installation but it is really frustrating that I can't find the in file agian!! I 'll keep looking

#25 gmwebs

gmwebs
  • Members
  • PipPipPip
  • Advanced Member
  • 174 posts
  • LocationLondon

Posted 28 October 2006 - 09:11 PM

The file should either be called my.ini or my.cnf and should be in the mysql\bin folder under your XAMPP installation. If you search your drives using the windows file search utility for either of these files, then you should find it.

#26 witham

witham
  • Members
  • PipPipPip
  • Advanced Member
  • 86 posts

Posted 29 October 2006 - 06:45 PM

The only file I can find when I search under my.cnf is a my speed dial shortcut, all the other files in the folder are applications?

#27 witham

witham
  • Members
  • PipPipPip
  • Advanced Member
  • 86 posts

Posted 29 October 2006 - 07:46 PM

I finally coded it out instead using:

DELETE FROM prodname USING prodname, man
WHERE prodname.manno != man.manid;

But I would very much like to thank you for our help




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users