MySQL Forums :: InnoDB :: Innodb configuration optimal for my workload?
Innodb configuration optimal for my workload?
Posted by: Fernando Perez
Date: October 03, 2011 09:14AM
Hi, i have a GPS tracking application, we use MySQL to store the data sent by devices, my application receives the data from the devices via TCP sockets and then launch a thread to insert/update the data in two innodb tables for each device (one table, eventdatalast, just to store the last report for every device and the other, eventdata, to store all the historical data). Due to the number of devices allready reporting to this server im doing between 15 and 20 inserts/updates per second. For my customers i have a java web application to track the units in a map, doing selects over eventdatalast every time i select a unit from a list.
We used MyISAM in the past but we changed to Innodb because with MyISAM i get my tables corrupted very often, and the table eventdata have 15M rows. Now with Innodb everything seems ok execept i get deadlocks in eventdatalast table.
The point of my post is, if someone is so kind, verify that the configuration of MySQL is the optimum for the type of load that the server has.
Windows 2003 Server Enterprise x64
Dual Xeon E5405(Harpertown) 2.00Ghz
System HD 500GB SATA 7200RPM
HD for database 150GB Velociraptor SCSCI 10K RPM
MySQL Version: 5.5.16-log
# CLIENT SECTION
# SERVER SECTION
basedir="E:/MySQL/MySQL Server 5.5/"
datadir="E:/MySQL/MySQL Server 5.5/Data/"
#*** MyISAM Specific options
#*** INNODB Specific options ***
innodb_lock_wait_timeout = 300
transaction_isolation = REPEATABLE-READ
max_allowed_packet = 1M
Thanks in advance.
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.