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 throu
AIL 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 us
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 PROTEC
es and disable 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:
>
&g
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
-
ot;gerald_clark" <[EMAIL 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 L
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 t
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
- Origina
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 in
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 owne
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 PROTECTE
set (0.00 sec)
Richard.
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
To: "Richard Clarke" <[EMAIL PROTECTED]>
Cc: "Victoria Reznichenko" <[EMAIL PROTECTED]>; "MySQL"
<[EMAIL PROTECTED]>
Sent: Tuesday, December 24,
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 end
.
> 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
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: "P
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 M
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 other
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 ti
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 Stor
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:
http://www.mysql.com/manu
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/
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
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'
m
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 i
>
> > INSERT INTO my_table VALUES (foo, foo), (bar, bar), (z, z)...
>
>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 isn
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,
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]>
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;
++---++-
--+
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 n
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 ho
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 produ
gt;
> > Heikki
> >
> > > Best regards,
> > >
> > > Heikki Tuuri
> > > Innobase Oy
> > > ---
> > > Order technical MySQL/InnoDB support at https://order.mysql.com/
> > > See http://www.innodb.com for the online manual an
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 PROTECT
"Heikki Tuuri" <[EMAIL PROTECTED]>
To: "Richard Clarke" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, May 19, 2002 1:01 PM
Subject: Re: 4.0.1 Bugs
> Richard,
>
> the assertion failure below is very probably caused by the SHOW CREATE
TAB
Pierre,
I'm not so sure what you are asking here but from this statement,
More importantly are there functions in mySQL I can call to convert a
standard date, ie "mmdd" to the expected mySQL value?.
I can tell you that mysql is quite happy to accept mmdd formatted dates
without any
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
give tables and queries here since they form a large set of
statistical analysis queries. Only information I can helpfully give is that
the same set 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.
- Ori
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
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:
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 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:
>
> R
David,
I could be wrong but since bigint isn't a date or time oriented data
type I imagine this would be completely useless to you unless you are
storing unix timestamps. You also have the option of using datetime data
types. I'm not quite sure what you are asking nor what difference it makes
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 tab
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
Hi,
---
In MySQL Version 3.23, in-memory temporary tables will automatically be
converted to a disk-based MyISAM table after the table size gets bigger than
tmp_table_size.
---
It also says this though. I'm using mysql 4. Is the above not true for mysql
4?
Ric
- Original Message -
From:
Hi,
create table test select * from summary_rts union select * from
summary_rts_old;
ERROR 1114: The table '#sqld70c_b4_0' is full
Can someone please help me figure out what is wrong with this. It was
working fine up until a few hours ago. The only reason I really choose to
use Mysql 4.0 was
age -
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,
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 P
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: e
t; <[EMAIL PROTECTED]>
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 t
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 column
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 ev
l_size=100M
set-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 PROTECT
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
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Richard Clarke" <[EMAIL PROTECTED]>
Sent: Thursday, January 31, 2002 7:11 AM
Subject: Re: database/table performance
> Your message cannot be posted because it appears to be either spam or
> simply off to
Yeh I forgot to originally state that I was using freebsd. You were correct,
freebsd is compiled by default to not allow processes bigger than roughly
500megs. I recompiled the kernel, changing the limit to 1.5 gigs and now it
runs fine using all my memory.
For anyone else who needs the howto for
I have a system with 1gig of ram and i am trying to get the innodb buffer to
be about 750megs. Whenever I set the value in the database config file it
won't start with an error along the lines of,
011207 21:02:42 mysqld started
InnoDB: Fatal error: cannot allocate 67108864 bytes of
InnoDB: memor
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 211
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 d
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,
`forw
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 |
I thought truncates were supposed to be really fast. I don't really notice
any difference in speed between a truncate query and a delete query. What is
actually involved in a truncate. The docs says its faster because a drop and
recreate occurs but how is this actually faster.
Ric
-
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
d
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 re
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 th
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:1
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 def
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 advance,
an 30%. Or is that
then gonna seriously affect other queries which go over the 30%. Should I
just always add a limit 1 statement since our queries 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
73 matches
Mail list logo
