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
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
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
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
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
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
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
- 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
+
1 row in set, 1 warning (0.06 sec)
- Original Message -
From: "Justin" <[EMAIL PROTECTED]>
To:
Sent: Fr
-
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
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
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
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
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.
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
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
n't effect anything. Anyone have any ideas?
Justin Best
NOC - Infostations
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To requ
d max_allowed_packet - increase max_allowed_packet on master
(read_errno 0,server_errno=65535)
On the master, max packet is set to 8M.I have one slave server working
correctly and the other isn't.
Justin Best
NOC - Infostations
---
Under redhat you can type setup and choose the services you want to
start during boot.
Justin Best
NOC - Infostations
On Thu, 2002-07-11 at 09:45, David Kramer wrote:
> I tried to automate the starting and stopping of the mysql service upon
> reboot. I created the two links for mysql.ser
error,
but never seen any explanation as to WHY indexes corrupt, just to
repair them when they do..
thanks for any help.
-Justin
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.
.22 mysql talking to 3.23
server, and am wondering if this is this cause.
thanks
-Justin
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To re
et=1m
table_cache=300
sort_buffer=4m
record_buffer=2m
tmp_table_size=2m
thread_stack=128k
-Justin
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
'sending data' phase,
temporarily cured by server restart and/or table reorganization.
-Justin
On Thu, Mar 08, 2001 at 07:44:51AM -0600, Gerald L. Clark wrote:
> Justin wrote:
> >
> > I have a puzzle..
> >
> > Frequently, about, weekly? our data server get
dates are waiting...
at least this is my interpretation..
-Justin
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread,
est will hang for far too long...
as there is "always something selecting" on a table.. anybody
with experience with a select-priority mysql server setup?
-Justin
On Fri, Mar 09, 2001 at 03:58:31PM +1300, Quentin Bennett wrote:
> Hi,
>
> Imagine the scenario of the following
lumn?
How can the SQL server get things so fundamentally wrong and not report any error?
As with my previous posts to this list, this is the mysqld binary from
mysql.com, latest release of the 3.22 server..
thanks
-Justin
-
tly, or if you have no issues.
Today the ratio is currently 304 (3.7million questions and
12000 seconds of uptime), but weekdays it is over 500 / sec ..
thanks
-justin
-
Before posting, please check:
http://www.mysql.com/manual.
ped.
Typically indexes get corrupted and cause selects to malfunction,
OR, cause mysqld to crash, OR cause count(*) or distinct(*) queries
to run in infinite loops, but not necessarily on the corrupt table.
it seems to me index corruption can poison the server beyond the
afflicted table.
-Justin
the memory
usage document.. so depending on those, I expect 300 threads could
eat a lot of memory, which is not returned to the OS.
-Justin
On Sat, Mar 10, 2001 at 11:35:20PM -0800, Mike Wexler wrote:
> I have a server that averages 256 queries/sec.
> It maxes out at 1187 queries/sec
ort@ about this. Just so you don't think we're
not willing to pay for some attention.
thanks
-Justin
On Sun, Mar 11, 2001 at 02:21:55PM +0200, Sinisa Milivojevic wrote:
> Justin writes:
> > What is your key buffer size? In my case, key buffer size is set
> > to 384mb .. a
it via perl, perhaps each day
(table) at a time, and using hashes to accumulate summary info.
This I find is more flexible than struggling with complex selects
and indexes, plus you can use limit on the select to quickly
get the program right before pouring all the data through it.
-Justin
On M
few months.. I put it down to increased load, but maybe
that was incorrect.
So if your SMP server starts doing odd things and has been up
for a while .. a simple reboot costs nothing and may very well help.
-Justin
-
Before postin
the server creates the mysql.sock directory wherever you tell
it to .. check /etc/my.cnf
Once that is setup properly, server and client should agree.
If you leave it in /tmp, then set the /tmp sticky bit to stop
it getting accidently rm'd
-Justin
On Mon, Mar 12, 2001 at 07:57:49PM
bit on.
As far as I can guess this started with a linux kernel
upgrade to 2.4.1
There seems to be no other ill effects from this
-Justin
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
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]
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
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
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,
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]
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
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
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
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
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]
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
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
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&#
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
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]
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
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
--- 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
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
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
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
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
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-
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
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
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
> 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
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
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
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) );
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
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
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
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]
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
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 ..
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
> 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
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
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
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
--- 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
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
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
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
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
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
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
<
;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
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
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
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
.
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]
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
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
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
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
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
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
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 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
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
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
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
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
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]
1 - 100 of 184 matches
Mail list logo
