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 dataf
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 debuggin
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 MySQ
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 with
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, I
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:http://lists.mysql
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 th
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
innodb_flush_metho
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 wi
--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, bu
--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
s
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.
Gl
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 A
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 progra
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 but
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 arbitrary
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 (ascendig
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 record
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 fou
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
>
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 Alejan
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: details
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, Septem
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 PRO
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..
R
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 tony2
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 PROT
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 outp
* 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, a
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
-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
(JOracle
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 ` character
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
> * Alb
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: 'uc
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\bin>SHOW 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 ". 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 a
* Albert
> When I enter :
>
> mysql\bin>SHOW 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>" d
This is the error I get and yes uma is a user and listed in my.ini file
actually
C:\mysql\bin>SHOW 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 PROTE
-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: http://www.m
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 n
On Tue, 2 Sep 2003 08:45:42 -0400
"Albert" <[EMAIL PROTECTED]> wrote:
> When I enter :
>
> mysql\bin>SHOW 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
>
> An
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
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, wit
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 Mes
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 a
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 PROTEC
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.
/var/ex...006LT-00-tmp/document_9446
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
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 a
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: Unk
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 Ge
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` var
-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 s
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 queri
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/mys
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 see
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
> 0
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 tha
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 K
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 not
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
Mikhail Entaltsev wrote:
Paul,
Where did you find information about 'littlesync' and 'n
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 My
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 su
>
> 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:
-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). Wha
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 the
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 r
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 the
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
> Content-Transf
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 PROTE
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 (http://www.
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 (http://ww
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:
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 p
Hi Marty,
Yes, a query like this:
SELECT t1.* FROM table1 t1
LEFT JOIN table2 t2 ON (t2.id=t1.id)
WHERE t2.id IS NULL
This assumes that table2.id is defined as NOT NULL.
See also: http://www.mysql.com/doc/en/JOIN.html
Hope that helps.
Matt
- Original Message -
From: "Martin Moss" <[
1 - 100 of 119 matches
Mail list logo
