On Fri, Jul 9, 2010 at 9:09 PM, Andrés Tello <mr.crip...@gmail.com> wrote: > Hi, I'm using mysql 4.1.21, a legacy system. Next step to migrate it, but > for now, I need the community help. > > I have a 23GB table, if I do a select count(over_an_index) from table it > uses 1.4minutes to read. The main issue is that this table is the main table > of a system and each query is taking too long to complete.
A table definition would be heplful here. > How can I optimize the access of the database? > > any mysql variable I could use? > or how can I load the index into memory? I have 32GB of ram XD plenty to > useit into something more useful.... A configuration file would be helpful here. > > Thanks. > My guess is that you have a innodb table and that you have unallocated innodb buffer pool. This is nothing more than a guess What is ram XD? -- Rob Wultsch wult...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
