MySQL ERROR, Hosting Or My Script Causing The Troubles
Jun 5, 2008
I hosted one aardvark topsite @ PluginSpace.com which consist of high traffics (3500+ unique visitors/day). I'm facing max_users_connection for quite number of times and I also have complain to my hosting but I still get no luck, they fix my problem for a short period and the problem appear again after some time.
I rent myself a dedicated server with 320GB Space and 3400GB Bandwith and 2GB RAM. Everytime I manage to get a lot of traffics to my topsite, maybe 100+ online users at a time, tracked by freeonlineusers[dot]com. I'll got these errors. Can anyone tell me what can I do? Can anyone tell me more about how much visitors can a normal dedicated server handle? Is it my script problem or my server problem?
(ERROR WILL POST IN NEXT POST)
can the dedicated server stand many visitors or suppose a normal dedicated server can handle so many visitors or my hosting maintenance is poor?
View 13 Replies
ADVERTISEMENT
Oct 10, 2012
- Apache version : 2.2.21
- operating system : MAC OS Lion Server
- mod_ssl : 2.2.21
I have a certain area on a homepage which is protected by an .htaccess file. The code of the .htaccess file is the following:
Code:
AuthType Digest
AuthName "Password Required"
Options +Indexes
# code for HTTPS
RewriteEngine On
RewriteCond
%{SERVER_PORT} !^443$
RewriteRule (.*) https://%{SERVER_NAME}%{REQUEST_URI}
Require valid-user
Usually everything has been working fine with this .htaccess-file until today. There hasn't been any change on the system.
If you click on the hyperlink to the restricted area the login window appears where you need to type in your username and a password. After typing in these data the following message appears in the browser:
500 Internal Server Error
The server encountered an internal error or
misconfigruation and was unable to complete your request. (…)
The apache error log file contains the following message:
Request exceeded the limit of 10 sub request nesting levels due to probable configuration error.
Use 'LimitInternalRecursion' to increase the limit if necessary.
Use 'LogLevel debug' to get a backtrace.
The increase of the LimitInternalRecursion does not solve the problem. So I switched the LogLevel in the httpd.conf file from warn to debug and looked again on the entries of the error log.
The following appeared (I have replaced ip addresses, usernames and URL by xyz or <URL>) :
Code:
[error] [client xyz]
mod_digest_apple: Client is using a nonce not issued by this server for this context:/rb/Vorlesung/WS12/Downloads/, referer:
http:<URL>
[Code] ....
View 3 Replies
View Related
Jul 6, 2009
Now I'm looking at our last cpu_exceeded_logs file and there is long list point to "/ramdisk/bin/php5" which I don't know much about it or don't know how to deal with that. would you please tell what exactly it means and what should I do to avoid it?
Example of my last cpu_exceeded_logs file:
Quote:
Mon Jul 6 00:34:50 2009: used 0.77 seconds of cpu time for /ramdisk/bin/php5
Mon Jul 6 00:34:50 2009: used 0.50 seconds of cpu time for /ramdisk/bin/php5
Mon Jul 6 00:34:50 2009: used 0.80 seconds of cpu time for /ramdisk/bin/php5
Mon Jul 6 00:34:50 2009: used 0.55 seconds of cpu time for /ramdisk/bin/php5
I can't find the cause of problem when look at /ramdisk/bin/php5.
View 5 Replies
View Related
Apr 12, 2008
Server is Xeon 3060, 3GB Ram, 250GB SATA-II HDD. I followed the recommendations made by mysqlprimer tuner script.
top - 11:54:33 up 237 days, 15:01, 1 user, load average: 6.06, 2.80, 1.65
Tasks: 133 total, 2 running, 131 sleeping, 0 stopped, 0 zombie
Cpu(s): 13.0% us, 4.9% sy, 0.0% ni, 24.3% id, 57.8% wa, 0.0% hi, 0.0% si
Mem: 3114144k total, 3096468k used, 17676k free, 30220k buffers
Swap: 2096440k total, 32348k used, 2064092k free, 2515412k cached
PID USER PR NI %CPU TIME+ %MEM VIRT RES SHR S COMMAND
8610 nobody 16 0 28 1:37.73 0.7 78908 20m 16m S lsphp4
10520 nobody 16 0 3 0:01.97 0.4 78788 10m 6884 S lsphp4
26474 nobody 15 0 2 15:04.07 0.4 14196 11m 3216 S lshttpd
28275 mysql 22 6 1 131:28.83 7.4 733m 224m 2700 S /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pi
Code:
[mysqld]
max_connections=500
max_user_connections=300
skip-locking
skip-innodb
query_cache_limit=1M
query_cache_size=64M
query_cache_type=1
interactive_timeout=60
wait_timeout=60
connect_timeout=6
thread_cache_size=128
key_buffer_size=640M
max_allowed_packet=16M
table_cache=2048
join_buffer=1M
sort_buffer=2M
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
safe-show-database
max_connect_errors=10
thread_concurrency=2
myisam_sort_buffer_size=64M
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
#log_slow_queries=/var/log/mysql/mysql_slow-queries.log
long_query_time=3
tmp_table_size=32M
max_heap_table_size=32M
#log-queries-not-using-indexes=/var/log/mysql/mysql_queries_no-indexes.log
join_buffer_size=2M
low_priority_updates=1
read_rnd_buffer_size=2M
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
var/lib/mysql/mysql.pid
open_files_limit=8192
[mysqldump]
quick
max_allowed_packet=16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer=32M
sort_buffer=32M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=32M
sort_buffer=32M
read_buffer=16M
write_buffer=16M
[mysqlhotcopy]
interactive-timeout
Whenever there are a lot of members online on my forum, the iowait shoot up, >30% and often times hovering at 60%. It'll eventually drop down to normal levels. However, during the high iowait, there are over 2.5GB of free memory according to the command, free -m
is it due to mysql not optimized or other processes? I don't think the bottleneck is on the cpu or ram.
View 12 Replies
View Related
Oct 24, 2009
i have wrong procedure doing to enable my SSL/HTTPS services in my vps.
First i noticed the HTTPS in my services is not running, now i'm looking to google, i found openssl website, then download the latest version and install it into my server and following the instructions, after that, i try to recompile the apache becuase i have a new updates, i found an error ssl and cannot continue to compile because of my last installation i suspect.
View 10 Replies
View Related
Jan 27, 2008
The main function of my dedicated server is the vBulletin forum that we run.
Ever since I had bastille firewall installed and configured on my server we have been getting regular vBulletin errors.
Everything runs pretty smoothly most of the time, we can carry lots of connections without any issues, server has plenty of free RAM and CPU is never overloaded even during peak hours. I have been told bastille firewall (iptables) is configured correctly, all ports that need to be open are open.
But about twice per day we have a MySQL "disconnect" that lasts about 30-60 seconds per incident. For example we will start getting the following message via e-mail, and it will amount to 20-30 e-mails like this during the 30-60 second incident. After that, the e-mails and problems will go away, until next time.
vBulletin Database Error!
mysql_connect(): Can't connect to MySQL server on 'sql.datacolony.com' (4)
/hsphere/local/home/site/site.com/forum/includes/class_core.php on line 274
MySQL Error :
Error Number :
Date : Saturday, January 26th 2008 @ 07:53:05 PM
Script : [url]
Referrer : [url]
IP Address : 92.3.190.54
Username :
Classname : vb_database
The server is running CentOS 4.6, PHP 4.4.7, MySQL 5.0.45. The vBulletin software has been patched to the latest version. The vBulletin people are not sure why this could be happening.
Well we never believed that the firewall was causing the issue BUT it only started happening on the day the new firewall was installed. So we tried stopping the firewall for a full week and the MySQL database errors stopped happening, completely. So I'm convinced the problem is the firewall blocking MySQL connections but I can't figure out why?
There are no entries in the MySQL .err logs pertaining to this. Can't figure this out, any help or ideas is appreciated since the people who installed the firewall are not sure either.
View 3 Replies
View Related
May 2, 2008
I am trying to install APC on my server and getting the following error:
Quote:
[root@ic ~]# pecl install apc
downloading APC-3.0.18.tgz ...
Starting to download APC-3.0.18.tgz (115,957 bytes)
.........................done: 115,957 bytes
47 source files, building
running: phpize
Configuring for:
PHP Api Version: 20041225
Zend Module Api No: 20060613
Zend Extension Api No: 220060519
ERROR: `phpize' failed
Why am I getting that error?
FYI, if this might help:
Php version:
Quote:
PHP 5.2.5 (cli) (built: Dec 12 2007 11:48:35)
Copyright (c) 1997-2007 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies
MySQL version:
Quote:
mysql Ver 14.12 Distrib 5.0.24a, for redhat-linux-gnu (i686) using readline 5.0
I am running CentOS 4.4-32
View 2 Replies
View Related
Jun 10, 2009
I use Debian Lenny and I would like to host 2 sites on my apache web server.
So I created two virtualhost files site1 and site2.
Site 1 configuration file:
<VirtualHost *:80>
ServerAdmin mymail@admin.com
ServerName www.mydomain.com
ServerAlias mydomain.com
DocumentRoot /var/www/premier
<Directory /var/www/peremier>
[...]
Site 2 config file:
<VirtualHost *:80>
ServerAdmin mymail@admin.com
ServerName lemonsite.mydomain.com
ServerAlias /lemonsite
DocumentRoot /var/www/lemonsite/
[...]
Obviously I a2ensite both sites and reload Apache2.
When I digit lemonsite.mydomain.com on address bar of firefox, it returns Address not found.
When I digit MYIP/lemonsite, I get a 404 not found error generated by www.mydomain.com CMS.
When I digit MYIP on bar I get www.mydomain.com.
I would like to see lemonsite.
View 8 Replies
View Related
Jan 21, 2007
I installed the MySQL binary packages in /usr/local/mysql/ after removing the MySQL RPM package. MySQL is functioning when I executed /usr/local/mysql/bin/safe_mysqld. I reinstalled MySQL before I installed PHP. When I used a PHP script to access a MySQL database, it outputs an error:
Code:
Warning: mysqli::mysqli() [function.mysqli-mysqli]: (HY000/2002): can't connect to local mysql server through socket /var/lib/mysql/mysql.sock in index.php on line 2
However, I installed MySQL in /usr/local/mysql, not in /var/lib/mysql. How do I fix MySQL?
View 1 Replies
View Related
Dec 18, 2007
I keep getting this error :
MySQL Error : MySQL server has gone away
How do I fix it?
my.cnf contents
Quote:
[mysqld]
safe-show-database
old_passwords
back_log = 75
skip-innodb
max_connections = 800
key_buffer = 48M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 3000
thread_cache_size = 128
wait_timeout = 90
connect_timeout = 30
tmp_table_size = 128M
max_heap_table_size = 64M
max_allowed_packet = 256M
net_buffer_length = 16384
max_connect_errors = 10
thread_concurrency = 4
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 8M
query_cache_limit = 3M
query_cache_size = 48M
query_cache_type = 1
query_prealloc_size = 262144
query_alloc_block_size = 65536
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
default-storage-engine = MyISAM
max_user_connections = 500
[mysqld_safe]
nice = -5
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
[mysqlhotcopy]
interactive-timeout
View 5 Replies
View Related
Jun 29, 2008
Can someone figure out by the screenshot, if my CPU is really
97% iddle, and what can be causing these average load numbers?
View 14 Replies
View Related
Jul 14, 2009
In my server iowait is causing high load, how do we find out which are all users taking memory that could cause my server to use swap memory.
server : linux centos/Cpanel
I have tried the below commands, but how do we locate user specific,
ps aux --sort -vsz | head -25
vmstat 1
View 7 Replies
View Related
Jul 28, 2008
I just installed a fresh new server with CSF
Soon I find out that my ping keeps dropping. The server was smoothly running, SSH is smooth, Website are loading fine, except I cannot ping my server. I disable SELINUX completely and it still doesn't help.
When I disable CSF, my server ping are responding back!
So I remove CSF installation and reinstall CSF, the same problem appear
How can I solve this issue?
My kernel is 2.6.18-92.1.6.el5PAE running on latest version of cPanel on CentOS 5.1
View 7 Replies
View Related
May 9, 2007
I'm having a very intermittent PHP error on my dual processor CPanel/CentOS 4x box. And it happens randomly across several domains, so I know it's not a single domain problem.
I can never figure out what causes it. 95% of the time the sites work fine (no error), but ever so often my php includes give me something like this:
PHP randomly fails to find the directory/file. And it requires an Apache restart to make it work smoothly again. It will be fine for a few days, but then it happens again. So I suppose it may not be directly related to PHP, but more of a server/apache issue? Any ideas at all?
View 0 Replies
View Related
Aug 31, 2014
Plesk 12 - Domain with no hosting I'm getting error when changing hosting settings to Website Hosting
Error: Some fields are empty or contain an improper value. ('home' = '')
View 3 Replies
View Related
Jun 18, 2008
Ever since Monday morning, my site has had problems because the server at my host is under attack.
Most of Monday my site was down. Then Monday late afternoon, it came back...I thought. The forum is up and running, but the rest of the site, built on WordPress, is screwy.
Most of the plugins aren't working because of inability to connect with the database.
I can't log in to my cPanel at all and haven't been able to since Sunday.
This is the first time I've experienced anything like this, lasting this long.
It has me wondering if I should start considering a new host. I have loved their service, especially their speedy support (native English speaking to boot) so I hate to leave but I'm not sure if their service is going a little downhill or not.
View 8 Replies
View Related
May 18, 2007
Which command do we type to see what is causing a high server load?
I've restarted the VPS numerous of times, and I wish to found out the problem
View 7 Replies
View Related
Jun 21, 2009
For the past few days, one of the server is causing a bandwidth utilization surge for the entire rack on almost daily basis. It happen for a few minutes and it went off then it will be the same thing again the next day. When the surge is happening, most of the servers on the same segment will be inaccessible for the few minutes.
The bandwidth utilization graph for my rack is recording an abnormal surge from (6mbps --> 90mbps) for the few minutes. My MRTG is showing 2 of the Plesk servers giving the problem but the NOC guys said it the Cpanel that causing the problem.
I tried logging in to both servers but could not find what's the cause for this.
View 2 Replies
View Related
Jul 17, 2008
It's been a while since I've posted in this area of the forum, but was just wondering if by now someone or some company has developed a script/software that you can install on your server that will tell you the exact area where the high CPU load is coming from, such as from someone sending email, a certain users account, and etc?
Most times, you have to be mointoring your server at the time of the high load to be exactly sure of what is causing the high load, so, I'm talking about something that will email you right on the spot of the high load in case you are away and will know what caused it.
Most I've seen only tell you that you have a high load, but don't tell you what exactly caused it.
View 2 Replies
View Related
Nov 8, 2008
I have a large chunk of rewrites to help clean up my url's a bit on my site.. On my local machine I am running Apache and just use an .htaccess file and normal php as a module, so no problems there..
But on my server however, I am running Nginx and running PHP as a fastcgi process. In my site's config file I have my fastcgi_param set to /home/user/html/public$fastcgi_script_name...
Well I need a way to change the value of fastcgi_script_name when I have modified (search friendly..) url's that are being rewritten. Because instead of grabbing the script name, like public/text.php?x=z it will grab public/text/post-title.html and then throw me a "No input file given." error (because there is no file there..).
How should I go about sending the true PHP script name to my fastcgi_script_name variable? It just grabs the URI of the PHP script.. what other options are there?
View 1 Replies
View Related
Nov 13, 2008
How to find what Perl script is causing high CPU usage?
I logged into my CentOS box tonight and notice after viewing the output of the "top" command that there are the following lines of output that have me concerned. What command can I use to find the source of the Perl script that is causing the CPU spike?
It seems it's been running for some time too.
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
30120 apache 25 0 6908 4544 1216 R 99.8 0.2 13416:07 perl
30654 apache 25 0 8028 4508 1212 R 99.4 0.2 13417:22 perl
21273 apache 25 0 7584 4528 1200 R 98.1 0.2 2225:12 perl
20516 apache 25 0 6760 4540 1232 R 96.8 0.2 2221:30 perl
View 8 Replies
View Related
Jul 21, 2007
I have this error my site:
dbconn: mysql_connect: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
*dbconn: mysql_connect: 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*
View 4 Replies
View Related
Mar 3, 2007
I recived this error message while testing my website registartions form and was wondering what to do with this and i think it should be permission to access to the database is not given to the user but this is my own account and im the admin and how come the access is denied?
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'alien'@'localhost' (using password: YES) in /home/seektran/public_html/db_connect.php on line 12
Error: Could not connect to database server. Please try again later.Access denied for user 'alien'@'localhost' (using password: YES)
View 5 Replies
View Related
Dec 14, 2007
My host has suspended saying my server was overloaded and sent me a log to my mail and i don't have access to cpanel also. I just have a wordpress blog and when i had contacted host through chat they told some ip might be causing this issue so ban that ip when ur account is unsuspended.
But i am really unaware of how to find which ip is causing this issue as i have little knowledge on analysing logs. Any help regarding this is highly appreciated and please leave your suggestions for me.
I am pasting the logs that were sent by host to me in mail:
Srv PID Acc M CPU SS Req Conn Child Slot Host VHost Request
0-5 22363 32/49/49 K 5.76 2 1695 583.9 0.82 0.82 76.227.169.69
GET /index.php/181/ HTTP/1.1
1-5 22365 81/81/81 W 42.69 3 0 3060.8 2.99 2.99 76.183.97.67
GET /index.php/181/ HTTP/1.1
2-5 22367 87/87/87 K 45.81 2 991 3287.3 3.21 3.21 76.183.97.67
GET /index.php/181/ HTTP/1.1
3-5 22369 2/41/41 K 2.07 8 0 15.3 0.12 0.12 67.87.117.129
GET /wp-content/plugins/postratings/images/stars/rating_half.gi
6-5 22387 0/13/13 W 2.21 57 0 0.0 0.12 0.12 81.22.20.143
GET /index.php/181/ HTTP/1.1
7-5 22388 76/76/76 W 39.94 0 0 2871.9 2.80 2.80 141.153.137.168
GET /index.php/181/ HTTP/1.1
8-5 22396 0/26/26 W 2.46 38 0 0.0 0.34 0.34 127.0.0.1
care.com GET /whm-server-status HTTP/1.0
13-5 22413 0/18/18 W 1.46 44 0 0.0 0.33 0.33 81.22.20.143
GET /index.php/181/ HTTP/1.1
14-5 22414 0/25/25 _ 0.76 55 672 0.0 0.28 0.28 71.77.3.233
GET /wp-content/uploads/2007/12/cup.jpg HTTP/1.1
20-5 22464 2/14/14 K 0.66 8 0 52.5 0.14 0.14 67.87.117.129
GET /wp-content/plugins/postratings/images/loading.gif HTTP/1.1
21-5 22484 0/6/6 _ 1.31 40 329 0.0 0.03 0.03 74.77.10.155
-care.com GET /~realrina/nun.jpg HTTP/1.1
22-5 22510 27/37/37 K 18.07 0 1832 982.5 1.25 1.25 80.195.137.10
GET /index.php/181/ HTTP/1.1
23-5 22523 8/34/34 K 1.76 8 0 94.6 0.30 0.30 67.87.117.129
GET /wp-content/plugins/postratings/images/stars/rating_on.gif
27-5 22540 0/10/10 _ 3.36 39 167 0.0 0.19 0.19 90.192.174.63
GET /wp-content/uploads/2007/10/anand.jpg HTTP/1.1
28-5 22542 1/14/14 K 1.76 8 823 151.9 0.23 0.23 67.87.117.129
GET /wp-content/themes/ProSense%20Redux/images/picture.jpg
HTTP
29-5 23481 0/6/14 _ 0.37 11 2803 0.0 0.11 0.12 82.37.128.175
radio.audio-perfection.co.uk GET /img/player.png HTTP/1.1
30-5 22584 32/44/44 K 15.47 0 1284 989.6 1.06 1.06 80.195.137.10
GET /index.php/181/ HTTP/1.1
31-5 22588 22/25/25 K 5.77 0 751 468.0 0.46 0.46 76.227.169.69
GET /index.php/181/ HTTP/1.1
32-5 23520 0/5/8 _ 0.20 19 414 0.0 0.05 0.09 72.95.237.89 pown.us
GET /images/files/36.jpg HTTP/1.1
33-5 23627 1/6/22 K 0.06 3 967 28.0 0.06 0.35 66.249.65.196
GET /index.php/category/telugu-online-movies/page/4/
HTTP/1.1
36-5 23637 2/3/6 K 0.00 3 37 0.0 0.000 0.03 83.181.190.92 akirad.net
GET /files/color/garland-9bf1a50e/menu-expanded.gif HTTP/1.1
37-5 23673 8/9/16 K 0.49 8 0 126.9 0.20 0.21 67.87.117.129
GET /wp-content/uploads/2007/12/movie_dus_kahaniyaan.jpg HTTP/1
38-5 23674 1/3/10 K 0.00 11 1536 23.0 0.06 0.15 84.57.59.109
teeth-whitening-kit.com GET /affiliate/scripts/sb.php?a_aid=17&a_bid=7
HTTP/1.1
39-5 23690 10/10/22 K 0.99 3 0 35.6 0.03 0.29 83.181.190.92
akirad.net GET /files/color/garland-9bf1a50e/bg-tab.png HTTP/1.1
40-5 23693 0/5/10 _ 0.00 44 1106 0.0 0.04 0.07 67.11.157.83
teeth-whitening-kit.com GET /affiliate/scripts/sb
44-5 23721 1/3/6 K 0.00 8 0 0.4 0.000 0.00 67.87.117.129
GET /wp-content/plugins/share-this/share-icon-16x16.gif HTTP/1.
45-5 - 0/0/3 . 0.00 39 1 0.0 0.00 0.00 83.181.190.92 akirad.net GET
/files/color/garland-9bf1a50e/menu-expanded.gif HTTP/1.1
46-5 - 0/0/5 . 0.22 22 1332 0.0 0.00 0.04 81.22.20.143
GET /index.php/181/ HTTP/1.1
47-5 22780 51/52/52 K 26.66 0 940 1927.2 1.88 1.88 76.183.97.67
GET /index.php/181/ HTTP/1.1
48-5 - 0/0/3 . 0.00 37 6786 0.0 0.00 0.02 81.22.20.143
GET /index.php/181/ HTTP/1.1
51-5 - 0/0/13 . 0.26 35 34109 0.0 0.00 0.06 71.77.3.233
GET /favicon.ico HTTP/1.1
54-5 23746 2/3/3 K 0.51 3 0 0.0 0.02 0.02 83.181.190.92 akirad.net
GET /files/color/garland-9bf1a50e/menu-leaf.gif HTTP/1.1
55-5 23747 0/0/0 W 0.00 20 706795599 0.0 0.00 0.00 81.22.20.143
GET /index.php/181/ HTTP/1.1
56-5 - 0/0/3 . 0.00 16 4868 0.0 0.00 0.00 66.7.206.192
care.com GET /serverstats_inc.php HTTP/1.0
57-5 - 0/0/5 . 0.09 44 0 0.0 0.00 0.01 195.13.38.198 (unavailable)
POST /users_adm/start1.php HTTP/1.1
58-5 - 0/0/1 . 0.00 24 1640 0.0 0.00 0.02 81.22.20.143
GET /index.php/181/ HTTP/1.1
61-5 - 0/0/2 . 0.07 12 10194 0.0 0.00 0.01 172.188.47.93
radio.audio-perfection.co.uk GET /play_wmp.php HTTP/1.1
View 5 Replies
View Related
Jul 1, 2009
in phpMyadmin when trying to import a database from a file, i'm getting the error:
#1153 - Got a packet bigger than 'max_allowed_packet' bytes
The file I'm importing is only 7.08MB
I have tried setting the packet size in the shell as follows:
mysql> mysqld --max_allowed_packet=32M
I got no error or no confirmation either using this command, sorry I dont use shell commands much so I dont know if thats a problem or if it worked.
View 3 Replies
View Related
Jul 8, 2009
I have a new customer moving from another host. His account was terminated already, so just have backup file. When restoring his mysql database, I have this error
Quote:
Unable to restore database dbname.sql to agesuke_forum : ERROR at line 521 in file: '/backup/dbname.sql': Unknown command ''.
Googling shows error in version < 5.0.6 but we are using 5.1.35 already. Is there any idea to fix? This account will run on CentOS 5 - 64bits, FYI.
View 6 Replies
View Related
Nov 7, 2008
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 6 Replies
View Related
Jul 22, 2007
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 7 Replies
View Related
Dec 12, 2007
Error: Missing Dependency: php = 4.3.9-3.22.9 is needed by package php-mysql
above is the error if i try to install php-mysql
tried several times:
yum install php-mysql
but i get the same error everytime
i am using Centos4 + PHP5 + mySQL5
View 7 Replies
View Related
