Hi Roman,
I see, thank you. I guess that translates for me on a Linux system than to
"netstat".
Best regards
Nils Valentin
Tokyo/Japan
2003年 6月 17日 火曜日 14:21、Roman Neuhauser さんは書きました:
> # [EMAIL PROTECTED] / 2003-06-17 11:25:36 +0900:
> > Hi Roman,
> >
> > just saw this by chance.
> >
> > >s
# [EMAIL PROTECTED] / 2003-06-17 11:25:36 +0900:
> Hi Roman,
>
> just saw this by chance.
>
> >sockstat -4l | grep 3306.
>
> I never heard of such a tool , also I did not find any info on the
> internet. I assume you dont mean sock, of course.
>
> Could you let me know where I can find the tool
I've been using MySQL 4.12 on my RH9 laptop for quite some time just
fine. I used the RPM's from the msql website. Today, I went to start
mysql and I get the following error:
[EMAIL PROTECTED] root]# /etc/init.d/mysql start
[EMAIL PROTECTED] root]# Starting mysqld daemon with databases from /var/l
At 21:09 +0200 6/16/03, Fernando Martins wrote:
In AUTO_INCREMENT fields, inserting a 0 into the field requests a new
sequence number.
Is it possible to turn off this behaviour? (without messing with the code,
of course)
No.
Using NULL to get the next sequence number is good enough for me and I us
Hi Roman,
just saw this by chance.
>sockstat -4l | grep 3306.
I never heard of such a tool , also I did not find any info on the internet. I
assume you dont mean sock, of course.
Could you let me know where I can find the tool ?
Best regards
Nils Valentin
Tokyo/Japan
2003年 6月 17日 火曜日 06:22
> At 15:05 +0900 6/12/03, Joel Rees wrote:
> >Paul DuBois advised us that
> >> Alexander Barkov and Peter Gulutzan have written up some documentation
> >> on the new character set support in MySQL 4.1, which has now been added
> >> to the online manual. You can read it here:
> >>
> >> http://w
Foreign key support for MyISAM tables is planned for version 5.0 (refering to
some presentations of the UC).
Best regards
Nils Valentin
Tokyo/Japan
2003年 6月 17日 火曜日 03:23、Becoming Digital さんは書きました:
> > so i want userTypeID in tblUsers to be a foregn key referencing the
> > userTypeID col in u
Hi Jonas,
don't get me wrong, but I strongly believe there is some (not a lot) of
advanced documentation around, the point is that it is spread all over the
place. MySQL's documentation is anything but complete yet, so you will find
that climping up the mountain will get mor and more difficult.
Is anyone familiar with this book and also uses cedant.com as their webhost?
If so I need to speak with you, I am new to this and a bit at sea with the how
to go about completing the excercises in the book.
thank you,
Peter Mitchell
Peter Mitchell Design
--
MySQL General Mailing List
For lis
Thanks for the tip, I'll take a look, both slave and master have innodb
tables ( a few of our users utilize them). It's atleasta place to
look...Though my feeling is it's something else.
--On Tuesday, June 17, 2003 3:04 AM +0300 Heikki Tuuri
<[EMAIL PROTECTED]> wrote:
Michael,
in the case t
Your statements are all too true, so much so that I feel no need to quote any
one part. This is information everyone should pay attention to.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Ryan Yagatich" <[EMAIL PROTECTED]>
To: "Becoming Digital" <[EM
Hi All
I'm trying to create a new database using the embedded server (MySQL 4.0.13). I
compiled the source distribution on linux as follows:
./configure --prefix=/fs32/b/sgsubram/bin/MySQL-with-new-hash/LINUX --enable-assembler
--with-mysqld-ldflags=-all-static
--localstatedir=/fs32/b/sgsubram
Another note about this is the mention of large database sizes. MySQL
and it's memory management, in my experience, are usually better at
handling this type of thing. So, for a parent-child relationship of
information which can contain say millions of lines of data, the
database can probably handle
Michael,
in the case the memory leak would be in InnoDB, you can monitor its memory
allocation with
SHOW INNODB STATUS\G
"
Total memory allocated 50738427; in additional pool allocated 1762432
"
Regards,
Heikki
- Original Message -
From: "Michael Loftis" <[EMAIL PROTECTED]>
Newsgrou
> I'm still a bit of newbie, but surely these are not the same query. The
> empty string is not the same thing as NULL.
You are correct, sir.
http://www.mysql.com/doc/en/NULL_values.html
http://www.mysql.com/doc/en/Working_with_NULL.html
http://www.mysql.com/doc/en/Problems_with_NULL.html
Edward
> how much more efficient would it be to write the same statements
> to a text file, and then fork a child thread to connect to the
> database, and read the entire infile at once?
If I understand you correctly, this is addressed in the section of the manual to
which I previously referred you. Fro
NOT NULL ensures that a field cannot be left blank. This is necessary for
primary keys because a null value would lead to a collapse in relationships.
For other fields, NOT NULL is used to speed SELECT queries and again to make
sure the field is filled.
Think of the many cases in which you would
With editing removing any passwords or sensitive stuff. (paths is all)
# Example mysql config file.
# You can copy this to one of:
# /usr/local/etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /usr/local/var) or
# ~/
On Mon, Jun 16, 2003 at 04:41:49PM -0600, Michael Loftis wrote:
> I'm noticing that our MySQL 4.0.13 system is probably leaking RAM (uptime
> ~10 days)
>
> ...
> PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
> 26046 mysql 9 0 548M 162M 44008 S 5.9 8.0 0:16 m
Hi,
I can't format properly a double number in scientific style. The number is
around 3e-32, so I need it in scientific format with 2 decimals. In a usual
'select' it comes in scientific format but with a large number of decimals.
If I try to fix the number of decimals with round() or format() it
I'm noticing that our MySQL 4.0.13 system is probably leaking RAM (uptime
~10 days)
...
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
26046 mysql 9 0 548M 162M 44008 S 5.9 8.0 0:16 mysqld-max
...
And it just keeps growing. Even with our admittedly aggressive
On Sat, Jun 14, 2003 at 03:27:52PM +0200, Roberto Barbieri wrote:
> Yes but it can be done?
>
> If i'm not wrong actually db replication is only supported
> between secondary db or not?
It can be done if you avoid auto-increment columns. That's not the
only way, but it's the easiest to explain
# [EMAIL PROTECTED] / 2003-06-16 15:27:21 +0200:
>
> I'm trying to use 4.1.0-alpha's "extensive unicode support".
[...]
> Now I try to read the data, this time from the commandline client:
>
> mysql> select * from unitest WHERE ID=72;
> ++---+---+
> | ID | vc
Hello,
I don't know if this has been answered, but here goes. I am using MySQL
4.1.0-alpha with the C api. Using the C api because not yet using the STL.
Anyway, is this true, If I make a call to mysql_options and give it a new
options file, does that fill in the database handle with options from
Hello again,
After realizing the obvious implementation flaws, I thought of a new idea and
again, would appreciate some feedback on the efficiency benefits.
My last post involved INSERT vs UPDATE efficiency. Neither is going to be a
directly useful approach. With 48k records and growin
# [EMAIL PROTECTED] / 2003-06-16 12:01:57 +:
> I installed the mysql 4.0 pkg on Mac OS 10.2, then I followed the
> installation instruction. It works fine. I then tried to create
> database, but is says"Access denied". I checked "Show database" ,
> there is only one database in, which is 't
Hello Mr Bader,
A simple answer to this solution, after all my own searches for a good
API to communicate with MySQL, I found nothing better than the standard
MySQL C API standard with MySQL. The calls are not at all cryptic, the
functionality is quite featureful (including escaping strings f
# [EMAIL PROTECTED] / 2003-06-16 15:15:31 -0400:
> I have two tables...
> Table 1 newdata contains a lot of statistical data on our customers,
> including last 12months sales amt.
> table 2 sdtik contains all ticket information for all customers.
> Both tables have acctno as primary key.
>
> I ca
I'm generating text files and MySql seems to have problems with certain
characters. It is inserting 'slash 0' in the text whenever it hits an
unexpected character like a CHR(16).
In Windows 2000 Server, using BCP from MS Sql Server I don't see these
characters.
Is there a work around for this
On 16-Jun-2003 Tom Johnson wrote:
> Is it possible to convert the following query to run in MySQL? The query
> is
> based on a table called "ardata" which contains the fields 'author',
> 'lname', and 'fname'. The 'author' field contains the authors first and
> last name with a space in the middl
# [EMAIL PROTECTED] / 2003-06-16 21:09:14 +0200:
> In AUTO_INCREMENT fields, inserting a 0 into the field requests a new
> sequence number.
>
> Is it possible to turn off this behaviour?
I doubt that.
> (without messing with the code, of course)
I doubt that some more.
> Using NULL to
Hi all,
this _my_ "simple" problem: I wrote a little c++ programm in linux using
the plusplus api
My purpose was to create a simple interface to mysql. Programmer uses my
class, gives a sql-string and gets a pointer to the result array wich my
class creates out of the result set.
this is a short
# [EMAIL PROTECTED] / 2003-06-16 15:23:21 -0500:
> I thought it was written in EnglishIt wasn't?
It was written in English, but your MUA labeled it as being encoded
with ks_c_5601-1987. Is that a Korean charset? Non-broken MUA will
obey the header, and display it as though it was e
It is generally faster to use your programming language for data processing.
However, if you can retrieve the data in a usable format with a single database
query, by all means, do it. Generally, developers seem to strive for as few
steps/operations as possible, whatever they may be. The differen
On 16-Jun-2003 Colin Knowles wrote:
>
>>Description:
>
> Mysql starts and then closes again. The following is in the log file:
>
> 030613 16:36:37 mysqld started
> 030613 16:36:37 InnoDB: Started
> 030613 16:36:37 Fatal error: Can't open privilege tables: Table
> 'mysql.host' do
> esn't exi
InnoDB is very fast. In theory, I guess MyISAM is considered faster
(that may not even be true these days). We're talking about fine hairs
here and I haven't heard anybody complain about InnoDB-specific speed
problems. Anyway, if you're using Windows, you're must not be too
concerned about speed
Dear Roman,
I thought it was written in EnglishIt wasn't?
Here I'm sending the message again, Roman~~
***My message 2**
Thank you, Ryan,
And I'd like to know if, to use pure SQL is more efficient than to parse the
multiple values in one field?
What if
# [EMAIL PROTECTED] / 2003-06-16 14:47:19 -0500:
> Content-Type: text/plain; charset="ks_c_5601-1987"
>
> ?...
posting in english would yield more replies.
--
If you cc me or remove the list(s) com
Hey,
I've been learning sql using mysql. Now I got the basics. But I'm stuck
I want to learn more advanced things, and since all the site's I know
handle mysql stuff with php it doesn't get really advanced.
Anyone knows any good resources with advanced sql based on mysql stuff ?
Like joins and di
Thank you, Ryan,
And I'd like to know if, to use pure SQL is more efficient than to parse the
multiple values in one field?
What if the amount of the database is really huge? How about the performance
speed comparing with the method using
composite key tables as you suggested?
Thanks in advance,
I have two tables...
Table 1 newdata contains a lot of statistical data on our customers,
including last 12months sales amt.
table 2 sdtik contains all ticket information for all customers.
Both tables have acctno as primary key.
I can use:
SELECT sum(if(voidreason>0,0,amt)) as sales FROM sdtik
In AUTO_INCREMENT fields, inserting a 0 into the field requests a new
sequence number.
Is it possible to turn off this behaviour? (without messing with the code,
of course)
Using NULL to get the next sequence number is good enough for me and I use
quite a lot 0 for special purposes (default recor
> -Original Message-
> From: Fred van Engen [mailto:[EMAIL PROTECTED]
> Sorry, you'll need a backup. If your backup is not recent
> enough and you
> have a binary log (e.g. for replication), you can use that
> log to restore
> the database state.
If you have a backup and the update lo
> second, i have followed some discussions here about
> foreign keys but i still have not managed to create
> foreign keys
>
> so i want userTypeID in tblUsers to be a foregn key
> referencing the userTypeID col in userTypes
. . .
> what is wrong?
Nothing is wrong. Sounds like a perfect fine use
On Sun, Jun 15, 2003 at 03:01:18PM +0800, Ares Liu wrote:
>
> MySQL 4.0.12 max on AIX 4.3.2 HA. When I use show full processlist
> on localhost, all Hosts show as localhost. but when I use show full
> processlist from remote, all Hosts show as remote IP. as follow:
Known bug fixed in 4.0.13 (the
> so i want userTypeID in tblUsers to be a foregn key referencing the
> userTypeID col in userTypes
> both tables are myISAM
You answered your own question. MyISAM tables don't support foreign keys.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "R
Hello,
MySQL has been running smoothly on my machine for the past month. This morning I
installed PHP 4.3.2 and now I can't seem to get MySQL running anymore.
I get the following error message:
# Starting mysqld daemon with databases from /var/lib/mysql
030616 11:19:03 mysqld ended
Any clues?
Hello,
I have a problem to start to create database. Can someone please give me some help?
I installed the mysql 4.0 pkg on Mac OS 10.2, then I followed the installation
instruction. It
works fine. I then tried to create database, but is says"Access denied". I checked
"Show
database" , the
Sorry...
I read mysql page and I read that is need mysql 4 and my server only has
mysql 3.23.51!!!
I'll try to contact my ISP in order to they update the server.
Thanks all,
Nuno Lopes
> SELECT * FROM 'test' WHERE MATCH (p) AGAINST ('arvor*' in boolean mode );
>
> Santino
>
> >Hello,
> >
> >I
Ben,
please print with
SHOW INNODB STATUS
what kind of foreign key error InnoDB complains about in the import.
Can you produce a repeatable test case with table dumps that shows the
error?
Are you sure you are importing all the tables within the same connection
where you have set foreign_key_c
On Mon, 16 Jun 2003, Grimes, Dean wrote:
> Have you been able to compile Apache/MySQL/PHP successfully on SCO 5.0.6? If
> so, could you send me a listing of the patches you have installed?
Yes, This is what I have on my system
OSS629A: SCO HTTP Security Supplement (ver 1.0.0)
OSS635
On Mon, 16 Jun 2003 12:45:53 -0400, Martin's - Web Dept. wrote:
> I am quite willing to acknowledge that I'm new at this ...
>
> But I can't find the syntax error in this query:
>
> SELECT * FROM products WHERE MATCH (desc) AGAINST ('usb')
>
> desc is a field name, usb is the keyword I'm sear
On Mon, Jun 16, 2003 at 12:45:53PM -0400, Martin's - Web Dept. wrote:
> I am quite willing to acknowledge that I'm new at this ...
>
> But I can't find the syntax error in this query:
>
> SELECT * FROM products WHERE MATCH (desc) AGAINST ('usb')
>
> desc is a field name, usb is the keyword I'm s
I am quite willing to acknowledge that I'm new at this ...
But I can't find the syntax error in this query:
SELECT * FROM products WHERE MATCH (desc) AGAINST ('usb')
desc is a field name, usb is the keyword I'm searching for.
MYSQL version 4.0.12
Thanks for your help.
Ryan
--
MySQL Genera
Is it possible to convert the following query to run in MySQL? The query is
based on a table called "ardata" which contains the fields 'author',
'lname', and 'fname'. The 'author' field contains the authors first and
last name with a space in the middle. I want to convert the names over so
the f
Check permissions (mysql) of data files.
Do You have host and mysql data files in your filesystem?
If not launch ./scripts/mysql_installdb
and relaunch te server.
There is a file named (your machine).err where You found more info about errors
Santino
Hello All,
I am using phpMyAdmin to administer
MyPerl allows you to store and execute perl code inside of your MySQL
database. You can use it to write custom functions.
You can find copies of MyPerl here:
http://software.tangent.org/download/myperl-0.9-1.i386.rpm
http://software.tangent.org/download/myperl-0.9.tar.gz
Among the fixes are that
What you need to do is specify username in your select query and JOIN
the two tables together.
Marks table:
User_id | Marks
User Table
User_id | Name
Query:
SELECT User.Name, Marks.Marks FROM User, Marks WHERE User.User_id =
Marks.User_id
Regards,
Mike Hillyer
www.vbmysql.com
-Origina
In mysql 4.0.12:
SELECT * FROM 'test' WHERE MATCH (p) AGAINST ('arvor*' in boolean mode );
Santino
Hello,
I have a table with just one column and with 1000 rows. It's indexed using
full text.
I've tried MATCH with AGAINST and LIKE and nothing works right!
I've tried:
SELECT * FROM 'test' WHERE M
| user_id | Marks | Now I have an other table where I keep the name
etc.. from each user. You will all kill me for this, but in access you
could the setup a relation between user_id and the id of the user in the
user table. Is something like that possible in mysql ?
So that if I select some data
JeRRy wrote:
Hi,
I want to run my php scripts, mysql from home. Now
after being pointed to download apache for Windows as
well as mysql for windows I have installed them both.
Apache loads fine on localhost as I have tested it.
But I can't get my php pages to load correctly via
apache. It show
Heikki:
Thanks for the tip, but th thing is that I have 3.23.55-Max-log version,
I entered the SHOW INNODB STATUS and I didn't look the error you mentioned,
Any suggestion..
Greetings
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Re: Can't delete on cascade
Date: Sun,
I really don't get the user of NOT NULL
anyone knows a good page on the manual that talks about it I can't seem
to locate one.
Or any good resource help to help me figure this out would be greate regards
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
I'm still a bit of newbie, but surely these are not the same query. The
empty string is not the same thing as NULL.
Roddie Grant
[EMAIL PROTECTED]
> I tested these 2 queries:
>
> select * from mytable where myfield is null;
>
> select * from mytable where myfield = '';
>
> The second one run f
lines as long as 380 characters are hard to read.
hit enter every now and then, please.
# [EMAIL PROTECTED] / 2003-06-15 17:47:39 -0700:
> I created the following function to move a record from one table to
> another. The only difference in the table structures are the
> auto-incremented
Disks are currently 36GB 10kRPM SCSI ultra3 with hardware RAID (PERC 3/DI
onboard with 128MB cache)
iostat for the DB disk partition is:
avg-cpu: %user %nice%sys %idle
8.620.034.62 86.73
Device:rrqm/s wrqm/s r/s w/s rsec/s wsec/srkB/swkB/s avgrq-
Hello All,
I am using phpMyAdmin to administer my MySQl DB. I am running Mac OS
Jaguar.
when I try to strt up phpMyAdmin I get an error
Welcome to phpMyAdmin 2.4.0
Error
MySQL said:
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
So I try to start up the MySQL Server
I suppose you're doing this on your workstation (Windows?)? Ideally,
Mysql should be on it's own machine - it (or any database) is designed
to suck up resources. Also, you definitely need to tweak the
configuration file. MySQL's default config is very anemic (annoying I
know) as opposed to Oracl
Andy Stubbs wrote:
>
> Hi, long time listener, first time caller (I think),
>
> I've got a database which I'm looking to increase performance, either by
> buying bigger kit or by somehow optimising current configuration.
>
> I'm running MySQL-Max-3.23.56-1 from the mysql.com RPMs on a Dell
> Pow
Jerry,
Try this link:
http://www.phpbuilder.com/columns/moon19990716.php3
Andy
> -Original Message-
> From: JeRRy [mailto:[EMAIL PROTECTED]
> Sent: 16 June 2003 14:35
> To: [EMAIL PROTECTED]
> Subject: question?
>
>
> Hi,
>
> I want to run my php scripts, mysql from home. Now
> afte
IMHO, I create link tables which have the many-to-many relationships as
you are looking for. Here's a small example
CREATE TABLE users (
iUserID INT(4) NOT NULL AUTO_INCREMENT,
cUsername VARCHAR(15) NOT NULL UNIQUE,
PRIMARY KEY(iUserID));
CREATE TABLE games (
iGameID INT(4) NOT NULL AUTO_INCREMEN
Hi,
I tested these 2 queries:
select * from mytable where myfield is null;
select * from mytable where myfield = '';
The second one run faster. Is that true? Is checking NULL slower than
checking a string without any character?
Thanks
--
MySQL General Mailing List
For list archives: http://
First off, this is a PHP development issue, not necessarily a mysql
issue. Nonetheless, I have included some comments.
On Mon, 2003-06-16 at 07:33, sgannon60 wrote:
> I am using PHP, Mysql on IIS5.
>
> Process
> 1 - submit a unique user name, password
> 2- check against database and if successf
Hi,
I want to run my php scripts, mysql from home. Now
after being pointed to download apache for Windows as
well as mysql for windows I have installed them both.
Apache loads fine on localhost as I have tested it.
But I can't get my php pages to load correctly via
apache. It shows html correc
I'm trying to use 4.1.0-alpha's "extensive unicode support".
What I've learned so far: unicode only works in 4.1.0-alpha,
but it's not activated in the binary distribution, so I had
to compile it myself.
I can create a table like this:
CREATE TABLE unitest (
ID mediumint(9) NOT NULL
Hi Andy,
You have many questions, most I cant answer,but upgradng from 3.23-xx to 4.xx
will definitely give you a performance boost. I am running on siple boxes (
no replication etc.). So I am unable to say how much speed , but I strong
believe that it will be enough to be realised immediately
Hi, long time listener, first time caller (I think),
I've got a database which I'm looking to increase performance, either by
buying bigger kit or by somehow optimising current configuration.
I'm running MySQL-Max-3.23.56-1 from the mysql.com RPMs on a Dell
Poweredge 2500 with dual 1400MHz PIII
Description:
Mysql starts and then closes again. The following is in the log file:
030613 16:36:37 mysqld started
030613 16:36:37 InnoDB: Started
030613 16:36:37 Fatal error: Can't open privilege tables: Table
'mysql.host' do
esn't exist
030613 16:36:37 Aborting
030613 16:36:37 InnoDB: Sta
I have rs506a and I have tried every patch I can find but to no avail. Below
is a list of the patch I've tried in various combinations:
1. oss629a:
Support Level Supplement (SLS) OSS629A, the SCO HTTP Security
Supplement,
addresses a potential security exploit of scohttpd. This SLS re
Hello,
I am using mysql 3.23.49 on openbsd3.2 with php4.2.3. Formerly I was
connecting to mysql with php without any problem but now (I don't know
what I have changed) when I try to connect to mysql with php it gives
the following errors:
Warning: Can't connect to local MySQL server through so
I am using PHP, Mysql on IIS5.
Process
1 - submit a unique user name, password
2- check against database and if successful enter details in database which
creates a primary key which is the constant between the client details table
and the projects
3 - when a successful login if the first time a
Dear MySQL:
I am getting the error 'ERROR 1005: Can't create table './db/table.frm'
(errno: 150)' using InnoDB tables on 4.0.13-max-log.
This is nothing to do with referential checking. The command:
SET foreign_key_checks=0
Does alow the import of referential tables, but not all tables. Some
Hi ,
u can try this one out
http://www.zend.com/zend/tut/tutorial-delin4.php
Regards
Eric
===
Kamara Eric Rukidi Mpuuga
Computer Frontiers International
Plot 32 Lumumba Avenue
P.O Box 12510,Kampala
Tel :256-41-340417/71
Mob :256-71-190856
Email:[EMAIL PROTECTED]
Web
Did you run mysql_install_db?
> Hi!
>
> I have redhat 7.3 with the mysql packages that came with it.
> Since RHSA-2003:093-14 came out I upgraded mysql with
>
> mysql-3.23.56-1.73.i386.rpm
> mysql-devel-3.23.56-1.73.i386.rpm
> mysql-server-3.23.56-1.73.i386.rpm
>
> When I try to start mysqld
hi all!
i am currently working on a community projekt
the DB is a mySQL DB but i am not sure which engine to use
i know that innoDB supports foreign keys which i really want i order to
keep the data consistent since there will be a lots of insert, delete
and update activity with forums and guestbo
Hello Mysql Fans ;-);
030613 16:05:54 3 Connect [EMAIL PROTECTED] on
3 Query SHOW VARIABLES
3 Query SET autocommit=1
3 Query SET autocommit=1
030613 16:05:55 3 Query USE `sam_group_by_db`
How large is the status table? I would recommend trying to reduce the
inital recordset of your largest table with a subquery and then joining
the subquery to the other tables. Could you please show me the full query
with the table
sizes?
Jake Johnson
[EMAIL PROTECTED]
http://www.plutoid.com
On
Hi,
I'm having intermittent problems with a big query where I grab about 30
fields from 4 tables.
I've snipped my query:
Select ... Status_Msg from Extracts, Transacts, Publisher, Status where (
Transacts.ID=33237 and
Extracts.Pub_ID=Publisher.ID and
Transacts.Status=Status.ID and
Transacts.Extr
Bruce,
Bruce Leidl schrieb:
>
> I'm having a problem with some very slow queries that spend a very long
> time in the 'Sorting result' state and I'm wondering how sorts are
> implemented in mysql and what I can do to optimize these types of queries.
>
> The query looks something like this:
>
>
89 matches
Mail list logo
