I have a 256 MB VPS. Currently I run BIND to serve a few zones as the primary server and twenty more as the secondary. BIND’s memory footprint is >40 MB which is too much for such low usage. I want to replace BIND with other software to free some memory. Could you please tell me what DNS server has the least memory usage while supporting AXFR? No recursion needed.
What I’ve tried was djbdns. Its zone file format is terrible but perhaps a Web interface such as VegaDNS can help, and TinyDNS does use much less memory than BIND. What else is there?
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
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?
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
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
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 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).
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.
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?
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.
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?
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.
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
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%
__ 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:
I need to know what happens when a rack has capped its (lets say) 5A limit. I'm trying to calculate what exactly I can put into a rack and am considering that not all servers are going to be 100% load, as that would be bad performance anyway.
I guess it could do the following (but really don't know):
Cap performance of all servers
Cause system failures
Trip
The rack would have servers, a switch and perhaps a Remote Power Strip and Firewall. I don't know how they would be affected.
Would it be bad to run only 24 hard drives on a 900 watt redundant PSU setup provided in a super micro machine? No motherboard, just the hard drives and backplane? I know that if PSU's aren't loaded enough, they can malfunction or shutdown, as well as encounter efficiency issues. Is there a general rule of thumb for this sort of thing? Should I see if supermicro can give me a lower rated PSU or something? I searched around on the net a bit but couldn't find anything solid for this particular question..
I maybe interested in co-locating a server but looking from the power max for a 1U server of around 0.3Amps I'm wondering if it will be easy.
Doing the equation 0.3 * 240 gives me 72watts I believe. (Where 240 is the voltage for the UK). So with this, it doesn't give me much choice considering most processors run around 90watts and that doesn't leave any room for the power from hard drives and memory. Does anyone know what the average power consumption is for hard drives and memory?
I'm not looking for a really power system, but I would like something that if I pull it out of co-location that I can still use it one way or another. So was looking at an AMD Athlon 64 X2 where there is a 34watt version that is seemingly discontinued. Or use an AMD Turion X2, which are again hard to find, with a mini-itx board. Running with the mini-itx board, there is also the Intel Core 2 Duo which I can get quite easily.
Does anyone else co-locate and how to you manage the specification?
I've been having a problem with my webhost (in a shared server), and I don't know if this should be a usual problem or if it is my fault or if it is the host's fault.
The thing is I am getting lots of consecutive petitions for the same files from an IP at a time, which in my logs gets registered like this:
The thing is I am getting too much bandwidth consumption, and since I've only been with this host for 3 months now, and I never had similar problems before, I was wondering if this problem is something I can do something about? Or is it the host's config? Why do these repeat 206 petitions happen?
my friend has an un-managed VPS plan in kloxo-hypervm mode
yesterday the stats showed in hypervm as the space was over used, so I personally deleted the processed stats which cleared around 20gb space, again today the space is totally consumed, I don't know why its happening and have no clue where are the other locations where the space could have been consumed i.e similar to location of logs or any other specs which could have been consuming space
unknown space consumption - very high no idea how!
its actually an image hosting site and I noted that not many pics and not much space was consumed in the pics uploaded in the last 24hrs but this really puzzles and troubles me as I am currently tracking my friend's VPS, please help me sort this out problem and keep my head high before my friend
My nearest major city is Manchester, so naturally I'm looking for rackspace in the region.
Unless anyone has better suggestions, I'm thinking of going with NorthernColo. They start at £50/month but jump to £70/month if you draw more than 1A of current.
If my basic physics is anything to go by, 0.5A at our 240V means a maximum server power rating of 120 watts.
...are there any dual-core / 2GB RAM box configurations which consume less than 300W thesedays? My own USB mouse for my laptop consumes 50mA.
Otherwise I'm begining to think of their 0.5A pricing as being a bit of a scam, since the 1A price also pays for 2U worth of space.