Hi,
Michael Fernández M. wrote:
key_buffer_size=402653184
read_buffer_size=2093056
max_used_connections=323
max_connections=800
threads_connected=55
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections
= 3666809 K
bytes of memory
El mar, 20-02-2007 a las 13:16 +0100, Nils Meyer escribió:
Hi,
Michael Fernández M. wrote:
key_buffer_size=402653184
read_buffer_size=2093056
max_used_connections=323
max_connections=800
threads_connected=55
It is possible that mysqld could use up to
key_buffer_size +
Hi,
Michael Fernández M. wrote:
i use 32 Bits kernel.
Remember that you have to stay under 2GB total memory allocation! I
think you hit that limit.
innodb_additional_mem_pool_size = 500 MB.
innodb_buffer_pool_size = 8 MB
Before the innodb_additional_mem_pool_size was 1 MB, (the default
El mar, 20-02-2007 a las 13:38 +0100, Nils Meyer escribió:
Hi,
Michael Fernández M. wrote:
i use 32 Bits kernel.
Remember that you have to stay under 2GB total memory allocation! I
think you hit that limit.
Sorry, but why do you say that?, because of the 32 bits kernel?
Michael Fernández M. wrote:
Remember that you have to stay under 2GB total memory allocation! I
think you hit that limit.
Sorry, but why do you say that?, because of the 32 bits kernel?
Yes exactly. Depending on kernel version you can allocate something
between 2 or 2.7GB. Until 2GB it's
Privet!
key_buffer_size + (read_buffer_size +
sort_buffer_size)*max_connections = 441967 K
Check that you have enough virtual memory for MySQL processes.
Have a look at:
http://dev.mysql.com/doc/refman/5.0/en/freebsd.html
http://dev.mysql.com/doc/refman/5.0/en/crashing.html
What version
I wouldn't run 3.23.51, there have been major security patches since then.
I always mess up the byte math, but it looks to me like you have 2 gigs of
ram in your box and you are allocating 2.3 gigs to mysql. With 263
connections you would have been using about 1.4 gigs, if you have anything
else
Joe,
- Original Message -
From: Jennifer Goodie [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Friday, March 21, 2003 9:45 PM
Subject: RE: mysqld got signal 11; (CRASH max-3.23.51) What do I need to do
to clean up?
I wouldn't run 3.23.51, there have been major security
Hello,
I have followed your suggestion.
I have installed mysql-debug-4.0.10-gamma-sun-solaris2.9-sparc-64bit on the
Solaris 8 (Machine with 8 cpus, 32GB of Memory and 64 of swap) server.
I have started the mysqld program as root
I have specified the
core-file
in the /etc/my.cnf file.
Other info
Mariella Di Giacomo writes:
Hello,
I have followed your suggestion.
I have installed mysql-debug-4.0.10-gamma-sun-solaris2.9-sparc-64bit on the
Solaris 8 (Machine with 8 cpus, 32GB of Memory and 64 of swap) server.
I have started the mysqld program as root
I have specified the
core-file
Hi,
I will install the 2.8 debug version.
The reason why I set
setting sort and record buffers to 1K
is because with a few tests I have noticed that I was getting a better response
time for queries.
The limit for the core file was unlimited.
I will look into customer support.
Mariella
At
Mariella Di Giacomo writes:
Hi,
I will install the 2.8 debug version.
The reason why I set
setting sort and record buffers to 1K
is because with a few tests I have noticed that I was getting a better response
time for queries.
The limit for the core file was unlimited.
I will look
Hi,
I would prefer the debug version which the latest I believe is the 4.0.10.
The same error I get it when I run ALTER TABLES or I try to insert data
into tables.
I will try and let you know.
Thanks,
Mariella
At 06:31 PM 2/24/03 +0200, you wrote:
Mariella Di Giacomo writes:
Hi,
I will
Mariella Di Giacomo writes:
Hi,
I would prefer the debug version which the latest I believe is the 4.0.10.
The same error I get it when I run ALTER TABLES or I try to insert data
into tables.
I will try and let you know.
Thanks,
Mariella
4.0.11 will be quite soon, but your
- Original Message -
From: Mariella Di Giacomo [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, January 29, 2003 1:12 AM
Subject: mysqld got signal 11; This could be because you hit a bug
Hello,
I am running mysql server
On Tue, 28 Jan 2003 17:12:14 -0700
Mariella Di Giacomo [EMAIL PROTECTED] wrote:
Hello,
I am running mysql server (mysql-standard-4.0.5-beta-64bit) 64 bit on
Sun Solaris 2.8 and I have got the binaries form the mysql web site.
The machine I am using has 32GB of RAM + 64GB of swap.
Thanks
Hi Mark,
Thanks.
The memory that we are using is ECC.
The reason I have only 16 connections is because that DB is used only
for updates.
In reality for that DB we use 3 or 4 connections maximum.
We have a mirror copy used for customers which has a lot of
connections.
Mariella
At 10:22 AM
Hi,
MEMORY PROBLEM ... a pointers is gone a way ...
The signal is SIGSEV and this mean in fact: Invalid memory reference.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
Luc,
Friday, May 17, 2002, 6:26:19 PM, you wrote:
LF Can anyone tell me what this means??
LF mysqld got signal 11;
LF The manual section 'Debugging a MySQL server' tells you how to use a
LF stack trace and/or the core file to produce a readable backtrace that may
LF help in finding out why
Luc Foisy writes:
Can someone give me some clue as to what this means to me?
mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you how to use a
stack trace and/or the core file to produce a readable backtrace that may
help in finding out why mysqld died
Attemping
info
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 17, 2002 11:52 AM
To: [EMAIL PROTECTED]
Subject: Re: mysqld got signal 11;
Luc,
Friday, May 17, 2002, 6:26:19 PM, you wrote:
LF Can anyone tell me what this means??
LF mysqld got signal 11
- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, May 17, 2002 6:52 PM
Subject: Re: mysqld got signal 11;
Luc,
Friday, May 17, 2002, 6:26:19 PM, you wrote:
LF Can anyone tell me what this means??
LF mysqld got signal 11;
LF
What version of MySQL you use ? I hope is not 3.23.4x.
- Original Message -
From: Luc Foisy [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; MYSQL-List (E-mail) [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, May 17, 2002 7:25 PM
Subject: RE: mysqld got signal 11;
Luc Foisy writes
try to restart master and see what happen
- Original Message -
From: Luc Foisy [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; MYSQL-List (E-mail) [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, May 17, 2002 7:25 PM
Subject: RE: mysqld got signal 11;
Luc Foisy writes:
Can
On vendredi, mai 17, 2002, at 05:26 , Luc Foisy wrote:
Can anyone tell me what this means??
mysqld got signal 11;
[...]
(Could be) Bad RAM ?
R.
-
Before posting, please check:
http://www.mysql.com/manual.php (the
A post from the MySQL list
MEMORY PROBLEM ... a pointers is gone a way ...
The signal is SIGSEV and this mean in fact: Invalid memory
reference.
If this is a memory problem, how did it hit two servers ( several kilometers
apart )
Steve writes:
Hi,
I am running mysql 3.23.33 getting this error about once a day causeing
mysql to restart
Thanks and Regards,
Steve Reed
Network Administrator
Oznetwork Pty. Ltd.
8233 1900
142 Phillip St
Sydney NSW 2000
Hi!
Please can you check whether your hyperseek_links
On Monday 21 May 2001 23:29, Steve wrote:
Hi,
I am running mysql 3.23.33 getting this error about once a day causeing
mysql to restart
mysqld got signal 11;
Hi,
OK, I now still have the same problem after upgrading to
3.23.33-pc-linux-gnu-i686 binary. After myisamchking all tables, this time
it took just about one minute before crashing:
mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you how to use a
stack trace and/or
Hi,
Ah, today's problems are from a bug that dates back a year or more.
Streaming a large number of insert delayeds into a table that does not exist
causes the crash. The table was not created correctly last night.
Is there a web version of mysql code like PHP has http://lxr.php.net ? I'd
like
MAIL PROTECTED]
Sent: Tuesday, March 06, 2001 6:29 PM
Subject: Re: mysqld got signal 11
Hi,
OK, I now still have the same problem after upgrading to
3.23.33-pc-linux-gnu-i686 binary. After myisamchking all tables, this time
it took just about one minute before crashing:
mysqld got signal 11;
Steven Roussey writes:
Hi,
Ah, today's problems are from a bug that dates back a year or more.
Streaming a large number of insert delayeds into a table that does not exist
causes the crash. The table was not created correctly last night.
Is there a web version of mysql code like
I have tried the above with 3.23.33 and was not able to reproduce it.
I could be wrong (imagine that!). It crashed again today even with the table
in place.
In order to take one item out of the equation, I stopped the replace delayed
process I had running. It still crashed (about 8 hours
An update:
o I found other queries that were insert delayed into non-existent tables
and others that had wrong column names. Removing these, I thought would fix
things. Nope.
o I tried writing a log and a trace file. Too slow and unworkable. I tried
just log (worked OK -- I got a crash but
mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you how to use a
stack trace and/or the core file to produce a readable backtrace that may
help in finding out why mysqld died
Attemping backtrace. You can use the following information to find out
where mysqld died. If
One more thing:
In the processlist:
| Delayed_insert | 578 | reschedule | log_day_20010307
After another minute (now over 10 minutes to reschedule) I get a _lot_ of
these:
| Query | 9| waiting for handler insert | insert delayed into
logging.log_day_20010307 ...
Which
"Matis, Jan" wrote :
Hallo,
I have small problem with my sql (again :)
version:3.23.32
linux: SuSE 6.2 kernel: 2.2.16, 2.2.18, 2.4.1
lib: libc-2.1.2-31 (suse)
compiled: gcc-2.95.2, egcs 2.7.2.3
compilation parameters: --prefix=/opt/mysql ( --without-debug
--enable-assembler)
memory:
On Thu, Feb 01, 2001 at 09:14:36AM +0100, Matis, Jan wrote:
Hallo,
I have small problem with my sql (again :)
version:3.23.32
linux: SuSE 6.2 kernel: 2.2.16, 2.2.18, 2.4.1
lib: libc-2.1.2-31 (suse)
compiled: gcc-2.95.2, egcs 2.7.2.3
compilation parameters: --prefix=/opt/mysql (
Have you tried using the binary tarball from the MySQL web site?
http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.32-pc-linux-gnu-i686.ta
r.gz
Jeremy
no I didn't ...so I changed it now and we will see on afternoon :)
Jan
Now I can say I tryed
http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.32-pc-linux-gnu-i686.ta
r.gz
too
and it dind't helped
mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you how to use a
stack trace and/or the core file to produce a readable backtrace
40 matches
Mail list logo