RE: mySql versus Sql Server performance

2010-10-26 Thread Patrick Thompson
Thanks a lot - I'll try playing around with some of that stuff and at least get the memory utilization between mySql and Sql Server comparable. At some point I would like to see the abstraction layer running under mono - but won't get to that for a while - when I do I can post linux based number

RE: mySql versus Sql Server performance

2010-10-26 Thread Gavin Towey
It's not much, but the dataset is definitely larger than your buffer pool. You could try this query to show how much data+index is in innodb: SELECT SUM(data_length+index_length) as data size FROM INFORMATION_SCHEMA.TABLES WHERE ENGINE='InnoDB'; = Then SET GLOBAL buffer_pool_size= I don't hav

Re: Is SSD suitable for mysql server?

2010-10-26 Thread mos
At 12:56 AM 10/25/2010, you wrote: Hello, We are a company for gaming. Our main db is mysql 5.1 installed on Linux. Currently the hardware for mysql is 2*4 CPU, 16G memory, Raid 10 (four disks). Now we have the plan to replace the disks with SSD for better performance. Do you think is it right f

Re: SQL book recommendation?

2010-10-26 Thread Arthur Fuller
Visit our site (www.artfulsoftware.com) for lots of tips, especially on queries. Arthur >-Original Message- > >From: Philip Riebold [mailto:p.rieb...@ucl.ac.uk] > >Sent: Tuesday, October 26, 2010 7:31 AM > >To: MikeB > >Cc: mysql@lists.mysql.com > >Subject: Re: SQL book recommendation?

RE: SQL book recommendation?

2010-10-26 Thread Jerry Schwartz
You might want to use an on-line introductory course, if you have time for the leisurely pace. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com >-Origina

Re: SQL book recommendation?

2010-10-26 Thread Philip Riebold
On 26 Oct 2010, at 11:49, MikeB wrote: > I'm finding the MySQL online manuals hard going in figuring out how to > construct SQL queries. Can anyone perhaps recommend a good book that can shed > light on the subject? > > Thanks. The book I've been using is 'MySQL, The definitive guide to using

RE: SQL book recommendation?

2010-10-26 Thread Jay Blanchard
[snip] I'm finding the MySQL online manuals hard going in figuring out how to construct SQL queries. Can anyone perhaps recommend a good book that can shed light on the subject? [/snip] http://www.peachpit.com/store/product.aspx?isbn=0321375734 MySQL, Second Edition: Visual QuickStart Guide, 2n

SQL book recommendation?

2010-10-26 Thread MikeB
I'm finding the MySQL online manuals hard going in figuring out how to construct SQL queries. Can anyone perhaps recommend a good book that can shed light on the subject? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql

Re: Is SSD suitable for mysql server?

2010-10-26 Thread Joerg Bruehe
Hi Warren, all! Your statement is true ... Warren Young wrote: > [[...]] > > A lone 2 TB rotating disk will beat a top-of-the-line SSD for linear > writes, and you can beat an SSD for linear reads with a pair of disks in > RAID-0 or -1, or four disks in RAID-10. [[...]] ... but irrelevant: Li

RE: Is SSD suitable for mysql server?

2010-10-26 Thread Glyn Astill
--- On Mon, 25/10/10, Daevid Vincent wrote: > From: Daevid Vincent > Subject: RE: Is SSD suitable for mysql server? > To: "'mysql'" > Date: Monday, 25 October, 2010, 21:52 > > I guess it depends on how > important your data is too.  Quite > > a few of the SSDs on the market have been proven to