Re: suggestions - server options/mysql variables
We don't know anything about you structures, your data, or your indicies. You should show them along with the output of EXPLAIN on your query. Derick Smith wrote: Hi! All the select statements have indexes on appropriate fields. Mysql appears to run fast, I was just wondering if there was anyway to make it faster. It is currently running on Windows, I have also ported it to HP-UX 11. The queries are of the type : SELECT * FROM textl WHERE parsetext = "" and filter = "" GROUP BY code. I think the query code is optimized, I was wondering is there were any settings I could change in mysql to speed it up? or any other tricks to increase speed? I tried setting set-variable = key_buffer_size=64M, but that did not appear to make a big difference. Thanks Eric From: "Mike Hillyer" <[EMAIL PROTECTED]> To: "Derick Smith" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> Subject: RE: suggestions - server options/mysql variables Date: Thu, 19 Jun 2003 09:13:33 -0600 If you have queries that are only selects, in small tables, with few rows, you should have very fast performance as is. Are your queries properly indexed? What hardware are you running on? What do these queries look like? Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Derick Smith [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 19, 2003 9:08 AM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: suggestions - server options/mysql variables > > > Hi! > Does anyone know any mysql options I can change in the my.ini > file or mysql > variables to increase the speed of select statements? > > About database: > -uses only select statements for queries > -no transactions > -if database becomes corrupt in anyway, not a big deal I can > recreate it > -it is a small database, I do not need recovery, raid or any > other backup > mechanism > -queries generally return very little data > > I will test any suggestions people have for me. > Thanks > Eric > > _ > MSN 8 with e-mail virus protection service: 2 months FREE* > http://join.msn.com/?page=features/virus > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: suggestions - server options/mysql variables
Hi! All the select statements have indexes on appropriate fields. Mysql appears to run fast, I was just wondering if there was anyway to make it faster. It is currently running on Windows, I have also ported it to HP-UX 11. The queries are of the type : SELECT * FROM textl WHERE parsetext = "" and filter = "" GROUP BY code. I think the query code is optimized, I was wondering is there were any settings I could change in mysql to speed it up? or any other tricks to increase speed? I tried setting set-variable = key_buffer_size=64M, but that did not appear to make a big difference. Thanks Eric From: "Mike Hillyer" <[EMAIL PROTECTED]> To: "Derick Smith" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> Subject: RE: suggestions - server options/mysql variables Date: Thu, 19 Jun 2003 09:13:33 -0600 If you have queries that are only selects, in small tables, with few rows, you should have very fast performance as is. Are your queries properly indexed? What hardware are you running on? What do these queries look like? Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Derick Smith [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 19, 2003 9:08 AM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: suggestions - server options/mysql variables > > > Hi! > Does anyone know any mysql options I can change in the my.ini > file or mysql > variables to increase the speed of select statements? > > About database: > -uses only select statements for queries > -no transactions > -if database becomes corrupt in anyway, not a big deal I can > recreate it > -it is a small database, I do not need recovery, raid or any > other backup > mechanism > -queries generally return very little data > > I will test any suggestions people have for me. > Thanks > Eric > > _ > MSN 8 with e-mail virus protection service: 2 months FREE* > http://join.msn.com/?page=features/virus > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: suggestions - server options/mysql variables
If you have queries that are only selects, in small tables, with few rows, you should have very fast performance as is. Are your queries properly indexed? What hardware are you running on? What do these queries look like? Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Derick Smith [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 19, 2003 9:08 AM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: suggestions - server options/mysql variables > > > Hi! > Does anyone know any mysql options I can change in the my.ini > file or mysql > variables to increase the speed of select statements? > > About database: > -uses only select statements for queries > -no transactions > -if database becomes corrupt in anyway, not a big deal I can > recreate it > -it is a small database, I do not need recovery, raid or any > other backup > mechanism > -queries generally return very little data > > I will test any suggestions people have for me. > Thanks > Eric > > _ > MSN 8 with e-mail virus protection service: 2 months FREE* > http://join.msn.com/?page=features/virus > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
suggestions - server options/mysql variables
Hi! Does anyone know any mysql options I can change in the my.ini file or mysql variables to increase the speed of select statements? About database: -uses only select statements for queries -no transactions -if database becomes corrupt in anyway, not a big deal I can recreate it -it is a small database, I do not need recovery, raid or any other backup mechanism -queries generally return very little data I will test any suggestions people have for me. Thanks Eric _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]