The script to prove it follows.
Splitting a million-row fact table into a 5-part merge table makes
3-second queries take 9 seconds.
The basic problem is this: fact tables are generally referenced by
unique combinations of dimensions, and though often only one
underlying table needs to be referen
> Now that I know what's causing the slow queries, what can I do to fix it?
The only thing I can suggest is breaking up the query into two parts -
the first part to retrieve just the product codes and salesrank, and
sort and limit that.. save in a temp table or use application code to
retrieve and
"Jesse" <[EMAIL PROTECTED]> wrote on 12/22/2005 05:09:12 PM:
> I'm experimenting with Foreign Keys to maintain referential integrity. I
> have just added a Foreign Key to one of my tables, but now when I
attempt to
> add a new record, I get this error:
>
> #23000Cannot add or update a child r
I'm experimenting with Foreign Keys to maintain referential integrity. I
have just added a Foreign Key to one of my tables, but now when I attempt to
add a new record, I get this error:
#23000Cannot add or update a child row: a foreign key constraint fails
(`fccamp/families`, CONSTRAINT `FK_C
Hello.
In my opinion, if it works in general with 5.0. MySQL tries to keep
backward compatibility for its products as much as possible. So it
should work, however, not all features of 5.0 could be available. MyODBC
3.51.12 is suitable for use with any MySQL version including MySQL 4.1
or 5.0
Hello.
I was unable to reproduce this behavior on official binaries
of 4.1.16 and 5.0.17 versions. I'm not sure about possible reasons
for you of such a delay. Check if the problem still exists on binaries
of the latest releases from mysql.com. Play with different versions of
glibc. Find out
Privet!
MySQL 4.1 and 5.0 should work fine with koi8-r and may other character
sets. Please, read :
http://dev.mysql.com/doc/refman/5.0/en/charset.html
in case you haven't done this yet. And if you don't solve you problems,
send to the list output of the following statements:
show var
Hello.
Are you sure that configure is saying that it is unable
to find 'termcap data base'? I haven't seen this message
inside the configure script. May be it is looking for termcap
library? In this case, you should install some termcap development
package for Debian (I not a Debian user, so
Hello.
Check that you're using the latest version of MySQL Administrator. This
is a bug with similar error message, though it is related to Query
Browser it might be helpful:
http://bugs.mysql.com/bug.php?id=4423
Jesse wrote:
> I am trying to schedule automatic MySQL Backups. I hav
One other restriction that I found was that both columns must be of the same
type. That was my problem. I had one column set to INTEGER and the other set
to INT(10). I set the INT(10) to INTEGER, and it worked fine.
Thanks,
Jesse
- Original Message -
From: [EMAIL PROTECTED]
To
"Jesse" <[EMAIL PROTECTED]> wrote on 12/22/2005 02:51:21 PM:
> I am trying to add referential integrity to my database. I'm trying to
add
> a foreign key reference to one of my tables, but I'm getting an error
when I
> try to do so. Here's what I'm executing:
>
> ALTER TABLE Campers ADD CON
I am trying to add referential integrity to my database. I'm trying to add
a foreign key reference to one of my tables, but I'm getting an error when I
try to do so. Here's what I'm executing:
ALTER TABLE Campers ADD CONSTRAINT FK_Activities FOREIGN KEY FK_Activities
(ID)
REFERENCES Activit
You will experience the same problem with old-client vs. new-server
authentication as you did when you first set up your user accounts for 4.1
but other than that , it should be compatible.
http://dev.mysql.com/doc/refman/5.0/en/old-client.html
Shawn Green
Database Administrator
Unimin Corporat
There is no such thing as Debian 2.8--see
http://www.us.debian.org/releases/.
> -Original Message-
> From: John Galatti [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 22, 2005 8:53 AM
> To: mysqlList
> Subject: INSTALLING MYSQL 5.0 ON LINUX DEBIAN 2.8
>
> All
> I am trying to buil
I am trying to schedule automatic MySQL Backups. I have used MySQL
Administrator to do so, but when it starts to execute, I get an error in the
Event Viewer in Windows:
Connection -bpBackupData cannot be found.
Here is what it placed in the Scheduled Tasks:
"C:\Program Files\MySQL\MySQL A
All
I am trying to build the mysql 5.0 from the source
When I run the configure scripts it error out saying it can not find termcap
data base also, can not find tegenent in any library
I am running under debian linux 2.8
Does any one have nay idea on what I should do
John
Here are the results of alias and type
[EMAIL PROTECTED]:~$ alias
alias ls='ls --color=auto'
[EMAIL PROTECTED]:~$ type mysql
mysql is /usr/bin/mysql
And for the emily account:
[EMAIL PROTECTED]:/home/mark$ alias
alias ls='ls --color=auto'
[EMAIL PROTECTED]:/home/mark$ type mysql
mysql is /usr/
Hello.
I have mysql-4.1.14 and 4.1.15 on PLD's.
When the Slave_IO_State is in 'Connecting to Master' state
because of the unreachable master host (timeouting)
the 'slave stop' or 'slave stop io_thread' tooks
minimum 2 minutes.
fe.:
mysql> stop slave io_thread;
Query OK, 0 rows affected (2 min 52
At 2:30 pm + 22/12/05, C.R.Vegelin wrote:
>Hi James,
>I saw your email about "are primary keys always essential ?".
>And that your app is essentially creating summary reports from large amounts
>of summary data.
>May I ask what reporting tool you use for summary data ?
My client sells (well,
Mark Phillips wrote:
David,
This is what I got:
[EMAIL PROTECTED]:~$ aliases
bash: aliases: command not found
Your shell is bash, so the correct command is `alias`.
[EMAIL PROTECTED]:~$ which mysql
/usr/bin/mysql
Since you are using bash, it's a better idea to use `type` instead of `which
Hi James,
I saw your email about "are primary keys always essential ?".
And that your app is essentially creating summary reports
from large amounts of summary data.
May I ask what reporting tool you use for summary data ?
TIA, Cor Vegelin
--
MySQL General Mailing List
For list archives: http
21 matches
Mail list logo
