It looks like this:
Failed Attempts 134,815 / Total 956,969
Now.. I belive the number of Failed Attempts is CRAZY, what should there be done? Any ideas?
I've read on dev.mysql about mysql_close and such, but on php.net they say it's not really useful if there isn't a mysql_pconnect...
have a look at my mysql status? My php forum gets quite slow at times and I don't really have a clue about the reason why. The server runs on a 3GHz Pentium 4 with 2Gb. The load is strangely not excessive.
I have already made an effort at optimising queries; a week ago, everything seemed fine. I'm worried though about the value of zero for handler_key_reads. Any ideas?
Here's the mysql status output:
Variable_name Value
Aborted_clients 13089
Aborted_connects 1249
Binlog_cache_disk_use 0
Binlog_cache_use 0
Bytes_received 104
Bytes_sent 72
Com_admin_commands 0
Com_alter_db 0
Com_alter_table 0
Com_analyze 0
Com_backup_table 0
Com_begin 0
Com_change_db 0
Com_change_master 0
Com_check 0
Com_checksum 0
Com_commit 0
Com_create_db 0
Com_create_function 0
Com_create_index 0
Com_create_table 0
Com_dealloc_sql 0
Com_delete 0
Com_delete_multi 0
Com_do 0
Com_drop_db 0
Com_drop_function 0
Com_drop_index 0
Com_drop_table 0
Com_drop_user 0
Com_execute_sql 0
Com_flush 0
Com_grant 0
Com_ha_close 0
Com_ha_open 0
Com_ha_read 0
Com_help 0
Com_insert 0
Com_insert_select 0
Com_kill 0
Com_load 0
Com_load_master_data 0
Com_load_master_table 0
Com_lock_tables 0
Com_optimize 0
Com_preload_keys 0
Com_prepare_sql 0
Com_purge 0
Com_purge_before_date 0
Com_rename_table 0
Com_repair 0
Com_replace 0
Com_replace_select 0
Com_reset 0
Com_restore_table 0
Com_revoke 0
Com_revoke_all 0
Com_rollback 0
Com_savepoint 0
Com_select 0
Com_set_option 0
Com_show_binlog_events 0
Com_show_binlogs 0
Com_show_charsets 0......
Code:
mysql> SHOW STATUS;
+----------------------------+------------+
| Variable_name | Value |
+----------------------------+------------+
| Aborted_clients | 510 |
| Aborted_connects | 0 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 441269798 |
| Bytes_sent | 2031527307 |
| Com_admin_commands | 27428 |
| Com_alter_db | 0 |
| Com_alter_table | 4 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 27481 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 0 |
| Com_dealloc_sql | 0 |
| Com_delete | 16883 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_drop_user | 0 |
| Com_execute_sql | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 5515 |
| Com_insert_select | 379 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 0 |
| Com_optimize | 0 |
| Com_preload_keys | 0 |
| Com_prepare_sql | 0 |
| Com_purge | 0 |
| Com_purge_before_date | 0 |
| Com_rename_table | 0 |
| Com_repair | 1 |
| Com_replace | 0 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_revoke_all | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 154467 |
| Com_set_option | 132 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 7 |
| Com_show_charsets | 33 |
| Com_show_collations | 33 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 0 |
| Com_show_databases | 6 |
| Com_show_errors | 0 |
| Com_show_fields | 0 |
| Com_show_grants | 17 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_ndb_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_privileges | 0 |
| Com_show_processlist | 0 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 2 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 38 |
| Com_show_variables | 79 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_close | 0 |
| Com_stmt_execute | 0 |
| Com_stmt_prepare | 0 |
| Com_stmt_reset | 0 |
| Com_stmt_send_long_data | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 38964 |
| Com_update_multi | 0 |
| Connections | 306 |
| Created_tmp_disk_tables | 6302 |
| Created_tmp_files | 3 |
| Created_tmp_tables | 26220 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 7984 |
| Handler_discover | 0 |
| Handler_read_first | 10826 |
| Handler_read_key | 80354286 |
| Handler_read_next | 921590052 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 2852179 |
| Handler_read_rnd_next | 358019891 |
| Handler_rollback | 0 |
| Handler_update | 34804652 |
| Handler_write | 3299547 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 350900 |
| Key_blocks_used | 136652 |
| Key_read_requests | 177777142 |
| Key_reads | 234783 |
| Key_write_requests | 192997 |
| Key_writes | 70499 |
| Max_used_connections | 18 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 126 |
| Open_streams | 0 |
| Open_tables | 89 |
| Opened_tables | 124 |
| Qcache_free_blocks | 1493 |
| Qcache_free_memory | 101831304 |
| Qcache_hits | 247556 |
| Qcache_inserts | 154232 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 170 |
| Qcache_queries_in_cache | 2670 |
| Qcache_total_blocks | 6866 |
| Questions | 491633 |
| Rpl_status | NULL |
| Select_full_join | 0 |
| Select_full_range_join | 0 |
| Select_range | 15228 |
| Select_range_check | 0 |
| Select_scan | 42652 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 29 |
| Sort_merge_passes | 0 |
| Sort_range | 26186 |
| Sort_rows | 92603755 |
| Sort_scan | 28212 |
| Table_locks_immediate | 427295 |
| Table_locks_waited | 239 |
| Threads_cached | 1 |
| Threads_connected | 17 |
| Threads_created | 18 |
| Threads_running | 2 |
| Uptime | 9400 |
+----------------------------+------------+
163 rows in set (0.00 sec)
this is what SHOW STATUS; commands give me can anyone provide me any helpful tips on what I can adjust in my.cnf to lower my server load which is above 10 during peak hours and mysql is the only thing eating this serve up I have lots og 3gb ram and a 64bit AMD 2800 server
In httpd-status under vhosts column i sometime see "(unavailable)" instead of actual vhost.
Can you please tell me if it means that the connection has timed out or something else?
Days ago i did some edit in my.cnf and php.ini, httpd.conf ( i don't remember what i edited , sorry ). Now i can't view server status . I mean
img244.imageshack.us/img244/9193/49930251.jpg ( my friend )
img520.imageshack.us/img520/8650/17287760.jpg ( my page ).
Maybe i disable it... Can you please tell me how to re-enable it again?
This month I just pruchase dedicated server, spec are AMD X2 with 1GB RAM.
On ssh, the memory result is:
root@server1 [~]# free -m
total used free shared buffers cached
Mem: 883 836 47 0 163 397
-/+ buffers/cache: 275 608
Swap: 2047 0 2047
My question:
1. Why the total ram just 883MB? I think it should 1024Mb?
2. The server still empty, but why I see the total used memory is 836Mb?
I only have experience with cpanel vps and when my server empty it only use around 200MB RAM and around 400MB ram usage when my vps load with 30+ account.
we have an option in WHM which we can view the Apache Process, but we don't have this option in PLESK, can I view Apache Process in PLESK too or from SSH?
View 3 Replies View RelatedIt seems to be common that in httpd status in Apache 2.x except real connections you can also see multiple connections from www.example.com
Is it a bug and if not is there a way to make httpd status to not show those www.example.com connections?
I have a message in queue for about 24 hours and checking the delivery log I found this.
LOG: MAIN
cwd=/usr/local/cpanel/whostmgr/docroot 4 args: exim -v -M 1INUw5-0007VU-DZ
delivering 1INUw5-0007VU-DZ
Connecting to mx.uol.xxx.br [xxx.xxx.com.br]:25 ... connected
SMTP<< 220 starfury20.xxx.com.br ESMTP
SMTP>> EHLO svr01.xx***********
SMTP<< 250-starfury20.xxx.com.br
250-PIPELINING
250-SIZE 20971520
250-VRFY
250-ETRN
250 8BITMIME
SMTP>> MAIL FROM: SIZE=3111
SMTP>> RCPT TO:
SMTP>> DATA
SMTP<< 250 Ok
SMTP<< 450 Client host rejected: cannot find your hostname, [74.86.12.2]
SMTP<< 554 Error: no valid recipients
SMTP>> QUIT
I have checked dnsreport for this domain and found this
WARNING: One or more of your mailservers is claiming to be a host other than what it really is (the SMTP greeting should be a 3-digit code, followed by a space or a dash, then the host name). If your mailserver sends out E-mail using this domain in its EHLO or HELO, your E-mail might get blocked by anti-spam software. This is also a technical violation of RFC821 4.3 (and RFC2821 4.3.1). Note that the hostname given in the SMTP greeting should have an A record pointing back to the same server. Note that this one test may use a cached DNS record.
***********.co claims to be host svr01.xx*********** [but that host is at 74.xx.xx.2 (may be cached), not 74.xx.xxx.13]. <br />
What should i do to correct this error? btw, I host about 100 sites on this server.
I have just upgarded to Apache 2.2.x and see these processes in httpd-status
127.0.0.1 www.example.com
Tens of them actually.
why httpd-statsu displays local addresses along with remote ones?
I have a Debian server with RAID 1 via hardware.
Could someone tell me how can i check the RAID status? ( if a hd failed or something like this ).
I have a PROMISE TECH hardware raid card running a 4 disk RAID 10 array. I logged into today to check the drive statuses which were:
Drive 1: OK
Drive 2: OK
Drive 3: OK
Drive 4: OK, PFA
So they all look to be okay, but that 4th disk has PFA (I'm guessing that stands for predicted failure analysis) but I am not sure if that means its predicting a fail, or just stating that the technology is running?
Also, this array is the system drive on a server which has much too little memory, (there is usually 5-7GB PF swap during the day) and I'm concerned that the drives constantly under that stress are more prone to fail. They are 2.5" SAS 10k Fujitsu if that means anything.
how i can enable apache status like cPanel ! in directadmin
before im enabled
Location /httpd-status>
SetHandler server-status
</Location>
but seems its not like cPanel ( dont show IP and where file now downloaded ... and more information)
Server Version: Apache/2.2.3 (CentOS)
Server Built: May 28 2009 12:50:07
Current Time: Wednesday, 10-Jun-2009 05:59:10 EDT
Restart Time: Tuesday, 09-Jun-2009 13:39:08 EDT
Parent Server Generation: 0
Server uptime: 16 hours 20 minutes 1 second
19 requests currently being processed, 13 idle workers
Scoreboard Key:
"_" Waiting for Connection, "S" Starting up, "R" Reading Request,
"W" Sending Reply, "K" Keepalive (read), "D" DNS Lookup,
"C" Closing connection, "L" Logging, "G" Gracefully finishing,
"I" Idle cleanup of worker, "." Open slot with no current process
PID Key:
4494 in state: W , 5241 in state: W , 3142 in state: _
4318 in state: _ , 4319 in state: W , 5173 in state: _
4175 in state: W , 5242 in state: W , 5174 in state: W ....
I just installed DirectAdmin with Apache 2.2 on CentOS 5.2 and whenever I manually restart httpd, it doesn't show if it started the service or not.
Code:
[root@server ~]# service httpd restart
Stopping httpd: [ OK ]
Starting httpd:
[root@server ~]# service httpd status
httpd (pid 17586 17585 17584 17583 17579 17555) is running...
It's running but it doesn't show the OK..
Is this bad? I'd like to fix it before I start moving my files over so I don't mind if I have to reimage it.
This has threw me a little bit. I am to configure WHCMS for my server and its asking me for my server status address. Can some one explain what this odes, i know it has something to do with monitoring. Additionally how should i configure this?
View 2 Replies View Relatedto place the status file that comes with WHMCS to my servers in a place that can be reached by a browser so that the details will be displayed in WHMCS.
Any ideas where I can put it?
All 3 servers are running CentOS 5.2
my server status goes high,when i check current cpu usage is see all time this only /usr/local/cpanel/whostmgr/bin/whostmgr2 ./top what is this bcz iam newbie in this dedicated server also iam seeing lotz of /usr/local/apache/bin/httpd -k start -DSSL
View 7 Replies View RelatedHow would I enable and use server-status with lighttpd?
I've heard that this may help with this problem that I'm facing.
Anyone else seeing packet loss / high latency? I was told that Savvis and or Layer3 are having some routing issues tonight.
View 4 Replies View RelatedWhen looking at the above page (and I've been told this reflects the usage of the entire server I'm on, not just my vps) everything looks fine except the Memory Usage. It's up at about 75%
View 2 Replies View Relatedif anyone can provide me with some syntax help for Apache 2 CustomLog.
Basicly. I want my CustomLog LogFormat to only log entries when the status code is either 200 or 304.
I've looked over [url]
I just can't figure out how to only log those 2 status codes.
How do you add more server status services? Like how do you add like "exim" to show that it's up and running or something like http, ftpd etc..
How do you get things like that to show up showing green under server status?
Are there any good scripts for getting server status?
I want to have a status page for all of my servers.
I am just checking apache status page in WHM
View 1 Replies View Relatedsometimes the load go to 30% and to 50% and more , but the normal status is about 1 --5 % .
the server info is
Processor Information
Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Xeon(R) CPU E5310 @ 1.60GHz
Processor #1 speed: 1600.584 MHz
Processor #1 cache size: 4096 KB
Processor #2 Vendor: GenuineIntel
Processor #2 Name: Intel(R) Xeon(R) CPU E5310 @ 1.60GHz
Processor #2 speed: 1600.584 MHz
Processor #2 cache size: 4096 KB
Processor #3 Vendor: GenuineIntel
Processor #3 Name: Intel(R) Xeon(R) CPU E5310 @ 1.60GHz
Processor #3 speed: 1600.584 MHz
Processor #3 cache size: 4096 KB
Processor #4 Vendor: GenuineIntel
Processor #4 Name: Intel(R) Xeon(R) CPU E5310 @ 1.60GHz
Processor #4 speed: 1600.584 MHz
Processor #4 cache size: 4096 KB
Memory Information
Memory: 6228000k/7077888k available (1892k kernel code, 61808k reserved, 768k data, 192k init, 5373312k highmem)
Current Memory Usage
total used free shared buffers cached
Mem: 6229508 6021996 207512 0 95168 3073956
-/+ buffers/cache: 2852872 3376636
Swap: 4192824 156644 4036180
Total: 10422332 6178640 4243692
i have Centos cpanel server , about 350 acount in this server .
the top when the load is ubnormal :
top - 20:19:33 up 7 days, 3:28, 1 user, load average: 56.20, 55.22, 36.37
Tasks: 392 total, 1 running, 391 sleeping, 0 stopped, 0 zombie
Cpu(s): 1.0% us, 3.4% sy, 10.2% ni, 26.2% id, 59.2% wa, 0.0% hi, 0.0% si
Mem: 6229508k total, 5888852k used, 340656k free, 28236k buffers
Swap: 4192824k total, 162760k used, 4030064k free, 2817588k cached
PID USER PR NI %CPU TIME+ %MEM VIRT RES SHR S COMMAND
15313 mysql 21 6 3 278:06.02 8.7 736m 527m 3096 S mysqld
19305 nobody 20 4 3 0:04.82 0.4 48504 23m 4044 S httpd
31096 nobody 19 4 3 0:00.78 0.4 47436 22m 4272 S httpd
2290 nobody 19 4 3 0:00.44 0.4 47232 21m 3532 S httpd
1111 nobody 19 4 2 0:01.80 0.4 49792 24m 3936 S httpd
1134 nobody 19 4 2 0:02.19 0.4 47864 22m 4004 S httpd
3178 nobody 20 4 2 0:00.31 0.4 47252 22m 3820 S httpd
12710 nobody 19 4 2 0:03.48 0.4 48448 23m 4096 S httpd
2283 nobody 19 4 2 0:01.37 0.4 47540 21m 3572 S httpd
1116 nobody 19 4 1 0:01.46 0.4 47740 22m 3556 S httpd
1152 nobody 21 4 1 0:00.87 0.4 47728 22m 3940 S httpd
30930 nobody 19 4 1 0:01.63 0.4 50288 24m 3572 D httpd
2272 nobody 19 4 1 0:00.59 0.4 47360 21m 3456 S httpd
3170 nobody 20 4 1 0:01.10 0.4 50640 25m 3520 S httpd
3816 named 18 0 1 30:08.91 0.2 80124 13m 1956 S named
1040 nobody 20 4 1 0:00.94 0.4 51476 26m 3948 S httpd
1245 nobody 19 4 1 0:00.94 0.4 51876 26m 3516 S httpd
4879 root 16 0 1 0:00.12 0.0 2536 1208 780 R top
4965 root 20 4 1 0:00.02 0.1 12496 4004 2780 S exim
4970 root 22 4 1 0:00.02 0.1 11228 4008 2784 S exim
4973 root 23 4 1 0:00.02 0.1 11048 4008 2784 S exim
345 nobody 19 4 0 0:02.17 0.4 51300 25m 3960 D httpd
502 nobody 19 4 0 0:07.25 0.4 49868 24m 4088 S httpd
1033 nobody 19 4 0 0:03.28 0.4 48748 23m 3960 S httpd
1115 nobody 19 4 0 0:01.53 0.4 47384 21m 3540 D httpd
1117 nobody 19 4 0 0:01.08 0.4 47772 22m 3936 S httpd
1122 nobody 19 4 0 0:01.20 0.4 47900 22m 3952 S httpd
1132 nobody 19 4 0 0:01.13 0.4 47860 22m 4344 D httpd
1199 nobody 19 4 0 0:01.12 0.4 47340 22m 3932 S httpd
1215 nobody 20 4 0 0:00.76 0.4 47128 21m 3452 S httpd
1232 nobody 19 4 0 0:00.66 0.4 47388 22m 3992 S httpd
2269 nobody 19 4 0 0:00.88 0.4 47784 22m 3548 S httpd
2277 nobody 19 4 0 0:01.22 0.4 47628 22m 3504 S httpd
2279 nobody 19 4 0 0:01.96 0.4 47828 22m 3932 D httpd
2284 nobody 19 4 0 0:01.74 0.4 48112 22m 3580 S httpd
2285 nobody 19 4 0 0:01.25 0.4 47816 22m 3540 S httpd
2287 nobody 19 4 0 0:00.97 0.4 47540 21m 3544 S httpd
I have an account at HostMonster.
Server Load: 12.08 (8 cpus) with RED status
Is it too much?
Any hostmonster users?
Issue: Unable to access simple server status reports though server-status.(chrome could not find..)
Environment:
Home Lab; Win8(dont ask..)
apache 2.0(httpd-2.0.64-win32-x86-no_ssl)
*Fire down, router rules unrestrictive
set in httpd:
...
<Location /server-status>
SetHandler server-status
Order Deny,Allow
Deny from all
Allow from all
</Location>
...
Advanced mods, require compilation to standing installation of apache but the server status is said to be precompiled with the version.
i am trying to get server-status to display. when i have the following set:
<Location /server-status>
SetHandler server-status
Order deny,allow
Deny from all
Allow from .myServer.com
</Location>
You don't have permission to access /server-status on this server.
Pretty new to Apache and recently enabled teh Apache Server Status module.
A column is confusing me, after CONN/CHILD/SLOT is CLIENT, most of the addresses in this column are my own local addresses but I have a few which I don't recognise and show up on whois.net as follows;
203.188.201.201 = Yahoo Mail
199.87.232.177 = No Result
141.44.51.95 = Query terms are ambiguous
58.218.204.102 = CHINANET-JS
Why would these show on my status?
