Hi guys, i have a server with 20GB InnoDb on a single database and i use just one user for its. I use mysql 5.4
1- If i change my SCSI 15k RPM to a SSD i will increase my performance ? 2- What is the fast method to a backup to this InnoDB database ? And the more easy ? And how i restore its ? 3-I need make a clean on one table, its something like: table 1 = 400k rows ( Index field ) table 2 = 15kk rows ( Index field ) table 3 = 150k rows ( Index field ) table 4 = 15kk rows ( Index field ) Its like: "delete from table 4 where id NOT IN ( select id from table1 ) and id NOT IN ( select id from table2 ) id NOT IN ( select id from table3 ) " Have others better methos to make its ? 4- InnoDB have a optimize table ? For re-index or something to make a better performance Thanks guys !! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
