Quote:
Originally Posted by AdultEUhost
innodb or myisam? do you have blob or text fields?
|
myisam , no text fiends
Quote:
Originally Posted by HomerSimpson
How in the hell are you going to move 167gb database from one server to another?
It should work if indexes are good and there are no complex queries...
|
zip and ftp ....
Quote:
Originally Posted by borked
You should *very seriously* look at migrating this database over to apache solr. You will get much, much better response with a tiny footprint for such a key/value pair database. Run with either the standalone Jetty app or bundle it behind Tomcat.  |
okie., need to learn that thing.