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 sa
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?
>
> >
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 va
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_s
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
Ho
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 versio
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
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 r
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, b
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 in
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
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 06:17
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
> cor
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 t
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 1/29/0
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.
>
- 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 serve
>
> 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
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 m
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
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, 20
- 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
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 sig
>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
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
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]
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 signa
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 h
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 fill
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 you
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 not
> 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 later
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
; <[EMAIL 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 c
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 t
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 the
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 that
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
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 ( -
"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)
40 matches
Mail list logo
