we have a mysql database with many records (some tables 40 million rows) and will be growing quickly.
We were on a server with single i7 processor and 16 gig ram. no slowness issues.
We move to fater server with two zeon hex cores and 16 gig ram and now some large queries are very slow. - we still own the old server we run same slow querites they 1.5-2 times faster.
is this somethingthat you could help with?