[mythtv-users] mysql problems and how to fix them ...

[Sebastian Niehaus]

Anthony Giggins <seven at seven.dorksville.net> writes:

> On 9 September 2012 07:55, Sebastian Niehaus <niehaus at web.de> wrote:

[...]


> mysqlcheck --repair mythconverg
>
> should be able to repair it, 


Thanks, but it seems to hang. 

> mysqlcheck may not have been stuck it just may
> have been a big table which recordedseek normally is depending how many
> recordings you have.

This is the maschine, no significant load, 3 cores ...

,----
| mythtv at ceramic:~$ cat /proc/cpuinfo 
| processor       : 0
| vendor_id       : AuthenticAMD
| cpu family      : 16
| model           : 4
| model name      : AMD Phenom(tm) II X3 720 Processor
| stepping        : 2
| cpu MHz         : 2800.000
| cache size      : 512 KB
| physical id     : 0
| siblings        : 3
| core id         : 0
| cpu cores       : 3
| apicid          : 0
| initial apicid  : 0
| fpu             : yes
| fpu_exception   : yes
| cpuid level     : 5
| wp              : yes
| flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext fxsr_opt pdpe1gb rdtscp lm 3dnowext 3dnow constant_tsc rep_good nonstop_tsc extd_apicid pni monitor cx16 popcnt lahf_lm cmp_legacy svm extapic cr8_legacy abm sse4a misalignsse 3dnowprefetch osvw ibs skinit wdt
| bogomips        : 5600.72
| TLB size        : 1024 4K pages
| clflush size    : 64
| cache_alignment : 64
| address sizes   : 48 bits physical, 48 bits virtual
| power management: ts ttp tm stc 100mhzsteps hwpstate
| 
| processor       : 1
| vendor_id       : AuthenticAMD
| cpu family      : 16
| model           : 4
| model name      : AMD Phenom(tm) II X3 720 Processor
| stepping        : 2
| cpu MHz         : 800.000
| cache size      : 512 KB
| physical id     : 0
| siblings        : 3
| core id         : 1
| cpu cores       : 3
| apicid          : 1
| initial apicid  : 1
| fpu             : yes
| fpu_exception   : yes
| cpuid level     : 5
| wp              : yes
| flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext fxsr_opt pdpe1gb rdtscp lm 3dnowext 3dnow constant_tsc rep_good nonstop_tsc extd_apicid pni monitor cx16 popcnt lahf_lm cmp_legacy svm extapic cr8_legacy abm sse4a misalignsse 3dnowprefetch osvw ibs skinit wdt
| bogomips        : 5600.00
| TLB size        : 1024 4K pages
| clflush size    : 64
| cache_alignment : 64
| address sizes   : 48 bits physical, 48 bits virtual
| power management: ts ttp tm stc 100mhzsteps hwpstate
| 
| processor       : 2
| vendor_id       : AuthenticAMD
| cpu family      : 16
| model           : 4
| model name      : AMD Phenom(tm) II X3 720 Processor
| stepping        : 2
| cpu MHz         : 800.000
| cache size      : 512 KB
| physical id     : 0
| siblings        : 3
| core id         : 2
| cpu cores       : 3
| apicid          : 2
| initial apicid  : 2
| fpu             : yes
| fpu_exception   : yes
| cpuid level     : 5
| wp              : yes
| flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext fxsr_opt pdpe1gb rdtscp lm 3dnowext 3dnow constant_tsc rep_good nonstop_tsc extd_apicid pni monitor cx16 popcnt lahf_lm cmp_legacy svm extapic cr8_legacy abm sse4a misalignsse 3dnowprefetch osvw ibs skinit wdt
| bogomips        : 5599.99
| TLB size        : 1024 4K pages
| clflush size    : 64
| cache_alignment : 64
| address sizes   : 48 bits physical, 48 bits virtual
| power management: ts ttp tm stc 100mhzsteps hwpstate
| 
`----

It did not finish after 8 hours, think it is broken ...


Sebastian
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: not available
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20120909/441ad669/attachment.sig>