hat colums are foreign keys and what they reference without having to
tell the code? I use 'describe table' to get most of the information out
I need.
Oh yes, MySQL 4.0.12 on FreeBSD using INNODB tables.
Thanks much.
--
Michael Conlen
--
MySQL General Mailing List
For
always puts the number in there for me and I know it's
going to be unique unless MySQL does something it should not do.
The id field just takes the guesswork, mess and headaches out of the
code (well not *all* of them, but enough) and with the size of disk
space these days the extra space isn
e can.
--
Michael Conlen
Luis Enrique Bauzá Peña wrote:
Hi, I need some link to a spanish mysql list, would you ...?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AN link fails the IP addresses will
show up on the other WAN link even though it's from a different provider.
This is just a quick run down of immediate issues in a 24x7x365, it's
not exhaustive. Think about every cable, every cord, every component,
from a processor to a memory chip an
many 9's do you need?
I'd look at having two servers, one a master and another a slave, and
some software that can tell when one of them goes down then promote the
salave to master, and take over the IP address of the down system.
--
Michael Conlen
Rick Franchuk wrote:
On Thu, 1
old 20 disks
internally and there's PCI slots for a lot more if you need large files.
On the other hand I think "need 64 bit" and "affordable" are rare
situations.
--
Michael Conlen
Mike Wexler wrote:
Not necessarily. People that need relatively affordable 64 bit syste
Do you have disk performance data? My guess would be it's the time to
read the information off the disk.
I think redhat has the iostat command. Try running
iostat 1
in one window while you run your query in another, what result do you
get from the iostat?
--
Michael Conlen
Bob Oste
ntire OS and getting everything
installed that you want.
If you need more assistance shoot me a line, off the MySQL list (as it's
no longer a MySQL issue) and I'll answer what I can.
--
Michael Conlen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
talk to a lawyer if there's a license issue.
--
Michael Conlen
Joel Rees wrote:
What does internal distribution mean? Is it another thing than copying?
I've wondered that myself.
See
http://www.gnu.org or
http://www.fsf.org
to get more information on the GPL. Licensing, e
tes to your profile may take a few moments" or some such. Sun, HP
and IBM make some very good hardware using their own designs (Sparc,
PA-RISC and Power4)
--
Michael Conlen
Steven Balthazor wrote:
I am interested in any thoughts that people may have for creating a scalable mysql
infrastruct
and d) or (a and e) or (a and f) or (b
and d) ...
--
Michael Conlen
Reto Baudenbacher wrote:
hi
Sorry for this newbie-question:
is it possible to simplifiy the following (working) query?
"SELECT * FROM mytable WHERE
((col1 LIKE '%test%') OR (col2 LIKE '%test%') OR (
f not, does anyone have access to the Intel compilers to benchmark this
with?
--
Michael Conlen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I'm getting ready to upgrade a server from 4.0.12 and was wondering if
anyone knew the time frame for 4.0.14, or if I should just go with .13
for now.
--
Michael Conlen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[
What Operating system are you using and how are you measuring
unresponsiveness?
--
Michael Conlen
Tim Fountain wrote:
This may be a silly question but what can be done to stop
load-intensive MySQL processes taking down a server? Things like
adding fulltext indexes to very large tables, or
I'm developing a net-snmp module that executes a 'show status' command
on a MySQL server and advertises the values. My choices seem to be
super concrete: one server, one set of results, the variables don't
change, ever...
moderatly concrete: multiple possible servers, one set of results each,
t
ially in terms of quantity of
rows, and see what it handles. Measure performance and system usage
metrics and go from there.
--
Michael Conlen
NEWMEDIAPLAN wrote:
Can mysql handle 5000 concurrent webusers sending queries to the db through
a web search engine.
Is it possible (with a very big serve
Something to ask yourself in all this is, how fast can I change out a
piece of hardware? If I needed a high availability system, on the cheap
(ie, not a million dollars US worth of Sun hardware) I'd probably go
with a bunch of SuperMicro 2U rack mount servers with the hot swap SCSI
drives. You
17 matches
Mail list logo
