I'm wanting to add a new field to my table that I will both be grouping by,
searching with full text hits and plain likes..
I know I'll need a FULL TEXT index, but will that full text index also index
like a normal index will? or should I also add an index too..
thanks.
try
SELECT * from geno_260k WHERE ident IN (SELECT ident FROM geno_260k WHERE
a1=0
GROUP BY ident HAVING count(a1)>25);
This will give you what you're deleting first.. then if that is good. do
DELETE FROM geno_260k WHERE ident IN (SELECT ident FROM geno_260k WHERE
a1=0
GROUP BY ident
table_cache.
- Original Message -
From: "Justin" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, September 04, 2007 1:46 PM
Subject: Memory Issue would someone confirm
alright.. after some testing this afternoon I'm beginning to wonder if
this is a memory issue.. here's w
alright.. after some testing this afternoon I'm beginning to wonder if this
is a memory issue.. here's what the test was..
I did a insert select from a table that has approx 500,000 rows and the
table data is about 1gb in size.. the query went and was in the repair by
sorting phase when all of
-
From: "Baron Schwartz" <[EMAIL PROTECTED]>
To: "Justin" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, September 03, 2007 4:42 PM
Subject: Re: servers full potential / FT searches locking tables
Justin wrote:
lockup just happened again.. here's a innodb stat
+
1 row in set, 1 warning (0.06 sec)
- Original Message -
From: "Justin" <[EMAIL PROTECTED]>
To:
Sent: Fr
- Original Message -
From: "Michael Dykman" <[EMAIL PROTECTED]>
To: "Justin" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, August 28, 2007 1:31 PM
Subject: Re: servers full potential / FT searches locking tables
No, I'm afraid not. 32 bit architectures have
heh.. ok I'll throw that at my system tech. and see what it's going to
take to get a 64bit version of an OS.
for now I'll limit to 2.5
thanks michael.
- Original Message -
From: "Michael Dykman" <[EMAIL PROTECTED]>
To: "Justin" <[EMA
eu Bruneau" <[EMAIL PROTECTED]>
To: "Justin" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, August 28, 2007 12:51 AM
Subject: Re: servers full potential / FT searches locking tables
Your settings doesn't seem optimized much.
So here first question, do you use 32bits or 64 bi
x27;s a LAMP backend..
- Original Message -
From: "Jay Pipes" <[EMAIL PROTECTED]>
To: "Rolando Edwards" <[EMAIL PROTECTED]>
Cc: ; "Justin" <[EMAIL PROTECTED]>
Sent: Monday, August 27, 2007 3:03 PM
Subject: Re: servers full potential / FT searches
ge -
From: "Jay Pipes" <[EMAIL PROTECTED]>
To: "Justin" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, August 27, 2007 2:26 PM
Subject: Re: servers full potential / FT searches locking tables
SELECTs don't lock the table. Are you having frequent UPDATEs while
s
at happens. Is there any way not
to lock the tables on a Full Text search? (does that make sense?)
thanks again for any insight
Justin.
Here's a dump of the my.cnf and the phpmyadmin dump of vars.
/etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
0316 2this is version 2 This was the first one
today but agian we needed to update.
does that make sense?
- Original Message -
From: "Olexandr Melnyk" <[EMAIL PROTECTED]>
To: "Justin" <[EMAIL PROTECTED]>;
Sent: Saturday, March 17, 200
der by `rev` DESC
I would think this would return
20070315 - 2
20070316 - 2
but it doesn't it returns
20070315 - 1
20070316 - 1
What am I missing? I'm trying to do a group by the date and return the
higher rev..
thanks agian!
Justin.
--
MySQL General Mailing List
For list ar
ks in advance.
Regards,
Justin Palmer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I forgot to mention that it is happening from my ant scripts too. So the
problem is occurring outside of the query browser as well. However, from the
command line I can execute the two statements.
Any ideas what could be causing this?
-Original Message-
From: Justin Moore
Sent
Hi,
Anyone know why I can't run multiple commands from the query browser using
semicolons to separate the commands?
ex:
The following command works fine:
select now();
However the following commands do not
select now();
select version();
Your help is appreciated,
-JM
--
MySQL General Mail
Good Afternoon,
In Oracle there is a keyword called RETURNING, where I can do an insert
and specify what row to return, this helps with autoincrement fields;
How can I achieve this in MySQL?
Thanks a bunch!!
-- Justin W. Burger
--
MySQL General Mailing List
For list archives: http
When I open over nine connections to mysql I see vi.recover in my show
databases output. The existing connections stay open and continue to
operate. No new database connections can be made at this point. I should
be seeing the mysql, phpdig and test databases when performing the query
but I on
Chris W. Parker wrote:
interesting you say that because i was going to do this same thing
except not as completely as i probably should (which i think is what you
are suggesting). what i mean is, my extra table of addresses was going
to be merely shipping addresses for the customer and nothing else
What you have so far looks good, but what I learned from doing my ecomm
project was that it is beneficial to make a separate table for anything
and everything that you might have more than one of... Addresses, phone
numbers, and email addresses are all great candidates for breaking out
into an
nance (backups, etc.) a chore.
Ruben Safir Secretary NYLXS wrote:
How does that help? The database itself should be allowed to organize
everything.
Ruben
On Thu, Oct 07, 2004 at 04:57:39PM -0700, Justin Smith wrote:
Is it possible to create a database in a lower-level subdirectory of
MySQL&#
Is it possible to create a database in a lower-level subdirectory of
MySQL's data directory? We have almost 100,000 sites, and we would like
to have a separate database for each site. However, it's very
impractical from a filesystem maintenance standpoint to have 100,000
subdirectories of MyS
ng I might be missing something in regards to primary
keys...
Can a primary key (or unique key) be established on two columns (eg
primary key = client_id + post id)?
Can an auto-increment column only increment in relation to the client
id?
Or am I expecting *way* too much out of MySQL and rela
I am creating an index on a very large innodb table that is taking a
very long time to complete which I understand is a limitation of
innodb.
The problem is that another application has been issuing queries
against the table and those queries have never timed out. So now I
can't kill the connecti
more complex query -- can any
one lend a hand?
My guess is maybe something like
SELECT article.title, article.user_id, user.username
FROM article, user
WHERE user.id = article.user_id
---
Justin French
http://indent.com.au
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
I have the same problem. I have an open bug report here:
http://bugs.mysql.com/?id=4761
I can't figure out why my management server can not see my ndb
servers. Perhaps I should try to down the secondary interface on all
the servers?
On Tue, 17 Aug 2004 15:54:29 -0400, Wheeler, Alex <[EMAIL PROT
Are you swapping? Check vmstat and iostat
Are your queries optimized, are they doing full table scans? Enable
the slow query log.
On Mon, 16 Aug 2004 14:48:35 +0200, Fahr o Mavastradioz
<[EMAIL PROTECTED]> wrote:
> Hello people,
>
> I'm currently configuring a quad CPU system as a standalone
Oracle has a procedure called DBMS_APPLICATION_INFO.SET_APPLICATION_INFO
that allows you to specify up to 64k of addtional information about
the current connection. It doesn't have any way to specify this
information at connect time though.
The data can be accessed in Oracle through the V$SESSION
is "if I am not
backlogged, then I am up"
On Tue, 10 Aug 2004 17:50:27 -0400, Mayuran Yogarajah
<[EMAIL PROTECTED]> wrote:
> Justin Swanhart wrote:
>
> Im curious about this part.
>
> >My healthcheck logic will make sure that server A doesn't ap
FYI, the atomicity of rename and using it to swap tables is discussed
in the manual here:
http://dev.mysql.com/doc/mysql/en/RENAME_TABLE.html
Justin
On Tue, 10 Aug 2004 13:50:34 -0700, Haitao Jiang <[EMAIL PROTECTED]> wrote:
> It would be great if there is a swap table command that
You can put multiple renames in one statement, and the entire rename
will be atomic..
I create "summary" tables from some of my data, and I periodically
refresh them. When refreshing them I create new tables to replace the
old tables with..
Then I do:
rename current_table to old_table, new_table
.
Does this sound like a good idea, or should I be thinking about some
other way to do this?
Justin Swanhart
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
There must be an even number of replicas because the cluster mirrors
data between two machines. It doesn't do "three way" mirroring. An
even number of nodes are required because each two data nodes becomes
a node group.
If you have three machines, you could create two NDB processes on each
machi
Because not doing so violates the SQL standard. Allowing you to
included non aggregated columns in the SELECT list is a non standard
MySQL extension to the SQL language. You will get an error in other
products, such as oracle, where you will get a "xxx is not a group by
expression" error.
Inform
Can someone give me a quick/clear explanation about why you would
create a table with columns of NULL / NOT NULL?
I clicked around the MySQL manual last night I *think* I know what's
what, but it'd be great to read one clear paragraph that summarises it
all.
---
Justin F
;m inclined to believe that if you can create a db connection handle, then
> any other process should be able to use it, as long as the creating
> process/parent process is still alive/running
>
> -bruce
>
>
>
>
> -Original Message-
> From: Justin Swanhart [mailto:[EMAIL PR
TOP is a microsoft SQL extension.
MySQL uses the LIMIT clause.
for instance, the following is a rather typical "top 10" sql query:
select some_column, sum(another_column) total
from some_table
group by some_column
order by total desc
LIMIT 10
On Wed, 28 Jul 2004 14:39:11 -0400, Kamal Ahmed
<
but it's there.
Cheers,
Justin
Quoting Mark Matthews <[EMAIL PROTECTED]>:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Steve Richter wrote:
>
> | In light of the licensing restrictions on using MySql in a commercial
> | package, why would MySql be
You probably want to pick up a good SQL book. MySQL by Paul DuBois is
a really good one.
http://www.amazon.com/exec/obidos/tg/detail/-/0735712123/qid=1090786499/sr=8-2/ref=pd_ka_2/102-0741496-3072118?v=glance&s=books&n=507846
You want to use the WHERE clause of the select statement.
SELECT tabl
Create a seperate table called member_interests or something similar
Store one member_id and one interest_id (or whatever you have your PKs
named) in each row.
This is similar to an order entry system, which typically has one
table for order_headers and one for order_detail. The order_header
tab
While the extension on the file isn't set in stone, many people add
the .dmp extension to files created with the Oracle exp utility.
You can use a third party utility call nxtract
(http://www.elmbronze.co.uk/nxtract/index.htm) to convert exp files
into tab delimited files. The eval version only d
MySQL doesn't guarantee that there will be no gaps in sequence values.
Assigment of the id is always atomic because innodb uses an AUTO_INC
lock that lasts for the time of the insert, not the life of the
transaction.
lets say your highest order number is 10
transaction begins for client 1
inse
Version 4.0 doesn't support subqueries.
In any event, your query would return all rows from
channels as long as there are any rows in users, which
I doubt is what you intended.
--- nambi c <[EMAIL PROTECTED]> wrote:
> Hi,
>
> My server version : 4.0.18-max-nt
>
> I have created 2 tables 'chan
--- matt ryan <[EMAIL PROTECTED]> wrote:
> >Do you ever delete from this table?
>
> Temp table is trunicated before the EBCDIC file is
> loaded
I meant the history table :)
> >Have you removed the unecessary duplicate key on
> the first column of your primary key?
>
> Have not touched the DIC in
arlier was because I wasn't aware that a temporary
table was being loaded first.
Do you ever delete from this table?
Can you post the results from
"show variables" for us?
Have you removed the unecessary duplicate key on the
first column of your primary key?
Thanks,
Justin
You do have ByteOrder: Big in the .ini file for the
sparc database servers, right?
--- Alexander Haubold <[EMAIL PROTECTED]> wrote:
> Hi everyone,
>
> Just to follow up on my previous post regarding
> Cluster on Sparc/Solaris 9:
> On an x86 Solaris 9 machine that was set up similar
> to the Sp
nce loss by having all 20,000 articles in one table, with
a indexed `siteID` column identifying which site each article belongs
to, as opposed to 100 tables (one for each site) holding only their own
data??
Should I worry at 40,000? 100,000? Or will the indexing of the siteID
keep everything extens
> I've used it, with oracle, but oracles index
> searches are better, hit
> the best one first, then 2nd best, then 3rd, but I
> really dont want to
> go to oracle, it's too complicated for my tech's
Oracle rarely performs index merges, but it does have
the ability to do, which mysql lacks.
> Qu
Insert ignore doesn't insert the record if there is a
duplicate. It simply doesn't insert the row. Without
the IGNORE clause, the query would generate an error
insert of silenty ignoring the insert.
--- [EMAIL PROTECTED] wrote:
> That's the whole point. Eliminate your indexes and
> your load pro
g table. Once again, this only works if you don't
need the primary key on the big table. This will use
more CPU/memory but it may get around your read
problems.
Justin
--- matt ryan <[EMAIL PROTECTED]> wrote:
>
> >
> > You might be out of luck with MySQL ..
Indexes can generate vast amounts of random i/o.
Because of rotational latency, random i/o can really
slow you down, especially if you are using IDE or SATA
disks because they can't do tagged queueing like SCSI
disks can.
If you have the budget for it, I would consider
getting some solid state di
yone else built a hold system before that might be able to help me
out with some pointers?
I hope this makes sense. If not please ask for clarification. As always
I appreciate any assistance.
Thank you,
Justin Palmer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Creating a key will make that query execute very fast,
but if that is the only reason for the key you are
going to be trading quite a lot of space for the speed
of one query.
How often are you going to run this query? If you
have 324 million rows, then that index is going to
consume somewhere i
Does access_no contain actual textual data, or is it
simply a key like a category or an integer? If you
don't need to do a fulltext search against access_no
then there is no reason to include it in your fulltext
index. You should most likely have a seperate index
for access_no in that case.
The
An option would be a log reader program that uses
Oracle log miner to only show commited transactions
from the redo logs. You could then replay the SQL
that is being executed on the oracle box on the mysql
server as long as the tables are defined the same.
9i has an enhanced log miner that can be
t,last,email
otherwise you would get an error that "first is not a
GROUP BY expression".
That query would return four rows on your data, each
with a count of 1.
My apologies,
Justin
>
> create table bar ( email varchar(64), first
> varchar(64), last
> varchar(64) );
You are doing an implicit group by of first, last as
well as your explicit group by of email.
So you could have two records with the same e-mail
address generate two records with your group by
Justin Time [EMAIL PROTECTED]
Justin Credible [EMAIL PROTECTED] --DUPE--
Case differences
Having that many instances on one box is going to be a
management nightmare. I can only imagine the recovery
scenarios should you have a hardware problem. Perhaps
you may want to think about writing your metric data
to a local mysql instance then pulling the data from
each instance into the depot
> Does that mean the max. string that can be indexed
> and therefore searched on is 500 chars? What exactly
> is this limitation?
I may have been wrong on this limit. I know I read
about it somewhere, but I can't seem to find out where
at the moment. Since the fulltext index is maintained
as a se
A beta takes as long as a beta takes. That is really
the nature of beta testing. As for an approximate
timeline, I've heard various quotes, but most people
seem to think somewhere late third quarter that the
release will be marked "stable."
4.1.3 is really quite stable and you should have very
Keep in mind that if you create an index on multiple
fields, then all of those fields must be searched at
once. You can't index product_name, product_desc and
product_category for instance, then only search on the
product_name field using MATCHES.
If you want to bypass this (and many other
limita
rpm -qa|grep mysql will show you what mysql
packages you have installed.
You probably have both 3.x and 4.x packages installed
and assuming you don't have a 3.x database you want to
preserve, I would suggest uninstalling the 3.x package
with rpm --erase name_of_3.x_package
To determine where the
I highly recommend simply using ext3 for your Linux
setup. The 1 or 2 percent performance benefit that
you may get from raw partitions is way outweighed by
complexness of backups of the raw data.
either way:
First I would suggest you read the Linux RAID howto:
http://www.tldp.org/HOWTO/Software-
Do you have a hosts.MYD, or a hosts.frm file?
If you do, and there is no .MYI file, perhaps the
older version is just ignoring the table and not
making it available while the newer version errors
out.
If those files exist, try removing them from the data
directory (move them somewhere else) then
If you are usign 4.1 you could try:
SELECT DISTINCT d, title
FROM
(select p.id, p.title
from product p
join e_prod ep on ep.product=p.id
join story s on s.id = ep.story and s.status = 9 and
s.type = 14
where p.platform_id = 5 and p.genre_id = 23282
order by s.post_date desc
)
limit 10
otherwise
You can do it one of two ways.. Either you can do a
"self join" like the following:
select t1.userid
from answers t1,
answers t2
where t1.qid = 5
and lower(t1.answer)='student'
and t2.qid = 6
and lower(t2.answer) like 'edu%'
and t1.userid = t2.userid
or you can use a union (avail
Create a unique index on each column that you don't
want to be duplicated.
create UNIQUE index table_u1 on table(some_column)
--- John Mistler <[EMAIL PROTECTED]> wrote:
> Is there a way to do an INSERT on a table only if no
> row already exists with
> the same info for one or more of the columns
--- Asif Iqbal <[EMAIL PROTECTED]> wrote:
> gerald_clark wrote:
> > What about getting a bigger drive?
>
> I guess that would be my only option eh?
>
If any of your data can be considered "history" data
that is never modified, you could create compressed
myISAM tables for that data, removing it
LOCK TABLE active_table WRITE, history_table WRITE;
#assuming the columns in the tables are exactly
#the same
insert into history_table
select * from active_table;
delete from active_table;
UNLOCK TABLES;
if the columns aren't the same between the tables then
you need to do something like
No, that isn't possible using mySQL.
Try linking PHP with older client libraries (9.0.1,
8.1.5, etc) instead of the newer 9.2 libraries and see
if that fixes your problem with PHP. You can download
them from otn.oracle.com
swany
--- "Alonso, Claudio Fabian"
<[EMAIL PROTECTED]> wrote:
> Hello S
of 1.4TB of storage.
Any thoughts?
Thanx,
Justin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--- John Mistler <[EMAIL PROTECTED]> wrote:
> Is there a SELECT statement, if I have a table with
> 50 columns, to select
> every column EXCEPT the last one? Can I do this
> without typing the name of
> all 49 columns?
>
> If so, then what if I want to exclude the last TWO
> columns?
>
> Thanks,
Hey,
Maybe just whip something up and let us see. If there is more interest
after that then maybe you could do the latter.
Regards,
Justin Palmer
-Original Message-
From: Joshua J. Kugler [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 15, 2004 4:54 PM
To: [EMAIL PROTECTED]
Subject
Hi Joshua,
I would love to here more about multi-user issues (like record locking).
I searched the archives by the title and by your name with no luck. If
you don't feel like going into detail, could you point out some good
links to learn more about the subject.
Regards,
Justin P
Hi,
Can anyone give me a hint to what this error message is trying to say.
Thanks,
Justin Palmer
-Original Message-
From: Justin Palmer [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 15, 2004 1:38 PM
To: [EMAIL PROTECTED]
Subject: FW: Error ?
The query that generated this error
The query that generated this error was:
SELECT t1. *
FROM `wat_student_profile` AS t1, `wat_student_job` AS t2
LEFT JOIN t2 ON t1.student_id = t2.student_id
WHERE t1.cv != '' AND t1.sevis_id = '' AND t2.student_id = NULL
LIMIT 0 , 30
Regards,
Justin Palmer
-Origin
Hi,
I get this error from a query:
#1066 - Not unique table/alias: 't2'
What does it mean? Can anyone point me to a place where I can look up
what these codes actually mean?
Any help would be great.
Regards,
Justin Palmer
--
MySQL General Mailing List
For list arch
Hi,
Thanks. So what you are saying is if a record is not there it is
considered NULL?
Regards,
Justin Palmer
-Original Message-
From: Brent Baisley [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 15, 2004 12:54 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: SELECT
the id is not
in another table (The second id will be in the second table someday just
not today).
Not sure if this is possible at all or not, but thought I would ask.
Regards,
Justin Palmer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
abase being served off one central machine that also runs the active
directory and some accounting functions. I would be more than happy to
provide more information.
Justin Tulloss
> From: Peter Jönsson <[EMAIL PROTECTED]>
> Date: Fri, 2 Apr 2004 13:21:33 +0200
> To: Justin Tullo
?
Thanks for you help,
Justin Tulloss
Network Administrator
InterChez Logistics Systems, Inc.
ta model is right for this application.
The only catch is I have no idea where to look next. Hours of Googling
has returned very little.
Any hints on where to look next would be great.
---
Justin French
http://indent.com.au
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
nd
downgrading certain packages with no luck...
If anyone has any ideas at all I would be most grateful!
Thank you so much for any help you could offer!
Justin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
category and not the numerical value of the category?
Does this make sense?
Thanks,
Justin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Wednesday, February 11, 2004, at 03:29 PM, Keith Warren wrote:
I want to be able to track how many times any particular record is
returned from a search, and I have two ideas about how to do this. But
because I have little experience with MySQL, I may be totally off > base.
This database is
Hi,
Can someone please calrify when I would use VARCHAR 255, and when I
would use TINYTEXT (which also has a length of 255)?
Thanks,
Justin French
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi all,
I'm trying to merge and existing list of 900-odd email-list subscribers
into an existing membership system.
The existing system uses the userid (eg "Justin") as the primary key.
Obviously, I don't have the leisure of asking 900-odd people what their
preferre
On Tue, 2003-08-05 at 10:57, Paul DuBois wrote:
> At 10:30 -0700 8/5/03, Justin Hopper wrote:
> >Hello,
> >
> >I have a table with a FULLTEXT index on a column of type 'text'.
> >Searches on this table using MATCH() AGAINST() work fine for most
> >wor
rds are in there? Can I exclude words from the
stopword list without recompiling MySQL?
Thanks for any help.
--
Justin Hopper
UNIX Systems Engineer
Spry Hosting
http://www.spry.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Henry,
The information you've posted is a good start, can you post the results of
an EXPLAIN command? That would go a long way towards finding a solution.
--Justin
On Sun, 13 Jul 2003, Henry Hank wrote:
>
> I have the following SQL. The source table has 8.1 million ro
Well, for the image type at least, the blob type would be appropriate.
-justin
v7rg8 wrote:
Hi all,
my table is like this:
professor (name, gender, bodyImage)
Could anyone guide me how to deal with this image type data?
Another question is how to implement "weak entity" in mysq
Anybody have any recommendations for one that runs on Mac OS X?
Thanks!
Justin
On 6/12/03 9:21 AM, "Adam Nelson" <[EMAIL PROTECTED]> wrote:
> I like MySQL Manager - it costs a bit of money, but I find it
> indispensible.
>
> www.ems-hitech.com
>
> It r
y key(foo_id)
) type=innodb;
create table bar (
bar_idint unsigned auto_increment,
foo_idint unsigned,
bar_value int,
primary key (bar_id),
foreign key(foo_id) references foo(foo_id),
) type=innodb;
ERROR 1005: Can't create table './test/bar.frm' (errno: 150)
-justin
--
M
s
where I might further optimise this?
The only other thing I'm worried about is the fact that I'll have to do a
couple of queries PER HIT using this system (check if the row exists, then
either add one hit or insert a new row), rather than just a simple INSERT...
Any ideas on this too???
direction?
Justin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ossible. What I'm wondering
is:
Does this look like the right way to tackle the problem?
Should I use a HEAP table or TEMPORARY table to do this? Its going to be on
a webserver with hopefully some steady traffic so performance is a concern.
Any h
occasionally do the results
differ between each query, usually returning the same two rows.
The data in the two tables isn't identical, but both tables DO contain the
same number of rows, with the same IDs.
Where should I be looking for reasons why the RAND() isn't very random???
TIA
J
thank you in advance.
Justin
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]&
)
I know I need to include a count(), and select from both service and
pid2sid, but other than that, I'm lost :)
TIA
Justin
query,sql
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
1 - 100 of 184 matches
Mail list logo
