|
Description: |
I have a MySQL database that performs very slow. I would like to have this database optimized or issues resolved to significantly increase its performance. This is a very large database and contains around 175 million records. The search querys work and produce valid results but take far to long. I need it to return results in a few seconds and wish to be able to search by all fields in the database. At one time it worked well but then when some records were removed that were older records it slowed a great deal. I have attached a document that shows one such search I just ran. The attached also provides a view of the admin area where prices and number of searches are set.
This project is not for you to design a site but I would like the search fields to be able to be accessed from the domain and not just the test area where they currently reside.
We have a database of similar size on the server and managed to get good performance but ended up using PostgresSQL to do it. If you wish to change this to PostgreSQL please indicate this when biddding. I don't know which is better other than do know the PostgresSQL worked better for our other database of similar size.
Thank you for your consideration.
Additional Info (Added 11/15/2008 at 14:35 EST)...As there has been questions about the hardware I want to explain. This databse is on a dedicated server with virtualy zero traffic on it. Most of the time there is no traffic. I am running four 2.5" 10,000 RPM drives in a RAID 0 and 8 XEON processors. Hardware is not the issue. Here are the full specs on this new server from Dell:
Item Number Quantity Item Description
1 Quad Core Intel® Xeon® E5335, 2x4MB Cache, 2.0GHz, 1333MHz FSB
1 Quad Core Intel® Xeon® E5335, 2x4MB Cache, 2.0GHz, 1333MHz FSB
1 8GB 667MHz (4x2GB), Dual Ranked DIMMs
1 No Keyboard or Mouse Selected
1 LOM NICs are TOE Ready
1 Riser with 2 PCIe Slots
1 146GB 10,000 RPM Serial Attached SCSI 3GBps Hard Drive, 2.5-inch,
1 PERC 5/i, Integrated Controller Card
1 No Operating System
1 Dual Embedded Broadcom® NetXtreme II 5708 Gigabit Ethernet NIC
1 24X IDE CD-RW/DVD ROM Drive for PowerEdge Servers, All OS
1 Rack Bezel
1 1x4 Backplane for 2.5-inch Hard Drives
1 Electronic Documentation and OpenManage DVD Kit
1 146GB 10,000 RPM Serial Attached SCSI 3GBps Hard Drive, 2.5-inch,
1 Integrated SAS/SATA RAID 0, PERC 5/i Integrated
1 Rack Chassis w/Sliding Rapid/Versa Rails and Cable Management
1 3Yr BASIC SUPPORT: 5x10 HW-Only, 5x10 NBD Onsite
1 Non-Redundant Power Supply
1 Power Cord, NEMA 5-15P to C14, 15 amp, wall plug, 10 feet / 3 meter
1 146GB 10,000 RPM Serial Attached SCSI 3GBps Hard Drive, 2.5-inch,
1 146GB 10,000 RPM Serial Attached SCSI 3GBps Hard Drive, 2.5-inch,
|
