sometimes some forum use a lot of resource of cpu and memory,
my friend want to check which mysql thread waste a lot of resource,
he want to improve his program,
when i ssh the server,
what command can help me check and resource it?
i am looking some shared hosting plan,
some companies say each account can not use system resource (ram and cpu) over 5%,
i want to ask how do they record the value?
ps.the server is centos with cpanel.
What factors do I need to look at in determining the proper setting for thread_concurrency in my.cnf running on a virtuozzo VPS? Processor threading as per usual or barrier values under /proc/user_beancounters?
I commented it out entirely a while back because I was I was hitting the privmpages limit. I forgot about it because I'd been having acceptable performance. Now it it's occurring to me that I could maybe slowly take it back up.
I am looking to add a mysql external source to my plesk. So far no difficulty.
My question is if I remove the mysql server where the currently plesk. I have to say to the panel get the information (psa, roudcube, horde) on the remote mysql to invez mysql local server?
I'm starting to get annoyed with companies stipulating that is it considered a waste of space to store your own files, and backups or whatever on your shared hosting account.
I don't understand why that is considered a waste of space you purchase that space and bandwidth. So why can you not use it for whatever you want in legal terms.
In fact I would be confident to say I have not seen a single terms of service NOT state that you cannot use your space as storage.
I have a problem where mysqld is using 95 - 97% CPU usage all the time.
How can I see what user is causing this ? I have installed mytop but when I use it I get
Quote:
[root@server1 ~]# mytop
Cannot connect to MySQL server. Please check the:
* database you specified "test" (default is "test")
* username you specified "root" (default is "root")
* password you specified "" (default is "")
* hostname you specified "localhost" (default is "localhost")
* port you specified "3306" (default is 3306)
* socket you specified "" (default is "")
The options my be specified on the command-line or in a ~/.mytop
config file. See the manual (perldoc mytop) for details.
Here's the exact error from DBI. It might help you debug:
Access denied for user 'root'@'localhost' (using password: NO)
I really need to track down the culprit!
we've currently got a 2 server setup, apache+mysql
Mysql server is a Xeon 3.2Ghz with 2Gb ram, scsi 73gb raid1 disks
Server has been running a while, steadily increasing in traffic. whilst 90% of the time it's running ok (load around 0.5 - 1.0, cpu around 25-50% busy mainly mysql, disk i/o around 3% busy) during heavy traffic times everything slows right down
At the moment the mysql box is only running mysql so we've allocated about 1.5gb out of the 2gb to mysql.
At present, when we get busy the apache server is queing up requests as it waits for the mysql server. Query log shows most queries are <1sec, any other's are being optimised but due to the nature of our website there are a few pesky queries (only occasionally being slow though).
question is, can this config be tuned any more or is it time for an upgrade - mainly ram to add more innodb buffers?
Here's the result of tuning-primer.sh
Code:
SLOW QUERIES
The slow query log is enabled.
Current long_query_time = 2 sec.
You have 9 out of 159346 that take longer than 2 sec. to complete
Your long_query_time seems to be fine
BINARY UPDATE LOG
The binary update log is enabled
The expire_logs_days is not set.
The mysqld will retain the entire binary log until RESET MASTER or PURGE MASTER LOGS commands are run manually
Setting expire_log_days will allow you to remove old binary logs automatically
See http://dev.mysql.com/doc/refman/4.1/en/purge-master-logs.html
WORKER THREADS
Current thread_cache_size = 384
Current threads_cached = 15
Current threads_per_sec = 0
Historic threads_per_sec = 0
Your thread_cache_size is fine
MAX CONNECTIONS
Current max_connections = 150
Current threads_connected = 4
Historic max_used_connections = 18
The number of used connections is 12% of the configured maximum.
Your max_connections variable seems to be fine.
MEMORY USAGE
Max Memory Ever Allocated : 1 G
Configured Max Per-thread Buffers : 5 G
Configured Max Global Buffers : 803 M
Configured Max Memory Limit : 6 G
Physical Memory : 1.99 G
Max memory limit exceeds 90% of physical memory
KEY BUFFER
Current MyISAM index space = 82 K
Current key_buffer_size = 5 M
Key cache miss rate is 1 : 1862
Key buffer fill ratio = 100.00 %
Your key_buffer_size seems to be fine
QUERY CACHE
Query cache is supported but not enabled
Perhaps you should set the query_cache_size
SORT OPERATIONS
Current sort_buffer_size = 16 M
Current read_rnd_buffer_size = 7 M
Sort buffer seems to be fine
JOINS
Current join_buffer_size = 4.00 M
You have had 0 queries where a join could not use an index properly
Your joins seem to be using indexes properly
join_buffer_size >= 4 M
This is not advised
OPEN FILES LIMIT
Current open_files_limit = 11095 files
The open_files_limit should typically be set to at least 2x-3x
that of table_cache if you have heavy MyISAM usage.
Your open_files_limit value seems to be fine
TABLE CACHE
Current table_cache value = 5467 tables
You have a total of 732 tables
You have 155 open tables.
The table_cache value seems to be fine
TEMP TABLES
Current max_heap_table_size = 255 M
Current tmp_table_size = 256 M
Of 21109 temp tables, 35% were created on disk
Effective in-memory tmp_table_size is limited to max_heap_table_size.
Perhaps you should increase your tmp_table_size and/or max_heap_table_size
to reduce the number of disk-based temporary tables
Note! BLOB and TEXT columns are not allow in memory tables.
If you are using these columns raising these values might not impact your
ratio of on disk temp tables.
TABLE SCANS
Current read_buffer_size = 7 M
Current table scan ratio = 929 : 1
read_buffer_size seems to be fine
TABLE LOCKING
Current Lock Wait ratio = 1 : 117
You may benefit from selective use of InnoDB.
If you have long running SELECT's against MyISAM tables and perform
frequent updates consider setting 'low_priority_updates=1'
Server is mainly Innodb due to previous row-locking issues.
How can i check (using SSH) which databases/users cause server load to mysql ?
I've tried "mysqladmin proc stat" but it shows just the current. How can i get stats of the last 24 hours for example ?
I've also seen slow connections stats. What is the command to check more detailed report of the slow connections; which databases caused it etc', in the last 24 hours for example as well.
I have cPanle shared account.
Is there a way to automatically check and repair mysql databases and tables, that can be scheduled as cron job?
I have linux server and when i run a command with normal user i m getting following error ---->
[~]# sudo java -Xms16m -Xmx64m -version
Error occurred during initialization of VM
Cannot create VM thread. Out of system resources.
but it works with root user so can anyone tell me how to run with normal user.
[~]# free -m
total used free shared buffers cached
Mem: 4054 2340 1714 0 652 1260
-/+ buffers/cache: 427 3627
Swap: 8000 0 8000
As you can imagine it is daunting trying to filter out the reviews of various webhosts on this forum. For someone who has not ruled out any webhost for hosting his business website, the time it takes to do appropriate research can be very time consuming.
I was wondering if there was some meta/uber thread that has a bunch of webhosts on it with a general rating for the host, maybe a "percentage approved" scale or something.
Or am I resigned to reading a bunch of threads?
I find that lots of hosts don't put the link to a phpinfo() script on their websites, even though that would save everyone a lot of unnecessary questions.
So I figure we should have a thread where people can add links to phpinfo scripts on their own hosts, or hosts where they happen to have the URL of a phpinfo script.
For those of you who own your own web hosting services, here's a chance to show off all your installed goodness, and all it takes is placing a simple link here (and put one in your FAQ section on your web site too, for the love of God)..
Since the forum doesn't allow editing your own posts (I still think that is nuts), please include all previous links in your post, so visitors will only need to read the LAST post to find all the updated links in one place.
As of 12-15-08 our spam system has learned and blocked these addresses. Check attachment for your records help stop spam at the source.
View 9 Replies View RelatedI've been having trouble the past few days with someone who's been "attacking" my site so to speak by continuously downloading very large files with as many connections as (he) can open. I operate a large downloads site for computer games, this person has selected the largest files (like 400-500MB). Not sure of the real intent other than to clog up my bandwidth capacity. Also he appears to be using proxies since as soon as I ban one, another shows up seeminly from China.
Anyway, I have mod_bw and I've limited the number of connections in the downloads area to 2. While that works ok, his tool uses threads like a download manager would and he's using up 30-40 child threads for his 2 file downloads.
So 2 questions,
Is there anyway to not only limit file downloads to 2, but limit the number of connections per request? Many of my visitors do use download managers and I'd like for them to continue using them but use a reasonable number of threads like 6 or 8, but not 30.
Also, is there a way to restrict access to someone using a proxy?
we are try SuPhp on Cpanel server but seem that is use a lot of resource, on 2 X quad core server we can't add more than 300 domains for server, whic configuration do u use? any alternative solution?
View 7 Replies View Relatedi know admin can limit the ram and hd resource for each vps account,
but about the cpu,
can admin limit how many percentage or MHz or each vps account?
how do we know if our blog spent alot of resource on server (shared hosting)? can we monitor it, so if i knew i spent alot of resource i can move to another webhost (maybe VPS) before they suspend my blog?
View 10 Replies View RelatedI have a VPS account and during the recent days it seems to have slowed down a lot, when I check the process I can find loads of
1727 0.2 0.0 /usr/local/apache/bin/httpd -DSSL 0 24 7152 S 00:00:02 99
My system usage is at 98.5% and the numproc out of 400 allowed 392 is in use It wasn't like this before and i have used up only 38% of the space alloted and cpu load is also at just 19%.
Could anyone explain me whats actually the problem of high system usage?
There are Small Hosting companies and There are Big Hosting companies.
And Then There are Huge Hosting companies.
Who Consumes The Most Resources?
Your Views On It?
I own a dedicated server and have 3 cpanel for each of my 3 sites in my WHM, I was wondering how much resource would each cpanel account use?
Reason I'm asking is because I have a couple of other sites i'd like to add to this server but I'm not sure if I should simply add them as domain add-on's in one of my current cpanel accounts or if it's ok to create another for each site without using up my server's resources.
Hope that makes sense.
I own a couple of servers xeon setups. All use cPanel/WHM.
A client yesterday asked if we could have ffmpeg-php installed on the server so that they could run phpfox.
I have heared ffmpeg is resource intensive? Will it make a big difference on dual core server? Should I install ffmpeg-php or risk losing a client?
If I should install ffmpeg-php I have been having trouble doing so, can anyone help me with this.
I am running a youtube clone on a VPS with 512mb ram at Lunarpages.
Whenever I log into Plesk, I find that my system usage is extremely high. 90%++ even up to 100%. However my CPU usage is often less than 5%.
This problem often occurs when there is slightly more visitors on my site. I am talking about only 30++ visitors and this problem will occur and my site slows to a crawl and I have to restart the VPS.
The script or the server?
I am wondering if simultaneous downloads could take up a lot of CPU/Ram usage? Could a celeron server with 512MB handle simultaneous downloads and how many users can it support simultaneously? The server will be serving as a pure download, no database, no php, no cgi, no nothing. And what is the highest mbps this server could potentially reach?
View 6 Replies View Relatedi have one Question regarding MX-Records, i cant solve myself. Why is an MX-Record not allowed to contain an Ip or a CNAME-Record? As far as i know, the Record has always to point to an A-record which includes the Ip. Anyone here, who can explain why thats the case? Is there any RFC Dokument where this is explained?
View 9 Replies View RelatedI would like to know how resource intensive is ClamAV Scanner. Should I allow it or not to my VPS clients/resellers?
Can I set it to use it as root? How?
I've been running website for several years, however, there's one thing that I've never quite figured, most likely because I haven't gone over to dedicated/vps yet.
How much memory would a static 10kb HTML use or for that matter a PHP page (static)?
I know it's quite a broad question, but I'm asking this as I might start a project and this one page may receive many hits. Oh and, would the memory usage go up if I have embedded objects from an outside source (e.g. embedded Youtube videos)?
I have seen posts that some hosts suspend a user after they so many seconds of high server resource usage... I was wondering how this is done so that I can do this on my dedicated server.
View 1 Replies View RelatedI would like to know how to check load via ssh and check files causing load?
I want the ssh codes for 2 different set of control panels, one with cpanel+whm and other with kloxo+hypervm
and I would also know how to check the files causing the load, such as some files could have been interrupted while processing, so they could be causing load some times, so I want to stop such processes if any are running on the vps on my friends accounts
Excessive resource usage: dbus (2015)
I get below alarm from lfd
Quote:
Time: Sun Sep 28 12:16:06 2008 +0200
Account: dbus
Resource: Process Time
Exceeded: 134303 > 1800 (seconds)
Executable: /bin/dbus-daemon
The file system shows that this executable file that the process is running has been deleted. This typically happens if the original file has been replaced by a new file when the application is updated. To prevent this being reported again, restart the process that runs this excecutable file.
Command Line: dbus-daemon --system
PID: 2015
Killed: No
How can I find which process runs this excecutable file ?
I got this resource shortage in my VPS
Disk Inodes 100.0% (Red Zone)
and when i ebter the ssh i got
/tmp/RsBfUSnM: Disk quota exceeded
-bash: echo: write error: Broken pipe
What is cause this and how can i solve this issue?