SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 05:10 AM
| ||||
| ||||
 MySQL on a ram disk? We have an intense data process that runs every few minutes, clearing and then loading a database with thousands of records of data, which are then queried on from a website. The periodic load takes about 20 seconds. Some of the front end select queries take a second or two. This is all running on MSSQL, and we are wondering if we could find any speed improvements by moving to MySQL, possibly running on a ram disk. Any input appreciated. Thanks, -Ryan      |
|
02-28-2008, 05:10 AM
| |||
| |||
| RE: MySQL on a ram disk? Hello, Depending on the characteristics of the data and baring dependencies on specific features like FKs or complex JOINs, you may want to take a look at MySQL Cluster. MySQL Cluster supports in-memory and disk-based databases. So, it may give you the high-performance characteristics you are looking for, with the added benefit of high availability. More info at: http://www.mysql.com/products/database/cluster/ Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc > -----Original Message----- > From: Ryan Stille [mailto:ryan@cfwebtools.com] > Sent: Wednesday, November 08, 2006 8:22 AM > To: mysql@lists.mysql.com > Subject: MySQL on a ram disk? > > We have an intense data process that runs every few minutes, > clearing and then loading a database with thousands of > records of data, which are then queried on from a website. > The periodic load takes about 20 seconds. Some of the front > end select queries take a second or two. > This is all running on MSSQL, and we are wondering if we > could find any > speed improvements by moving to MySQL, possibly running on a > ram disk. > Any input appreciated. > > Thanks, > -Ryan > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=jguerrero@mysql.com > > |
|
02-28-2008, 05:10 AM
| |||
| |||
| Re: Re: MySQL on a ram disk? Depends on the value of your data, and what you might want to invest in cluster setup (time, money) to get this done. Another simple option from a hardware perspective might be the use of a PCI card with RAM that serves as a Serial ATA disk. They're relatively new on the market but they're out there, and not too expensive. If you set that up as the storage point for the database in question, and possibly also moved MySQL temp space onto it, it could provide a speed boost. Seems like you could also use two or more of these cards and software or hardware RAID for even more speed. Not exactly enterprise-grade clustering but may suit your needs. Dan On 11/8/06, Ryan Stille <ryan@cfwebtools.com> wrote: > Maybe I should just be looking at using a HEAP table? > > -Ryan > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=drbuettner@gmail.com > > |
|
02-28-2008, 05:11 AM
| ||||
| ||||
| Re: MySQL on a ram disk? Pretty much the only way you're going to find out is by giving it a shot.  I imagine it shouldn't take too much time to setup. Server and querytuning is what will take most time, but I suspect it will be worth it in the end. Once you have your setup, it'd be worth explaining your data and how you work with it in more detail as the list will be able to help you tune your database. Atle - Flying Crocodile Inc, Unix Systems Administrator On Wed, 8 Nov 2006, Ryan Stille wrote: > We have an intense data process that runs every few minutes, clearing > and then loading a database with thousands of records of data, which are > then queried on from a website. The periodic load takes about 20 > seconds. Some of the front end select queries take a second or two. > This is all running on MSSQL, and we are wondering if we could find any > speed improvements by moving to MySQL, possibly running on a ram disk. > Any input appreciated. > > Thanks, > -Ryan > > > > |
Linear Mode
