Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Performance » MySQL » Help: bad performance
Help: bad performance [message #1019] Mon, 02 April 2007 11:17 Go to previous message
ruid is currently offline ruid
Messages: 2
Registered: April 2007
Junior Member
I have two questions below:
1. The query speed is very slow, I was just wondering whether it was normal or not: My CPU is Intel Xeon Processor Dual-Core 2.4GHz and the memory is 1GB. There are 40,000 records in the database. When I deleted 150 records, the operation took 2 minutes.

2. I always encounter an error: Fatal error: Maximum execution time of 90 seconds exceeded in c:\program files\apache group\apache\htdocs\sugarcrm\include\database\MysqlManager.p hp on line 139
Is it possible if we modify the period of maximum execution time to make it longer?
Thanks very much in advance!

[Updated on: Mon, 02 April 2007 11:25]

Report message to a moderator
[Message index]

Read Message
Read Message
Read Message
Read Message
Previous Topic:MYSQL goes very slow after every 4-5 hours
Next Topic:mysqldump speed for a DB with thousands of tables
Goto Forum:

  

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]

Current Time: Fri Jul 10 02:44:31 EDT 2009

Total time taken to generate the page: 0.02068 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.