It is possible to show resources usage stat. to customers?
Any addons & scripts?
This is very important function, but cpanel didn't have it.
I created same thread to forums.cpanel.net but no replies.
Is there way to show the memory usage of the server in PHP?
The server is a VPS on Virtizzio(or whatever its called).
I want to make a little WAP page I can access on my mobile to show the servers CPU and Memory usage.
I already know how to show the CPU load.
OK, seems owner can be seen when api is set to CGI :-)
View 0 Replies View Related[openvz] WHM not show partition on Service Status and Disk usage
Hi, the VPS not show the partition on "Service Status" of WHM and in the "Show Current Disk Usage" see the Attach Files images...
How to fix/show this?
Attached Thumbnails
ÂÂ*
I migrated from one server running Plesk 10.4.4 Update #59 to a new server running Plesk 11 which I then updated to 12.0.18 Update #32. Since moving to Plesk 12 the "Notify when disk space/traffic usage reaches" emails have been being sent to our customers set up on the server whereas previously they were sent to the server admin email address.
Is this a change with this version?
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
We are running Plesk 12.0.18 with MySQL (Server Version: 5.5.33-MariaDB - openSUSE package) on OpenSuSE 13.1
MySQL is running in strict mode and its fine for the most of our customers. But some are trying to run Contenido, thats a CMS, which could work with this mode and we have to disable mysql strict mode.
So my question is: Is it possible to disable mysql strict mode just for choosen customers?
I've got a e-mail notification problem since i upgraded from Plesk 11.5 to Plesk 12: One specific Application Update for customer X is being sent to all my customers.
Last week we did have a problem with a busted customer portal. ( not customer X, plus still on Plesk 11.5 ) I fixed this by using this procedure: [URL] ..... Restored two records and problem solved.
As a temporary resolution we disabled Application Updates for our customers, but I do want that my customers receive Application Updates, but just the one where they are the recipient.
After running for a while mysql suddenly starts using 100% CPU and my site goes down due to apache waiting with 150 sleeping processes.
Here is the top stats
PHP Code:
top - 00:20:47 up 12:01, 2 users, load average: 1.11, 1.04, 0.95
Tasks: 200 total, 2 running, 198 sleeping, 0 stopped, 0 zombie
Cpu(s):100.0%us, 0.0%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 1004152k total, 618132k used, 386020k free, 118436k buffers
Swap: 2000084k total, 0k used, 2000084k free, 282372k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
2011 mysql 18 0 177m 43m 5684 S 99.9 4.5 86:51.60 mysqld
14877 root 15 0 2360 1216 860 R 0.3 0.1 0:00.11 top
1 root 15 0 1948 648 556 S 0.0 0.1 0:00.97 init
ps ax | grep apache -c
152
On restarting mysql everything goes back to normal.
Can someone tell me how I could go about rectifying this?
I'm sure the server can take the load, coz before this the site was on a way slower machine and worked flawlessly.
is there any way to find out which users are most intensively using mysql? i've installed mytop which gives me some info, but the only user it shows connected is me (i.e. localhost) with no break down of what tables are being used etc.
also in whm i can see mysql has consuming quite a bit of memory/cpu, but it doesn't show me individual users; just the service as a whole.
I am using lighttpd php and mysql.
How to lower the cpu usage?
What's the best way to monitor mysql usage?
Quote:
top - 10:39:48 up 10 days, 35 min, 1 user, load average: 8.22, 9.38, 8.50
Tasks: 132 total, 5 running, 127 sleeping, 0 stopped, 0 zombie
Cpu(s): 73.5%us, 22.3%sy, 0.0%ni, 2.1%id, 0.0%wa, 0.1%hi, 2.0%si, 0.0%st
Mem: 2075000k total, 1919256k used, 155744k free, 113660k buffers
Swap: 2031608k total, 56k used, 2031552k free, 1177200k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
21899 mysql 20 0 200m 53m 4752 S 182 2.6 8100:18 mysqld
2548 lighttpd 20 0 20288 16m 680 S 19 0.8 878:33.76 lighttpd
9759 lighttpd 20 0 23168 7880 3048 S 10 0.4 8:50.96 php-cgi
30959 lighttpd 20 0 23164 7896 3096 S 10 0.4 11:40.95 php-cgi
9732 lighttpd 20 0 23204 7544 2664 S 8 0.4 8:59.42 php-cgi
10671 lighttpd 20 0 23248 7612 2664 S 8 0.4 4:51.95 php-cgi
9769 lighttpd 20 0 23312 8012 3048 S 7 0.4 8:55.61 php-cgi
9771 lighttpd 20 0 23104 7312 2584 S 7 0.4 8:50.33 php-cgi
10601 lighttpd 20 0 23336 8032 2996 S 7 0.4 4:56.21 php-cgi
31091 lighttpd 20 0 23064 7860 3100 S 7 0.4 11:30.69 php-cgi
9782 lighttpd 20 0 23116 7880 3060 S 7 0.4 8:57.46 php-cgi
8559 lighttpd 20 0 23396 7780 2668 R 6 0.4 6:43.16 php-cgi
Does anyone know if MySQL 5.1 or 5.0 uses less memory than 4.1 does?
View 3 Replies View Relatedhow to set MAX_CONNECTIONS_PER_HOUR for one of my CPANEL USER (like:
cpaneluser_somesubuser) for all his databases?
I tried:
Quote:
mysql> GRANT USAGE ON *.* TO 'cpaneluser_somesubuser'@'localhost' WITH MAX_CONNECTIONS_PER_HOUR 10;
I'm having a problem with high MySQL CPU usage on my server, one of my sites is getting hit pretty hard right now and MySQL is just killing the box. Its averaging a load of over 20, CPU usage is around 130%.
here is my my.cnf file. is there anything in their that should be changed to help lower the CPU usage?
# The MySQL server
[mysqld]
port= 3306
socket= /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 256M
max_allowed_packet = 1M
table_cache = 512
max_connections=500
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 2
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
Server Specs.
Pentium E 2.0Ghz
2GB ram
2x 320GB hard drives.
Cent OS 5
Cpanel
My mysql is using alot of memory although there is not much data into the mysql tables.
I tried to control mysql usage by editing my.cnf file but that didnt help.
Which variables should I edit in my.cnf to keep mysql using low memory?
I edited sort_buffer_size, key_buffer_size but that didnt help much. It uses alot of per-thread memory as well.
I need some help my CPU (Intel Core 2 Duo 1.7 Ghz) always gets high usage from mysql sometimes its using 95% cpu etc... How can I modify my.cnf to use less CPU and more ram since I have 3gb ram installed?
here is my.cnf
Code:
[mysqld]
back_log = 5
skip-innodb
max_connections = 400
key_buffer = 190M
myisam_sort_buffer_size = 156M
join_buffer_size = 4M
read_buffer_size = 4M
sort_buffer_size = 5M
table_cache = 1024
record_buffer = 1024
thread_concurrency = 2
long_query_time = 1
thread_cache = 1024
thread_cache_size = 992025
wait_timeout = 13
connect_timeout = 5
tmp_table_size = 64M
max_heap_table_size = 16M
max_allowed_packet = 16M
max_connect_errors = 500
read_rnd_buffer_size = 1024
bulk_insert_buffer_size = 32M
query_cache_limit = 1M
query_cache_size = 64M
query_cache_type = 1
query_prealloc_size = 163840
query_alloc_block_size = 32768
low_priority_updates=1
default-storage-engine = MyISAM
[mysqld_safe]
nice = -2
open_files_limit = 4096
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 32M
write_buffer = 32M
I'm always having MySQL consuming quite a bit of cpu & ram.
what's happening here?
PHP Code:
mysql 27519 7.2 12.8 158736 132496 ? Sl Mar08 180:57 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/server.hostname.pid --skip-external
I have replaced my server's real hostname to server.hostname
is there is any way or command to know every account on the server how much it using for mysql space?
i know i can know it from cpanel page but it's for one account is there a way to make a list for the usage?
and also i want if there is any wait to limit the database size?
cuz i want make a limitation for my clients every account cannot put any databases more thatn 100MB size?
I am very low of system resources but wish to use MYSQL as my database backend so I have installed MYSQL 4.0 on my Debian Sarge 3.1 VPS with linuxthreads and configured it to use least possible resources as my VPS only offers 32MB main memory. Generally I use the PS command to get the memory usage of running processes. But MYSQL being threaded confuses me. My system uses linuxthreads so all the threads get listed as seperate processes but show same stats in PS command output. On initialization, MYSQL starts 3 threads which according to documentation, are necessary for its functioning. This is what I see:
root 139 0.0 0.0 2436 4 ? S Feb07 mysqld_safe
mysql 163 0.0 4.5 5480 1264 ? S Feb07 0:02 mysqld
mysql 164 0.0 4.5 5480 1264 ? S Feb07 0:00 mysqld
mysql 165 0.0 4.5 5480 1264 ? S Feb07 0:00 mysqld
Is that means MYSQL is using only 1264 Kb of real memory? If that is the case, I am really happy about my tweaking skills. After doing a query through PHP, the output becomes:
root 139 0.0 0.0 2436 4 ? S Feb07 mysqld_safe
mysql 163 0.0 4.5 5510 1278 ? S Feb07 0:02 mysqld
mysql 164 0.0 4.5 5510 1278 ? S Feb07 0:00 mysqld
mysql 165 0.0 4.5 5510 1278 ? S Feb07 0:00 mysqld
Thats just very nominal resource usage. I am assuming that what PS is showing are just duplicate entries for a single MYSQLD process and 1278 Kb can be safely taken as its RAM usage. I hope it is not (1278 X No. of mysqld threads).
I had a 280 MB MySQL db on a 384 MB Linux Dual Xeon 3.2 GHz VPS (no CP, no additional software) and it was no where near enough. Even if I upgraded the VPS to say 1 GB of Memory, it would take no time at all to over load it at this rate. There must be something wrong with the setup, I can't see MySQL being so resource heavy... or is it?
View 7 Replies View RelatedWe have been getting a high quantity of requests for our VPS's with CPANEL preinstalled.
However, we feel that CPANEL uses way too many resources, and honestly its a bit expensive for what it does.
So, here's the deal, WHY CPANEL, and not Open source alternatives such as ISP Config?
Please give me some other Open Source (aka free), Web Hosting panels, as part of this poll!?
I personally always have favored doing everything on the 'bare' system, this is why CPANEL doesn't make too much sense for myself.
So, what is it about cpanel and plesk, etc thats so much better against the free options out there?
Where does cpanel keep the reseller username and the usernames that are under each reseller?
View 5 Replies View RelatedI'm checking my CPU/Memory/MySQL Usage and I'm seeing that something called Munin is running at 54%. That is apparently the average for today. Can anyone give me any insight as to what this is?
Wikipedia classifies Munin as a network monitoring application. I don't think it should be using this much processing.
It appears that I may have enabled this plugin when I rebuilt my apache using EasyApache. Are there any big benefits to this? Looking at the graphics at first glance it doesn't look like there is. but then again, I'm not that knowledgable about this stuff.
I'm no SQL expert so I'm not exactly sure what to look for in-depth here. However, I noticed that MySQL would periodically raise to 98% cpu usage in top. So, I checked it out and turns out every time you load the front page of a site I host it takes about 30 seconds to load and its during that time that MySQL is freaking out.
I know the user relies heavily on MySQL, however I want to try to narrow down the problem as much as possible for them. Any recommendations on what else to look for?
just noticed mysql cpu usage has shot up from its usual 5-10% cpu to 30%+. domains are as normal and no extraordinary php processes.
any way i can tell what users are most heavily running mysql? (as in number queries / slow queries etc?) i know mysqladmin processlist but that only gives me a snapshot, whereas i want to see over 24 hours, who used mysql the most...
What is the average memory/cput usage for httpd connections.?One of the site is using 2.8% memory. Is it acceptable for 1 GB RAM servers?
View 6 Replies View Relatedon my server i have 104 accounts and the MySQL Usage for th cpus is 25.23
like this pic [url] is that danger? and how can i resolve it?
Not displaying CPU/Memory/MySQL Usage stats.Can u tell me how can i do it.
View 2 Replies View Relatedmy server is jammed and takes minutes to load simple pages, can you please take a look ath the following image, its show under "CPU %" for mysql 177, does that mean mysql is using 177% of resources of cpu?
View 3 Replies View Related