On Fri, Oct 1, 2010 at 12:24 PM, Jake Peavy wrote:
> All,
>
> I have a number of routers which report in with various stats
> periodicially. This period is not a regular interval and can drift based on
> other factors. Each router drifts independently. The stats the routers
&g
All,
I have a number of routers which report in with various stats
periodicially. This period is not a regular interval and can drift based on
other factors. Each router drifts independently. The stats the routers
provide need to be analyzed in terms of deltas between reports (rather than
the a
ch RAM as you can stuff in the box.
Whether it can use it *effectively* is something I don't have any
experience with beyond ~8GB. I suspect it would work just fine,
though.
Jake
On Tue, Jan 20, 2009 at 12:08 PM, wrote:
> While specing out a new server, I was wondering if there is
What error is shown by 'show slave status\G' on server C after you
issue that query?
There's all sorts of things that could break replication...
On Tue, Jan 20, 2009 at 7:21 AM, Krishna Chandra Prajapati
wrote:
> Hi Baron,
>
> In production we have three servers.
>
> A> B ---
erience beyond MyISAM and InnoDB, but perhaps some of
the more complicated ones would make it easy to spread the data out
over multiple servers and balance the load that way.
Good luck,
Jake
On Wed, Jan 14, 2009 at 7:13 PM, xufeng wrote:
> Hi all,
> One website is based on LAMP(Linux+Apache+
D-5 and good ACLs)
Who knows, they may decide that the downtime of a normal dump is worth
the tradeoff once the alternatives are actually spelled out. Or they
might decide the uptime is still king and it's not worth the hassle at
all. Of course, go ahead and mention what you'd *like* to do, as
yo
t while you
do your mysqldump / mysqlhotcopy / mk-table-checksum.
Jake
On Tue, Jan 6, 2009 at 4:04 AM, Claudio Nanni wrote:
> All, Happy New Year, and let's hope somebody tries to stop the killing in
> gaza.
>
> I need to setup a replication slave off a master that is currently
&
tips, Here's a couple scripts I like to use
that give some decent tuning advice:
http://www.day32.com/MySQL/
http://wiki.mysqltuner.com/MySQLTuner
Neither of these will be specific to this particular query of course.
There is a query profiler tool in maatkit (http://www.maatkit.org/),
howev
in maatkit which does replication tracking,
although I've not yet used it. Judging by the other tools in that
package though, it's probably pretty decent :).
Jake
On Mon, Dec 22, 2008 at 8:26 PM, xufeng wrote:
> Hello everyone,
> In my production system, I set up MySQL 5.0.67 master/
e cores... assuming, of course,
that your OS actually *knows* about them (ie: you're running an
SMP-aware OS kernel).
Jake
On Mon, Dec 8, 2008 at 4:52 AM, Kunal Jain <[EMAIL PROTECTED]> wrote:
> How we can configure Mysql in such a way so that i start using all the cores
> of CPU. I
e effort
tuning MySQL itself than the underlying system. Linux has lots of
knobs if you go looking, but (at least for us) you generally don't
need to mess with them. We run CentOS mostly, for the record...
Jake
On Wed, Nov 12, 2008 at 12:20 PM, Shain Miley <[EMAIL PROTECTED]> wrote:
> Th
there's
lots of overhead involved with PAE mode, so if you actually have more
than 4GB of memory 64-bit will almost always be faster (as far as the
hardware is concerned).
Jake
On Wed, Nov 12, 2008 at 10:35 AM, Shain Miley <[EMAIL PROTECTED]> wrote:
> Hello all,
> I was wondering i
You might try out these two scripts... they've been very helpful
diagnosing MySQL performance issues for me on Linux servers. Good luck
getting them going on Windows though... Cygwin might be necessary :)
http://www.day32.com/MySQL/
http://wiki.mysqltuner.com/MySQLTuner
Jake
2008/11/11 RP Khar
rely on which
limitation you're running into... if the current index files for the
relevant tables on disk exceed 2GB, you might want to increase
myisam_max_sort_file_size. Otherwise, myisam_sort_buffer_size might be
better.
Jake
On Fri, Oct 31, 2008 at 12:20 AM, Moon's Father
<[EMAIL PR
g
the connection... don't know what your setup is. Another long shot in
a multi-db-server config would be to make sure they all have different
server ID's.
Good luck... hopefully someone else has better advice :)
Jake
On Wed, Oct 29, 2008 at 2:47 AM, Waynn Lue <[EMAIL PROTECTED]>
through the most
common tweaks you might need. mysqlreport is more in-depth, but less
hand-holding... good for after the tuning primer one. The blog is just
lots of general info...
Good luck,
Jake
On Sat, Oct 25, 2008 at 5:50 AM, Grant Peel <[EMAIL PROTECTED]> wrote:
> Hi all,
>
>
On 9/19/08, Kinney, Gail <[EMAIL PROTECTED]> wrote:
>
> Hello, We have MySQL 4.0.14 and have just gotten an error:
>
Please help.
>
Answer the door, 2004 is calling.
--
-jp
I hope that someday we will be able to put away our fears and prejudices and
just laugh at people.
deepthoughtsbyjackh
On 7/19/08, Rob Wultsch <[EMAIL PROTECTED]> wrote:
>
> On Sat, Jul 19, 2008 at 6:54 AM, Jake Peavy <[EMAIL PROTECTED]> wrote:
> > I may be wrong, but I think you could accomplish this through the use of
> > triggers. Triggers are designed to monitor data change ac
On 7/18/08, Jason Yergeau <[EMAIL PROTECTED]> wrote:
>
> Hi Rob ---
>
> MySQL 5.
>
>
>
> On Fri, Jul 18, 2008 at 3:01 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote:
> > On Fri, Jul 18, 2008 at 2:00 PM, Jason Yergeau <[EMAIL PROTECTED]>
> wrote:
> >> I'm having trouble working through a data problem. A
first THEN SELECT * FROM
files ORDER by file_id
I would suspect this can be accomplished by a sub query somehow but I
don't know how.
Thanks,
- Jake
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On 4/5/08, Jonathan Mangin <[EMAIL PROTECTED]> wrote:
>
> I'm getting incorrect results from a sum and wonder if
> anyone sees something obviously wrong. (Won't surprise
> me.) Leaving 'simple' out of the equation (or adding
> 'simple' values manually) gets me the correct number.
>
> $menu is a per
Hello,
Not sure if this is known or not but I just wanted to let you guys
know that MySQL 5.1.21 fails the make. I've never had this problem on
other versions of mysql. It looks like GNU make worked all the way
through but why won't regular make work anymore?
- Jake
--
MySQL Gener
Hi all,
Can someone suggest a good method or normalized schema for storing product
information (id, description, price) which changes over time so that as a
product is gradually discounted, an order will reflect the cost of that
particular product at that particular time?
--
-jp
At birth, Chuck
On 5/4/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
Hi,
Jake Peavy wrote:
> On 5/4/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
>>
>> Mark Leith wrote:
>> > Baron Schwartz wrote:
>> >> I will test again on my servers now that I have upgraded t
-- Forwarded message --
From: Jake Peavy <[EMAIL PROTECTED]>
Date: May 4, 2007 7:41 AM
Subject: Re: expire_logs_days
To: Baron Schwartz <[EMAIL PROTECTED]>
On 5/4/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
Mark Leith wrote:
> Baron Schwartz wrote:
>&
On 2/6/07, Yong Lee <[EMAIL PROTECTED]> wrote:
Hi all,
Just wondering how people are dealing with tables that are used for
logging, ie: insert only tables supporting occasional queries used for audit
or event logs.
These tables will keep growing and there is no need to keep them that
large
On 1/25/07, Sid Lane <[EMAIL PROTECTED]> wrote:
all,
I have been tasked with upgrading a critical 3.23.55 database to 5.0
(.27-ish).
short version is it's never been upgraded because authors have moved on
and
nobody's sure of everything that uses it.
I enabled the general log a few days ago an
On 1/11/07, Dan Nelson <[EMAIL PROTECTED]> wrote:
In the last episode (Jan 11), Jake Peavy said:
> On 1/11/07, Gilles MISSONNIER <[EMAIL PROTECTED]> wrote:
> >How could I load in the database, data from a text file containaing
> >date in a NOT MySQL standard date form
On 1/11/07, Gilles MISSONNIER <[EMAIL PROTECTED]> wrote:
hello,
I rewrite my question in a simpler (?) way :
How could I load in the database, data from a text file containaing date
in a NOT MySQL standard date format [precisely char(10)], so that I get
the date into a MySQL standard date forma
-- Forwarded message --
From: Jake Peavy <[EMAIL PROTECTED]>
Date: Jan 4, 2007 10:48 PM
Subject: Re: mysql data into CSV file.
To: Shain Lee <[EMAIL PROTECTED]>
On 1/4/07, Shain Lee <[EMAIL PROTECTED]> wrote:
I wanted to get that info which has stored in rela
On 12/6/06, Mikhail Berman <[EMAIL PROTECTED]> wrote:
-Original Message-
>
From: Dotan Cohen [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, December 06, 2006 3:37 PM
> To: MySQL General
> Subject: How many records in table?
>
> What's a quick query to determine how many records a given tab
As I only qualify as 'barely literate' as a Unix admin, does anyone know of
a good article on inode count, or, even better, one as it pertains to
partitioning?
I'm thinking about developing a two partitions per month per table schema
but I'm worried about the sheer number of files this will creat
On 7/10/06, Kishore Kumar Barik <[EMAIL PROTECTED]> wrote:
< snip >
Please send me solution immediately.
anything else, your highness?
--
-jp
Chuck Norris got in touch with his feminine side, and promptly got her
pregnant.
On 7/6/06, Jake Peavy <[EMAIL PROTECTED]> wrote:
On 7/6/06, Chuck Holzwarth <[EMAIL PROTECTED]> wrote:
>
> Is there a way to set the auto_increment start number? I am trying to
> set up a development and test system and the application that is writing to
> the tables
On 6/13/06, Jake Peavy <[EMAIL PROTECTED]> wrote:
On 6/7/06, Jake Peavy <[EMAIL PROTECTED]> wrote:
>
> On 6/7/06, Paul DuBois <[EMAIL PROTECTED]> wrote:
> >
> > At 17:30 -0600 6/7/06, Jake Peavy wrote:
> > >Hey yall,
> > >
> > >I&
On 5/24/06, Dan Trainor <[EMAIL PROTECTED]> wrote:
Hi -
I would like to be able to replicate all queries from a live MySQL
server, to a testing server at the office.
The reason for doing this is to test load under [semi]real-world
conditions with the new server. I think that by doing somethin
On 6/7/06, Jake Peavy <[EMAIL PROTECTED]> wrote:
On 6/7/06, Paul DuBois <[EMAIL PROTECTED]> wrote:
>
> At 17:30 -0600 6/7/06, Jake Peavy wrote:
> >Hey yall,
> >
> >I'm unable to open the .chm I just downloaded for 5.1. I get the
> followi
On 6/8/06, Jay Pipes <[EMAIL PROTECTED]> wrote:
Jesse wrote:
> I have been using Microsoft SQL Server for a while, and I'm now trying
> to switch all our applications over to use MySQL. Microsoft SQL Server
> is pronounced "Sequel Server". Is MySQL pronounced "My Sequel", or is
> it pronounced
On 6/7/06, Paul DuBois <[EMAIL PROTECTED]> wrote:
At 17:30 -0600 6/7/06, Jake Peavy wrote:
>Hey yall,
>
>I'm unable to open the .chm I just downloaded for 5.1. I get the
following
>error:
>
>Cannot open the file: mk:@MSITStore:C:\Documents and Settings\jpeavy1\My
Hey yall,
I'm unable to open the .chm I just downloaded for 5.1. I get the following
error:
Cannot open the file: mk:@MSITStore:C:\Documents and Settings\jpeavy1\My
Documents\refman-5.1-en.chm.
Any ideas?
TIA
--
-jp
One time in an airport a guy accidently called Chuck Norris "Chick Norr
On 6/1/06, Lukasz Budnik <[EMAIL PROTECTED]> wrote:
name column is:
`name` varchar(50) NOT NULL default 'NN'
and table is DEFAULT CHARSET='latin2' but as I wrote before
all those names have only latin1 characters
I am not able to reproduce it on 5.0.16 on WinXP.
mysql> DROP TABLE IF EXIS
On 5/31/06, Lukasz Budnik <[EMAIL PROTECTED]> wrote:
I'm losing my mind - no idea what's going on with this name.
Any hints most welcome ;)
Show your show create table?
--
-jp
Chuck Norris does not teabag the ladies. He potato-sacks them.
On 3/27/06, Lucas Vendramin <[EMAIL PROTECTED]> wrote:
>
> Thank you.
> The INET_ATON() function works fine. :D
> I hope this solution save me.
> Thanks.
>
> > Take a look at the MySQL function INET_ATON and it's counterpart (I
> don't
> > remember what it's counterpart is but it should be easy to
On 3/14/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
> "Jake Peavy" <[EMAIL PROTECTED]> wrote on 03/14/2006 01:52:28 PM:
>
>
> > On 3/10/06, Jake Peavy <[EMAIL PROTECTED]> wrote:
> > >
> > > On 3/7/06, C.R.Vegelin <[
On 3/10/06, Jake Peavy <[EMAIL PROTECTED]> wrote:
>
> On 3/7/06, C.R.Vegelin <[EMAIL PROTECTED]> wrote:
>
> > Hi Ariel,
> >
> > Maybe this example helps you to create CSV output from MySQL.
> > The first SELECT generates the headerline; the second the
On 3/7/06, C.R.Vegelin <[EMAIL PROTECTED]> wrote:
> Hi Ariel,
>
> Maybe this example helps you to create CSV output from MySQL.
> The first SELECT generates the headerline; the second the data.
> ( SELECT 'FieldA','FieldB','FieldC', ... )
> UNION
> ( SELECT `FieldA`, `FieldB`, `FieldC`, ...
> INTO
On 3/3/06, Vinay <[EMAIL PROTECTED]> wrote:
>
> Hello,
>I am trying to install DBI and mysql DBD for perl on HP-UX 11.23i. I
> have installed DBI successfully but having a hard time installing DBD for
> mysql on HP-UX.
> I am getting make errors while installing. I want to use perl to connect
>
On 2/3/06, Andrew Braithwaite <[EMAIL PROTECTED]> wrote:
>
> Hi everyone,
>
> Does anyone know if there is a way to get the last access time from a
> mysql table through mysql commands/queries?
>
> I don't want to go to the filesystem to get this info.
>
> I understand that this could be tricky esp
On 1/30/06, Jacques Brignon <[EMAIL PROTECTED]> wrote:
>
> I would like some advice on the various and best ways of finding the rank
> of the
> row which satisfies a given condition in a rsult set.
>
> Let's assume that the result set includes a field containing an identifier
> from
> one of the t
DROP TABLE IF NOT EXISTS?
On 1/16/06, Michael Williams <[EMAIL PROTECTED]> wrote:
>
> Hi All,
>
> Having a bit of mysqldump trouble again. I've looked over the
> documentation (again) and can't seem to find the flag to make
> 'mysqldump' out put "CREATE TABLE IF NOT EXISTS". Any ideas?
>
> Reg
On 1/12/06, Mark Phillips <[EMAIL PROTECTED]> wrote:
> There is a column in my table with string values, but the strings have
> spaces
> in them. I want to read the unique column values into an array in my bash
> script, so I can use these values in a separate query on this table. How
> do I
> get
Hey yall,
I have a delimited text file I'm trying to load into my db. The problem is
that for whatever reason (totally beyond my control) the line and field
delimiters include an Extended ASCII char (0xA0) like so:
05HIUT841427BLCA á Dell Computer á"One *Dell* Way, *Round
Rock*Texas 786
On 1/6/06, Brian Dunning <[EMAIL PROTECTED]> wrote:
>
> On Jan 5, 2006, at 9:38 PM, Michael Stassen wrote:
>
> > DATEDIFF was added in 4.1.1. What version of mysql do you have?
>
> Thanks Michael - that was indeed the problem. Some ancient-ass
> version that's been on my development server for who
you could also have a look at
http://dev.mysql.com/tech-resources/articles/mysql-triggers.pdf which I
found useful.
-jp
e found a bit similar issue related to building php-mysql extension
>
> on MySQL forums. The person declares that he has solve the problem. May
>
> be it will help you:
>
> http://forums.mysql.com/read.php?52,9,9,quote=1`
>
>
>
>
>
>
>
>
>
> J
r.so.1
/platform/SUNW,Ultra-80/lib/libmd5_psr.so.1
On 12/7/05, Mir Islam <[EMAIL PROTECTED]> wrote:
>
> hmm it appears that the module got compiled fine. Try doing:
> ldd /export/home/root/.cpan/build/DBD-mysql-3.0002
> /blib/arch/auto/DBD/mysql/mysql.so
>
> and see if a
Since I didn't get a response from the perl list, and since Daryn received
some responses to his similar question I thought I might see if you guys had
any ideas on why I can't make test for DBD::mysql on Solaris.
TIA,
F
-- Forwarded message ------
From: Jake Peavy <[EM
Also, do you know if there is any way at all to do the tiniest amount of
research on my own to find out even the most basic information about MySQL
without bothering an entire worldwide mailing list with my trivial
questions?
Hey, I sent this a while ago, but never received a response.
This still seems to exist under 5.0.15-standard (at least under
mysql-standard-5.0.15-linux-i686-glibc23)
Can anyone from MySQL comment on this or should I open it as a bug?
Thanks,
JP
On 6/11/05, Jake Peavy <[EMAIL PROTECTED]>
Hey, sorry everyone - I figured it out.
I had to add the following to my.cnf
read-only
skip-innodb
I guess I shoulda kept googling before asking... mybad.
/JP
On 9/21/05, Jake Peavy <[EMAIL PROTECTED]> wrote:
>
> Hey yall,
> I'm trying to use a DVD (containing a num
donly directory as the datadir? Are there
other options I can specify in my.cnf where I can tell mysqld to write the
error files/etc?
TIA,
Jake
fully chosen table names to keep things organized? What have
others done in this situation?
Thanks,
Jake Krohn
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On 6/16/05, Gabriel B. <[EMAIL PROTECTED]> wrote:
> If i have a table with about 800M records. and one of the fields is a
> enum("a", "b", "c") and i want to change it to enum("a","b","x")
My understanding (such as it is) is that the best way to do this is to add a
second column with enum('a','b
On 6/17/05, asteddy <[EMAIL PROTECTED]> wrote:
> Hello,
> I have found Mysql Performance Tuning Seminar available for download, but I
> don't know how to see it.
Use the WebEx player at http://www.meetingcenter.net/record_play.htm
-JP
--
MySQL General Mailing List
For list archives: http://lis
Has anyone been able to use a named pipe for their general query log
(or any of the other logfiles for that matter)?
I tried the following as user mysql:
rm /var/lib/mysql/myhost.log
mkfifo -m 0660 /var/lib/mysql/myhost.log
but the mysql server would not start.
I think it would be very useful
Hello,
I was wondering when or will views be supported?
--
Jake Johnson
http://www.plutoid.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
.
Thanks for the quick responses :-)
Jake Walters
> Can I ask why?
>
> Why not define a char(50) (or whatever size) with the relative or complete
> path to the .tar file? Storing it in your database would create huge row
> sizes.
>
> Joshua Thomas
> Network Operat
tutorial and I can create the database and tables, but I can't seem to
insert the .tar file properly...Any pointers would be appreicated...
Thanks,
Jake
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I am trying to select the column names from a table to be displayed in a
web page. Is there anyway to select column names without desc?
Thanks,
Jake Johnson
[EMAIL PROTECTED]
__
Plutoid - http://www.plutoid.com - Shop Plutoid
Thanks for your help. I found that the permissions to the files were wrong
and I had to restart mysql. I also needed to repair t_table to get things
back to normal. I was scared I lost my data, but only for a second :-).
Regards,
Jake Johnson
[EMAIL PROTECTED
How do I fix this error? My tables have data.
Regards,
Jake Johnson
[EMAIL PROTECTED]
__
Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on
Rims, Car Audio, and Performance Parts.
--
MySQL General Mailing
Still the same problem, but I am still able to select from the DB using
mysql.
Regards,
Jake Johnson
[EMAIL PROTECTED]
__
Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on
Rims, Car Audio, and Performance
ENCODE("hello","goodbye")) |
+--+
|0 |
+--+
1 row in set (2.59 sec)
Regards,
Jake Johnson
[EMAIL PROTECTED]
__
Plutoid - http://www.plu
I am using php and mysql and I want to show the column names. How do I go
about doing this without hardcoding the headers in my php?
Regards,
Jake Johnson
[EMAIL PROTECTED]
__
Plutoid - http://www.plutoid.com - Shop Plutoid
ydb
-
-- Server version 3.23.49-log
Does anyone have any ideas why this doesn't work anymore?
Regards,
Jake Johnson
[EMAIL PROTECTED]
__
Plutoid - http://www.plutoid.com - Shop Plutoid for
my table is small but I can't tell what is faster.. a max or a limit
mysql> select max(counter) from web;
mysql> select counter from web order by counter desc;
They seem to be the same in performance.
Regards,
Jake Johnson
[EMAI
No kidding. I didn't know that. Thanks a lot!
Regards,
Jake Johnson
[EMAIL PROTECTED]
__
Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on
Rims, Car Audio, and Performance Parts.
On Mon, 14 Jul
Be careful! Phil wanted the top 20 and the limit 20 will only return a
random 20 records.
Regards,
Jake Johnson
[EMAIL PROTECTED]
__
Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on
Rims, Car Audio, and
If you want to add another column name, just insert a new record into
Contract Column Lookup
--
col_id
col_name
Regards,
Jake Johnson
[EMAIL PROTECTED]
__
Plutoid - http://www.plutoid.com - Shop
_name
Contract table
user_id
Cont_id
col_id
qty
This should be a good start...
Regards,
Jake Johnson
[EMAIL PROTECTED]
__
Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on
Rims, Car Audio
Have you tried single quotes (ie. registry_program='EA')?
Regards,
Jake Johnson
[EMAIL PROTECTED]
--
Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on
Rims, Car Audio, and Performance Parts.
On M
Yes, that works for Teradata and Oracle as well.
Regards,
Jake Johnson
[EMAIL PROTECTED]
--
Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on
Rims, Car Audio, and Performance Parts.
On Thu, 26 Jun 2003 [EMAIL
Cool, Thanks a ton. I think I will stick with mysqldump for a while until
my tables get too large. Currently my backups only take a few seconds.
Regards,
Jake Johnson
[EMAIL PROTECTED]
--
Plutoid - http://www.plutoid.com - Shop
Is this better than using mysqldump?
Regards,
Jake Johnson
[EMAIL PROTECTED]
--
Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on
Rims, Car Audio, and Performance Parts.
On Thu, 26 Jun 2003, SAQIB wrote
What is the purpose of the join? I think I know what you are trying to do
so make the first query a sub query and join the subquery to the carello
table.
Regards,
Jake Johnson
[EMAIL PROTECTED]
--
Plutoid - http://www.plutoid.com
Nice approach Bruce, but I too won't have any problems with your
case because I am grouping by sku and stock in the sub-query.
Regards,
Jake Johnson
[EMAIL PROTECTED]
--
Plutoid - http://www.plutoid.com
Shop Plutoid for the
Hello Greg,
You are much better off using a not exists clause...
delete from child c
where not exists ( select 1 from parent p
where p.id = c.id)
Regards,
Jake Johnson
[EMAIL PROTECTED]
--
Plutoid - http
This is one quick way to get the newest records of a group if you are
grouping by the sku and stock.
select stock, sku, qty
from table
where concat(dt_tm,stock,sku) IN (
select concat(max(dt_tm), stock, sku)
from table
group by stock, sku
)
Regards,
Jake Johnson
[EMAIL PROTECTED
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
alex, chuck a copy of phpMyAdmin onto the machine.
edit the phpMyAdmin configuration file to your username and password and
load it up on the loopback address.
you should find a button saying 'reload mysql' on the page.
phpMyAdmin rules!!!
cheers,
jake
on 21/5/02 1:43 pm, Alex
and rarely give me hassle - redhat on the overhand has
been a nightmare to set up but then again, i'm only starting out on it...
the main thing is windows offers so many other web technologies (plugin 'n
stuff) that i need it!
bloody microsoft!
cheers,
jake
on 25/3/02 18:33, Andrew Haze
et up from access, you can then use the 'Insert
textfiles into table' function to load all the information.
a bit time consuming but it does work! phpMyAdmin is wicked as well
hope this helps,
jake
>
>
> I have a project where I may need to connect an MS ACCESS db and MyS
user' would be able to do a full range of tasks with
the database.
i'd then also set-up 'web' permissions so that hosts connecting in can
select, insert, delete and update rows in the tables - that way the php
scripts can talk to the database.
hope this helps!
cheers,
jake
p
hello!
i've been developing a MySQL database in mac osX - i would like to transfer
it to work onto a win2k box running apache and mysql.
what files from X do i need to copy over? is this a fairly simple process or
am i heading for a world of pain?!
cheers,
jake
p.s. if this is possible,
bout
starting the mysql daemon using /var/lib/mysql ect ect
i also tried the:
service mysqld start
and get a message saying:
mysqld: unrecognised service
have i missed something again?
thank you for any help you can chuck my way!
many thanks,
jake
p.s. has anyone ever found a co
e section 2.4 Post-installation Setup and Testing.' where
it all goes wrong - none of the directories seem to be there!
in your new server wisdom dus you have any advice?? driving me bonkers...
cheers dude,
jake
-
Before
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=10M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50
Any assistance you can provide would be greatly appreciated.
Jake DiMare
Premier
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=10M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50
Any assistance you can provide would be greatly appreciated.
Jake DiMare
Premier
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=10M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50
Any assistance you can provide would be greatly appreciated.
Jake DiMare
Premier
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=10M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50
Any assistance you can provide would be greatly appreciated.
Jake DiMare
Premier
1 - 100 of 103 matches
Mail list logo