I am trying to increase my open file limit on my CentOS release 4.6 VPS.
I have tried modifying my /etc/security/limits.conf with the following:
@mysql soft nofile 4096
@mysql hard nofile 4096
@mysql soft sigpending 4096
@mysql hard sigpending 4096
Even is a mannual set it with "ulimit -n 4096 mysql" it will not stick.
Any ideas what I can do to get this limit increased permanently?
I been having a heck of a time just with this one cpanel server and open files limit. At first using open_files_limit did not work so I changed it to open-files-limit that seemed to work but now it rejects the value and sets its down to 65535.
Then system open files limit is 500000. I try to set it to any value about 65535 in my.cnf and here is usual error:
090630 9:32:07 [Warning] option 'open_files_limit': unsigned value 120510 adjusted to 65535 090630 9:32:07 [Warning] option 'open_files_limit': unsigned value 120510 adjusted to 65535
When I run something like the tuning-primer it shows:
Current open_files_limit = 120510 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
But Im not sure if it is just reading my.cnf or something. I am still getting complaints from users about lost connections and I see the errors in error log. Ive looked everywhere and cant seem to find a solution to this.
Rapidly growing error logs showing the same message
$ug-non-zts-20020429/ffmpeg.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20020429//usr/local/lib/php/extensions/no-debug-non-zts-20020429/ffmpeg.so: cannot open shared object file: No such file or directory in Unknown on line 0
root@server [~]# ls /usr/local/lib/php/extensions/no-debug-non-zts-20020429 ./ ../ eaccelerator.so* root@server [~]# ls /usr/local/lib/php/extensions/no-debug-non-zts-20020429 ./ ../ eaccelerator.so*
How to increase the Open Files limits descriptor in Apache. In the earlier version of Cpanel, we had an option of Raise FD Size Limit to 16384, but the option no longer appear while rebuilding Apache. What is the way to do it and make the change permanent?
I have following error when try to login in my vps, how can resolve this issue?
Code:
Last login: Thu Jun 19 21:00:43 2008 from xxx.xxx.xxx.xxx
ALERT! You are entering a secured area! Your IP and login information have been recorded. System administration has been notified. This system is restricted to authorized access only. All activities on this system are recorded and logged. Unauthorized access will be fully investigated and reported to the appropriate law enforcement agencies.
i had install cpanel on Cent Os 5 on a VPS Cpanel Correctly Running but named does not working ! i try to restart named but it say : root@server [/etc]# service named restart Stopping named: [ OK ] Starting named: Error in named configuration: none:0: open: /etc/named.conf: file not found [FAILED]
Basically mysql is behaving very very intermittently. Crashes were every 4 hours, I've brought them down to once every 8 or so hours but mysql keeps dying.
the error log will show the same routine each time.
on mysql start:
Quote:
091101 21:58:03 [Warning] option 'open_files_limit': unsigned value 120000 adjusted to 65535 091101 21:58:03 [Warning] Could not increase number of max_open_files to more than 65535 (request: 200110) 091101 21:58:03 [Note] /usr/sbin/mysqld: ready for connections.
Then we'll see errors due to crashed databases:
Quote:
091102 0:33:07 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './<nameofdatabase.frm>'
following this a heap of:
Quote:
091102 0:36:35 [ERROR] /usr/sbin/mysqld: Can't open file: '>another database here.frm> 091102 0:36:36 [ERROR] /usr/sbin/mysqld: Sort aborted 091102 0:36:52 [ERROR] /usr/sbin/mysqld: Sort aborted 091102 0:43:00 [ERROR] Error in accept: Too many open files
On attempting to select the configuration->filter option on RoundCube, we got the error message:
SERVICE CURRENTLY NOT AVAILABLE! Error No. [501]
On /var/log/plesk-roundcube/errors we can see the following logs:
[06-Jun-2015 14:57:17 -0300]: PHP Error: SieveRules plugin: Unable to open default rule file in /usr/share/psa-roundcube/plugins/sieverules/sieverules.php on line 1523 (GET /roundcube/?_task=settings&_action=plugin.sieverules) ... [06-Jun-2015 14:57:17 -0300]: PHP Error: SieveRules plugin: Unable to open example rule file in /usr/share/psa-roundcube/plugins/sieverules/sieverules.php on line 1560 (GET /roundcube/?_task=settings&_action=plugin.sieverules) ... [06-Jun-2015 14:57:17 -0300]: PHP Error: Error loading template for sieverules.sieverules in /usr/share/psa-roundcube/program/include/rcmail_output_html.php on line 496 (GET /roundcube/?_task=settings&_action=plugin.sieverules)
I have a big problem concerning the file upload limit (I need a large size, around 2Go) : I was using my app in /var/www/vhost/default and it was working perfectly, I decided to change it and use /var/www/vhost/mydomain.com to have it throught the plesk panel, and there I have an upload limit than I need to push. I can't upload files larger than 128Mo and I don't know why.
- I have checked all php.ini files (with locate php.ini) and they are all correct. - I used plesk panel to set php conf -> done. - I put : php_value memory_limit 2000M php_value upload_max_filesize 2000M php_value post_max_size 2000M in my .htaccess in htdocs
[Code]....
I reload/restart apache2, psa, ... And it still doesn't work, I have no more idea every conf file seems correct. It's not a permission problem because I can upload some 80Mo files but not 500Mo ...
i dont want clients taking the servers I/O and server load over 4.00 when they do major update ect... querys on sql. is there a way to limit the ammount they can do?
We have found that we need to limit the amount of cpu uage by users on our video share server. On this server we currently have 20 users on a sharred plan. Thought that the obvious BW usage would be the biggest challenge, as it turns out we havent gone over the 2 TB that we have.
We have come up with an encoding process that uses the 264 codec and gives us excellent results in terms of quality but is very cpu intensive to the point of really slowing down the server when 10 or more users simutaneously are encoding their videos.
Can someone suggest a script that would allows us to limit the file size in terms of MB/GB that each user could upload per month.
So for example a client pays 10.00 per month and we wanted to limit their uploads to a total of 900 MB per month vs the client that is paying 50.00 per month who would have the ability to upload say 8 GB per month.
I try to search and not found the solutions to limit concurrent of db users to connect to MySQL in same time for example:
Limit user root to connect to MySQL maximum 5 connections in same time
There have max_connections setting but it limit for all users in all connection to MySQL.
But I found that in version 4.1.x there have max_connections property in user table (Users and global privileges) of mysql database, this setting is limit connection in 60 minutes.
I would like to know if there any setting or code modify for this solution that I want.
We have a dedicated server, on which we hosts about 15 sites. I am needing to: Backup each site individually (all files) Backup each Db associated with each site FTP to our own in-house ftp server
I have been searching around all afternoon, and possible solutions to each point above are the following:
Iterate through each top level folder in, say /var/www/vhosts/ and tar each folder individaully
I have only been able to do a mysqldump the whole server, and have only found scripts into which you have to manually specify each db if i need separate backups for each one done
Not an issue, we currently have backups from a separate server running
Is it possible to set this all up in one, top-level cron job?
what I can do about the following database error in mysql?
Incorrect key file for table '/tmp/#sql_(number of table.MYI); try to repair it
I've repaired, optimized and checked the database in phpmyadmin. Initially 2 tables were showing overhead, but the error message is for a temp table and I'm not sure how to try to repair a temp table.