Login | Register For Free | Help	Search this list this category for: (Advanced)

Mailing List Archive: MythTV: Users High mysql cpu usage   Index | Next | Previous | View Flat

martin at mstubbs Mar 23, 2012, 3:43 PM Views: 980 Permalink High mysql cpu usage I have been running the master branch for many months but over the last few weeks I have seen the system become very unresponsive. Unfortunately I can't say exactly when the problem started. When I looked at cpu usage it shows mysql at 100% usage for long periods of time. The log below was produced with -v schedule. 2012-03-23 21:37:20.770916 I [24958/24985] Scheduler scheduler.cpp:2011 (HandleReschedule) - Reschedule requested for id -1. 2012-03-23 21:37:20.775287 I [24958/24985] Scheduler scheduler.cpp:3345 (UpdateMatches) - Query 0: /record.search = :NRST AND program.manualid = 0 AND program.title = record.title 2012-03-23 21:37:20.775317 I [24958/24985] Scheduler scheduler.cpp:3345 (UpdateMatches) - Query 1: /record.search = :NRST AND program.manualid = 0 AND program.seriesid <> '' AND program.seriesid = record.seriesid 2012-03-23 21:37:20.775485 I [24958/24985] Scheduler scheduler.cpp:3406 (UpdateMatches) - |-- Start DB Query 0... 2012-03-23 21:37:20.849820 I [24958/24985] Scheduler scheduler.cpp:3431 (UpdateMatches) - |-- -1 results in 0.074297 sec. 2012-03-23 21:37:20.849932 I [24958/24985] Scheduler scheduler.cpp:3406 (UpdateMatches) - |-- Start DB Query 1... 2012-03-23 21:37:51.050528 I [24958/25333] DVBRead mythdbcon.cpp:453 (CloseDatabases) - Closing DB connection named 'DBManager23' 2012-03-23 21:37:58.901735 I [24958/24985] Scheduler scheduler.cpp:3431 (UpdateMatches) - |-- -1 results in 38.0518 sec. 2012-03-23 21:37:58.901814 I [24958/24985] Scheduler scheduler.cpp:3435 (UpdateMatches) - +-- Done. 2012-03-23 21:37:58.903036 I [24958/24985] Scheduler scheduler.cpp:360 (FillRecordList) - BuildWorkList... 2012-03-23 21:37:58.903049 I [24958/24985] Scheduler scheduler.cpp:365 (FillRecordList) - AddNewRecords... 2012-03-23 21:37:58.988499 I [24958/24985] Scheduler scheduler.cpp:3792 (AddNewRecords) - |-- Start DB Query... 2012-03-23 21:37:59.301672 I [24958/24985] Scheduler scheduler.cpp:3813 (AddNewRecords) - |-- 596 results in 0.313128 sec. Processing... 2012-03-23 21:37:59.331165 I [24958/24985] Scheduler scheduler.cpp:3988 (AddNewRecords) - +-- Cleanup... 2012-03-23 21:37:59.331998 I [24958/24985] Scheduler scheduler.cpp:367 (FillRecordList) - AddNotListed... 2012-03-23 21:37:59.332031 I [24958/24985] Scheduler scheduler.cpp:4038 (AddNotListed) - |-- Start DB Query... 2012-03-23 21:37:59.332747 I [24958/24985] Scheduler scheduler.cpp:4056 (AddNotListed) - |-- 0 results in 0.000698 sec. Processing... 2012-03-23 21:37:59.332791 I [24958/24985] Scheduler scheduler.cpp:370 (FillRecordList) - Sort by time... 2012-03-23 21:37:59.333603 I [24958/24985] Scheduler scheduler.cpp:372 (FillRecordList) - PruneOverlaps... 2012-03-23 21:37:59.333648 I [24958/24985] Scheduler scheduler.cpp:375 (FillRecordList) - Sort by priority... 2012-03-23 21:37:59.378252 I [24958/24985] Scheduler scheduler.cpp:377 (FillRecordList) - BuildListMaps... 2012-03-23 21:37:59.378513 I [24958/24985] Scheduler scheduler.cpp:379 (FillRecordList) - SchedNewRecords... 2012-03-23 21:37:59.378517 I [24958/24985] Scheduler scheduler.cpp:1228 (SchedNewRecords) - Scheduling: ### Lines not copied 2012-03-23 21:37:59.378687 I [24958/24985] Scheduler scheduler.cpp:549 (PrintRec) - +Click 80 BBC NEW 24 01:30-02:00 1 13 13 C 13 0/13 2012-03-23 21:37:59.378735 I [24958/24985] Scheduler scheduler.cpp:549 (PrintRec) - +Saturday Kitchen 1 BBC ONE 24 10:00-11:30 1 13 13 C 13 0/13 2012-03-23 21:37:59.378770 I [24958/24985] Scheduler scheduler.cpp:549 (PrintRec) - #This Morning - Saturday 3 ITV1 24 11:20-12:25 1 13 13 C - 0/13 2012-03-23 21:37:59.378792 I [24958/24985] Scheduler scheduler.cpp:549 (PrintRec) - !Saturday Kitchen 1 BBC ONE 24 10:00-11:30 1 13 13 C 13 0/13 ### Similar lines not copied 2012-03-23 21:37:59.399954 I [24958/24985] Scheduler scheduler.cpp:549 (PrintRec) - Narrow Boat Afloat - Knowle to Roy 38 QUEST 30 13:30-14:00 1 0 0 C R 0 2012-03-23 21:37:59.399974 I [24958/24985] Scheduler scheduler.cpp:549 (PrintRec) - New Tricks - Where There's Smoke 1 BBC ONE 30 21:00-22:00 1 0 0 C P 0 2012-03-23 21:37:59.399977 I [24958/24985] Scheduler scheduler.cpp:516 (PrintList) - --- print list end --- 2012-03-23 21:37:59.399994 I [24958/24985] Scheduler scheduler.cpp:2069 (HandleReschedule) - Scheduled 55 items in 38.6 = 38.13 match + 0.49 place 2012-03-23 21:37:59.400459 I [24958/24985] Scheduler scheduler.cpp:1818 (run) - sleeping for 60000 ms (interuptable) 2012-03-23 21:38:27.145753 I [24958/25370] DVBRead mythdbcon.cpp:75 (MSqlDatabase) - Database connection created: DBManager24 As you can see from the above logs the scheduling run took approx 39 secs and mysqld was showing 100% cpu usage for the whole time. I have done all the mysql tuning suggested in previous messages and also run mysqltuner.pl but it hasn't helped. I have also "repaired" and "optimised" the database. The backend uses a AMD Athlon(tm) 64 X2 Dual Core Processor 5200+ with 2Gb of RAM so is not short of power. Any ideas would be appreciated. Thanks Martin _______________________________________________ mythtv-users mailing list mythtv-users [at] mythtv http://www.mythtv.org/mailman/listinfo/mythtv-users

