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 ?
Hi Guys i have a dedicated mysql-server and neeed tips and sugestion
to optimize its to a better performance.
1-) Here i have results from mysqltunner
MySQLTuner 1.0.1 - Major Hayden ma...@mhtx.net
Bug reports, feature requests, and downloads at http://mysqltuner.com/
Run with '--help'
Hi guys i have a problem, 3 big tables: item_instance about 15KK rows,
character_inventory 15KK rows, guild_bank_item 2KK rows.
And i need i clean on item_instance how this query:
DELETE FROM `item_instance` WHERE guid NOT IN(SELECT item FROM
`character_inventory`) AND guid NOT IN(SELECT
Hi all, after random times not only about high usage, i have this
message on Mysql Administrator ( Windows ), logged to my Dedicated
Database ( Linux ).
Here is a print of error:
http://img25.imageshack.us/img25/2342/mysqlthreaderror.jpg
Here is a print of putty using 'top' on dedicated server: