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