<div>
May be this help you understanding your problem<br />
<a href="http://www.xaprb.com/blog/2006/09/26/an-introduction-to-innodb-error-handling/" rel="ugc">http://www.xaprb.com/blog/2006/09/26/an-introduction-to-innodb-error-handling/</a><br />
Thanks
</div>


May be this help you understanding your problem
http://www.xaprb.com/blog/2006/09/26/an-introduction-to-innodb-error-handling/ [http://www.xaprb.com/blog/2006/09/26/an-introduction-to-innodb-error-handling/]
Thanks

<div>
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.
</div>


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.

<div>
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.<br />

</div>


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.


<div>
I've found the problem. I copied over the &quot;my-innodb-heavy-4G.ini&quot; as my config and it magically works properly.<br />
<br />
I guess I'll have to learn more to find out what exactly in the original config was causing the problem.
</div>


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.

<div>
I am happy it worked out for you
</div>


<div>
<div class="content wysiwyg-content">
Hi all,<br />
<br />
I have installed MySQL 5.0.51a 64bit on Windows 2003.<br />
<br />
I have a php script that executes some queries, but it keeps timing out with &quot;Fatal error: Maximum execution time of 30 seconds exceeded in ...&quot;<br />
<br />
If I change my table from innoDB to myISAM then it takes about 2 seconds and does not time out.<br />
<br />
Any ideas?
</div>
</div>


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?

mysql timeout with innodb but not myisam

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.