Hi all
with Mysql 3.23 I would like to find missing values in the following situation:
1) table boxes: describes kind of boxes differing by how many items I can put
in.
Primary key is BoxID
boxID + Places
A + 1
B + 3
C + 5
2) table car describes how I can put some boxes on a
It appears that mysqld won't start if the setting for key_buffer
is more than 2GB.
Maybe you've also hit the quirks of memory management and malloc, just as
we've posted a while ago in http://lists.mysql.com/mysql/186930 ?
It seems to have been a simple issue of not unlimiting the datasize
Hello
I was re-reading last mails, analized it carefull again and...
> > while ( my1.fetch ) {
> > my2.query + my2.store
> > if ( my2.fetch ) {
> > report = my1 + my2 results
> > } else {
> > report = my1
> > }
> > my2.FreeResult <--- free for every my2.query inside loo
Hi All,
I have seen a couple of posting in this regard but didn't get the answer
by reading those; so I appreciate your answers.
Everything was fine about a week ago, untill we realized that our
website has got ver slow.
after spending some time I realized that it has nothing to do with
>
> Maybe you've also hit the quirks of memory management and malloc, just as
> we've posted a while ago in http://lists.mysql.com/mysql/186930 ?
An interesting thread, but I'm on NetBSD, not Linux. But it's some place
to start looking around, I guess.
--
MySQL General Mailing List
For list arc
- Original Message -
From: "Chris Kantarjiev" <[EMAIL PROTECTED]>
To:
Sent: Monday, September 19, 2005 9:06 PM
Subject: very large key_buffer on amd64?
> We're starting to use mysql (4.0.25) on an amd64 machine (running
> NetBSD-3). One of the reasons for doing this is to use much more
Hmm - and further to this. Strange differences of behaiour between the
last two production versions of MySQL
sh-2.05b# ln -s mysql-standard-4.0.24-apple-darwin7.7.0-powerpc mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.
This is really cool! Can something be done with this to use a
materialized view log on a table in Oracle and sync with a table in
mysql?
-Original Message-
From: Mark Leith [mailto:[EMAIL PROTECTED]
Sent: Friday, September 16, 2005 9:54 AM
To: mysql@lists.mysql.com
Subject: RE: databas
We're starting to use mysql (4.0.25) on an amd64 machine (running
NetBSD-3). One of the reasons for doing this is to use much more
RAM - we tend to thrash the key_buffer on i386 because one of our
indexes is 10GB in size (the table is 15GB).
It appears that mysqld won't start if the setting for ke
Schalk Neethling wrote:
> Greetings
>
> What might be causing the 1064 error in the following query?
>
> SELECT mem_number, first_name, last_name, area_represented,
> joining_points + E-Model Challenge + SA Pro Model + Star Model Challenge
> + Eastern Cape Classic + SA Model Super Star + KZN Mode
Hello Jake,
> I would like to use separate databases to group certain related tables
> to keep things clean, but I would also like to use foreign keys to
> enforce referential integrity between tables in different databases. I
> don't think this is possible. Am I right? And if so, am I reduced to
Still getting the following errors after running the chown's below...
Here is what the ls -l result window shows...
mysql]# ls -l /usr/local/mysql/data
total 20536
-rw-rw1 mysqlmysql10485760 Sep 19
10:05 ibdata1
-rw-rw1 mysqlmysql 5242880 Sep 19
10:05 ib_logfile0
-
On Mon, 2005-09-19 at 13:14 -0400, George Herson wrote:
> James G. Sack (jim) wrote:
>
> >On Mon, 2005-09-19 at 12:15 -0400, George Herson wrote:
> >
> >
> >>Dear Jim,
> >>
> >>Re: your post at http://lists.mysql.com/mysql/189058, why bother
> >>creating the mysqldump if you already have the sn
James G. Sack (jim) wrote:
On Mon, 2005-09-19 at 12:15 -0400, George Herson wrote:
Dear Jim,
Re: your post at http://lists.mysql.com/mysql/189058, why bother
creating the mysqldump if you already have the snapshot? Why not just
backup the snapshot?
[...]
The output of mysqldump *i
On Mon, 2005-09-19 at 12:15 -0400, George Herson wrote:
> Dear Jim,
>
> Re: your post at http://lists.mysql.com/mysql/189058, why bother
> creating the mysqldump if you already have the snapshot? Why not just
> backup the snapshot?
>
> (I'd have hit reply online but didn't see a Reply button a
Thanks; you're absolutely right - doh! It's just amazing that this ever
worked in MySQL 4.0 and below...
Andrew
-Original Message-
From: Roger Baklund [mailto:[EMAIL PROTECTED]
Sent: Mon, 19 Sep 2005 12:27
To: mysql@lists.mysql.com
Cc: Andrew Braithwaite
Subject: Re: possible MySQL bug
Miguel Cardenas <[EMAIL PROTECTED]> wrote on 09/19/2005 12:13:47 PM:
> Hello
>
> > Have you try :
> > select count(*) from mytable where id=x and list=something
> > if count ==0, it's like fetchrow==NULL from your solution, but without
> > all the fuss about use_result();
>
> No, but looks fine,
Harrison Fisk wrote:
Hi Ken,
On Sep 18, 2005, at 3:53 PM, Ken Gieselman wrote:
Scott Gifford wrote:
Ken Gieselman <[EMAIL PROTECTED]> writes:
[...]
So, here's my question: How can I find out how many rows are being
returned by a query, without using mysql_stmt_store_result() to
buffer all
Hello
> Have you try :
> select count(*) from mytable where id=x and list=something
> if count ==0, it's like fetchrow==NULL from your solution, but without
> all the fuss about use_result();
No, but looks fine, I didn't know this usage of count(*) combined with
conditions, but now will use it :
I'm using activestate perl on WinXP but I'm sure this applies to all
languages on all platforms. I cannot remember the JDBC terms presently.
There have been lots of discussion on the performance virtues of using the
prepare function instead of the do function.
Is it necessary to save the stateme
Well, as you can see in the first few lines, you have a Permission Denied
problem.
This means that your /data/ folder doesn't have the write permissions to it
via the mysql user.
Try running the permission scripts again, but this time use the full shell
names.
shell> chown -R root /usr/local/
Hi Ken,
On Sep 18, 2005, at 3:53 PM, Ken Gieselman wrote:
Scott Gifford wrote:
Ken Gieselman <[EMAIL PROTECTED]> writes:
[...]
So, here's my question: How can I find out how many rows are being
returned by a query, without using mysql_stmt_store_result() to
buffer all the rows back to the cli
NOW I see the violence inhierent in the system...
this has some profoundly cool possibilities...
BWAH-HA-HA-HA!!!
muchos!
I would like to use separate databases to group certain related tables
to keep things clean, but I would also like to use foreign keys to
enforce referential integrity between tables in different databases. I
don't think this is possible. Am I right? And if so, am I reduced to
using carefully c
Thanks Martijn - that is a clear explanation of the philosophy. I did not get it
from the examples and the manual.
Doug
On Mon, 19 Sep 2005, Martijn Tonies wrote:
> Hello Doug,
>
>
> > My question question from MySQL 4.0.22: is it okay that a null interger
> > tests as
> > equal to any value. I
Hobbs, Richard wrote:
> Hello,
>
> I have two tables - one containing messages, and another containing links
> between messages and other messages in a tree structure (much like a
> threaded mailing list archiving thing). A single message can have
> multiple "parents" though, meaning the links tab
Johnson, Richard (NY Int) wrote:
Hi there
Total Newbie here.Any idea why I am getting these error messages
[EMAIL PROTECTED] mysql]# Starting mysqld daemon with databases from
/usr/local/mysql/data
STOPPING server from pid file /usr/local/mysql/data/
RJLINUX.rj.johnson.net.pid
Check your <>.err logs located in the /data/ directory. This will
tell you why you can't start the server.
J.R.
-Original Message-
From: Johnson, Richard (NY Int) [mailto:[EMAIL PROTECTED]
Sent: Monday, September 19, 2005 10:38 AM
To: 'mysql@lists.mysql.com'
Subject: Startup Error
Hi th
Hi there
Total Newbie here.Any idea why I am getting these error messages
[EMAIL PROTECTED] mysql]# Starting mysqld daemon with databases from
/usr/local/mysql/data
STOPPING server from pid file /usr/local/mysql/data/
RJLINUX.rj.johnson.net.pid
050919
I know I sent this once Was my advice useful or not?
>>translated by http://babelfish.altavista.com/tr <<
Sé que envié esto una vez ¿Era mi consejo útil o no?
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
- Forwarded by Shawn Green/Unimin on 09/19/2005 10:20 AM
How can I test the performans benchmark of my MYSQL?
For instance how can I learn query per second information? And any other
informatioin?
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Fri, 9 Sep 2005, Michael Stassen wrote:
With mysql 4.1.12, `make -n test` reveals
cd mysql-test; ./mysql-test-run && ./mysql-test-run --ps-protocol
For the record, here's what I got on Solaris 9 for 4.1.13
neelix hgs 18 %> cd mysql-test && ./mysql-test-run --force
Installing Test Databas
Sid Lane <[EMAIL PROTECTED]> wrote on 19/09/2005 15:02:58:
> stupid ?:
>
> what keeps them from getting caught in a write loop? turning off
> log_slave_updates?
>
> I had never thought of this but is has intriging possibilities...
Each update is marked with the unique server id of the server w
Hello,
I have a MySQL database. Now I would like to create reports with Crystal
Reports XI. When I try to connect Crystal Reports to MySQL through ODBC
Connector 3.51.1 this error happens:
Details: ADO error Code 0x8000fff
Source: Provide
Description: Fatal Error
Native Error: -2147418113
Can
stupid ?:
what keeps them from getting caught in a write loop? turning off
log_slave_updates?
I had never thought of this but is has intriging possibilities...
Hi All,
I have a linux box with 2 ethenet interfaces let's say one public
10.10.10.10 and one private 192.168.1.1. How can I configure my.cfg to
listen on 192.168.1.1 and 127.0.0.1 but not 10.10.10.10?
Thanks in advance.
Andrea Sodomaco
--
MySQL General Mailing List
For list archives: http:
Andrew Braithwaite wrote:
Hi All,
I have a strange error when trying to insert into a table with 2
'double' fields. It inserts into the 1st field OK but fills the 2nd one
with nines. See below for a complete recreate.
[...]
| lon | double(7,6) | YES | MUL | NULL|
Hello Andrew,
> I have a strange error when trying to insert into a table with 2
> 'double' fields. It inserts into the 1st field OK but fills the 2nd one
> with nines. See below for a complete recreate.
>
> Is this a known problem? Does anyone have a solution?
>
> I'm running standard MySQL bi
Hi All,
I have a strange error when trying to insert into a table with 2
'double' fields. It inserts into the 1st field OK but fills the 2nd one
with nines. See below for a complete recreate.
Is this a known problem? Does anyone have a solution?
I'm running standard MySQL binaries on redhat l
Hello,
Perfect :-)
Thank you,
Hobbs.
Quoting Peter Brawley <[EMAIL PROTECTED]>:
Richard
>I would like to display all messages which match both 5 and 7 in terms
>of the parent_id, meaning messages 10 and 13 would be displayed.
SELECT f1.child
FROM foo AS f1
INNER JOIN foo AS f2 USING(child)
Running the command:
Drop table if exists table1
complaints of table1 does not exist (Error: 1051).
However, if table1 is swapped with another table, irrespective of its
existence it works just fine.
Running a Show Table command lists table1 as an existing table and
trying to create table1 complai
Hi,
always reply to the list please
2005/9/19, Miguel Cardenas <[EMAIL PROTECTED]>:
> > I'm a bit confused. If you just need to know if there is data matching
> > a criteria, a count(*) is enough and will do absolutely the same thing
> > that you want, and spare you the mysql_store_result with a
Hi Mark,
Thanks for the email. Yes i also read about this.
But the problem with this approach is since our oracle db is a production
database which runs 24*78 and during night time it runs lot of other jobs i
cannot make the reporting job run from this oracle database.
regards
anandkl
On 9/16
Hello Doug,
> My question question from MySQL 4.0.22: is it okay that a null interger
tests as
> equal to any value. I am not sure the table structure matters but in case
it is
> I included it.
>
> I did not expect that null was not not-equal to 1. Cursory testing seems
to
> indicate that a null
Hi Mark,
Thanks for the email. Yes i also read about this.
But the problem with this approach is since our oracle db is a production
database which runs 24*78 and during night time it runs lot of other jobs i
cannot make the reporting job run from this oracle database.
regards
anandkl
On 9/16
Thanks Roger, I wondered whether it was the spaces that caused the problem.
Roger Baklund wrote:
Schalk Neethling wrote:
Greetings
What might be causing the 1064 error in the following query?
SELECT mem_number, first_name, last_name, area_represented,
joining_points + E-Model Challenge + SA
46 matches
Mail list logo