Subject User Time High mysql cpu usage martin at mstubbs Mar 23, 2012, 3:43 PM     Re: High mysql cpu usage mtdean at thirdcontact Mar 23, 2012, 10:02 PM         Re: High mysql cpu usage martin at mstubbs Mar 24, 2012, 10:55 AM             Re: High mysql cpu usage mtdean at thirdcontact Mar 24, 2012, 11:10 AM             Re: High mysql cpu usage Jens.Peder.Terjesen at devoteam Mar 26, 2012, 12:29 AM     Re: High mysql cpu usage martin at mstubbs Mar 26, 2012, 1:48 AM         Re: High mysql cpu usage Jens.Peder.Terjesen at devoteam Mar 28, 2012, 3:01 AM     Re: High mysql cpu usage jarlethorsen at gmail Dec 30, 2012, 4:30 AM     Re: High mysql cpu usage dekarl at spaetfruehstuecken Dec 30, 2012, 7:27 AM         Re: High mysql cpu usage davescammell at gmail Dec 30, 2012, 8:15 AM         Re: High mysql cpu usage jarlethorsen at gmail Dec 30, 2012, 9:20 AM     Re: High mysql cpu usage jarlethorsen at gmail Dec 30, 2012, 9:25 AM     Re: High mysql cpu usage keemllib at gmail Dec 30, 2012, 9:37 AM     Re: High mysql cpu usage mtdean at thirdcontact Dec 30, 2012, 11:28 AM         Re: High mysql cpu usage davescammell at gmail Dec 30, 2012, 1:19 PM         Re: High mysql cpu usage Jens.Peder.Terjesen at devoteam Jan 8, 2013, 3:17 AM     Re: High mysql cpu usage jarlethorsen at gmail Jan 6, 2013, 11:01 AM     Re: High mysql cpu usage mtdean at thirdcontact Jan 6, 2013, 1:02 PM         Re: High mysql cpu usage jarlethorsen at gmail Jan 7, 2013, 11:36 AM     Re: High mysql cpu usage jarlethorsen at gmail Jan 8, 2013, 10:56 AM     Re: High mysql cpu usage mtdean at thirdcontact Jan 8, 2013, 11:35 AM         Re: High mysql cpu usage tom at redpepperracing Jan 8, 2013, 12:11 PM         Re: High mysql cpu usage jarlethorsen at gmail Jan 9, 2013, 10:45 AM     Re: High mysql cpu usage mtdean at thirdcontact Jan 8, 2013, 12:35 PM         Re: High mysql cpu usage tom at redpepperracing Jan 8, 2013, 12:45 PM         Re: High mysql cpu usage gary.buhrmaster at gmail Jan 8, 2013, 7:52 PM     Re: High mysql cpu usage michael at thewatsonfamily Jan 9, 2013, 3:20 PM         Re: High mysql cpu usage jarlethorsen at gmail Jan 10, 2013, 12:02 PM     Re: High mysql cpu usage jarlethorsen at gmail Jan 10, 2013, 12:47 PM     Re: High mysql cpu usage jrauti at iki Jan 10, 2013, 9:18 PM     Re: High mysql cpu usage mtdean at thirdcontact Jan 11, 2013, 7:13 AM         Re: High mysql cpu usage paul at raison Jan 11, 2013, 11:14 AM             Re: High mysql cpu usage belcampo at zonnet Jan 11, 2013, 12:13 PM         Re: High mysql cpu usage jrauti at iki Jan 12, 2013, 3:55 AM     Re: High mysql cpu usage jarlethorsen at gmail Jan 14, 2013, 11:47 AM     Re: High mysql cpu usage mtdean at thirdcontact Jan 14, 2013, 12:12 PM         Re: High mysql cpu usage jarlethorsen at gmail Jan 15, 2013, 11:37 AM     Re: High mysql cpu usage jrauti at iki Jan 14, 2013, 12:55 PM

Index | Next | Previous | View Flat   MythTV     Users     Theming     Dev     Mythtvnz     Commits     Translators     Firehose

Interested in having your list archived? Contact Gossamer Threads
 

Web Applications & Managed Hosting Powered by Gossamer Threads Inc.