mysql timeout with innodb but not myisam

Hi all,

I have installed MySQL 5.0.51a 64bit on Windows 2003.

I have a php script that executes some queries, but it keeps timing out with "Fatal error: Maximum execution time of 30 seconds exceeded in ..."

If I change my table from innoDB to myISAM then it takes about 2 seconds and does not time out.

Any ideas?
zattzAsked:
Who is Participating?
 
Computer101Connect With a Mentor Commented:
PAQed with points refunded (500)

Computer101
EE Admin
0
 
syedasimmeesaqCommented:
May be this help you understanding your problem
http://www.xaprb.com/blog/2006/09/26/an-introduction-to-innodb-error-handling/
Thanks
0
 
zattzAuthor Commented:
By the way, this is on an empty database, with no users connected. The exact same script works fine on a linux box with innodb, but when I run it on the windows box it times out.
0
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

 
syedasimmeesaqCommented:
ok in that case its your installation of mysql problem on windows box. Do you currently have any databases on windwos machine? If not, do you want to do a fresh reinstall? If you have the databases, then some other solution is needed.
0
 
zattzAuthor Commented:
I've found the problem. I copied over the "my-innodb-heavy-4G.ini" as my config and it magically works properly.

I guess I'll have to learn more to find out what exactly in the original config was causing the problem.
0
 
syedasimmeesaqCommented:
I am happy it worked out for you
0
All Courses

From novice to tech pro — start learning today.