Re: what is this? -- errno=2006 errmsg=Server gone
Hi, I'm still struggling with the errno=2006 err=server is gone. I thought I could provide some more info if that makes the problem any more clear: Basically, I'm uploading a file to a database. With no modifications to the form or the handler script it works on _some_ images and breaks on some. It's not a image size issue, I can happily upload some images larger than 2mb and it breaks on a 57kb image. Further I have examples of gif/jpg/png that works so it's not a file format issue either. The server runs locally (just as apache) and there is just one of them (no master/slave and/or replication stuff). I'm running everything on a win2k system with all service packs. I certainly wasn't shutting the server down at the moment and this error is 100% reprod on the specific files that break it. --- Joerg Bruehe; you pointed out that: this message is issued if the client gets an error reported while sending a command to the server. How can I determine if this is in fact the case? And in particular, how can I get my hands on the exact error sent? In general, is there any types of logging I can check and/or enable to further dig into the cause of this problem? regards, martin Martin Olsson wrote: Hi, I get this weird error message: ErrNo: 2006 Error: MySQL server has gone away. What does it mean? I couldn't find anything useful on google and the error message isn't exactly verbose.. :) regards, martin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Right column type for OLE objects
But what about size. I reffered MySQL manual for 5.0, but didn't find that what is he maximum size of binary data we can store in such column. Please help Thanks and regards, CPK -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: what is this? -- errno=2006 errmsg=Server gone
I also got this error when uploading a PDf file of about 2.5 MB size. I am using MS access 2003 and MySQL 5.0. Also I tried to upload a file from Navcat and SQLyog, but it doesn't work. Smaller size, upto 500 KBs will work fine. CPK On 4/17/06, Martin Olsson [EMAIL PROTECTED] wrote: Hi, I'm still struggling with the errno=2006 err=server is gone. I thought I could provide some more info if that makes the problem any more clear: Basically, I'm uploading a file to a database. With no modifications to the form or the handler script it works on _some_ images and breaks on some. It's not a image size issue, I can happily upload some images larger than 2mb and it breaks on a 57kb image. Further I have examples of gif/jpg/png that works so it's not a file format issue either. The server runs locally (just as apache) and there is just one of them (no master/slave and/or replication stuff). I'm running everything on a win2k system with all service packs. I certainly wasn't shutting the server down at the moment and this error is 100% reprod on the specific files that break it. --- Joerg Bruehe; you pointed out that: this message is issued if the client gets an error reported while sending a command to the server. How can I determine if this is in fact the case? And in particular, how can I get my hands on the exact error sent? In general, is there any types of logging I can check and/or enable to further dig into the cause of this problem? regards, martin Martin Olsson wrote: Hi, I get this weird error message: ErrNo: 2006 Error: MySQL server has gone away. What does it mean? I couldn't find anything useful on google and the error message isn't exactly verbose.. :) regards, martin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Right column type for OLE objects
http://dev.mysql.com/doc/refman/5.0/en/blob.html says See Section 11.5, Data Type Storage Requirements. Section 11.5 (http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html) says TINYBLOB, TINYTEXTL+1 byte, where L 2^8 BLOB, TEXTL+2 bytes, where L 2^16 MEDIUMBLOB, MEDIUMTEXTL+3 bytes, where L 2^24 LONGBLOB, LONGTEXTL+4 bytes, where L 2^32 L is the max length, and +1, +2, +3, +4 records the size of the record. HTH, Tim -Original Message- From: C K [mailto:[EMAIL PROTECTED] Sent: Sunday, April 16, 2006 8:33 AM To: Tim Lucia Cc: mysql@lists.mysql.com; [EMAIL PROTECTED] Subject: Re: Right column type for OLE objects But what about size. I reffered MySQL manual for 5.0, but didn't find that what is he maximum size of binary data we can store in such column. Please help Thanks and regards, CPK -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Should we petition GoDaddy?
- Original Message - From: Nicolas Verhaeghe [EMAIL PROTECTED] To: 'MySQL General' mysql@lists.mysql.com Sent: Saturday, April 15, 2006 11:20 PM Subject: Should we petition GoDaddy? I am slowly considering leaving GoDaddy, who has a very good bandwidth and ok tech support (I have seen better but much much worse) and acceptable prices, but unfortunately does not support MySQL 5 and PHP 5 either. I wonder if I could give these people a chance but one thing I'd like to do is see if we could petition these guys and simply threaten to close out our accounts if they do not get on with the music. The current version of MySQL is 3.23. I have no time upgrading my dedicated server to a RedHat machine with custom PHP and MySQL, I don't have the time to do that. Who think we could make them make the right move and pretty quickly? Save your energy and just move your web site to another host. Don't be too impressed by extravagent bandwidth claims. In a shared hosting environment, where servers are often grossly overloaded, you'll either have very little chance of reaching those bandwidth numbers, or if you do, you'll be asked to upgrade or close your account because of the high processing load needed to push that much traffic. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Should we petition GoDaddy?
James Eaton wrote: - Original Message - From: Nicolas Verhaeghe [EMAIL PROTECTED] To: 'MySQL General' mysql@lists.mysql.com Sent: Saturday, April 15, 2006 11:20 PM Subject: Should we petition GoDaddy? I am slowly considering leaving GoDaddy, who has a very good bandwidth and ok tech support (I have seen better but much much worse) and acceptable prices, but unfortunately does not support MySQL 5 and PHP 5 either. I wonder if I could give these people a chance but one thing I'd like to do is see if we could petition these guys and simply threaten to close out our accounts if they do not get on with the music. The current version of MySQL is 3.23. I have no time upgrading my dedicated server to a RedHat machine with custom PHP and MySQL, I don't have the time to do that. Who think we could make them make the right move and pretty quickly? Save your energy and just move your web site to another host. Don't be too impressed by extravagent bandwidth claims. In a shared hosting environment, where servers are often grossly overloaded, you'll either have very little chance of reaching those bandwidth numbers, or if you do, you'll be asked to upgrade or close your account because of the high processing load needed to push that much traffic. Who is GoDaddy and should I care? Is this an international issue? Regards -- David Logan South Australia when in trouble, or in doubt run in circles, scream and shout -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: bind-address question
Andrew wrote:
Hi Everyone,
I have been searching around for a while, but have had no luck as yet
for this question.
I am running debian with mysql 4.x on a x86 box. (2.6 series kernel).
Anyhow, up until now, I have had a single bind-address option passed,
however I need to add another address (so it binds to two, but not all
available addresses) - how can I do this in the my.cnf file?
Thanks,
ANdrew.
Hi Andrew,
judging by a quick look at the source of 5.0.18, I would say, that this is
not possible. You can either bind to one or all addresses.
Cheers
Frank
see sql/mysqld.cc:
case (int) OPT_BIND_ADDRESS:
if ((my_bind_addr= (ulong) inet_addr(argument)) == INADDR_NONE)
{
struct hostent *ent;
if (argument[0])
ent=gethostbyname(argument);
else
{
char myhostname[255];
if (gethostname(myhostname,sizeof(myhostname)) 0)
{
sql_perror(Can't start server: cannot get my own hostname!);
exit(1);
}
ent=gethostbyname(myhostname);
}
if (!ent)
{
sql_perror(Can't start server: cannot resolve hostname!);
exit(1);
}
my_bind_addr = (ulong) ((in_addr*)ent-h_addr_list[0])-s_addr;
}
break;
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: ~ How to install 3 instances of mysql~
Hi Logan,
Thanks for the links. But how am i suppose to allocate my physical
memory for the 3 mysql instances. Pls guide me on the innodb memory
settings. My total RAM memory is 1 GB.
Thanks in advance,
Abdul.
On Sat, 2006-04-15 at 23:35 +1000, Logan, David (SST - Adelaide) wrote:
Hi,
Also a read of
http://dev.mysql.com/doc/refman/5.0/en/multiple-servers.html and
http://dev.mysql.com/doc/refman/5.0/en/mysqld-multi.html would probably
be quite helpful. The second gives you a good idea on how to setup the
my.cnf file for multiple servers. The concepts are the same for version
4.1
Regards
---
** _/ ** David Logan
*** _/ *** ITO Delivery Specialist - Database
*_/* Hewlett-Packard Australia Ltd
_/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED]
_/ _/ _/ _/ Desk: +618 8408 4273
_/ _/ _/_/_/ Mobile: 0417 268 665
*_/ **
** _/ Postal: 148 Frome Street,
_/ ** Adelaide SA 5001
Australia
invent
---
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Saturday, 15 April 2006 10:45 PM
To: mysql@lists.mysql.com
Subject: Re: ~ How to install 3 instances of mysql~
On Sat, 15 Apr 2006, Mohammed Abdul Azeem wrote:
To: [EMAIL PROTECTED]
From: Mohammed Abdul Azeem [EMAIL PROTECTED]
Subject: Re: ~ How to install 3 instances of mysql~
Hello Keith,
Thank you very much for your guidence.
This is my existing my.cnf file
[mysqld]
port= 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer = 384M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
thread_cache = 8
query_cache_size = 32M
log_bin_trust_routine_creators = 1
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
#specify the storage engine
default-storage-engine = InnoDB
#specify the table type
default-table-type = InnoDB
#enable the full query log
log
#Print warnings to error log file
log_warnings
#specify max connections
max_connections = 30
#specify max user connections
max_user_connections = 12
# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = /mysql-system/mysql/data/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /mysql-system/mysql/data/
innodb_log_arch_dir = /mysql-system/mysql/data/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 384M
innodb_additional_mem_pool_size = 20M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 5242880
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 100
The variables key_buffer = 384M, innodb_buffer_pool_size = 384M,
innodb_additional_mem_pool_size = 20M, innodb_log_buffer_size = 8M
are set for 1 instance.
My RAM memory is 1GB. Can i have the same values for the above
variables
set for all the 3 instances ? if yes, will that not exceed the
available
RAM memory. Please help me set the correct values for these variables
for each instance.
Well, if you are running multiple instances of mysqld
concurrently, then I guess you will have to share the system
resorces as well, such as memory and file handles.
Note that if you are using qps to monitor processes, for
each mysqld you have running, the memory usage will increase
appropriately.
I only use MyISAM tables the moment, so I cannot help you
with your InnoDB table settings.
Kind Regards
Keith Roberts
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
This email has been Scanned for Viruses!
www.newbreak.com
This email has been Scanned for Viruses!
www.newbreak.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Where is the more detailed document of MySQL Network?
Hello: For example: What does Web Access and Remote Troubleshooting mean in this page https://shop.mysql.com/network.html?rz=s2 regards, gu lei
RE: ~ How to install 3 instances of mysql~
Hi Abdul,
As I only use MyISAM, I can only reinforce Keith Roberts mentioned,
these are three separate instances and will require three separate
memory spaces.
Have you looked here?
http://dev.mysql.com/doc/refman/5.0/en/innodb-parameters.html and
http://dev.mysql.com/doc/refman/5.0/en/innodb-tuning.html
I could also recommend the book by Jeremy Zawodny, High Performance
MySQL. This has a fair bit of information which would be helpful to you.
Chapter 6, Server Tuning, is on the mysql website here
http://dev.mysql.com/books/hpmysql-excerpts/ch06.html
Sorry, that is about all the help I can be as I am no InnoDB expert.
Regards
---
** _/ ** David Logan
*** _/ *** ITO Delivery Specialist - Database
*_/* Hewlett-Packard Australia Ltd
_/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED]
_/ _/ _/ _/ Desk: +618 8408 4273
_/ _/ _/_/_/ Mobile: 0417 268 665
*_/ **
** _/ Postal: 148 Frome Street,
_/ ** Adelaide SA 5001
Australia
invent
---
-Original Message-
From: Mohammed Abdul Azeem [mailto:[EMAIL PROTECTED]
Sent: Monday, 17 April 2006 12:35 PM
To: Logan, David (SST - Adelaide)
Cc: mysql@lists.mysql.com; [EMAIL PROTECTED]
Subject: RE: ~ How to install 3 instances of mysql~
Hi Logan,
Thanks for the links. But how am i suppose to allocate my physical
memory for the 3 mysql instances. Pls guide me on the innodb memory
settings. My total RAM memory is 1 GB.
Thanks in advance,
Abdul.
On Sat, 2006-04-15 at 23:35 +1000, Logan, David (SST - Adelaide) wrote:
Hi,
Also a read of
http://dev.mysql.com/doc/refman/5.0/en/multiple-servers.html and
http://dev.mysql.com/doc/refman/5.0/en/mysqld-multi.html would
probably
be quite helpful. The second gives you a good idea on how to setup the
my.cnf file for multiple servers. The concepts are the same for
version
4.1
Regards
---
** _/ ** David Logan
*** _/ *** ITO Delivery Specialist - Database
*_/* Hewlett-Packard Australia Ltd
_/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED]
_/ _/ _/ _/ Desk: +618 8408 4273
_/ _/ _/_/_/ Mobile: 0417 268 665
*_/ **
** _/ Postal: 148 Frome Street,
_/ ** Adelaide SA 5001
Australia
invent
---
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Saturday, 15 April 2006 10:45 PM
To: mysql@lists.mysql.com
Subject: Re: ~ How to install 3 instances of mysql~
On Sat, 15 Apr 2006, Mohammed Abdul Azeem wrote:
To: [EMAIL PROTECTED]
From: Mohammed Abdul Azeem [EMAIL PROTECTED]
Subject: Re: ~ How to install 3 instances of mysql~
Hello Keith,
Thank you very much for your guidence.
This is my existing my.cnf file
[mysqld]
port= 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer = 384M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
thread_cache = 8
query_cache_size = 32M
log_bin_trust_routine_creators = 1
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
#specify the storage engine
default-storage-engine = InnoDB
#specify the table type
default-table-type = InnoDB
#enable the full query log
log
#Print warnings to error log file
log_warnings
#specify max connections
max_connections = 30
#specify max user connections
max_user_connections = 12
# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = /mysql-system/mysql/data/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /mysql-system/mysql/data/
innodb_log_arch_dir = /mysql-system/mysql/data/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 384M
innodb_additional_mem_pool_size = 20M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 5242880
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 100
The variables key_buffer = 384M, innodb_buffer_pool_size = 384M,
innodb_additional_mem_pool_size = 20M, innodb_log_buffer_size = 8M
are set for 1 instance.
My RAM memory is 1GB. Can i have the same values for the above
How to connect to mySQL?
Hi, I want to know how I can connect to MySQL with ODBC driver? Is there something else to be installed besides MySQL for Windows? Thanks a lot! Best Wishes, -- John Xu, EE, BUPT, P.R. China 北京邮电大学-电子工程学院 徐晶 Addr:北京邮电大学219#信箱 Zip:100876 Dorm:北京邮电大学 学6-347 TEL:010-62284785 Mobile:13581764924 QQ:46119403 MSN:[EMAIL PROTECTED]
