Hello,
I have a situation where I'd like to do some debugging against a MySQL
database that's setup so I couldn't modify it (select only). I did some
google searching and searched mysql.com but didn't find much on readonly.
Is this possible?
I already know I can just backup/restore the
Hi Mark,
How about just giving the user(s) only the SELECT privilege temporarily?
Matt
- Original Message -
From: Mark Swanson
Sent: Monday, September 01, 2003 7:33 PM
Subject: [q] can I start MySQL in READONLY mode?
Hello,
I have a situation where I'd like to do some debugging
Hi
When you set up the mysql user use a GRANT statement that only gives SELECT
access. That is effectivly read only access for that user
Peter
-Original Message-
From: Mark Swanson [mailto:[EMAIL PROTECTED]
Sent: 02 September 2003 01:34
To: [EMAIL PROTECTED]
Subject: [q] can I start
I'm running a large database which is currently using MyISAM. There are
approximately 300 million rows in about a dozen tables totaling 7GB of
storage. The system is averaging 257 querries per second, probably
peaking at around 500-600+ during busy times. We're running a single
database
Could you send us your my.cnf / my.ini ? We might be able to help you
tune your InnoDB config for this setup.
In my experience, InnoDB performance should approach MyISAM in most
environments where the disk is the bottleneck (due to the fact, as said
in the InnoDB table type intro in the docs,
Paul,
if your MySQL server is runnign under Linux then try to play with
innodb_flush_method variable.
I've changed it to O_DSYNC and InnoDB became ~ 9 times faster (Suse 8.2
Linux 2.4.20-4GB i386).
Also check that you didn't allocate too much memory (OS shouldn't swap).
Best regards,
Mikhail.
Matt, Peter - thanks guys!!
--
Schedule your world with ScheduleWorld.com
http://www.ScheduleWorld.com/
Java Web start (JNLP):
http://www.ScheduleWorld.com/sw/ScheduleWorld.jnlp
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
On Mon, Sep 01, 2003 at 11:09:02AM -0700, Martin Gainty wrote:
Doug
I copied this from an SAP integration with Orace site
http://saphelp.cob.csuchico.edu/OraHelp/Darwin36/inst36fhp/html/5-odbc.htm
5.5.3 tsnames.ora File
the file
ORACLE_HOME/network/admin/tnsnames.ora must point to the
Thanks for the info.
I'm running MySQL 4.0.14 under Redhat 8.0 / Linux 2.4.20.
Here are the timings I ended up with from playing with innodb_flush_method:
innodb_flush_method=fdatasync (default) 10 minutes 37 seconds
innodb_flush_method=littlesync 10 minutes 22 seconds
Hi,
I have mysql 3.23.56 on RedHat 8.0
I can access mysql through my machine using PHP alright with the following
server: ns1.mydomain.ca
user: me
Password: foo
I can access Mysql using Putty with the same variables
However I am using a program that uses ADO and MyOBDC driver and it is unable to
Egor,
Thank you for the response. You are the perfect
person to answer my questions regarding Russian
character sets. :) I two follow-up questions:
1. Will this work even though I am using two different
character sets? I just want to be clear on what I am
describing: one column of my table
--On Friday, August 22, 2003 1:21 PM -0400 Lefevre, Steven
[EMAIL PROTECTED] wrote:
that is not true. mirroring gives you double the read speed and half
the write speed. RAID5 gives you less than half the write speed.
-
OK, I see how it can give you double the read speed, but how
--On Friday, August 22, 2003 8:37 PM -0600 Jim McAtee
[EMAIL PROTECTED] wrote:
I don't quite understand the need to read data before any write. Why
wouldn't it just calculate the parity of whatever is being written and
just write it to disk? Wouldn't there be slack space, as with any disk
I get the following strange behavior with a user variable. @T has the value
0 to start; after adding 1 to @T a few times, it ends up with a clearly
incorrect value. I'd expect it to have a value of 280 after the second
select.
--
SELECT @T
--
+--+
| @T |
+--+
On Sun, Aug 31, 2003 at 12:02:20AM -0400, K Old wrote:
I ran across this tool the other day and it is awesome. Basically it is
like the top utility for *nix, but it's for mysql. It basically gives
you a live look into the database and what queries it's processing, etc
in real time.
Glad
On Sun, Aug 31, 2003 at 07:14:12AM -0400, Albert wrote:
Can this tool be used on Windows and if so what version do I need to DL and
does it need anything else besides the software (e.g. Perl - which I see
listed for the nix versions.
When I last had a Windows box at work, mytop worked with
Just an update (but a good one): I have this working
now if I issue all of my SQL statements direct from
the MySQL monitor. Egor was 100% correct that this
can be done. As a native English speaker, I was
confused on how MySQL would handle characters that
were not of the Western European type
Mike Kinzie [EMAIL PROTECTED] wrote:
I have mysql 3.23.56 on RedHat 8.0
I can access mysql through my machine using PHP alright with the following
server: ns1.mydomain.ca
user: me
Password: foo
I can access Mysql using Putty with the same variables
However I am using a program that
Hallo everyone !
I already sent this, but I think some people think is
not clear enough ;-)
Im using Mysql 4.0.12 on RedHat 7.3 x86
I know it's not the last binary but I cannot upgrade
now. (And i saw nothing about this in the changelog
for 4.013 and 4.0.14)
I found the following :
I have two
hello list
i migrated a server of ours (from 3.23) to mysql-4.0.14 (solaris 8/sparc/64bit). i
took the precompiled binary of the website. so far so good.
my problem now is the mysql-server crashed with signal 11 every 15 minutes. Ok, signal
11 normally sounds like memory or hardware problem
Hi,
well, I'm not totally sure about your question. Which order is reversed ? The
order you get the entries with a select after the insert ? If it is this,
then I think it's not a problem with the insert. The order is then given by
the select, and if no order by is in the select, it is
Hi Stephan,
Let's see the case :
I use ORDER BY, because I want that order in PTemp
table, so I do not have to order them later (because
they are retrieved several times later).
1. Inserting with mysql c.l.i. :
I get the records well sorted : first by a, secondly
by b and finally by c
Paul,
Where did you find information about 'littlesync' and 'nosync'?
In InnoDB manual I found only
**
This is only relevant on Unix. The default value for this is fdatasync. Then InnoDB
uses fsync() to flush both the data and log files. If O_DSYNC is specified, InnoDB
uses O_SYNC
Hi Alejondro
I use ORDER BY, because I want that order in PTemp
table, so I do not have to order them later (because
they are retrieved several times later).
If I understand correct ,,,
U can never trust the order ur records get return from DB
(it is indepented of the order u insert records
Hi I'm a mysql/php novice.
I tried connect a mysql-db using php4 under linux. Then I get a warning
by the parser from the function mysql_free_result($result);
Warning: mysql_free_result(): supplied argument is not a valid MySQL result
resource in /srv/www/htdocs In all reference books I
On Tue, 2 Sep 2003 12:12:42 +0200
Magnus D. Klein [EMAIL PROTECTED] wrote:
I tried connect a mysql-db using php4 under linux. Then I get a warning
by the parser from the function mysql_free_result($result);
Warning: mysql_free_result(): supplied argument is not a valid MySQL result
resource
Hi,
I think you can't do this. There is no order in the table, so there is no
point in using order by with insert. You always have to do this when
retrieving the records (the order you get with select without order by is
accidential).
HTH
Stefan
Am Tuesday 02 September 2003 11:49 schrieb
Symantec AntiVirus found a virus in an attachment you ([EMAIL PROTECTED] [EMAIL
PROTECTED]) sent to Jay Blanchard.
To ensure the recipient(s) are able to use the files you sent, perform a virus scan on
your computer, clean any infected files, then resend this attachment.
Attachment:
Stefan,
Do you imply that tables cannot be sorted desc or asc based on one of the
columns e.g. a last name? or am I misunderstanding you.
Albert
Atlanta
(anyone else in Atlanta?)
- Original Message -
From: Stefan Kuhn [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September
A TNSNAMES file isn't going to help unless you have the Oracle client
software
installed. If you had the software, you would already have a tnsnames file.
-Original Message-
From: Doug Poland [mailto:[EMAIL PROTECTED]
Sent: 02 September 2003 02:58
To: Martin Gainty
Cc: [EMAIL
Hello,
I have dumped the database contents as one txt file by using this
command
mysqldump databasename -uusername -ppasswd textfilename.
but while redumping back to mysql it is giving some errors in the
textfile..is there any possibility to redump the contents without any
error..
On Tue, 2 Sep 2003 17:02:37 +0530 (IST)
Uma Shankari T. [EMAIL PROTECTED] wrote:
but while redumping back to mysql it is giving some errors in the
textfile..is there any possibility to redump the contents without any
error..
what exactly does it say ?
---
WBR,
Antony Dovgal aka tony2001
What are the errors?
For example, is the error like unable to create the tables, because the
tables still exist? See the dumpfile if tables are created (by default).
If so, delete the tables first, and redump back the dumpfile.
-Original Message-
From: Uma Shankari T. [mailto:[EMAIL
Hi Albert,
you are not misunderstanding me :-) Tables can indeed not be sorted, it's
output which gets sorted. The difference is not academic, but important: It's
not the table which gets an order, but the output. Take a command like:
insert into x ... select from y ... order by z. Here the
* Albert
Stefan,
I'm Roger, but I reply anyway. :)
Do you imply that tables cannot be sorted desc or asc based on one of the
columns e.g. a last name? or am I misunderstanding you.
In relational database theory the order of rows within the table is
undefined, i.e. it is up to the server, and
use
mysql database-name backupfilename
I think , the backup file name should have .sql extension , like backup.sql
Hoeven, Maarten van der wrote:
What are the errors?
For example, is the error like unable to create the tables, because the
tables still exist? See the dumpfile if tables are
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 2 Sep 2003, Roman Hochuli wrote:
i migrated a server of ours (from 3.23) to mysql-4.0.14 (solaris
8/sparc/64bit). i took the precompiled binary of the website. so far so
good.
my problem now is the mysql-server crashed with signal 11
On Tue, Sep 02, 2003 at 12:25:35PM +0100, Jim Smith wrote:
A TNSNAMES file isn't going to help unless you have the Oracle
client software installed. If you had the software, you would
already have a tnsnames file.
Thanks all for your help. I've found a free java-based application
Hi
The only problem I get with mysqldump is that if I have used a reserved word
as a column name, then the create starement fails.
(eg
CREATE TABLE fred (
KEY int(10) not null default '0'
);
will fail (but as produced by mysqldump)
However, if you edit the file and put `
Stefan,
Indeed, and my mistake (semantics). I meant what you explained. It is clear
to me that the order in the table remains in the manner the data were
entered, and that cannot be changed, unless a record is deleted and then
re-entered, which would place it elsewhere (at the end). This does not
Roger,
Thanks for the additional clarification
Albert
Atlanta
- Original Message -
From: Roger Baklund [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: Albert [EMAIL PROTECTED]
Sent: Tuesday, September 02, 2003 8:00 AM
Subject: Re: insert ... select .. order by, problem
* Albert
Dear programmers,
is this correct ?
mysql select version();
+---+
| version() |
+---+
| 4.1.0-alpha-max-debug |
+---+
1 row in set (0.00 sec)
mysql SET @s = CONVERT('ABC' USING ucs2);
ERROR 1115: Unknown character set:
try to export the database once again , using the command
mysqldump database-name file.sql .
then try importing the same using
mysql database-name file.sql .(delete all the backups before trying this)
by the way , are you trying to export/import between diff versions of mysql / or
between diff
When I enter :
mysql\binSHOW GRANTS FOR uma;
I get a response that show is not a command etc..
This is on Win32 version 4.x
The same happens when I try it from mysql
and also after I run mysqld
Any ideas what is wrong here?
Thanks
Albert
- Original Message -
From: Joris Beckers
Hi All!
How much user LOAD can Mysql bear before die.
Regards,
Tariq
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
We are currently running production on ver 3.23. We have two db servers
that are in need of hardware upgrade. DB1 replicates to DB2.
I plan on taking DB2 offline, upgrading RAM and Processors, installing
latest RH OS and MySQL 4.0. Then replace DB1 with the upgraded DB2
making it the new DB1
All,
I'm looking for opinions/suggestions on a backup procedure I plan on
implementing.
All databases (DBXX) will be MySQL ver 4.0
All our applications work with DB01.
DB01 replicates to DB02.
Once a day I will Stop the slave on DB02, lock the tables, flush the
logs and perform a mysqldump of
Matthew (UK),
I have two questions regarding this:
1. are you using the tick that is under the ~ sign on US keyboards, or the '
which is under the quotes on US keyboards?
I tried both and get an error executing the following query in mysql client
gui screen
GRANT ALL mysql.* TO USER 'albert'
Stefan,
Indeed, and my mistake (semantics). I meant what you explained. It is clear
to me that the order in the table remains in the manner the data were
entered, and that cannot be changed, unless a record is deleted and then
re-entered, which would place it elsewhere (at the end). This does not
Albert,
This may sound minuscule. You're certain that 'uma' is a user account and
not a database or table?
Normally, you use SHOW GRANTS FOR user_account. See example:
mysql SHOW GRANTS FOR test_usr;
+--+
| Grants for [EMAIL PROTECTED]
(newbie to MySQL)
I've been banging my head against the wall on this one for a bit now, and I understand
that last_insert_id() is per-connection based, but most webapps are connection pooled
(simple) or clustered (harder). What are my options to get the id of the inserted row
in a webapp? As
* Albert
When I enter :
mysql\binSHOW GRANTS FOR uma;
I get a response that show is not a command etc..
This is on Win32 version 4.x
The same happens when I try it from mysql
and also after I run mysqld
Any ideas what is wrong here?
When you say you try it from mysql do you mean
This is the error I get and yes uma is a user and listed in my.ini file
actually
C:\mysql\binSHOW GRANTS FOR uma;
'SHOW' is not recognized as an internal or external command,
operable program or batch file.
C:\mysql\bin
Albert
- Original Message -
From: Fortuno, Adam [EMAIL
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 02 September 2003 1:36 pm, Morten Gulbrandsen wrote:
mysql SET @s = CONVERT('ABC' USING ucs2);
ERROR 1115: Unknown character set: 'ucs2'
mysql
It works for me. I think you need to be using mysql 4.1.1alpha from BK.
see:
Stefan,
Indeed, and my mistake (semantics). I meant what you explained. It is clear
to me that the order in the table remains in the manner the data were
entered, and that cannot be changed, unless a record is deleted and then
re-entered, which would place it elsewhere (at the end). This does
On Tue, 2 Sep 2003 08:45:42 -0400
Albert [EMAIL PROTECTED] wrote:
When I enter :
mysql\binSHOW GRANTS FOR uma;
I get a response that show is not a command etc..
This is on Win32 version 4.x
The same happens when I try it from mysql
and also after I run mysqld
Any ideas what is
I recently restarted my MySQL server (4.0.10 in this case) with
the general query log enabled, to help out with some debugging and
optimization issues. After looking at a batch of these, I then
deleted the log file directly, with rm foo.log, assuming that it
would be re-generated as soon as the
I'm writing to get some help on the following problem:
We're running MySql (1.4.1 version) with MyODBC (version 3.51.06) and the
Report Application Server 9 (RAS) from Crystal Decisions. We're having a
problem getting the Report Application Server to connect to the MySql
database via MyODBC. We
I don't know the answer to your question, but as a side note, I've always found
cat'ing /dev/null into a file to be safer if the file may be in use
cat /dev/null foo.log
-Original Message-
From: Jesse Sheidlower [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 02, 2003 10:27 AM
flush logs from the mysql command line works
Jesse Sheidlower wrote:
I recently restarted my MySQL server (4.0.10 in this case) with
the general query log enabled, to help out with some debugging and
optimization issues. After looking at a batch of these, I then
deleted the log file directly,
OK I think I got it, in Win32 it has to be done from the mysql client screen
and not from the command prompt.
Either that or use another GUI client as the front end for MySQL I guess and
I have had some suggestions on that one.
I will try doing so. Thanks for the help
Albert
- Original
On Tue, Sep 02, 2003 at 07:59:07AM -0700, Bruce Ferrell wrote:
flush logs from the mysql command line works
And so it does. Thank you. I misunderstood what the Manual
said about this command, though I should have tried it first
anyway.
Jesse Sheidlower
--
MySQL General Mailing List
For list
For grant statemnets
grant all ON mysql.* to 'albert'
is the correct syntax
back ticks (`) are for around column names
single quotes (') are for around strings/varchars/chars...
M
-Original Message-
From: Albert [mailto:[EMAIL PROTECTED]
Sent: 02 September 2003 14:04
To: [EMAIL
Your EMail with subject 'Thank you!', sent to the recipient(s)
[EMAIL PROTECTED]
contains a virus or other harmful content. The message has NOT been delivered to the
recipients.
Please contact the postmaster (mailto:[EMAIL PROTECTED]) to resolve this issue.
shell groupadd mysql
shell useradd -g mysql mysql
shell cd /usr/local
shell gunzip /path/to/mysql-VERSION-OS.tar.gz | tar xvf -
shell ln -s full-path-to-mysql-VERSION-OS mysql
shell cd mysql
shell scripts/mysql_install_db
shell chown -R root .
shell chown -R mysql data
I'm getting the
Sounds like a problem authenticating the host the queries are coming from.
Try using the grant command with like john@%, which allows any host to
connect. (replace john with the username you want.)
As a historical note, we tried using Crystal RAS with Lotus Notes and
concluded it was too slow
Does anyone know what prompt the message below to be sent by the list?
I have now been getting a few of these and cannot figure out why.
Thanks for any input
Uma
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 02, 2003 11:39 AM
Subject: No valid command
mysql create table mytbl( c1 char(10) character set latin1_de);
ERROR 1115: Unknown character set: 'latin1_de'
mysql create table mytbl( c1 char(10) character set utf8);
ERROR 1115: Unknown character set: 'utf8'
mysql create table mytbl( c1 char(10) character set sjis);
ERROR 1115:
I have data that is in a progress database. I need to get
a copy of the data into my mysql database. What would
be the best approach ? I can dump the data in any specific
format, so.
Never tried ODBC with Progress (8.2C12), so don't know if
that can/will work.
thanks,
Darryl
--
MySQL
i copy the Bytefx.data i.72 i nto my project folder, but when i run the project, an
error occur :
File or assembly name System, or one of its dependencies, was not found. .
As usual, i copy the file into my project folder, then i add a reference. After that i
imports ByteFX.Data.MySQLCLIENT.
Assuming that I had a database containing a single table used to record an
audit trail of messages originated from customers and their applications
like so:
CREATE TABLE `LogMessage` (
`MessageID` int(11) NOT NULL auto_increment,
`CustomerName` varchar(100) default '',
`ApplicationName`
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 02 September 2003 5:40 pm, Morten Gulbrandsen wrote:
mysql create table mytbl( c1 char(10) character set latin1_de);
ERROR 1115: Unknown character set: 'latin1_de'
IIRC latin1_de is not a character set in Mysql 4.1.. The character set
I may be missing something, but why not just do:
SELECT CustomerName, ApplicationName, Status, COUNT(1) AS Count
FROM LogMessage
GROUP BY Status, CustomerName, ApplicationName with rollup;
which should return all the data you need in 1 query, which has got to run faster than
4 seperate
On Tuesday, September 02, 2003 5:01 PM CET, Gronquist, Jim M wrote:
shell groupadd mysql
shell useradd -g mysql mysql
shell cd /usr/local
shell gunzip /path/to/mysql-VERSION-OS.tar.gz | tar xvf -
shell ln -s full-path-to-mysql-VERSION-OS mysql
shell cd mysql
shell scripts/mysql_install_db
So, we have a webmail application that uses a mysql server for holding
it's session information. Obviously this causes many
reads,updates,inserts, and deletes to happen. Here are my lock
statistics.
| Table_locks_immediate| 73099 |
| Table_locks_waited | 32187 |
This ratio
On Tue, Sep 02, 2003 at 10:37:34AM -0700, James Kelty wrote:
So, we have a webmail application that uses a mysql server for holding
it's session information. Obviously this causes many
reads,updates,inserts, and deletes to happen. Here are my lock
statistics.
| Table_locks_immediate|
Well, there isn't a my.cnf file, so other that setting the
max_connections with the -O option, it's whatever is default for
3.23.56.
-James
On Tue, 2003-09-02 at 10:50, Jeremy Zawodny wrote:
On Tue, Sep 02, 2003 at 10:37:34AM -0700, James Kelty wrote:
So, we have a webmail application that
On Tuesday, September 02, 2003 7:20 PM CET, Gronquist, Jim M wrote:
Yves,
Thanks so much! Yes, I was able to create the data directory and get
farther along. Now, when I try and start
cd ~
/etc/rc.d/rc3.d/S90mysql start
starting mysql daemon with db from
/usr/local/mysql/var
030902
On Tue, Sep 02, 2003 at 10:58:03AM -0700, James Kelty wrote:
Well, there isn't a my.cnf file, so other that setting the
max_connections with the -O option, it's whatever is default for
3.23.56.
Since you didn't answer the other questions, I'm going to do some
guessing here... I'll guess that
Whoa, ok. Sorry. I didn't read the questions about the data and index
files. I'm, uh, not exactly sure how to tell that, can you give me a
hint there as well? *look sheepishly around*...
-James
On Tue, 2003-09-02 at 11:06, Jeremy Zawodny wrote:
On Tue, Sep 02, 2003 at 10:58:03AM -0700, James
Hi,
I'm having problems with a fulltext indexed table where it takes a
long time return from a query where many rows match. I noticed that
when I run a query like
select count(*) from table where keywords like '%x%';
it takes a long time but after that all fulltext queries are much
faster, I'm
I've not a clue - digging around somewhere on the Internet. I didn't
see the info in the manual regarding fsync being used as default for
Linux, but now I also notice that my manual says version 4.0.5 off
to grab current manual
Mikhail Entaltsev wrote:
Paul,
Where did you find
Can anyone tell me what is different between index and key when creating table?
like this situation:
create table info ( fname char(9), lname char (15), address char(30),
index(lname));
or
create table info ( fname char(9), lname char(15), address char(30),
key(lname));
Thanks.
mysql:
Can anyone tell me what is different between index and key when creating
table?
like this situation:
create table info ( fname char(9), lname char (15), address char(30),
index(lname));
or
create table info ( fname char(9), lname char(15), address char(30),
key(lname));
Thanks.
On Tue, Sep 02, 2003 at 11:23:57AM -0700, James Kelty wrote:
Whoa, ok. Sorry. I didn't read the questions about the data and index
files. I'm, uh, not exactly sure how to tell that, can you give me a
hint there as well? *look sheepishly around*...
Sure.
First you need to figure out where
Ahhh! Ok, yeah the index file was 1.0k and the data file was 8.6M.
-James
On Tue, 2003-09-02 at 12:17, Jeremy Zawodny wrote:
On Tue, Sep 02, 2003 at 11:23:57AM -0700, James Kelty wrote:
Whoa, ok. Sorry. I didn't read the questions about the data and index
files. I'm, uh, not exactly sure
From: Vivian Wang [EMAIL PROTECTED]
Date: 2003/09/02 Tue PM 02:16:26 CDT
To: [EMAIL PROTECTED]
Subject: Fwd: different between index and key when create table
mysql:
Can anyone tell me what is different between index and key when creating
table?
like this situation:
create table
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Dan Greene wrote:
(newbie to MySQL)
I've been banging my head against the wall on this one for a bit now,
and I understand that last_insert_id() is per-connection based, but most
webapps are connection pooled (simple) or clustered (harder). What
Hi All,
I'm having a few issues getting things up and running
in regards to replication.
I believe I have everything setup correctly the slave
is roughly in the same spot as the master as far as
the logs are concerned. However, when I make changes
in the master db I don't see them show up in
greetings,
I have created a text file in windows (from a database) that has the format
empnum name fname lname ext email listit bm bd hd
bm, bd are integers and hd is date.
I have tried to import using the follow command
#mysqlimport -u root -pmypass -d --local iweb emp2.txt
it imports the 97
Hi All,
I'm having a few issues getting things up and running
in regards to replication.
I believe I have everything setup correctly the slave
is roughly in the same spot as the master as far as
the logs are concerned. However, when I make changes
in the master db I don't see them show up in
Hi!
- Original Message -
From: Paul Gallier [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Tuesday, September 02, 2003 9:55 PM
Subject: Re: InnoDB slow?
--060404050304080006000506
Content-Type: text/plain; charset=us-ascii; format=flowed
Darryl,
Provide a copy of the table's details either with a describe table output or
the table's definition and a sample of the input file's top 5-rows.
Regards,
Adam
-Original Message-
From: Darryl Hoar [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 02, 2003 4:31 PM
To: [EMAIL
All,
Am wondering if it's possible to do a query that does something like this:-
SELECT table1.*,table2.id from Table1 AS table1,Table2 AS table2
WHERE table1.id DOESN'T EXIST IN table2.id;
Regards
Marty
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system
All,
Am wondering if it's possible to do a query that does something like this:-
SELECT table1.*,table2.id from Table1 AS table1,Table2 AS table2
WHERE table1.id DOESN'T EXIST IN table2.id;
Regards
Marty
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system
Use LEFT JOIN
SELECT t1.*, t2.id FROM table1 as t1 LEFT JOIN table2 as t2 ON
t1.id=t2.id WHERE t2 IS NULL;
-- something like that --
---Original Message-
--From: Martin Moss [mailto:[EMAIL PROTECTED]
--Sent: Tuesday, September 02, 2003 1:50 PM
--To: [EMAIL PROTECTED]
--Subject: Select
Hi,
If the index file is just 1k (the same size as an EMPTY table!), it
sounds like you don't have any indexes. The 8.6MB table is probably at
least a few thousand rows, right? Well, if all your queries are scanning
the whole table, that would cause a few Table_locks_waited! :-)
In order to help
Sorry I missed out the difficult bit,
query sould read:-
SELECT table1.*,table2.id from Table1 AS table1,Table2 AS table2
WHERE table1.otherkeyid = '7236523' AND table2.otherkeyid = '7236523' AND
table1.id DOESN'T EXIST IN table2.id;
If there are NO entries in table2 for otherkeyid I still want
Sorry I missed out the difficult bit,
query sould read:-
SELECT table1.*,table2.id from Table1 AS table1,Table2 AS table2
WHERE table1.otherkeyid = '7236523' AND table2.otherkeyid = '7236523' AND
table1.id DOESN'T EXIST IN table2.id;
If there are NO entries in table2 for otherkeyid I still want
select t1.* from table1 t1 LEFT JOIN table2 t2 on t1.id=t2.id WHERE t2.id IS
NULL
you can print out table2 values if you want, but they will all be NULL..
provided that table2.id and table1.id are the matches you are trying to find.
Kelley
Martin Moss wrote:
All,
Am wondering if it's
1 - 100 of 120 matches
Mail list logo
