4.0.4 replication slave "hangs" after master breakdown+reboot

conds). If the reboot on the master is done normally (without cutting the connection first), then everything works fine. Michael -- Michael Zimmermann (http://vegaa.de) - Before posting, please check: http://www.mysql.com/

Re: Normalization sql

me, L_Name, id) > Genre (Name, id) > Bitrate (rate, id) -- Michael Zimmermann (http://vegaa.de) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the lis

Re: Efficiency Query

matrix, processed and perhaps written out again. If your problem is fit for a relational database, then MySQL can do the job. If not, then other RDBS have the same problems with it, probably. Get my idea? Greetings Michael

Re: help with query, pelase

) In that case please include examples of your query with actual values. Thanks - -- Michael Zimmermann (Vegaa Safety and Security for Internet Services) <[EMAIL PROTECTED]> phone +49 89 6283 7632hotline +49 163 823 1195 Key fingerprint = 1E47 7B99 A9D3 698D 7E35 9BB5 EF6B EEDB 69

Re: Port 3306 restricted to IP addresses

Also, you can enable ipfw or some other > local firewall on the host itself if you are very serious. Yes, I was sloppy in my language. I meant local packet filters to allow the mysql-port for certain IPs only, sure. Greetings - -- Michael Zimmermann (Vegaa Safety and Security for Internet

Re: help with query, pelase

d of the sql results). Probably the last group has different 'order by' values.(?) - -- Michael Zimmermann (Vegaa Safety and Security for Internet Services) <[EMAIL PROTECTED]> phone +49 89 6283 7632hotline +49 163 823 1195 Key fingerprint = 1E47 7B99 A9D3 698D 7E35 9BB5 E

Re: Port 3306 restricted to IP addresses

? I let the firewall do that kind of restrictions. - -- Michael Zimmermann (Vegaa Safety and Security for Internet Services) <[EMAIL PROTECTED]> phone +49 89 6283 7632hotline +49 163 823 1195 Key fingerprint = 1E47 7B99 A9D3 698D 7E35 9BB5 EF6B EEDB 696D 5811 -BEGIN PGP SIGNATURE--

Re: CPU - hog / hangup with replication

ve an AHA! moment? Have a happy day! Michael - -- Michael Zimmermann (Vegaa Safety and Security for Internet Services) <[EMAIL PROTECTED]> phone +49 89 6283 7632hotline +49 163 823 1195 Key fingerprint = 1E47 7B99 A9D3 698D 7E35 9BB5 EF6B EEDB 696D 5811 -BEGIN PGP SIGNATURE-

Re: PigeonRank™

count 'not-yet-pecked' as the fourth). Working on it. Michael - -- Michael Zimmermann (Vegaa Safety and Security for Internet Services) <[EMAIL PROTECTED]> phone +49 89 6283 7632hotline +49 163 823 1195 Key fingerprint = 1E47 7B99 A9D3 698D 7E35 9BB5 EF6B EEDB 696D

CPU - hog / hangup with replication

sfule updates, where the system seems to 'hang' and one mysql process uses 99,9% CPU. Is my mysql or OS too outdated, or what would you do to debug the situation? mysql: 2.23.41 Kernel: 2.4.10-4GB Distro: SuSE 7.3 Thank you for any idea or hint where to look. Michael -- Michael Zi