MySQL Forums
Forum List  »  Performance

Re: How To Use More Resources
Posted by: Luis Cavazos
Date: January 08, 2015 05:48PM

Thanks,
I have made the sugested changes and is working very good,
I also changed this to se what hapend, it seems that when need to write or read from disk it goes much faster on IO. it reads or writes More MB/s but in Much Less Time,
but I can not tell if is because the changes you sugested the ones I changed or both,(if you can clarify this please do), I'm Very new with Mysql.

innodb_io_capacity = 4000
innodb_io_capacity_max = 8000
innodb_write_io_threads = 16
innodb_read_io_threads = 16

And yes My server has RAID 5+0 with 8Hdds total

Regarding Datatypes Decimal and Integers, The way we migrated the DB from Sybase To Mysql made al decimal type.

The Stored Procedures and Functions, I Already Checked One by One, and Made changes to them, I believe ther are in a Very good shape now.

Againg Thank you Very much For your help.!!

Options: ReplyQuote


Subject
Views
Written By
Posted
1747
January 07, 2015 11:12AM
747
January 07, 2015 07:14PM
1133
January 07, 2015 09:14PM
1089
January 07, 2015 11:21PM
702
January 07, 2015 11:42PM
Re: How To Use More Resources
784
January 08, 2015 05:48PM
845
January 09, 2015 02:39PM


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.