search for: processlist

...It doesn''t work. My rails is running on webrick in the production mode and the webrick is launched by RadRails. Even though I send multiple requests to my app on rails at the same time, it seemed only one connection is shared ( pooled ). I also checked on MySQL with the command "show processlist" but only one connection was shown. Do I have to do something ?? or Rails on Windows cannot make multiple connections ?? thanks. syuji --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk&...

Dear all, For example I want to process set of files. Typically Perl's idiom would be: __BEGIN__ @files = glob("/mydir/*.txt"); foreach my $file (@files) { # process the file } __END__ What's the R's way to do that? - Gundala Viswanath Jakarta - Indonesia

Today I switched one of our servers from Courier (deployed 3-4y ago) to DCrc7. Everything seemed very nice (system load dropped significantly). Unfortunately after some time and ~8000 pop3-logins the main DC loop just quit without _any_ notice. Some pop3-login childs still showed up in the processlist, but the main listener on port 110 was gone. The above described scenario has been observed 2 times. Any suggestions are welcome. System: Debian 3.0 woody, Linux kernel 2.4.x File offsets ........................ : 64bit I/O loop method ..................... : poll File change notification met...

We also spotted these sql connections getting aborted, upon upgrading MySQL from 5.6 to 5.7. (Going back to 5.6 we don't see them!) Turning on mysql general query logging we can see it is Dovecot's mysql connections that inquire about or update quota usage in particular: *** /logs//mysql.log *** 2019-10-30T10:52:22.624690-07:00 2 Connect dovecot at localhost on npomail using

...but I''m having a little trouble understanding how to handle general purpose queries. A few people have said "with rails I never need to" but either my cases are special or I just don''t "get it" yet. For example, my existing site runs the mysql query SHOW PROCESSLIST, captures the output in a recordset and dumps it to html. Another example is user management where I issue grant statements "GRANT ALL ON dbname.* to user%''*'' IDENTIFIED BY ''abcdefg''", and this merely executes and does not return a record set. I...

...Top also shows that HT CPU instances are idle 40% of their time. What then happens when these messages appear is Asterisk stops accepting originates on the AMI, and that no CDRs write through to the CDR DB anymore - MySQL itself is idle and has no locks or running inserts indicated in "show processlist" in MySQL CLI. The Asterisk instance will then effectively freeze, never hanging up terrminated calls, and never allowing new cals to start, keeping around 320 channels open, forever. Thing is I can sometimes peak at over 350 channels, then come back down as answers, hangups, etc. take place...

I have concluded that it is impossible to get this background process stable. I am out of ideas and could really use some help. Here is what I have: 50 workers, just running an infinite loop that constantly calls save! on a model. Keep in mind this is just for testing purposes. I catch all exceptions and put them in the log. I am tried setting allow_concurrency to true and false. Neither

Hello, Over the weekend, I upgraded one of my servers that runs mysql and pdns to 5.3. Previous to the update I have not had an issue form this server. But since, I have had mysql die multiple times from oom-killer. $ uname -a Linux rack2a 2.6.18-128.1.6.el5 #1 SMP Wed Apr 1 09:10:25 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux Unfortunately, the server has been rebooted by others before I have been

...e and mysql user, so I created a new user for dovecot. syslog shows a few communication packet errors but these are all from postfix, none from dovecot so far. It seems connections are closed after 60s of inactivity (vmail is postfix, vmail2 is dovecot): mysql> select * from INFORMATION_SCHEMA.PROCESSLIST where USER like 'vmail%'; +-----+--------+-----------------+-------+---------+------+-------+------+---------+-----------+---------------+------+ | ID | USER | HOST | DB | COMMAND | TIME | STATE | INFO | TIME_MS | ROWS_SENT | ROWS_EXAMINED | TID | +-----+--------+---------...

..., in run_iotop return curses.wrapper(run_iotop_window, options) File "/usr/lib64/python2.4/curses/wrapper.py", line 44, in wrapper return func(stdscr, *args, **kwds) File "/usr/lib/python2.4/site-packages/iotop/ui.py", line 457, in run_iotop_window process_list = ProcessList(taskstats_connection, options) File "/usr/lib/python2.4/site-packages/iotop/data.py", line 375, in __init__ self.update_process_counts() File "/usr/lib/python2.4/site-packages/iotop/data.py", line 431, in update_process_counts stats = self.taskstats_connection.get_si...

...created a new user for dovecot. > syslog shows a few communication packet errors but these are all from postfix, none from dovecot so far. > > It seems connections are closed after 60s of inactivity (vmail is postfix, vmail2 is dovecot): > > mysql> select * from INFORMATION_SCHEMA.PROCESSLIST where USER like 'vmail%'; > +-----+--------+-----------------+-------+---------+------+-------+------+---------+-----------+---------------+------+ > | ID | USER | HOST | DB | COMMAND | TIME | STATE | INFO | TIME_MS | ROWS_SENT | ROWS_EXAMINED | TID | > +-----+---...

Can a worker kill themselves when they''re ''done''? Or do I have to do that either from the controller or the worker manager? Thanks, Bill -------------- next part -------------- An HTML attachment was scrubbed... URL: http://rubyforge.org/pipermail/backgroundrb-devel/attachments/20061023/11dd429c/attachment.html

Every now and then, mysqld (5.0.22) jumps to 95%+ cpu usage and stays there. Seems to be a common issue, as far as google can tell, but details are alarmingly vague, and some people seem to suggest that it''s a bad query causing it. How do I go about determining if it''s something my application is doing? martin

...----- 296971.7 piranga_xen01 1 263 1 -b---- 1588245.8 piranga_xen02 39 255 1 -b---- 26560.5 piranga_xen03 35 255 1 -b---- 17036.2 piranga_xen04 59 511 1 r----- 15560.6 xenconsoled wasn't showing up in dom0 processlist. After service xend restart the xen04 domU went back to normal again. I've seen previous posts about (and experienced myself) the case where xm list, xm create, xm restart stops working because of a botched xend/xenconsoled, but this is the first time a domU just hangs for me. Anyone else exp...

...s problem occurred on 4 locations with the same hard- and softwareconfiguration. After updating LDAP (removed rpm's and install of latest stable version of openldap) problems where not disappeared but less. It became then clear that nscd was also a problem. The daemon caused the problem: the processlist showed that several instances of nscd were running. But one of the daemons locked the system: it was not possible to fork a new process. Stopping the nscd caused a locked server to run inmediatly as it should and user were inmediatly able to work. On the four locations the nscd is now stopped fo...

...tial attackers can not hack passwords (krb tickets are limited on time and probably uninteresting for them) * it would ease configuration with 'cfengine'; executing 'smbpasswd -w<password>' is really bad since '<password>' appears for a short time in the processlist. Since the password is stored in a binary format, it can not be modified in another way. The practical usage of GSSAPI based auth would be: 1. configure a krb5 cache file (e.g. with $KRB5CCNAME, or an option in smb.conf) 2. periodically (with a cronjob) write the ticket into this file (wh...

...CPU instances are idle 40% of their time. > > What then happens when these messages appear is Asterisk stops accepting > originates on the AMI, and that no CDRs write through to the CDR DB anymore > - MySQL itself is idle and has no locks or running inserts indicated in > "show processlist" in MySQL CLI. > > The Asterisk instance will then effectively freeze, never hanging up > terrminated calls, and never allowing new cals to start, keeping around 320 > channels open, forever. > > Thing is I can sometimes peak at over 350 channels, then come back down as >...

Hello, I want a simple operation in a puppet node like restarting the ssh service if it was stopped. My site.pp is simple as this: import "services/*" node default { include ssh } The services directory as a ssh.pp : class ssh { service { ssh: ensure => running, subscribe => File["/etc/ssh/sshd_config"] } } I''ve stopped the ssh service in the

Hi I've got the error "cannot allocate a new connection -- maximum of 16 connections already opened" after I tried to create a new connection to a database. However, the reason ist, that i did not disconnect previous connections.... I don't know the name of this connections. How can I disconnect this "unknown" connections and drivers? if I delete all objects, the

Hi All, I have an old (2004) Intel based server with 4G of ram running Linux ndgonline.net 2.6.18-92.1.22.el5 #1 SMP Tue Dec 16 12:03:43 EST 2008 i686 i686 i386 GNU/Linux fully up to date using centOS rpms for apache, php, and mysql. I have just changed from dmraid to md raid for the OS on mirrored 80Gb SATA drives. (long story for another time) Mysql lives on a Intel hardware raid 5 controlled