no.
- Original Message -
From: "Robinson, Eric" <[EMAIL PROTECTED]>
To:
Sent: Friday, April 28, 2006 8:51 AM
Subject: Quick Replication Question
When you have master-slave replication enabled, and something goes wrong
with one of the tables on the master, and you have to run mysqlch
Actually, you may be more interested in:
INSERT . ON DUPLICATE KEY UPDATE
- Original Message -
From: "steve" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, December 28, 2005 6:57 AM
Subject: update or insert if necessary?
I have a situation where I need to update a record for a given key
http://dev.mysql.com/doc/refman/5.0/en/replace.html
- Original Message -
From: "steve" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, December 28, 2005 6:57 AM
Subject: update or insert if necessary?
I have a situation where I need to update a record for a given key in a
MySQL table, but
The primary key by definition is an index ("key"). If you don't make it a
primary key index or unique index then duplicate entries can occur. It is
good practice to always set a primary key, and always make it a unique
auto-increment integer.
If you look at the output of EXPLAIN now, you can
The Windows DLL is thread safe. You do not have to call my_init() and
my_thread_init() because Windows DLLs receive events when they are attached to
a new process and when they are attached to a new thread in a process. This is
one of the nicer features of Windows shared libraries. Other than
ming production release."
Jeremiah Gowdy
Senior Software Engineer
FreedomVOICE Systems
http://www.freedomvoice.com
- Original Message -
From: "Jim McAtee" <[EMAIL PROTECTED]>
To: "Lenz Grimmer" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, September 26
The limit you are running into is the maxdsiz or max data size for a
process. It is defaulting to 512MB. In FreeBSD 5.x you don't have to
recompile your kernel to set a different maxdsiz. See
/boot/defaults/loader.conf. Putting kern.maxdsiz="1073741824" in
/boot/loader.conf should work.
T
The limit you are running into is the maxdsiz or max data size for a
process. It is defaulting to 512MB. In FreeBSD 5.x you don't have to
recompile your kernel to set a different maxdsiz. See
/boot/defaults/loader.conf. Putting kern.maxdsiz="1073741824" in
/boot/loader.conf should work.
T
ograms are written for. The first great example of how a well written
port to Windows can turn out high performance and scalability, take a look
at the WinNT port of Apache2, and then tell us how slow Windows is.
- Original Message -
From: "Jay Blanchard" <[EMAIL PROTECT
I am willing to bet you I can write a more scalable higher performing socket
server using NT I/O Completion Ports than you can write using Linux's epoll.
It you're running a 32 cpu system, Windows will consistently outperform
Linux in many areas.
My point is, blanket statements like this aren
When you use double quotes for strings in Perl, Perl looks through your
strings for variables like $foo, and replaces them with the current value of
$foo. This is called interpolation. When you use single quotes, it
considers your string a literal.
So when you use double quotes, you need to
s do not genrate
errors
:
http://platon.sk/cvs/cvs.php/scripts/perl/mysql/mysqldump-convert.pl
Mathias
Selon Jeremiah Gowdy <[EMAIL PROTECTED]>:
I have two servers doing replication for logs. When I do extended insert
syntax on the master to combine multiple log entries, the slave complai
I have two servers doing replication for logs. When I do extended insert
syntax on the master to combine multiple log entries, the slave complains
about duplicate primary key numbers, even though my inserts don't set the
primary key and the primary key is auto_increment.
So any time I use ext
I'm hoping this will serve as a reference since this topic comes up often.
If you Google search, you'll find people who explain these topics better
than I do, but here's what you need to know.
2GB is the division set between the user's address space, and the address
space the kernel maintains
I am proposing that when a query is received by MySQL, a timestamp could
be taken immediately, and that timestamp could travel with the query until
it is actually processed. For delayed inserts, the query would still sit
in the insert queue, and it would still say NOW(), but when the query
fin
- Original Message -
From: "Jeff Smelser" <[EMAIL PROTECTED]>
To:
Sent: Thursday, June 09, 2005 7:50 AM
Subject: Re: INSERT DELAYED and NOW()
On Thursday 09 June 2005 09:39 am, Jeremiah Gowdy wrote:
I am proposing that when a query is received by MySQL, a timestamp
, I'm just
wondering if doing so would break anything. Any comments, suggestions, or
input would be greatly appreciated.
Jeremiah Gowdy
Senior Software Engineer
FreedomVOICE Systems
http://www.freedomvoice.com
Well, here's the semi-relational way to do it:
CREATE TABLE `MyStrings` (
`ID` int NOT NULL AUTO_INCREMENT ,
`String` varchar(100) NOT NULL DEFAULT '' ,
UNIQUE `StringIndex`(`String`)
PRIMARY KEY ('ID') )
TYPE=MYISAM
CREATE TABLE `MyIntegers` (
`ID` int NOT NULL AUTO_INCREMENT ,
`StringID` int N
it
isn't implemented already.
Jeremiah Gowdy
Senior Software Engineer
FreedomVOICE Systems
http://www.freedomvoice.com
Yep.
- Original Message -
From: "Jeff McKeon" <[EMAIL PROTECTED]>
To: "Jeremiah Gowdy" <[EMAIL PROTECTED]>;
Sent: Friday, June 03, 2005 12:11 PM
Subject: RE: mysqlhotcopy
Am I right in assuming that while mysqlhotcopy is running, nobody else
can
I run 24/7 applications also. Use mysqlhotcopy to do exactly what you're
doing by hand now. Run mysqlhotcopy on a slave server. It does exactly
what you think. Lock and flush the tables, tarball them, and unlock them.
No shutdown required.
- Original Message -
From: "Jeff McKeon"
Nevertheless, foreign key constraints belong in the database, not in your
application... If you have foreign keys (your wording), you need foreign
key constraints. Period. Plain and simple. No discussion :-)
How about a log database? We log every phone call to a calls table which
currently has
I think you're confusing referential constraints with foreign keys.
In my book, referential constraints and foreign key constraints (the full
name)
are the same.
Yes, referential constraints and foreign key constraints are the same thing.
Notice the word constraints.
Let me say this again:
Hi,
If you're loocking for consurrent inserts/deletes, use innodb (row level
locking). This will be better than myisam.
I'm looking for concurrent inserts / selects, reading and writing. The key
is to get the reads and blocking writes (writes that need the insert ID,
which can't be done DELAY
>>key relationships?
>
> MyISAM can't FK's.
Yes it can, they're just not enforced.
LOL - that's just like saying that MyISAM supports transactions
if you only do transactions that are a single statement...
In other words: useles.
Somehow I use these "useles" foreign keys to create relational
You should be able to pull the ID of the parent table in when you do the
INSERT ... SELECT to pull the data in, in which case, the IDs in the foreign
key fields would still be valid.
I'd convert them all to MyISAM rather than doing half and half.
- Original Message -
From: "Scott Purc
- Original Message -
From: "Rafal Kedziorski" <[EMAIL PROTECTED]>
To: "Scott Purcell" <[EMAIL PROTECTED]>;
Sent: Wednesday, May 25, 2005 6:06 AM
Subject: Re: InnoDB to MyISAM
http://dev.mysql.com/doc/mysql/en/converting-tables-to-innodb.html
He's converting InnoDB to MyISAM.
I woul
I believe the products you are talking about, Borland C++ v3 and Turbo C++
v3, are for DOS. DOS programs typically only support 8 character file names
with 3 character extensions. You should consider upgrading your compiler.
If you only need a C++ compiler, and not a complete development envir
I was a huge fan of 3ware's IDE offerings, but was also disappointed by
their SATA cards. However, I found that the Adaptec 2410SA is a beautiful
card with excellent performance, and it has a small enough profile to fit in
most 1U cases.
- Original Message -
From: "Daniel Whitener" <[
, you should be able to turn this feature off),
therefore read speed on Raid 5 should be just fine, it's write speed that
should suffer.
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Jeremiah Gowdy" <[EMAIL PROTECTED]>; "Dathan Pattishall"
&
I use Redhat Advanced Server v4 (2.6 kernel) on my four dual opteron
systems. I've had no real performance issues with the I/O scheduler, but
that's because I run 8GB of ram with a huge key cache. I recommend taking
the box to 8GB of ram, it's worth it. Definately use RAID 10.
- Original
doh! need another redbull. :)
- Original Message -
From: "Reggie Burnett" <[EMAIL PROTECTED]>
To: "'Jeremiah Gowdy'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
Sent: Friday, May 06, 2005 9:31 AM
Subject: RE: C API : Problem using mu
Answer is simple. Can't do that.
- Original Message -
From: <[EMAIL PROTECTED]>
To:
Sent: Friday, May 06, 2005 5:40 AM
Subject: C API : Problem using multi-statements
Hello,
I have some problems using multiple queries in a databased driven project,
therefore I wrote a little testprogra
> Where could I find speciffication of how MySQL client and server
> communicate?
/...
Look at the source code of libmysql?
So, document regarding this protocol doesn't exist?
I didn't say that. I don't know of such a document, but I have never heard
of it. However, since the protocol can chang
Look at the source code of libmysql?
- Original Message -
From: "Nikola Skoric" <[EMAIL PROTECTED]>
To:
Sent: Sunday, May 01, 2005 10:25 AM
Subject: mysql<->mysqld connection
Where could I find speciffication of how MySQL client and server
communicate? It seems to
me there are two ways
Yes, replication can be behind. If you SHOW SLAVE STATUS on the slave
computer, you can see exactly how far behind the slave is on replication.
You should design your systems such that a lag in updates doesn't affect the
logic of your system.
There are many uses in which this is a non-issue.
I recommend you use the Intel compiled version of the MySQL pre-compiled
binaries for maximum speed. For x86 32bit architecture Linux, you should
use:
http://dev.mysql.com/get/Downloads/MySQL-4.1/mysql-standard-4.1.8-pc-linux-i686-icc-glibc23.tar.gz/from/pick
You'll also need to install the Int
How long until we'll see an Intel icc compile of 4.1.9 on the downloads site?
Thanks.
Jeremiah Gowdy
Senior Software Engineer
FreedomVOICE Systems
cd /usr/ports/databases/mysql41-server && make install clean
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
To: "Richard C Komatz" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, December 01, 2004 12:00 PM
Subject: Re: Help with installation: MySQL, FreeBSD 5, Spa
,
-> Provider,
-> Sequence,
-> ProviderCost,
-> CustomerPrice,
-> CallID
-> FROM
-> BillingLog
-> WHERE
-> Start BETWEEN '2004100100' AND '2004103100'
-> LIMIT 200
40 matches
Mail list logo