Richard,
TRUNCATE is still processed internally as DELETE FROM ... in 4.1.1. It is in
the TODO to make use of DROP + recreate of the table. A workaround: use DROP
+ CREATE for fast execution.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
hi,
I'm running a mysql-server (4.0.18) on windows XP. Connected to this server were max.
100 clients ( Also XP).
After a while ( maybe 8 hours ) I get error messages on the client and also in the
server log:
Error5: out of memory (needed bytes )
Does anyone has an idea what could
In the documentation there is a note that 4.1.2 will be released soon. I
need some features which are available only in this version... Any
estimated date when it will be ? Sorry for asking about the same thing...
ML
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Hi,
I want to set up 3 independent MySQL databases. What I mean by independent
is that...
I've got a program which requires the MySQL backend which I am currently
debugging and applying various tweaks.
I've also got 2 projects which requires a different architecture(in
MySQL).
These
Hello people,
I'm having a strange behavior when rebuilding and querying a 58million
row table. Probably because I'm new to mysql. I'm using it through java
btw.
My table has three columns: 2 mediumint and 1 smallint. The first two
columns are the primary key.
My first test was to write
Hello, I am running MySQL5.0.0 on my OpenBSD system. When I excute this
query I get 153 hits.
SELECT b.batch_id, b.date, b.creator, b.comments FROM cd_batch as b;
But when I add this table to the where clause i get 5831 hits
SELECT b.batch_id, b.date, b.creator, b.comments FROM cd_batch
Hello, I am running MySQL5.0.0 on my OpenBSD system. When I excute this
query I get 153 hits.
SELECT b.batch_id, b.date, b.creator, b.comments FROM cd_batch as b;
But when I add this table to the where clause i get 5831 hits
SELECT b.batch_id, b.date, b.creator, b.comments FROM
Jonas Lind?n [EMAIL PROTECTED] wrote:
Hello, I am running MySQL5.0.0 on my OpenBSD system. When I excute this
query I get 153 hits.
SELECT b.batch_id, b.date, b.creator, b.comments FROM cd_batch as b;
But when I add this table to the where clause i get 5831 hits
SELECT b.batch_id,
Hmmm... So are you saying that GROUP BY operations use the CPU cache to a larger
extent than other operations? (Is this documented somewhere?)
Don't forget that the other 80-odd operations listed in the benchmark are actually
faster on the new machine. It's odd that only these GROUP BY type
Hello Jonas,
Looking to the second query I think you're having a cartesian product. For each row
in one table you get all the rows from the other table. (And that's usually not the
intended result.) This is because there is no join between the tables.
I think that adding a where clause to your
Thank you everyone that responded, You were all correct. The query performed
a cartesian product. I added a where statement and all was fine again.
Thanks!
/Jonas
- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, May 24, 2004 12:16 PM
Hello,
I've just installed 4.1.1 to see how UTF-8 is working. In my.ini I have
set default-character-set=utf8 - so all input/output data should be send
in utf-8 charset. System variables (after start) are set as they should:
character_set_serverutf8
character_set_system
Hello, I tried dumping my innodb tables that contain blobs. No errors are returned
from mysqldump but I cannot restore the blob data. I have used the below mysqldump
statement.
mysqldump --opt --add-drop-table --force --single-transaction -uxxx -pxxx
--databases myDB bakupFile
I restore
Hello list,
im having a hughe problem with the RAND() function
first of all im using mysql 3.23 so subquerys are impossible.
table1
---
| id | content |
| 1 | apple |
---
relation_table
| id | id_table1 | id_table2 |
| 1 | 1
Hi,
I have this entry in my logfile:
040524 12:30:06 Got fatal error 1236: 'log event entry exceeded
max_allowed_packet; Increase max_allowed_packet on master' from master wh
en reading data from binary log
040524 12:30:06 Slave I/O thread exiting, read up to log 'db-bin.3320',
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Marek Lewczuk wrote:
| In the documentation there is a note that 4.1.2 will be released soon. I
| need some features which are available only in this version... Any
| estimated date when it will be ? Sorry for asking about the same thing...
|
| ML
|
|
Hi,
I've been using mysqldump to backup my entire database. Every day, I restore the whole
thing to my test/develop database by piping the large sql generated by mysqldump. All
is well until the file size of the sql file reached about 4Gbytes. I wonder if there
is a size limit to the database
This is not a newsgroup.
It is a mail list.
Robb Kerr wrote:
I only sporadically use newsgroups and choose to use the program 40tude
when I do. I greatly appreciate this group and wish to remain subscribed
but am receiving ALL of the posts as emails. How do I change my preferences
on this board
On Tue, May 18, 2004 at 10:08:32AM -0400, Ronnie Regev wrote:
Hi,
Before I go on, I know nothing about mysql, but my db admin is out of town
and I need to be pointed in the right direction please.
Running red hat 7.3, mysql-3.23.58-1.73, phpMyAdmin 2.5.0-rc2, in a virtual
hosting environment
On Mon, May 24, 2004 at 03:07:17PM +0100, Gilbert Wu wrote:
Hi,
I've been using mysqldump to backup my entire database. Every day, I restore the
whole thing to my test/develop database by piping the large sql generated by
mysqldump. All is well until the file size of the sql file reached
Hi,
I've tried mysql cluster recently and noticed strange thing, when I tried to
put the contents of service 'mysql' database into NDB cluster.
Some tables could not be put into cluster without modification since BLOB is
not yet handled, so I changed all blob and text to char(255) and
Sorry, I am running MySQL 4.0.17-nt on Windows 2000 Server.
-Original Message-
From: Brian Reichert [mailto:[EMAIL PROTECTED]
Sent: 24 May 2004 15:42
To: Gilbert Wu
Cc: [EMAIL PROTECTED]
Subject: Re: mysqldump problem
On Mon, May 24, 2004 at 03:07:17PM +0100, Gilbert Wu wrote:
Hi,
Hi!
I wonder if I can somehow preserve the table rows in a memory table when I restart the
MySQL server?
I've read the documentation about memory tables, and it states that I can populate the
table at startup, but it doesn't say if I can store the table rows at shutdown in a
file. Maybe I can
Massimo Petrini [EMAIL PROTECTED] wrote:
When it will be avalaible to download ?
It will be available in a few days.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/
How would the table survive a reset/reboot ?
If you need it to be persistant, use a regular table and lots of system
ram for cache.
m0llbuz_ wrote:
Hi!
I wonder if I can somehow preserve the table rows in a memory table when I restart the
MySQL server?
I've read the documentation about memory
Hi All,
The dump file is a 4Gytes text file. Could find an editor able to look at the content
of the file. Hence, I had to write a little Perl program (something I haven't done for
5 years). I discovered the line that caused a syntax error whenever I tried to restore
from the dump file.
It
I'm having a problem similar to the one mentioned in the list message
http://lists.mysql.com/mysql/165952
* I built, installed, and run MySQL 4.0.18
o gcc 2.95.3 on Solaris 9
* I created a user abcd and used MyPHPAdmin to give this user a password
xxyyzzaa
* I can login using
Trying to install MySQL 4.1.1 Max binary using MySQL-Max-4.1.1-0.i386.rpm onto Linux
Fedora version. When I do, I get the following failed dependencies:
libcrypto.so.0.9.6 is needed by MySQL-Max-4.1.1-0
libssl.so.0.9.6 is needed by MySQL-Max-4.1.1-0
libstdc++-libc6.2-2.so.3 is needed by
Lou Olsten wrote:
I haven't figured out where to get the libstdc++
That's part of gcc usually found in /usr/local/lib or in the lib dir under the gcc
installation dir.
--
Jack J. Woehr# [F]ar in the empty sky a solitary esophagus slept
http://www.well.com/~jax # upon motionless
Hi,
I have a table which I want to select data from (obiviously). In
this table, I have a field which is an integer, and defaults to 0. What
I would like to do is count all rows in that table which not only equals
0 for the field, but has a distinct value which is greater than 0.
id
Hello:
I am trying to setup a client mysql server to connect to a Master MySQL
server by MUST using a PASSWORD!!
CURRENT SYSTEM:
Master MySQL Server:
-
Name: datam
IP: 192.168.10.21
O/S:RH9
MySQL:4.0.18 (Source)
Client MySQL Server:
-
Name: datac
http://dev.mysql.com/doc/mysql/en/Adding_users.html
mysql GRANT ALL PRIVILEGES ON db.*
- TO mysql@'192.168.10.0/255.255.255.0'
- IDENTIFIED BY 'mysql123';
--
Ritter
Kirti S. Bajwa wrote:
Hello:
I am trying to setup a client mysql server to connect to a Master MySQL
server by MUST using a
Ritter:
What is the effect of enter the following in /etc/my.cnf:
[client]
password = mysql123
Kirt
-Original Message-
From: Jason K Larson [mailto:[EMAIL PROTECTED]
Sent: Monday, May 24, 2004 2:48 PM
To: Kirti S. Bajwa
Cc: [EMAIL PROTECTED]
Subject: Re: Restrict connection to MySQL
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 24 May 2004 02:01 pm, Kirti S. Bajwa wrote:
[client]
password
Is there some reason you cant look in the manual for this?
http://teaching.cs.uml.edu/MySQLdocs/MySQL_Manual/Connecting.html
-BEGIN PGP SIGNATURE-
Version: GnuPG
At 12:36 PM 5/24/2004, you wrote:
Hi,
I have a table which I want to select data from (obiviously). In this
table, I have a field which is an integer, and defaults to 0. What I
would like to do is count all rows in that table which not only equals 0
for the field, but has a distinct value
Can someone show me how a configuration file (my.cnf) would look to
have dual MySQL masters. I know it can be done, as I have read about
others using it. I simply can't figure out how to configure it myself.
There is nothing on the MySQL site about having a server be a master
and a slave to
Hi,
My team and I have developed a nifty little app, which somewhat
unfortunately, requires some time to process the data (15 million rows x
5 million rows x 3 million x 157 rows) when joining the queries.
We have worked very hard and dedicated trying to optimize the queries as
good as we can
Jack Woehr wrote:
I'm having a problem similar to the one mentioned in the list message
http://lists.mysql.com/mysql/165952
* I built, installed, and run MySQL 4.0.18
o gcc 2.95.3 on Solaris 9
* I created a user abcd and used MyPHPAdmin to give this user a password
xxyyzzaa
* I
For each master you will have in your dual master setup you will need to
modify the my.cnf file accordingly.
master-host=ip-address-other-master
master-user=replication-user
master-password=replication-password
master-port=listening-port
server-id=unique-server-id
log-slave-updates
log-bin
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 24 May 2004 02:28 pm, Free Grafton - CCB wrote:
Can someone show me how a configuration file (my.cnf) would look to
have dual MySQL masters. I know it can be done, as I have read about
others using it. I simply can't figure out how to
Hi
Your cnf file just needs to have log-bin and unique server-id's. Then use the CHANGE
MASTER TO commands on each. So each will be a slave to the other.
That's a brief summary.
Good luck.
Gabe
-Original Message-
From: Free Grafton - CCB [mailto:[EMAIL PROTECTED]
Sent: Monday, May
Rich Allen wrote:
iH
this should work
test select * from xt;
++---+
| id | field |
++---+
| 1 | 0 |
| 2 | 0 |
| 3 | 7 |
| 4 | 8 |
| 5 | 7 |
| 6 | 0 |
| 7 | 6 |
| 8 | 7 |
| 9 | 8 |
++---+
9 rows in set (0.00 sec)
test select
Jack Woehr [EMAIL PROTECTED] wrote:
I'm having a problem similar to the one mentioned in the list message
http://lists.mysql.com/mysql/165952
* I built, installed, and run MySQL 4.0.18
o gcc 2.95.3 on Solaris 9
* I created a user abcd and used MyPHPAdmin to give this user a
You can do:
Select count(distinct(field)) from table where field 0
Laercio.
-Original Message-
From: John Nichel [mailto:[EMAIL PROTECTED]
Sent: segunda-feira, 24 de maio de 2004 14:37
To: MySQL List
Subject: Query question
Hi,
I have a table which I want to select data from
-Original Message-
From: Free Grafton - CCB [mailto:[EMAIL PROTECTED]
Sent: Monday, May 24, 2004 11:29 AM
To: [EMAIL PROTECTED]
Subject: Dual Master Configuration
Can someone show me how a configuration file (my.cnf) would look to
have dual MySQL masters.
Its more then just
On Mon, 2004-05-24 at 11:32, John Nichel wrote:
Rich Allen wrote:
iH
this should work
test select * from xt;
++---+
| id | field |
++---+
| 1 | 0 |
| 2 | 0 |
| 3 | 7 |
| 4 | 8 |
| 5 | 7 |
| 6 | 0 |
| 7 | 6 |
| 8
I figured this out. It's the ANY setup in Privileges. Being set to allow ANY user to
login without password, MySQL interestingly interprets
that as even known users with passwords MUST log in without passwords. My two
solutions were either to delete the ANY privileges or
to create a second
Garth, good catch!
- hcir
mysql
- hcir
On May 24, 2004, at 1:05 PM, Garth Webb wrote:
On Mon, 2004-05-24 at 11:32, John Nichel wrote:
Rich Allen wrote:
iH
this should work
test select * from xt;
++---+
| id | field |
++---+
| 1 | 0 |
| 2 | 0 |
| 3 | 7 |
| 4 | 8
iH
this should work
test select * from xt;
++---+
| id | field |
++---+
| 1 | 0 |
| 2 | 0 |
| 3 | 7 |
| 4 | 8 |
| 5 | 7 |
| 6 | 0 |
| 7 | 6 |
| 8 | 7 |
| 9 | 8 |
++---+
9 rows in set (0.00 sec)
test select count(distinct(field))
Hi,
My team and I have developed a nifty little app, which somewhat
unfortunately, requires some time to process the data (15 million rows x
5 million rows x 3 million x 157 rows) when joining the queries.
We have worked very hard and dedicated trying to optimize the queries as
good as we can
Greetings,
This could be something basic that I missed, or discussed before.
Is there a way to look somewhere for logs that give a clue of how many
simultaneous connections, and which user did connect at what time and
other error logs, if any?
I see hostname.err
That has something like this.
I created the dump file from my current DB to make adjustments and also migrate to
Innodb tables. In the process I have tried to add some ENUM types in select table.
Obviously, I am doing something wrong as each one give me a syntax error 1064 when I
try to source in the text file. I've read
John
Try
select field, count(*)
from db.table
group by field;
David
-Original Message-
From: John Nichel [mailto:[EMAIL PROTECTED]
Sent: Monday, May 24, 2004 10:37 AM
To: MySQL List
Subject: Query question
Hi,
I have a table which I want to select data from
These are two simple stock quotes tables that contain a symbol and a close
amount.
Explain
Select Monday.Symbol, Friday.Close, Monday.Close
From Monday Force Index(Symbol) Inner Join Friday Force Index(Symbol) ON
Monday.Symbol = Friday.Symbol
Symbol is a VarChar(20) in both
We're going through an upgrade to Novell 6.5 and would like to use mysql on
a single server to store info on who's upgraded the client and who has not.
Can the command line client only be installed on the Novell server to
connect to a foriegn mysql host? Its easy when its unix-unix, but don't
Guys - I think this fusing of GROUP BY and ORDER BY is a bad thing - even if it works.
GROUP should group and if you want an order - add an ORDER clause explicitly. Yes, the
GROUP BY does a sort and you are tempted to leverege it but it could lead to problems.
It may not be visible in
Struggling with a query structure new to me...
Most of my apps are not very complex at all (simple joins, few
functions), but I've worked through a few tricky queries. However,
this one is stumping me on how to even begin. I can't even decide what
kind of query it is. As you can I wasn't even
Hi,
What is the cause of the error below?
040520 14:55:21 mysqld started
040520 14:55:21 Warning: Asked for 196608 thread stack, but got 126976
The server shutdown by itself, both RPM build and compiled from source
doesn't run. The system is running in Fedora Core 2 in my laptop.
Hi,
What is the cause of the error below?
040520 14:55:21 mysqld started
040520 14:55:21 Warning: Asked for 196608 thread stack, but got 126976
The server shutdown by itself, both RPM build and compiled from source
doesn't run. The system is running in Fedora Core 2 in my laptop.
One of the tricky things about finding errors is that the error is often
earlier than you expect. Mysql points out where it stopped understanding
you, but often it's due to something on the line before. That's the case
here. There's nothing wrong with your ENUM, but the previous line says
Hi there, this is a bit of black art, but I would like to setup locks on
inserting back queries and updates on MyIsam tables which need fulltext
search and other tables are Innodb. I am having issues with this query
LOCK TABLE complaint_threads as ct WRITE, complaint_info as ci WRITE;
For some
Jack Woehr wrote:
I figured this out. It's the ANY setup in Privileges. Being set to
allow ANY user to login without password, MySQL interestingly interprets
that as even known users with passwords MUST log in without passwords.
Well, that seems to be the effect, but that's not what it is doing.
Hi,
I am evaluating the utf8 support of MySQL V4.0.18. I followed the
documentation to create a database as the following:
CREATE DATABASE trdb CHARACTER SET utf8;
Strangely, I got syntax error(s). It seems that the reserved words
CHARACTER SET are not recognized.
Can anyone
All:
What are the consequences of renaming a column in a child table that is
the FK to the parent? Will innodb remap or do I need to destroy the
relationship, index and column and recreate?
I am using 4.0.13
Thanks for your time!
Boyd E. Hemphill
--
MySQL General Mailing List
For list
At 06:30 PM 5/24/2004, [EMAIL PROTECTED] wrote:
Guys - I think this fusing of GROUP BY and ORDER BY is a bad thing - even
if it works. GROUP should group and if you want an order - add an ORDER
clause explicitly. Yes, the GROUP BY does a sort and you are tempted to
leverege it but it could lead
michael_wu[] wrote:
I am evaluating the utf8 support of MySQL V4.0.18. I followed the
documentation to create a database as the following:
CREATE DATABASE trdb CHARACTER SET utf8;
Strangely, I got syntax error(s). It seems that the reserved words
CHARACTER SET are not
66 matches
Mail list logo