MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: Utilize maximum system resources for better performance
Posted by: Rick James
Date: October 02, 2015 08:50PM

> looking in to it, as when 6mil rows gets updated daily , only their seeders,leechers,verified, last_updated fields gets updated

It copies the entire record over, regardless of how little is changed.

> > Did you specify "ROW_FORMAT=FIXED"? If so, why?
> nope i didnt specify it , i convrted this table from myisam to innodb

Yeah, I don't know what, if anything, it means for InnoDB.

> generating xml

Perhaps much of the time is in this step?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Utilize maximum system resources for better performance
3119
Ronald Brown
July 14, 2015 01:54AM
Re: Utilize maximum system resources for better performance
1276
Ronald Brown
July 14, 2015 01:58AM
Re: Utilize maximum system resources for better performance
1233
Ronald Brown
July 14, 2015 02:12AM
Re: Utilize maximum system resources for better performance
1228
Peter Brawley
July 14, 2015 11:30AM
Re: Utilize maximum system resources for better performance
1178
Ronald Brown
July 14, 2015 11:57AM
Re: Utilize maximum system resources for better performance
1331
Rick James
July 15, 2015 08:36PM
Re: Utilize maximum system resources for better performance
1517
Ronald Brown
July 30, 2015 07:22AM
Re: Utilize maximum system resources for better performance
1382
Ronald Brown
July 30, 2015 07:26AM
Re: Utilize maximum system resources for better performance
1365
Rick James
July 31, 2015 10:20PM
Re: Utilize maximum system resources for better performance
1357
Ronald Brown
August 02, 2015 01:27AM
Re: Utilize maximum system resources for better performance
1372
Rick James
August 02, 2015 11:10AM
Re: Utilize maximum system resources for better performance
1753
Ronald Brown
August 08, 2015 01:27AM
Re: Utilize maximum system resources for better performance
1248
Rick James
August 08, 2015 11:49AM
Re: Utilize maximum system resources for better performance
1225
Ronald Brown
August 08, 2015 01:01PM
Re: Utilize maximum system resources for better performance
1811
Rick James
August 08, 2015 03:43PM
Re: Utilize maximum system resources for better performance
1342
Ronald Brown
August 09, 2015 12:40AM
Re: Utilize maximum system resources for better performance
1125
Ronald Brown
August 09, 2015 07:33AM
Re: Utilize maximum system resources for better performance
1202
Rick James
August 09, 2015 03:53PM
Re: Utilize maximum system resources for better performance
1362
Ronald Brown
August 09, 2015 08:04PM
Re: Utilize maximum system resources for better performance
1130
Rick James
August 09, 2015 11:17PM
Re: Utilize maximum system resources for better performance
1204
Ronald Brown
August 10, 2015 12:00AM
Re: Utilize maximum system resources for better performance
1261
Ronald Brown
August 10, 2015 08:36AM
Re: Utilize maximum system resources for better performance
1367
Rick James
August 10, 2015 11:00AM
Re: Utilize maximum system resources for better performance
1328
Rick James
August 10, 2015 11:03AM
Re: Utilize maximum system resources for better performance
1979
Ronald Brown
September 16, 2015 11:39AM
Re: Utilize maximum system resources for better performance
1372
Rick James
September 18, 2015 09:54PM
Re: Utilize maximum system resources for better performance
1028
Ronald Brown
September 19, 2015 01:18AM
Re: Utilize maximum system resources for better performance
1708
Rick James
October 02, 2015 08:50PM
Re: Utilize maximum system resources for better performance
1148
Ronald Brown
October 02, 2015 09:09PM
Re: Utilize maximum system resources for better performance
1114
Rick James
October 03, 2015 04:46PM
Re: Utilize maximum system resources for better performance
1229
Ronald Brown
August 09, 2015 01:07AM
Re: Utilize maximum system resources for better performance
1099
Ronald Brown
September 23, 2015 09:58AM


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.