On Fri, Jul 9, 2010 at 9:09 PM, Andrés Tello <[email protected]> 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 [email protected] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[email protected]
