One of my friends uses a popular shared hosting provider, and I was assisting him with a web site issue earlier.
I noticed the following warning in the host's control panel:
"[MySQL databases] may not be used for log evaluation operations, ad clicks, chat systems, banner rotations, or similar applications putting extreme loads on the database under any circumstances."
Is this common at other shared hosts?
Does anyone know of any shared hosting plans that don't have any MySQL limitations? Aplus.net and Powweb are trying to shut down my accounts because of this problem, and I can't afford dedicated hosting quite yet.
View 12 Replies View RelatedIs 40 max_user_connections for MySql typical in a Shared Hosting environment? Or are there Shared Hosts out there that allow more than 40 max_user_connections per account?
View 14 Replies View RelatedI have seen some shared hosting providers include cPanel. As far as I understand cPanel is to manage and install apps on VPS. Why would you need that on shared hosting?
View 14 Replies View RelatedI am in a shared hosting environment. Their php's setting does not have open_basedir set and safe_mode is off.
I was poking around their server and noticed that using some simple system() calls within a php script, I was able to access /etc/passwd and therefore access all their client's public_html.
I am currently calling them to let them know of the vulnerability. But out of curiosity, is it normal that I can read all the other site hosted? They do have config files with mysql pasword in it.
Has anybody successfully used nginx in a shared web hosting environment?
It seems quite powerful and looks like it would be well suited for such an environment, combined with FastCGI, looks like it could serve a lot of hits on relatively inexpensive servers.
The main problem I'm foreseeing is a demand for mod_rewrite, which may cause some support headaches.
Anything else I'm not thinking of?
(I did search but the last post I found was from 2007 with no replies, and necroposting is bad)
I'm running a shared hosting environment and I'd like to know if it's even possible to secure the Apache while it's running mod_php. I know I could go suPHP with PHP-CGI, but that'd increase drastically the server load.
So what should I do to best secure the server?
So far now I did:
- Apache:
Installed mod_security and mod_evasive.
- PHP:
Set register_globals=OFF
Set disable_functions = ini_restore, popen, exec, shell_exec, system, passthru, proc_open, proc_close
Set safemode=ON
Set open_basedir to user's directory on virtualhost
Is that would be a secure environment for my users?
I know,Free Hosting has various limitations but I wanted to get the communities view to It.
View 10 Replies View Relatedi want to install subversion on my shared environment,
i want to ask if it will waste alot of system resource or any problem?
my server is centos with cpanel
Does anyone have an opinion on the performance of XO's shared web hosting solution when you're using their built-in MySQL capability with PHP coding?
View 0 Replies View RelatedMySQL 5.0 supports stored procedures -- but is it safe to allow shared hosting customers to have privileges to create them? If the procedures are global, does that mean that:
a) one customer could write a procedure which accessed another customer's data?
b) any customer could call a procedure created by a different customer?
c) any customer could override an existing mysql function in a way that would affect other customers?
d) any customer could write a function that bound to a system library and crash the entire server instance?
I'm working with a non-profit and we're looking for an inexpensive hosting but we also need to be able to access MYSQL (port 3306) through the internet.
We use Crystal Reports and need to get to the database directly for reports.
I'm going to be rolling out a php/mysql driven site soon and I'm pretty much resigned to the fact that the mysql performance dreamhost has given me isn't going to cut it, its probably too oversold. Simple one table one column selects can take 30 seconds or time out depending on how badly the server is being hammered. HTTP requests are usually snappy, but the mysql performance is bogus.
What is a good host for me to launch this site with? Storage wouldn't need to be too terribly high, at least initially. I'm tempted by MediaTemple's slick marketing, but I've seen on here that some people have had poor sql performance (contrary to what some personal friends have experienced, so I'm torn). I was reading about downtownhost on here, but their load times seemed slow when I hit a couple domains listed on here that are hosted by them.
This host needs to be located in the US. Honestly, I like dreamhost and their panel, save for the sql sluggishness I'm getting.
Pros/cons? Success stories? Security/stability? Tried w/ cPanel? Yes/no?
A good friend handed me a SLES disc awhile back and I'm loading it up now to give it a shot on a whitebox with one of my test domains and IP's. Anybody have anything to share?
I'm running SQL 2005 in my hosting environment, and plan on offering as part of my plans.
The one issue I'm having is any user can view all the databases. My main issue is I need to store client information (sorry, I only can afford one server) into the database. Basically I'm creating *all* the backend panels, management, etc in ASPNET/C#.
The database will have FTP, email, payment, etc stored it in. Should I hold off and only offer mySQL? I DO NOT want the users seeing my databases like that. They can't access them, but still. I don't know what Microsoft was thinking!
I was thinking about developing my own SQL Manager where you could execute scripts, edit/create tables, and do everything you needed right inside of your webbrowser. This is, of course, a lot of work when you can do it easily in SQL Manager express. I imagine my way would be easier since I could make a list of blocked commands, run a check on the commands the user is executing, and block them.
By the way, I'm running Windows 2008 x64 w/IIS7 and the entire panel will be custom made by me and two other programmers, with me being the lead developer.
my friend and i are working on some web-based-commerce ideas and at current we're at godaddy.com. i can only imagine the vitriol they've rightfully earned here, as we decided to be done with them when the $30 SSL license they told us we could get one night quickly became $78 because there was a new "turboSSL server" package we needed, nevermind the guy the first time said with our hosting options we only needed to go through them for the SSL license, so basically, either the first guy lied to us or the second guy tried to hustle us, either way, i dont like companies whose sales model is revealed like the plot in a horror movie, so we're looking to go elsewhere.
basically we're looking for a virtual private server setup, although actually another question i'd love to ask someone is if joomla is better served on unix/linux or windows, with a few dozen accounts needed, and by accounts i mean domains and whatnot, as right now it's basically the blanket idea that you grab the names you need, or might go to if you change your mind on company names...
so basically, with all the people here talking about bad experiences with places, are there any good experience type places where someone can get competent tech support, no hustling in sales pitches, and quality service at a nice solid price?
again, sorry to show up and start asking for things, but i'm not necessarily well versed in these arts yet... rest assured once i have some information i shall contribute to the community and help others who are in my position now
I am under the impression that VPS services do not limit CPU Usage.
I would like to be able to just have programs run to their full potential usage, is this impossible on a VPS?
Is there any point in having inode limitations?
View 2 Replies View RelatedAfter 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
Warning: I do not want to re-open discussion on some previous threads about the legality of inode limitations. If it gets to that, please feel free to close this thread.
Reading through some other posts about inodes made me look at my own VPS setups. I use XenSource 3.1 on a CentOS 5 Dom0, using LVM for VM storage. When I create a new virtual machine (CentOS5 or Ubuntu, etc) I format the root filesystem with ext3. I use all the defaults, including number of inodes. So for a 20 gigabyte filesystem, I get:
Code:
Filesystem Size Used Avail Use% Mounted on
/dev/sda1 20G 453M 19G 3% /
Filesystem Inodes IUsed IFree IUse% Mounted on
/dev/sda1 2621440 13861 2607579 1% /
Would there be any advantage to limiting the number of inodes a VPS has? Sure, if you had 200,000 inodes instead of 2.6 million inodes, you would have more available space. But there doesn't seem to be a hard limitation on the disk drives I'm using (WD 250GB SATA using linux software raid 1). I assume I could set any amount of inodes to a filesystem?
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).