Mysql Status Inspection

May 24, 2008

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......

View 2 Replies


ADVERTISEMENT

MySQL Status

Nov 15, 2007

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...

View 3 Replies View Related

Mysql> SHOW STATUS; Optimization Of My.cnf

Feb 16, 2007

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

View 6 Replies View Related

Httpd-status Vhost Status

Feb 25, 2007

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?

View 8 Replies View Related

Server Status

May 12, 2009

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?

View 14 Replies View Related

Strange RAM Status

Aug 22, 2008

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.

View 10 Replies View Related

Apache Status

Jun 15, 2008

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 Related

Httpd Status

Dec 30, 2007

It 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?

View 14 Replies View Related

Status:ACTIVE

Aug 22, 2007

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.

View 3 Replies View Related

Httpd-status

Nov 29, 2007

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?

View 0 Replies View Related

Verify RAID Status

Oct 26, 2009

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 ).

View 3 Replies View Related

RAID Health Status

Oct 15, 2009

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.

View 0 Replies View Related

How Enable Apache Status

Jun 10, 2009

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 ....

View 1 Replies View Related

Httpd Does Not Show Status

Dec 6, 2008

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.

View 6 Replies View Related

Server Status Address

Feb 23, 2008

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 Related

WHMCS Status File

Dec 16, 2008

to 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

View 12 Replies View Related

Server Status Goes High

Apr 5, 2008

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 Related

Server-status Lighttpd

Oct 12, 2007

How would I enable and use server-status with lighttpd?

I've heard that this may help with this problem that I'm facing.

View 5 Replies View Related

Savvis / Layer 3 Status

Aug 31, 2007

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 Related

CPanel Server Status ?'s

Nov 8, 2007

When 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 Related

Apache CustomLog - Status Code

Apr 14, 2009

if 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.

View 0 Replies View Related

How To Add More Service Status Services In CPanel/WHM

Mar 15, 2008

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?

View 3 Replies View Related

Good Scripts For Getting Server Status?

Mar 10, 2008

Are there any good scripts for getting server status?

I want to have a status page for all of my servers.

View 3 Replies View Related

Checking Apache Status Page In WHM

Nov 15, 2008

I am just checking apache status page in WHM

View 1 Replies View Related

High Load , Strange Status

Feb 10, 2008

sometimes 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

View 4 Replies View Related

Server Load: 12.08 (8 Cpus) With RED Status

Nov 1, 2008

I have an account at HostMonster.

Server Load: 12.08 (8 cpus) with RED status

Is it too much?

Any hostmonster users?

View 14 Replies View Related

Apache :: Server Status Unavailable

Jan 14, 2014

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.

View 6 Replies View Related

Apache :: Get Server-status To Display

Mar 24, 2014

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.

View 3 Replies View Related

Apache :: Client Address Via Status

Nov 1, 2013

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?

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved