Lost Connection To Mysql Server During Query

Aug 12, 2007

some vBulletin customers facing to that error message, with session table with attachment only. Other just work fine. It's not because of server load. The load is just around 0 - 0.1

I have increased wait_timeout to 200 and max_allowed_packet to 64MB. Each attachment file in those vBulletin is just around 1-3MB.

Is there any idea why and how to fix?

View 1 Replies


ADVERTISEMENT

Lost Connection To MySQL

Dec 7, 2007

MySQL Error : Lost connection to MySQL server during query

I get this error around 10 times a day and the MySQL server goes down

Here are my.cnf contents

Quote:

[mysqld]
safe-show-database
old_passwords
back_log = 75
skip-innodb
max_connections = 650
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 = 10
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 64M
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

[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 3 Replies View Related

I Lost My Server Mysql Login

Jun 20, 2007

I have the root access for the server but i lost the password for the mysql is there any way that i can get it

View 4 Replies View Related

Lost SSH Connection During The Upgrade Process

May 11, 2008

if i lost SSH connection during the upgrade process, ie. apache upgrade

will this have any impact?

View 5 Replies View Related

Remove Server MySQL Connection

May 13, 2009

I bought a VPS to run a part of a application I have and it needs to connect to my database in cpanel. I have set everything up properly and allowed the remote server to connect to my server, I updated the DB connect file with the correct mysql server username and password. But when I try and run the script I get this error.

Quote:

Client does not support authentication protocol requested by server; consider upgrading MySQL client in

I'm not 100% sure what to do. I don't understand why it wouldn't work because it works perfectly on the main server with my scripts. But I get that error message on the remote server.

View 4 Replies View Related

Mysql Licensing Query

Nov 17, 2008

Our local authority is looking into using MySQL database for some internal applications and possibly our website.

Do we need a commercial or enterprise license for this particular use or can we use a free version?

View 2 Replies View Related

Mysql Files To .sql Query

Apr 30, 2008

I have the files .myd .myi and .frm files in a archive .tar.gz

My host do not provide shell access.

Is the any way that i can convert the files into .sql queries

Or is there any method other that using shell access.

Or is there any software to convert the database files into .sql query in my desktop computer so that i can restore it using phpmyadmin

My site has been down from several days

View 2 Replies View Related

Mysql And Query Cache

Jan 4, 2007

What is the good value to set query_cache_size. I have set it to 60 M and here
is the status. Is it good? I am not sure how to check this? Can anyone explain?

query_cache_size=60M

mysql> SHOW STATUS LIKE 'Qcache%';
+-------------------------+----------+
| Variable_name | Value |
+-------------------------+----------+
| Qcache_free_blocks | 5 |
| Qcache_free_memory | 62666440 |
| Qcache_hits | 922 |
| Qcache_inserts | 381 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 565 |
| Qcache_queries_in_cache | 182 |
| Qcache_total_blocks | 400 |
+-------------------------+----------+
8 rows in set (0.00 sec)

View 2 Replies View Related

Very Slow Query Time After Upgrade To Mysql 5

Apr 8, 2009

We have a dedicated server and we host 4 news portals based on e107 and joomla.

My partner on Sunday has upgraded mysql from version 4 to 5. Now the server experiences very high CPU usage and query time on portals has been increased very much.

We used to have query times lower than 1 sec for the main page of [url](which is a site that receives about 2000 visits/day) and now query times are 5-15sec !

Does anybody know if this is makes sense ?

Below is the server Status from WHM :
-------------------------------------

cpdavd up
cpsrvd up
exim (exim-4.69-15.1_cpanel_maildir) up
ftpd up
httpd (2.2.11 (Unix)) up
imap up
interval up
mysql (5.0.67-community-log) up
named (9.3.4) up
pop up
rsyslogd up
spamd up
syslogd up
Server Load 6.97 (1 cpu)
Memory Used 49.4 %
Swap Used 0.23 %
Disk /dev/hda3 (/tmp) DMA+ 70 %
Disk /dev/hda5 (/) DMA+ 22 %
Disk /dev/hda1 (/boot) DMA+ 14 %


Below is the Server Information from WHM :
------------------------------------------
Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Core(TM)2 Duo CPU E4600 @ 2.40GHz
Processor #1 speed: 2394.068 MHz
Processor #1 cache size: 2048 KB

Memory Information

Memory: 2064420k/2087424k available (2091k kernel code, 21752k reserved, 846k data, 236k init, 1169920k highmem)

System Information

Linux server.aktoweb.biz 2.6.20-1.2319.fc5 #1 Mon May 21 19:52:13 EDT 2007 i686 i686 i386 GNU/Linux

Physical Disks

hda: WDC WD3200AAJB-00TYA0, ATA DISK drive
hda: hw_config=600d
hda: hw_config=600d
hda: max request size: 512KiB
hda: 625142448 sectors (320072 MB) w/8192KiB Cache, CHS=38913/255/63<6>hda: hw_config=600d
hda: cache flushes supported

Current Memory Usage

total used free shared buffers cached
Mem: 2066428 1756324 310104 0 339576 486636
-/+ buffers/cache: 930112 1136316
Swap: 1052248 2428 1049820
Total: 3118676 1758752 1359924

Current Disk Usage

Filesystem Size Used Avail Use% Mounted on
/dev/hda5 288G 60G 213G 22% /
/dev/hda1 99M 13M 82M 14% /boot
tmpfs 1009M 0 1009M 0% /dev/shm
/dev/hda3 494M 215M 254M 46% /tmp

Below is the CPU/Memmory/Mysql Usage from WHM :
-------------------------------------------------
mysql42.707.300.0
Top Process%CPU 42.7/usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/server.aktoweb.biz.pid --skip-external-locking
Top Process%CPU 42.6/usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/server.aktoweb.biz.pid --skip-external-locking
giaprakigiapraki.com2.7012.111.7
Top Process%CPU 1.3httpd [urll] [/e107_plugins/pm/pm.php?inbox]
Top Process%CPU 1.1httpd [url] [/e107_plugins/forum/forum_viewforum.php?87]
Top Process%CPU 1.0httpd [url] [/e107_plugins/chatbox_menu/chatbox_iframe.php]
adsnetadsnet.gr1.177.900.7
Top Process%CPU 0.5httpd [adsnet.gr] [/www/delivery/lg.php?bannerid16&campaignid4&zoneid5&chan]
Top Process%CPU 0.4httpd [adsnet.gr] [/www/delivery/lg.php?bannerid50&campaignid6&zoneid15&cha]
Top Process%CPU 0.3httpd [adsnet.gr] [/www/delivery/lg.php?bannerid183&campaignid77&zoneid1&ch]
r40r40.gr1.073.340.0
Top Process%CPU 1.1httpd [r40.gr] [/index.php?optioncom_fireboard&Itemid188&funcshowcat&cat]
Top Process%CPU 0.5httpd [r40.gr] [/images/fbfiles/avatars/s_64.png]
Top Process%CPU 0.3httpd [r40.gr] [/index2.php?optioncom_jim&taskxml&no_html1]
root0.278.532.0
Top Process%CPU 0.2[kjournald]
alex123alexandroupoli.net0.030.270.0
Top Process%CPU 0.1httpd [alexandroupoli.net] [/e107_images/banners/banner468x60-alexandroupolinet.gif]
galfasgalfas.gr0.030.270.0
Top Process%CPU 0.1httpd [galfas.gr] [/racing/images/galfas_R40_banner.jpg]
eximstats0.000.000.3
nobody0.001.100.0
mailnull0.000.000.0
unauthenticated0.000.000.0
named0.000.10

View 8 Replies View Related

How To Enable Slow-query Logging In MySQL

Apr 23, 2007

how to enable slow-query logging in MySQL ? Im using mysql version 4.1.20

well i just added following line in my.cnf can you please tell me is it correct way or not?

Code:
log-slow-queries=/tmp/slow_queries.log
log-update = /var/lib/mysql/updates.log

View 6 Replies View Related

Mysql: Schedule Flush Query Cache

Dec 5, 2007

I want to run flush query cache, saying once a week. Is there anyway to schedule it, so system can do it automatically? Currently, I have to login server, and run it manually

View 1 Replies View Related

Mysql Access Host Via Command Line Or Sql Query

Apr 30, 2009

how to add a mysql access host by command line? or or how to add a mysql access host through an sql query?

View 3 Replies View Related

Lost MySQL Password

Aug 22, 2007

I can't remember my mySQL password. How can I find it out?

View 5 Replies View Related

MySQL Query Doing Odd Things - Removing Negative Sign For No Apparant Reason

Jan 10, 2007

I've got a problem with an SQL query that is behaving badly. Its probably really obvious, but I can't see the problem!

I have a table with 3 fields:

Code:

money bigint(20)
income int(12)
userID mediumint(7)

I have a row that has a negative money and a value of 0 for income. When I update the money value to add "0" to it, nothing happens (as expected). When I update the money field to add the income field (which is equal to 0) to it, MySQL flips the sign to make the money field positive.

The following queries show the problem:

Code:

mysql> SELECT money, income from users where userID=327961;
+----------------------+--------+
| money | income |
+----------------------+--------+
| -9223372036854775807 | 0 |
+----------------------+--------+
1 row in set (0.00 sec)

mysql> UPDATE `users` SET money = money + 0 WHERE userID =327961;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

mysql> SELECT money, income from users where userID=327961;
+----------------------+--------+
| money | income |
+----------------------+--------+
| -9223372036854775807 | 0 |
+----------------------+--------+
1 row in set (0.00 sec)

mysql> UPDATE `users` SET money = money + income WHERE userID =327961;
Query OK, 1 row affected, 1 warning (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 1

mysql> SELECT money, income from users where userID=327961;
+---------------------+--------+
| money | income |
+---------------------+--------+
| 9223372036854775807 | 0 |
+---------------------+--------+
1 row in set (0.00 sec)

mysql>
Notice that there is no negative sign after the third select!!

So, we are saying that executing an update where 0 is specified in the query results in the correct action but if you take the 0 from another field it takes the negative sign away...

This for various reasons is a rather urgent problem. This problem has only appeared after upgrading from MySQL 4.0 to MySQl 5.1. This problem does not occur in MySQL 4.1.

View 1 Replies View Related

Plesk 12.x / Linux :: Enable To Create New MySQL Database Server - Test Connection Failed

May 7, 2015

I freshly installed Plesk 12.0 on Ubuntu 14.04. Everything works accept the MySQL database creation.

When I try to create one, i get this error :

error: the test connection to the database server has failed because of network problems: connection refused...

View 1 Replies View Related

DNS Server Query

Aug 21, 2007

I have a dedicated server with the 'typical' 2 ips pointing to the same instance of BIND on it for its nameservers.

I would like to actually have an ns2 to remove this single point of failure. Even though my 'infrastructure,' such as it is, is only a single server; my research on here and elsewhere suggests that this separate DNS server will make my site appear to be non-responsive when the server is down rather than simply non-existent. This is the behavior I would like to have!

I am still left with questions on implementing this. I know I need either a small VPS account, or an account with a provider such as DNSMadeEasy.com. What is not clear to me is how I would set up such an arrangement with the separate DNS server.

Does anyone have a link to a resource that shows how to do this, or would be willing to do a quick run through here?

I am not technically incompetent but am unfamiliar with this procedure and cannot seem to find documentation.

View 2 Replies View Related

MySQL Connection

Jun 8, 2007

I have a database server – mysql.xx.com which is the main MySQL server in H-Sphere.

I've created a database from mysqladmin interface.

I can use the database without a problem but when I’m trying to access the database from another server that I’ve just installed, the PHP application says that it can not connect to the database.

Another thing is that if I move the php app with the same configuration file under a shared account under another H-Sphere server, it's working perfectly.

I’ve read the H-Sphere documentation about an option to enable remote access to the mysql server which I can’t find anymore under our H-Sphere 2.5 Patch 8.

I’ve done a lot of searching to see how can I make that PHP application to connect to mysql.xx.com but it seems that although I’ve run the command grant all …. Command for that database, it still doesn’t work.

One final thing – from that new server if I run "mysql –h mysql.xx.com –u user –p" I can connect to the database and do a use database, show tables etc.

From iptables on mysql.xx.com I see that it accepts connections from outside.

This issue of not getting that PHP application to connect to mysql.xx.com can be related to the fact that H-Sphere is using the server or what should I try further?

View 14 Replies View Related

MySQL Connection Fluctuates

Oct 1, 2009

I'm trying to diagnose where my problem is coming from.

I have a site hosted with Integra Telecom. The site is connecting remotely to a MySQL database hosted on Media Temple.

My problem is that the site's connection to the MySQL database seems to be fluctuating throughout the day. Sometimes the site is up, sometimes it's down.

When it was down, I got the error: "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)"

So is the problem with Integra Telecom or is my problem with Media Temple?

View 4 Replies View Related

Mysql Persistent Connection

Nov 3, 2009

Currently mysql.max_persistent and mysql.max_links are set to -1 which means unlimited

to optimize mysql, should i keep this unlimited or is it good to limit this? If i have to limit it, what is the best value that I can put there?

View 4 Replies View Related

Windows - MySQL Too Many Connection..

Jul 15, 2008

I have win2003 server and running plesk 8.4, there is a website on it and it gives me error with mysql max_connection even I set the limit 1 million or 10000 no matters.

View 3 Replies View Related

Zymic.com MySQL Connection

Mar 18, 2008

We have a front end server for the website Zymic.com (a free web hosting community), a mysql server and a main server for hosted websites. The problem lies between establishing a connection from the Zymic.com server to the database server - to sum it up, the connection just "hangs". We have never had this problem before, never edited anything which would cause a problem, its completely spontaneous.

My administrator has spent endless hours trying to debug the problem, here are some notes he gave me:

1. Ping to the mysql machine works fine.

2. Telnet to port 3306 of the mysql machine works great too – meaning NOT a network issue.

3. Strace on the connection shows it hangs when it calls the server and waits endlessly for response.

4. The mysql machine listens to the IP and port 3306 and connects great to the hosting server via SSH.

5. It's NOT a max connection issue but something to do with the mysql socket itself.

Here is a test from another site on the server to the mysql server:
[url]

Code:
<?php
mysql_connect('75.126.138.74', 'wkscript', 'PASSWORD') or die(mysql_error());
mysql_select_db('domains_data') or die('SELECT ERROR : ' . mysql_error());
?>

View 10 Replies View Related

LiteSpeed - Connection To Mysql

Dec 21, 2008

I have setup LiteSpeed and I have got a problem with php and mysql.

It seems php can't connect to mysql. At every script which use mysql(like phpbb3, phpbb2 etc) I getting errors

SQL ERROR [ mysql4 ] Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) [2002]
phpBB : Critical Error
Could not connect to the database

View 5 Replies View Related

Max MySQL Connection On Shared Host

May 31, 2009

What is the standard number on maximum mysql connection on most shared host providers and which one give the highest number.

View 11 Replies View Related

Host For Remote MySQL Connection

Feb 21, 2008

I have developed a desktop system that uses MySQL data.

I want to use a host to access the data but my current provider only allows access to MySQL data via a web server.

Can anyone suggest a host that would provide direct connection to a MySQL database?

View 11 Replies View Related

Allow User To Remote Mysql Connection

Aug 15, 2008

how to allow user to remote mysql connection from his localhost ( in linux server with WHM )

my user wants to connect to the mysql from his localhost

View 7 Replies View Related

Cpanel Mysql Remote Connection USE EXIST DB

Jun 29, 2009

A have set up a cpanel with remote mysql server.

My demo config:

cpanel:

centos VPS with cpanel WHM (demo)

mysql:

debian VPS

the configuration is OK, it works.

We have got 200 customers, and we will to change to cpanel.

The MYSQL server is on a solaris zone. It is possible to make the remote connecting with it. I will import the 200 users MYSQL databases to cpanel, with privileges (user settings). The mail/web dir a will import manuali to cpanel server(copy-paste-setuser:group).

View 0 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved