Re: High cpu usage

2018-10-26 Thread shawn l.green
sults from SELECT * FROM information_schema.INNODB_TRX; during the day as we get this issue regularly and will provide feedback. Regards (earlier thread below... ) From: shawn l.green Sent: Thursday, 25 October 2018 9:54:10 PM To: mysql@lists.mysql.com Sub

Re: High cpu usage

2018-10-26 Thread Machiel Richards
ursday, 25 October 2018 9:54:10 PM To: mysql@lists.mysql.com Subject: Re: High cpu usage Hello Machiel, On 10/25/2018 6:09 AM, Machiel Richards wrote: > Good day all > > > Hoping this mail finds you well. > > > I am hoping someone can perhaps give us some guidance her

Re: High cpu usage

2018-10-25 Thread shawn l.green
, replication is unpaused, and completes processing and catchup within about 15 minutes and is paused again about 30 minutes after the unpause. Give or take 45 minutes to an hour after the replication is paused again, mysql starts to cause high cpu usage with no apparent processes running as can

High cpu usage

2018-10-25 Thread Machiel Richards
minutes and is paused again about 30 minutes after the unpause. Give or take 45 minutes to an hour after the replication is paused again, mysql starts to cause high cpu usage with no apparent processes running as can be seen on full processlist (maybe one or two selects which completes

Re: mysqld shows high cpu usage over extended time, restart = normal

2003-07-17 Thread Jeremy Zawodny
On Wed, Jul 09, 2003 at 01:08:56PM -0400, Dave [Hawk-Systems] wrote: load). Is there a known issue (running on FreeBSD 4.8, MySQL 3.23.55 MyISAM)? its been a known issue for quite a long time use linuxthreaded version and it should work fine. although much of work has been done on

mysqld shows high cpu usage over extended time, restart = normal

2003-07-09 Thread Dave [Hawk-Systems]
(running on FreeBSD 4.8, MySQL 3.23.55 MyISAM)? Is there something I should check when next I notice the high CPU usage? Thanks Dave -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: mysqld shows high cpu usage over extended time, restart = normal

2003-07-09 Thread Terry
hi, load). Is there a known issue (running on FreeBSD 4.8, MySQL 3.23.55 MyISAM)? its been a known issue for quite a long time use linuxthreaded version and it should work fine. although much of work has been done on threads implementation, there are still such problems with mysql. it

Re: mysqld shows high cpu usage over extended time, restart = normal

2003-07-09 Thread Peter L. Berghold
On Wed, 2003-07-09 at 10:31, Dave [Hawk-Systems] wrote: Is there a known issue (running on FreeBSD 4.8, MySQL 3.23.55 MyISAM)? Is there something I should check when next I notice the high CPU usage? I used to see the same kind of behavior a while back with a MySQL installation I did

RE: mysqld shows high cpu usage over extended time, restart = normal

2003-07-09 Thread Dave [Hawk-Systems]
load). Is there a known issue (running on FreeBSD 4.8, MySQL 3.23.55 MyISAM)? its been a known issue for quite a long time use linuxthreaded version and it should work fine. although much of work has been done on threads implementation, there are still such problems with mysql. it happens

RE: mysqld shows high cpu usage over extended time, restart = normal

2003-07-09 Thread Dave [Hawk-Systems]
Is there a known issue (running on FreeBSD 4.8, MySQL 3.23.55 MyISAM)? Is there something I should check when next I notice the high CPU usage? I used to see the same kind of behavior a while back with a MySQL installation I did for a client. It turned out that what was happening was a poorly

busy site w/ high cpu usage on mysql

2001-10-29 Thread alexus
Hello I have a very busy site (www site) w/ a lot of hits my site is very heavily integrated w/ mysql and when i do top it shows me like over 80% of cpu even though i have dual p3 850mhz w/ 1.5 gig of ram any ideas what to do about it so it'll drop down? thank you in advance

Re: busy site w/ high cpu usage on mysql

2001-10-29 Thread Bill Adams
alexus wrote: Hello I have a very busy site (www site) w/ a lot of hits my site is very heavily integrated w/ mysql and when i do top it shows me like over 80% of cpu even though i have dual p3 850mhz w/ 1.5 gig of ram any ideas what to do about it so it'll drop down? Have you