Cameron,
Take a look in the data directory for a .err file. This error log
will almost certainly contain the reason why Mysql failed to load and
will make fixing it much easier.
Richard
On Wed, 28 Jul 2004 13:15:34 -0600, Cameron Roe [EMAIL PROTECTED] wrote:
Thanks Rory,
I did go through
PROTECTED] wrote:
Richard Clarke [EMAIL PROTECTED] wrote:
I have switched to the mysql standard binary and it helped in no way
at all. If anything it made the situation worse. It seems that mysql
grows even worse than before.
Mysql uses an extra 1MB roughly every 5-10 seconds.
mysql
Mysql won't stop eating RAM!! :(
Machine is a quad xeon 2.4 with 4 gigs of RAM.
Linux db2 2.6.7-rc3 #1 SMP Thu Jun 17 12:51:21 UTC 2004 i686 Intel(R)
Xeon(TM) CPU 2.40GHz GenuineIntel GNU/Linux
Mysql is 4.1.3-beta
Compile options are,
./configure --enable-thread-safe-client --enable-assembler
statistical operations
depending on the above functions temporarily.
I am using
gcc-3.3.3-r6 and glibc-2.3.3.20040420 gentoo packages.
Richard.
On Tue, 20 Jul 2004 15:57:17 +0300, Egor Egorov [EMAIL PROTECTED] wrote:
Richard Clarke [EMAIL PROTECTED] wrote:
I think that is possibly related to some
I have switched to the mysql standard binary and it helped in no way
at all. If anything it made the situation worse. It seems that mysql
grows even worse than before.
Mysql uses an extra 1MB roughly every 5-10 seconds.
Richard
On Tue, 20 Jul 2004 14:44:39 +0100, Richard Clarke
[EMAIL PROTECTED
A perhaps more perlish way would be,
my $table = MyTable;
my $sql = join ',', map {$_=?} keys %
- Original Message -
From: Daniel Kasak [EMAIL PROTECTED]
To: Nik Belajcic [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, June 01, 2004 5:15 AM
Subject: Re: Perl arrays into MySQL
Crap sorry about the double post.. where's that damn undo send e-mail button
:(
A 'better' way imo would be,
my %record; #full of my stuff
my $table = MyTable;
my $sql = join ',', map {$_=?} keys %record;
$dbh-do(insert into $table set $sql,undef,values %record);
Richard
- Original
The manual indicates that a GET_LOCK expires automatically when a new
GET_LOCK is issued. Can someone explain to me how this behaviour could
possibly be the most useful?
I wish to use GET_LOCK in my applications to provide advisory locking on
which tables should be used for certain operations. I
PROTECTED]
To: Richard Clarke [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, June 01, 2004 8:39 PM
Subject: Re: GET_LOCK(str,timeout) behaviour
GET_LOCK is just a string lock, and has nothing to do with tables.
Use LOCK TABLES instead.
Richard Clarke wrote:
The manual indicates
Alek,
Create a file of any name, e.g. script.cnf.
Put the following in it,
[client]
user = dba
password = dba_pass
Run mysql with the --defaults-file arg
mysql --defaults-file=script.cnf
So long as the cnf file is only readable by the the cronjob
Just think, one more click and you wouldn't have had to send an e-mail.
http://www.mysql.com/downloads/mysql-max-4.0.html
http://www.mysql.com/downloads/mysql-standard-4.0.html
Richard.
- Original Message -
From: Ray Kiddy [EMAIL PROTECTED]
To: Lenz Grimmer [EMAIL PROTECTED];
Victoria,
I pulled that latest updates to the 4.1 tree to make sure I had the most
recent version and I still have the same problem. Here is a log of my
actions.
# cd /usr/local/mysql-4.1
mysql-4.1 # bin/mysql --defaults-file=etc/my-small.cnf -u root
Welcome to the MySQL monitor. Commands
.
- Original Message -
From: Dan Nelson [EMAIL PROTECTED]
To: Richard Clarke [EMAIL PROTECTED]
Cc: Victoria Reznichenko [EMAIL PROTECTED]; MySQL
[EMAIL PROTECTED]
Sent: Tuesday, December 24, 2002 6:39 PM
Subject: Re: 4.1 questions: subqueries which use dual
In the last episode (Dec 24
.
I can't do it by ID because what if a row in the middle somewhere gets
deleted? I need to do it by the position in the table, and a static
numbering column won't work. This is a solution someone on EFNet came up
with:
SET @rowcount=0;
select docid,@rowcount:=@rowcount+1 as num FROM
http://www.mysql.com/newsletter/2002-10/a79.html
- Original Message -
From: Anthony W. Marino [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, December 20, 2002 1:14 PM
Subject: 4.1 Download
Where/how can I get a copy of 4.1?
Thanks,
Anthony
Gurhan,
The outlined method is unnecessary if you are using Mysql.
The same output can be achieved by using,
select @a:=substring_index(val,',',3), substring_index(@a,',',-1) as
value_i_want from test;
Richard.
- Original Message -
From: Gurhan Ozen [EMAIL PROTECTED]
To: Paul
Jeroen,
Two things are likely to make this umpteen times faster.
a) Commit the insert transaction every.. say 1000 records?
b) use mysql's extended insert statement,
insert into mytable values
(row1_field1,row1_field2),(row2_field1,row2_field2),(?,?),(?,?) etc etc
Ric.
- Original
Uhm, huh?
What use are these other products to him if his calendar is part of a bigger
application? What's he gonna do, plonk his webcalendar.sourceforge.net
instance into the middle of his current application? How exactly is he
reinventing the wheel? You comments clearly indicates that these
Except in the case that cars aren't held at the dealers and any one car can
be purchased from a range of dealers.
In which case you will need a seperate table like,
Dealer_Car_Map (dealer_id,car_id).
Ric.
- Original Message -
From: Artem Koltsov [EMAIL PROTECTED]
To: [EMAIL PROTECTED];
Randy,
I think I've firmed my theoritical understanding of relationships enough
to be dangerous. Now for the logical parthow do you actually define a
relationship in mysql? For instance...
http://www.mysql.com/doc/en/SEC447.html
table movies
columns (movie id(pk) , movie title ,
I believe your only choice is to move this stored procedure into client side
routines.
Ric
- Original Message -
From: Pradana [EMAIL PROTECTED]
To: MySQL [EMAIL PROTECTED]
Sent: Thursday, October 17, 2002 8:37 PM
Subject: Stored Proc
OK,
MySQL does not support the Stored Procedure
Have any of you guys come across this,
http://www.firstworks.com/sqlrelay.html, as a way of managing fault
tolerance from clients accessing mysql databases?
Richard
-
Before posting, please check:
Heikki Others,
I read through the 4.0.2 Changelog but I couldn't find indication of
the following bug fixes.
1. Was the bug with drop/create tables causing assertaion errors fixed.
I think that the latest 3.x release has this bug fixed but I know
4.0.1 certainly doesn't.
2. Do Unions
Jeremy Zawodny wrote:
On Sat, Jul 13, 2002 at 09:25:32AM +0100, Richard Clarke wrote:
Heikki Others,
I read through the 4.0.2 Changelog but I couldn't find indication of
the following bug fixes.
1. Was the bug with drop/create tables causing assertaion errors fixed.
I think
So this works as expected,
mysql create table test_1 (id int,value char);
Query OK, 0 rows affected (0.00 sec)
mysql create table test_2 (id int,val char);
Query OK, 0 rows affected (0.00 sec)
mysql insert into test_1 values (1,a),(2,b),(3,c);
ERROR 1054: Unknown column 'a' in 'field list'
Would it not be better to suggest that the poster gets a clue and goes buy a
book. I dare say there are hundreds that are useful. In all honesty should
the poster of a question like this not just give up?
http://www.mysql.com/doc/M/y/MySQL-Books.html
I'm sure one of these books would give some
snip
INSERT INTO my_table VALUES (foo, foo), (bar, bar), (z, z)...
snip
From my own experience, by using this method, that is doing one insert per
200 or more rows I can increase the insert speed from between 5x - 10x. A
couple more performance improvements where made as well so that value
They are bugged in 4.0.1 (apparently fixed in 4.0.2) so I wouldn't rely on
them too much.
Richard
- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, June 01, 2002 11:33 AM
Subject: Re: Unions
Arul,
Saturday, June 01, 2002, 9:26:48
. This is
perfect if you are doing any statistical calculations which involves
gathering the top 100 (or n) rows per id.
Richard
- Original Message -
From: Kevin Fries [EMAIL PROTECTED]
To: 'Richard Clarke' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, May 31, 2002 6:07 PM
Subject: RE: Finding
Or another approach could be (using same example tables)
mysql set @a:=0; set @b:=0; set @c:=0;
mysql select
id,@b:=IF(id=@a+1,id,concat(@a+1,..,id-1)),@a:=id,@flag:=IF(@b=id,id,MISS
ING) from seq;
++---++-
--+
| id
sql reset master;
Ric
- Original Message -
From: Iago Sineiro [EMAIL PROTECTED]
To: MySql Mail List [EMAIL PROTECTED]
Sent: Wednesday, May 29, 2002 6:14 PM
Subject: Can I remove innobd binarie files?
Hi all.
In the innodb directory I have these files (prototipo is the name of the
I'm sure this question should be put in the docs. It's asked at least once a
fortnight. Welcome to the wonderful world of Mysql variables.
create temporary table productorder select *,(@a:= IF(@b=product,@a+1,1)) as
cnt, @b:=product from
products order by product,price;
mysql select * from
This is OT, perhaps post to comp.lang.perl.*?
Ric
p.s. try use DBI or use lib qw(/path/to/module)
- Original Message -
From: Amy Zediak [EMAIL PROTECTED]
To: MySql List [EMAIL PROTECTED]
Sent: Tuesday, May 28, 2002 3:01 PM
Subject: @INC
I'm a little confused on how to add
manual and latest news on
InnoDB
- Original Message -
From: Richard Clarke [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Sent: Sunday, May 19, 2002 12:02 PM
Subject: Re: 4.0.1 Bugs
Heikki,
As for my crashes. This one is a little hard, see, we have
on InnoDB
- Original Message -
From: Richard Clarke [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Sent: Sunday, May 19, 2002 12:02 PM
Subject: Re: 4.0.1 Bugs
Heikki,
As for my crashes. This one is a little hard, see, we have two
machines
that do this. Both however
Andy,
I believe that that file is an on disk temporary file that was created
during the query. I would suggest you wait for the recover to finish as I
think (hope) your data will be returned to a fairly normal state when it
does.
Ric.
- Original Message -
From: andy [EMAIL
List,
I wondered if any movement has been made to determine the cause of the
following bugs that I have come across using Mysql 4.0.1.
1) selectunion causes a temporary table full type error when the
datasets aren't even that large and when there is bags of disk space.
2) Under FreeBSD
of roughly 30 queries is run every 5 seconds 24/7. After about
5-7 days the db server segv's on both our 4.4-release machines.
Ric.
- Original Message -
From: Carsten Gehling [EMAIL PROTECTED]
To: Richard Clarke [EMAIL PROTECTED]; MYSQL [EMAIL PROTECTED]
Sent: Saturday, May 18, 2002 9:48 PM
Not a direct answer to your question here, but why keep backups on the same
server and in the same storage medium?
Ric.
- Original Message -
From: kibserv-FtS Setiqueue [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Saturday, May 18, 2002 9:44 PM
Subject: Database and all
Or goto http://www.innodb.com of course.
Ric.
- Original Message -
From: Dan Nelson [EMAIL PROTECTED]
To: Sherzod Ruzmetov [EMAIL PROTECTED]
Cc: Edilson Vasconcelos de Melo Junior [EMAIL PROTECTED]; MYSQL
[EMAIL PROTECTED]
Sent: Friday, May 17, 2002 11:49 PM
Subject: Re: MyISAM - Innodb
There is plenty of space. In excess of 5 gigs.
Ric
- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, April 12, 2002 2:02 PM
Subject: Re: Re: unkown table is full
Richard,
Friday, April 05, 2002, 12:29:44 AM, you wrote:
RC Hi,
RC
This is mysql 4.0.1-alpha.
Ric
- Original Message -
From: Sinisa Milivojevic [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, April 12, 2002 5:08 PM
Subject: Re: Re: unkown table is full
Richard Clarke writes:
There is plenty of space. In excess of 5
Luke,
How exactly will the foreign keys save you time? Please explain.
Ric.
- Original Message -
From: Luke van Blerk [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 09, 2002 9:17 AM
Subject: InnoDB tables
Hi everyone,
I've been reading up about InnoDB tables and
Hello Mr CEO,
Hmmm... go away?
Ric
- Original Message -
From: Hugh O'Loughlin [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, April 06, 2002 1:31 PM
Subject: Do any of your applications work?
Responsible Person,
We have been asked by a client, to use your products in
create temporary table usertempcnt
SELECT *,(@a:= IF(@b=id,@a+1,1)) as cnt, @b:=id from user order by
id,points desc;
select *,sum(points) from usertmpcnt where cnt=2;
where 2 is your N
Regards,
Richard
- Original Message -
From: Anzej Becan [EMAIL PROTECTED]
To: [EMAIL
-
From: Richard Clarke [EMAIL PROTECTED]
To: Anzej Becan [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, March 11, 2002 5:26 PM
Subject: Re: How to sum only nest N values?
create temporary table usertempcnt
SELECT *,(@a:= IF(@b=id,@a+1,1)) as cnt, @b:=id from user order by
id,points desc
Hi,
What would the plausability of a function like this being implemented in the
future.
create table mytable (id int, val char(255), hits int);
insert some data...
select max(5,hits) from mytable group by id;
This would allow selecting of the top 5 rows for each id according to the
hit
]
To: Richard Clarke [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, March 04, 2002 5:56 PM
Subject: Re: extra max() function possibly very useful?
On Monday 04 March 2002 10:50 am, Richard Clarke wrote:
create table mytable (id int, val char(255), hits int);
insert some data...
select max(5
Correct.
Richard
- Original Message -
From: DL Neil [EMAIL PROTECTED]
To: Richard Clarke [EMAIL PROTECTED]; Christopher Thompson
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, March 04, 2002 6:34 PM
Subject: Re: extra max() function possibly very useful?
LIMIT to be applied
Hi,
I'm running mysql 4.0.1.max on freebsd 4.4-stable. I have a fairly high
volume db server which is user to processe approx 200 apache hits/sec. After
previously having problems with 4.0.0 I changed to 4.0.1 and everything
seemed fine for about 4 days. The exact same queries happen almost
-variable = innodb_additional_mem_pool_size=20M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50
Richard
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
To: Richard Clarke [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, February 24, 2002 5:32 PM
Hi,
I seem to be getting intermittant crashes of mysql. The error log prints
the following,
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error
Hi,
I have a box with 1gig ram which i am using as my mysql server. however
when i try to assig about 600megs to the innodb buffer pool it reports that,
InnoDB: Fatal error: cannot allocate 524304384 bytes of
InnoDB: memory with malloc! Total allocated memory
InnoDB: by InnoDB
DBD::mysql::st execute failed: The table 'ip_src' is full at
/usr/local/lib/perl5/site_perl/5.005/i386-freebsd/Mysql.pm line 172.
I get this error when running a query on my database. According to the
documentation, in later versions of mysql this problem should be bypassed
due to the automatic
So I have found out that mysql creates bin logs of all queries so that it
can do rollbacks and such. But is it really necessary for it to maintain
these logs forever so that they end up to be 10gigs + for only a few
thousand current rows.
Ric
If I have a process inserting into an innodb table in 200 insert chunks.
i.e. it commits after every 200 inserts, must another process, which wants
to delete data from this table, wait for the next commit on the insert end?
If not is there any reason why my process is doing this.
Ric
There is definitly something to do with this row count that is causing a
problem. My table uses no blobs.
CREATE TABLE `raw` (
`cid` int(11) default NULL,
`agent` char(255) default NULL,
`referer` char(255) default NULL,
`addr` char(15) default NULL,
`via` char(255) default NULL,
This is a followup to my previous messages indicating database slow down.
After noticing the queries start to slow down earlier i decided to try and
get some debug info. a show table status had one interesting thing.
| raw| InnoDB | Fixed | 169681 | 1030 |
174817280 |
Can anyone explain to me what these files are for. If they are related to
innodb why don't they go in my specified ibdata directory. I set innodb to
use 4gig's and when i start mysql it creates this file in the specified
location so why does it need to create bin files when i insert rows into my
06 13:38:46 mysqld restarted
InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 5 778892274
InnoDB: Doing recovery: scanned up to log sequence number 5 778957312
InnoDB: Doing
Hi,
I'm building an application which uses Innodb. It is very imperative
that all data is processed as quickly as it possibly can and so the problem
I have is quite a concern. My perl script executes the queries however if if
make an error in the code and the script crashes half way through
What does this mean. How can I fix it. It seems silly that I have to read
data out just to write it back in again instead of using the create...select
command.
Rich
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, November 13, 2001 10:13 AM
Hi there. Can anyone offer a solution to this problem.
CREATE TABLE `raw` (
`cid` int(11) default NULL,
`agent` char(255) default NULL,
`referer` char(255) default NULL,
`addr` char(15) default NULL,
`via` char(255) default NULL,
`forward` char(15) default NULL,
`ctime` datetime
Hi,
I have a database with 14 million rows which contains 3 indexes. I am
trying to drop two of these indexes and create another one. However each
operation takes about 12 hours. Is there anyway I can make this a lot faster
by changing runtime variables and similar things.
Thanks in
are always based
around the sum total of the rows. Can someone more experienced with index's
please suggest to me the best way to go.
Is there any other way I can bring the select times down. Less than one
minute would be beautiful.
Richard Clarke // icespirit // [EMAIL PROTECTED
65 matches
Mail list logo