Limiting MySQL Memory Access
I have a VPS with 256MB ram. i want to limit mysql memory access. suppose i want that mysql should not use more than 128MB ram.
is this possible? if yes how?
is this possible for all other services too?
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Limiting Process Memory Usage
I've been unable to limit the size of a process to keep it from hosing a system. I've tried the following methods: - RLimitMEM for just Apache (although I'd like this to apply to any process in the system) - ulimit - PAM limits.conf (/etc/security/limits.conf) In theory, either ulimit or limits.conf should do the trick, but when I start up Apache and run a test script to build up some memory, it doesn't get killed off. Is there any way to do what I want? I'll even take kernel modification as an option. We're running CentOS 4.4, but I don't have a problem with swapping out for another kernel.
View Replies!
View Related
Limiting SSH Access
I've recently hired a new server with the aim of offering FTP backups. I have Plesk CP but I don't want to use that to create the accounts for these users - i want to use the Plesk license for webhosting customers. My box is running CentOS with ProFTPd. The problem i'm having, is locking down SSH access to the Backup customers - if i add an account using "useradd", it is enabled in ProFTPd as I want, and I have set ProFTPd to only allow access to their home dir. However, the users can still log in via SSH and have full access to the box. Ideally, I want to be able to remove these users from SSH access, or if that's not easily possible, not allow them to "cd" above their home dir. I know it's possible to add their usernames to the SSHd config file under Deny, but is there a more elegant solution (bearing in mind i'm planning to have quite a few of these users)?
View Replies!
View Related
FTP- Limiting Types Of Access
Is it possible to setup ftp accounts that have the ability for the users to view files on the server and upload their own files, but not download anything from the server? If so, how would this be done, if not, then as a 2nd option, do most hosting companies provide the option to disallow downloads on an ftp account if you need to do so, but allow uploads?
View Replies!
View Related
Limiting Cpu/memory Of A Single User/domain In Whm
i've been researching this but can't seem to find a decent solution. basically trying to limit the cpu usage of a single domain, or limit accesses per hour if that's possible? i tried adding an entry in /etc/security/limits.conf which restricts numproc to 2 and then down to 1, but it doens't seem to make any impact on the load. load of the server drops from about 1.5-2 down to 0.02 when this single site is suspended, and i can't have it run wild. ideally would like a message that says something along the lines of server is too busy... trying again in 5 seconds or something along those lines?
View Replies!
View Related
Access RAM Memory & CPU Usage By User Files
I don't really now how this can be done, but as far as I can remember when I was in shared hosting, they always complaint about memory usage.... but they always know what specific files were cosing the most load on the server. So, I remember I have this count.php file that was constantly hited and the complaint and tell me exactly what file it was cosing the heavy load. This is just an example, but looks like they always knew the specific files that were cosing problems, so what the hell, this can be done! Now that I have my own server I would like to know these things as well, so I can know what files need to be optimized. I searched and searched and searched and... OK, you'll get the point, and I just HAVE NOT find any information on this. Can someone tell me this "secret"? What do you use to get the files that are cosing the most heavy load on a Linux server?
View Replies!
View Related
MySQL Memory
We have recently recompiled Apache and now we are receiving MySQL errors on some of our sites. The errors are only displayed sometimes (not on every single load of the page). We have been advised that the problem may be due to MySQL running out of memory - is this correct? I have tried changing the 'memory_limit' in php.ini to 100MB but still this does not change anything. Here is the error we are receiving: Code: Warning: mysql_list_tables() [function.mysql-list-tables]: Unable to save MySQL query result in /home/username/public_html/includes/tables.php on line 16
View Replies!
View Related
Mysql Memory Consumption
I have a vps with 1GB of ram and mysql consume lots of memory I googled about this subject but everywhere mysql performance tuning is described mysql has 10 threads like below 7338 mysql 0 0.0 4.5 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/zeta60.wuhosting.com.pid --skip-external-locking 7339 mysql 0 0.04.5 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/zeta60.wuhosting.com.pid --skip-external-locking 7378 mysql 0 0.04.5 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/zeta60.wuhosting.com.pid --skip-external-locking 2507 mysql 0 0.04.5 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/zeta60.wuhosting.com.pid --skip-external-locking 2517 mysql 0 0.04.5 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/zeta60.wuhosting.com.pid --skip-external-locking 2518 mysql 0 0.04.5 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/zeta60.wuhosting.com.pid --skip-external-locking 2519 mysql 0 0.04.5 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/zeta60.wuhosting.com.pid --skip-external-locking 2520 mysql 0 0.04.5 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/zeta60.wuhosting.com.pid --skip-external-locking 7399 mysql 0 0.14.5 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/zeta60.wuhosting.com.pid --skip-external-locking 5162 mysql 0 0.04.5 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/zeta60.wuhosting.com.pid --skip-external-locking my.cnf properties are set-variable = max_connections=90 set-variable = wait_timeout=10 set-variable = connect_timeout=10 set-variable = long_query_time=4 skip-locking key_buffer = 2M max_allowed_packet = 1M table_cache = 4 sort_buffer_size = 64K read_buffer_size = 256K read_rnd_buffer_size = 256K net_buffer_length = 2K thread_stack = 64K table_cache = 1M query_cache_size = 1M [isamchk] key_buffer = 8M sort_buffer_size = 8M [myisamchk] key_buffer = 8M sort_buffer_size = 8M [mysqlhotcopy] interactive-timeout
View Replies!
View Related
MySQL Error : Out Of Memory
MySQL Error : Out of memory I'm getting this very frequently today MySQL Error : Out of memory (Needed 76760 bytes) Error Number : 5 Request Date : Friday, November 7th 2008 @ 01:52:17 PM Error Date : Friday, November 7th 2008 @ 01:52:18 PM Script : [url] Referrer : [url] IP Address : Username : Classname : vB_Database MySQL Version : I have Mysql 5 installed, on a Centos/Cpanel box. Server has 4GB memory, server load is green/normal. I already ran optimization on the database too. It started happening yesterday, pretty much after I installed this hack:[url] Quote: [mysqld] local-infile=0 datadir=/var/lib/mysql skip-locking skip-networking safe-show-database query_cache_limit=2M query_cache_size=128M ## 32MB for every 1GB of RAM query_cache_type=1 max_user_connections=500 max_connections=500 interactive_timeout=10 wait_timeout=28800 connect_timeout=20 thread_cache_size=128 key_buffer=512M ## 128MB for every 1GB of RAM join_buffer=8M max_connect_errors=20 max_allowed_packet=32M table_cache=1024 record_buffer=8M sort_buffer_size=4M ## 1MB for every 1GB of RAM read_buffer_size=4M ## 1MB for every 1GB of RAM read_rnd_buffer_size=4M ## 1MB for every 1GB of RAM thread_concurrency=8 ## Number of CPUs x 2 myisam_sort_buffer_size=64M server-id=1 collation-server=latin1_swedish_ci [mysql.server] user=mysql old-passwords = 1 [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/lib/mysql/mysql.pid open_files_limit=8192 [mysqldump] quick max_allowed_packet=24M [mysql] no-auto-rehash #safe-updates [isamchk] key_buffer=64M sort_buffer=64M read_buffer=16M write_buffer=16M [myisamchk] key_buffer=64M sort_buffer=64M read_buffer=16M write_buffer=16M [mysqlhotcopy] interactive-timeout
View Replies!
View Related
MySQL - Out Of Memory Error
Warning: mysql_connect() [function.mysql-connect]: Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug in /home/user/public_html/includes/functions.php on line 423 Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug
View Replies!
View Related
MYSQL Memory Usage
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).
View Replies!
View Related
MySQL Crashes: Might Be Because Of Memory
My mysql server keeps on crashing. I wonder if it is because of out of memory. Last week, I upgraded my memory from 2GB to 6GB and I executed the command "free" to check memory usage. It uses 5GB in memory usage and leave under 10,000k unuse. Do you think this might be the cause of weekly mysql crashes? I only use the server for mysql, so it is a dedicated mysql server.
View Replies!
View Related
MySQL Memory Usage
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 Replies!
View Related
CPU/Memory/MySQL Monitor
Since upgrading to Apache 2 I am no longer able to tell which domains are the busiest using CPU/Memory/MySQL Usage. Now Apache processes are all lumped together and individual domains only show cron, mail and FTP usage. I opened a ticket with cPanel and they know of the problem but there is still no solution. Is there another way I can tell which of my sites is using the most resources until this bug is fixed?
View Replies!
View Related
Mysql Memory Usage On My VPS
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.
View Replies!
View Related
MySQL Cpu / Memory Usage
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
View Replies!
View Related
CPU/Memory/MySQL Usage - Munin @ 54%
I'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.
View Replies!
View Related
Low Memory After Installing Mysql Mod Php5
I have a VPS. I have installed "Lighttpd, php5cgi, mysql-server, mysql-client, libmysqlclient15-dev" I have optimized the MySQL Server (/etc/mysql/my.cnf). All these together just take 30 mb Memory. Lighttpd use just 12mb memory And everything is very good. But, When I install php5 mod MySQL: apt-get install php5-mysql Then the Lighttpd memory increases to 90mb! I am using updated Debian Lenny, MySQL5, php5.
View Replies!
View Related
Server Optimisation Request/mysql High Memory
cpu speed/type single or dual cpus): Intel Xeon 2x3.6 how much memory installed: 2048MB hard drive type/configuration: 2x160GB SATA linux distributor or windows version: CentOS 4.5 x86_64 apache/IIS version: apache 1.3.37 PHP version: php 4.4.7 MySQL version: 4.1.22-standard PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 19017 teknoloj 16 0 0 0 0 Z 27 0.0 0:00.93 php <defunct> 17751 mysql 15 0 241m 55m 3148 S 25 2.8 0:53.73 mysqld 19025 root 18 0 16204 6104 1392 D 6 0.3 0:00.17 cpcpan_check_in 18968 sohbetgo 16 0 44596 7540 3556 S 5 0.4 0:00.44 php 18552 nobody 15 0 32636 4208 1204 S 2 0.2 0:00.28 httpd 18808 resimsit 17 0 46944 9960 3616 R 1 0.5 0:00.23 php 18896 resimsit 16 0 46944 9984 3616 D 1 0.5 0:00.08 php 18921 resimsit 17 0 46404 9444 3572 R 1 0.5 0:00.09 php 18819 nobody 17 0 32644 4176 1192 S 1 0.2 0:00.06 httpd 18868 haylazt 16 0 0 0 0 Z 1 0.0 0:00.48 php <defunct> 18871 nobody 15 0 32504 4056 1148 S 1 0.2 0:00.06 httpd 18892 root 16 0 6416 1180 756 R 1 0.1 0:00.24 top 18978 nobody 16 0 32504 4028 1132 S 1 0.2 0:00.02 httpd 11 root 5 -10 0 0 0 S 0 0.0 0:24.56 events/1 2638 root 0 -20 0 0 0 S 0 0.0 0:16.96 loop0 2981 named 18 0 88016 2328 1152 S 0 0.1 8:44.12 named 3592 mailman 16 0 50316 2320 1828 S 0 0.1 0:00.78 python2.4 my.cnf [mysqld] safe-show-database skip-innodb max_connections = 500 key_buffer = 80M myisam_sort_buffer_size = 64M join_buffer_size = 1M read_buffer_size = 1M sort_buffer_size = 2M table_cache = 1800 thread_cache_size = 384 wait_timeout = 25 connect_timeout = 10 tmp_table_size = 128M max_heap_table_size = 128M max_allowed_packet = 64M max_connect_errors = 10 read_rnd_buffer_size = 524288 bulk_insert_buffer_size = 8M query_cache_limit = 4M query_cache_size = 96M query_cache_type = 1 query_prealloc_size = 16384 query_alloc_block_size = 32768 ft_min_word_len=3 ft_max_word_len=25 [mysqld_safe] open_files_limit = 8192 [mysqldump] quick max_allowed_packet = 16M [myisamchk] key_buffer = 64M sort_buffer = 64M read_buffer = 16M write_buffer = 16M ft_min_word_len=3 ft_max_word_len=25 [mysqlhotcopy] interactive-timeout MySQL 4.1.22-standard uptime 0 0:39:9 Sat Jun 30 21:33:29 2007 __ Key __________________________________________________ _______________ Buffer used 19.34M of 80.00M %Used: 24.17 Current 33.70M %Usage: 42.12 Write hit 32.57% Read hit 98.45% __ Questions __________________________________________________ _________ Total 63.26k 26.9/s Slow 2 0.0/s %Total: 0.00 %DMS: 0.01 DMS 32.14k 13.7/s 50.80 __ Table Locks __________________________________________________ _______ Waited 40 0.0/s %Total: 0.08 Immediate 50.58k 21.5/s __ Tables __________________________________________________ ____________ Open 486 of 1800 %Cache: 27.00 Opened 702 0.3/s __ Connections __________________________________________________ _______ Max used 12 of 500 %Max: 2.40 Total 4.33k 1.8/s __ Created Temp __________________________________________________ ______ Disk table 26 0.0/s Table 2.23k 1.0/s File 428 0.2/s 6-7 vbulletin sites-vbseo and other scripts online avarage; 120 registered user ve 500+ unregistered user cookie timeout : 7200 unique hit : 15000-20000 KeepAlive ON MaxKeepAliveRequests 100 KeepAliveTimeout 2 MinSpareServers 10 MaxSpareServers 15 StartServers 10 MaxClients 180 Maxrequestsperchild value 1000 [root@server ~]# uname -a Linux server.xxxxx 2.6.9-55.ELsmp #1 SMP Wed May 2 14:04:42 EDT 2007 x86_64 x86_64 x86_64 GNU/Linux [root@server ~]# ulimit -aH core file size (blocks, -c) 1000000 data seg size (kbytes, -d) unlimited file size (blocks, -f) unlimited pending signals (-i) 1024 max locked memory (kbytes, -l) 32 max memory size (kbytes, -m) unlimited open files (-n) 4096 pipe size (512 bytes, -p) 8 POSIX message queues (bytes, -q) 819200 stack size (kbytes, -s) 8192 cpu time (seconds, -t) unlimited max user processes (-u) 14335 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited [root@server ~]# cat /proc/cpuinfo processor : 0 vendor_id : GenuineIntel cpu family : 15 model : 4 model name : Intel(R) Xeon(TM) CPU 3.60GHz stepping : 10 cpu MHz : 3600.322 cache size : 2048 KB physical id : 0 siblings : 2 core id : 0 cpu cores : 1 fpu : yes fpu_exception : yes cpuid level : 5 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm pni monitor ds_cpl est tm2 cid cx16 xtpr bogomips : 7207.08 clflush size : 64 cache_alignment : 128 address sizes : 36 bits physical, 48 bits virtual power management: processor : 1 vendor_id : GenuineIntel cpu family : 15 model : 4 model name : Intel(R) Xeon(TM) CPU 3.60GHz stepping : 10 cpu MHz : 3600.322 cache size : 2048 KB physical id : 3 siblings : 2 core id : 3 cpu cores : 1 fpu : yes fpu_exception : yes cpuid level : 5 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm pni monitor ds_cpl est tm2 cid cx16 xtpr bogomips : 7199.29 clflush size : 64 cache_alignment : 128 address sizes : 36 bits physical, 48 bits virtual power management: processor : 2 vendor_id : GenuineIntel cpu family : 15 model : 4 model name : Intel(R) Xeon(TM) CPU 3.60GHz stepping : 10 cpu MHz : 3600.322 cache size : 2048 KB physical id : 0 siblings : 2 core id : 0 cpu cores : 1 fpu : yes fpu_exception : yes cpuid level : 5 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm pni monitor ds_cpl est tm2 cid cx16 xtpr bogomips : 7509.03 clflush size : 64 cache_alignment : 128 address sizes : 36 bits physical, 48 bits virtual power management: processor : 3 vendor_id : GenuineIntel cpu family : 15 model : 4 model name : Intel(R) Xeon(TM) CPU 3.60GHz stepping : 10 cpu MHz : 3600.322 cache size : 2048 KB physical id : 3 siblings : 2 core id : 3 cpu cores : 1 fpu : yes fpu_exception : yes cpuid level : 5 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm pni monitor ds_cpl est tm2 cid cx16 xtpr bogomips : 7199.26 clflush size : 64 cache_alignment : 128 address sizes : 36 bits physical, 48 bits virtual power management:
View Replies!
View Related
'MySQL Client Ran Out Of Memory' On A FullText Search
I'm trying to do a FULLTEXT search (1 field) on a ~3 gig table with ~650,000 rows. A lot of queries work fine and give results in seconds, but for queries on words that (I believe) occur very commonly in the database (e.g., this is a Italian database, the word 'italia' probably occurs a lot) take a while and then give the following errror: #2008 - MySQL client ran out of memory But the server has 8 gigs of RAM (and plenty of free hard disk space). Server is Linux with MySQL 4.0.27. Here's my /etc/my.cnf file: [mysqld] set-variable = max_connections=1000 safe-show-database log_slow_queries long_query_time=5 max_allowed_packet=16M ft_min_word_len=3 what I can do to make this work?
View Replies!
View Related
MySQL DB Access Allowed? Are There Any?
For window hosting are there any that offers sql db external access without ip limit? I've seriously requested thought the forums and actually signed up with few but all of em are either offered it but not anymore(security issue) or not even offering at all. If you have any experience with hosting company that actually does offer sql db external access please share please! vps nor dedicated servers are not my choice unfortunatley and i don't think there's any free hosting that offers this. 99% freehostings use localhost
View Replies!
View Related
Mysql Access Denied
I've setup a mysql user and assigned a password for it. When I try logging in to it with Quote: mysql -u USERNAME -p and then providing the password I get an error: Quote: ERROR 1045 (28000): Access denied for user 'USERNAME'@'localhost' (using password: YES) I don't have trouble logging in as root and when I check the user table there, the password assigned to the user is same as the value the mysql function PASSWORD gives me. Really driving me nuts here, why is it telling me the password is wrong when it's not? I've tried: Restarting mysql setting new password changing username Using mysql server 5.1.34
View Replies!
View Related
Mysql Account Access
I run a shared hosting OS:centos with whm/cpanel and would like to restrict access to mysql database example: username:user1 created database:user1_db1,user1_db2 etc.. and can only access his own databases so user2 can't access user1_db1.db2 etc.. and user1 can't access user2_db1,db2 etc..
View Replies!
View Related
Allow Remote Mysql Access
I have a Ubuntu Lamp server setup in my building which is used for development purposes. So I also have phpmyadmin setup and am using a Mysql Query browser and Mysql Administrator desktop programs to administor the database on the server. However I am not able to connect to the server from my desktop. I am able to login to my myphpadmin but not able to login via the Mysql Query Browser program. Hopwing someone can help. I have read about port forwarding and also read a post about editing the my.cnf file on the server and changing the Bind-Address= 127.0.0.1 to the actual hostname but before I start editing the actual configuration files on the server I want to see if their is another way as I am worried that if I change the me.conf file that the phpmyadmin may stop working?
View Replies!
View Related
How To Secure Access To MySQL Database
What can I do to secure access to my MySQL database to stop it from getting compromised from hackers? Is there any way I can restrict access to the MySQL database to my IP only? The database is for an IPB 2.3.4 forum and the username/password are stored in a conf_global.php file that is CHMODed 0444.
View Replies!
View Related
Fast MySql Access- Localhost
I've been using Dreamhost for years and they're very good, but their MySql databases are quite slow. Then I moved to ServInt with a VPS, and my MySql is on localhost instead of on a different server. WOW! It's so fast! However, now I'm trying to find a shared hosting package that has fast MySQL service. I'm not sure if the requirement is that it's on localhost but it sure doesn't hurt. Is there anyone who is familiar of a good solid shared hosting package with fast MySQL service?
View Replies!
View Related
MYSQL Gives Access Error After Server Move
I can't find any straight answers when searching Google. I've been stuck in a what has become a nightmare server move for about 2 weeks now. After finally getting a mysql.sock issue fixed I can get the MYSQL dbs over to the new server but it appears that their permissions need to be changed. Is there a way to handle this from the root level? I have roughly 120 dbs to process I am moving from a VPS to a dedicated server - both have root access.
View Replies!
View Related
MySQL: Access Denied For Root User
When I deleted a database, the user apparently was orphaned because when I tried to recreate it, it returned "user already exists". I've never encountered that problem although from Googling, I see others have and they delete the user to get around it. When I log into mysql using the da_admin@ account and attempt to remove the user with drop user <user_name>; I receive the following error message: ERROR 1227 (42000): Access denied; you need the CREATE USER privilege for this operation It seems I don't have rights even as the root user. How can I get remove the orphaned user?
View Replies!
View Related
Copying (MySQL) Database Without Panel Access.
A customer would like to move his hosting from another host to me. But the other host does not want to cooperate and give me access to the panel or files. Threw the customer I did get the ftp information, and within the config file I have the database username and password. How is it possible to copy the database, without having the hosting panel access?
View Replies!
View Related
Configuring Server To Handle Both MySQL And MS Access Databases
Since I have never worked on the server end of things I had a quick question for all you web hosting gurus. Is it possible to have PHP installed on ONE single server and still have the ability for the server to work with both MS Access AND MySQL at the same time? I would think YES, but I am being told by our server branch at my current job that this is not the case. They claim there is no way for the server on one machine to be able to handle both types of databases. Are they right? If they are wrong and it is possible to have one server run both type of databases, what steps would be necessary to set up the server to handle both types? Do we need to tweak the php.ini file or is there another method of allowing the server the ability to work with both MySQL and MS Access. Sorry if this question seems stupid or odd, as I said, I have minimal experience on the server end but I am confident that a server can handle both.
View Replies!
View Related
Recommend An ISP For Webspace? (need Php + Mysql + Root SSH Access)
cheap-ish place to host a PROTOTYPE website. We're going to need php + mysql, but we're going to need to have more control such as root SSH access. Here is the list of what we need to start with: SSH access PHP 5 Java MYSQL 4 or 5 Apache 2 SendMail Any ISP recommendations? For now this is just a prototype, and it will NOT get hammered with traffic. But we do need an outfit that is efficient and reliable. Ship Shiperton Henethe We are based in the UK.
View Replies!
View Related
MySQL Error "out Of Memory"
This error has just arrived on my mysql server. Mysql error log. [ERROR] Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space [ERROR] Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space the sites get this kind of error message. ---8<--- Microsoft OLE DB Provider for ODBC Drivers error '80040e31' [MySQL][ODBC 3.51 Driver][mysqld-5.0.18-nt]Out of memory (Needed 556520bytes) ---8<--- MySQL said: #5 - Out of memory (Needed 1048548 bytes ---8<--- System.Data.Odbc.OdbcException: ERROR [HYT00] [MySQL][ODBC 3.51 Driver] Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug ---8<--- The Mysql server is a duel Xeon 3GHz with 2Gb ram + 2Gb swap file. mysql version: mysqld-5.0.18 The ini settings for the mysql server: ---8<--- [client] port=3306 [mysql] default-character-set=latin1 [mysqld] basedir="C:/MySQL/MySQL Server 5.0/" datadir=G:/MySQL/Data/ default-character-set=latin1 default-storage-engine=INNODB innodb_additional_mem_pool_size=11M innodb_buffer_pool_size=500M innodb_data_home_dir="G:/MySQL Datafiles/" innodb_flush_log_at_trx_commit=1 innodb_log_buffer_size=6M innodb_log_file_size=100M innodb_thread_concurrency=10 key_buffer_size=258M max_allowed_packet=5M max_connections=150 myisam_max_extra_sort_file_size=100G myisam_max_sort_file_size=100G myisam_sort_buffer_size=59M net_buffer_length=8K port=3306 query_cache_limit=10M query_cache_size=1048M read_buffer_size=64K read_rnd_buffer_size=256K sort_buffer_size=256K sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" table_cache=1520 thread_cache_size=38 tmp_table_size=59M wait_timeout = 240 ---8<--- key_buffer_size + (read_buffer_size + sort_buffer_size) * max_connections = total memory use? 258000K + (64K+256K) * 150 =38 748M So the key_buffer_size and the max connections is to high? 128000k + 320k * 16 = 2053,1M That can't be right?
View Replies!
View Related
Limiting Inodes
I am just playing around with a server of mine, and I wanted to know is there anyway to limit the amount of inodes ( files and folders) a user can have? I am using cpanel/whm. Or is there a way I can receive an " alert" once a user has reached the specified limit?
View Replies!
View Related
Bandwidth Limiting
bandwidth limiting on my home network, to some specified pc's, as they are taking up to much download bandwidth. Im leaning towards windows more but i am still unsure, would any one be able to guide me or give me a few tips on what type of program will do this, what operating system and maybe some tutorials if anyone knows any good ones?
View Replies!
View Related
IP Limiting On A Switch
IP limiting on switch port. Where a switch is set to only allow a specific IPs to be streamed from the servers connected to it. Any server set with another IP even with a same C class range will be dropped or ignored. eg. Switch : with a set IP of 111.111.111.1 - 10 Any server that tries to set an IP of 111.111.111.11 and above will not get connected. Currently I am using 3com SuperStack III 3250 switches. but after reading the manual and also searching on the net, I am a little lost on ideas....
View Replies!
View Related
Memory Usage :: Put More Content Into Memory?
I just got a new server Dual E5520 with 6GB RAM, SAS 15k rpm raid10. It's running well. However, the memory usage is just around 2.5GB, even when I have more traffic. Here is the kernel info Quote: # uname -a Linux server2.[url]2.6.18-128.1.10.el5 #1 SMP Thu May 7 10:35:59 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux Any idea that we can put more content into memory?
View Replies!
View Related
Limiting International Traffic
Is it possible to limit internationally traffic? National would be Australian bandwidth. For example; Offering Unmetered national bandwidth and 10 GB international bandwidth. OR Offering 50 GB national bandwidth and 5 GB international bandwidth. How would you go about doing this, tracking it, managing it, etc. Is there any software that does it already? For example Xen or Virtuozzo?
View Replies!
View Related
Connection & Bandwidth Limiting
We have Linux and windows shared hosting on our dedicated servers using Plesk are we are interested in putting in connection limits and bandwidth limiting in place but not sure what to use - we don't want to set them to be too restrictive but we don't want it to be free reign either. I was wondering if anyone else was doing this, and if so what their levels were. Additionally, does anyone use anything for IIS 6 on 2003 that supports bandwidth throttling of dynamic content? I know there are things for IIS 7 in 2008 but that doesn't help much
View Replies!
View Related
Rate Limiting On The Switch
Which brand / model would you recommend for those: 1 - bw limiting on specific port (like 3mbits/sec on port4) 2 - creating vlans by ports (like vlan1 = port1 + port2) 3 - creating vlans by ips (like vlan1 =x.x.x.1 to 8, vlan2 = x.x.x.9 to 27) 4 - managing the switch from GUI
View Replies!
View Related
Hardware Based IP Limiting
I've been searching a while for a box that I can throw in front of my servers that will basically look at inbound connections and if there are more than X amount of connections from IP:XXX it will block it for X minutes. I thought a standard load balancer would do it, but according to Barracuda, their load balancers don't. They do DDOS prevention, but that's based on packet inspection. What I'm looking for is something that will block legitimate traffic when there's just been too much in a short amount of time. Basically I've got people using autosurfing programs and refreshers on my site and I'm getting tired of analyzing log files to find them.
View Replies!
View Related
Limiting User Activity
I am interested in setup user activity limits to avoid peaks on the server load, I have readen a lot about PAM and limits.conf but still have no idea on how set this limits. Most of the examples are similar to this page http://www.seifried.org/lasg/users/ but they are still confusing to me >> I would like to setup rules like this: Customers may not use more than 2% CPU daily, 3% memory daily, run more than 10 simultaneous processes per user, allow any process to run for longer than 30 CPU seconds, run any process that consumes more than 20% of available CPU at any time, or run any process that consumes more than 16 MB of memory.
View Replies!
View Related
|
TRACKER
