no.
- Original Message -
From: Robinson, Eric [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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
http://dev.mysql.com/doc/refman/5.0/en/replace.html
- Original Message -
From: steve [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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
Actually, you may be more interested in:
INSERT . ON DUPLICATE KEY UPDATE
- Original Message -
From: steve [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Wednesday, December 28, 2005 6:57 AM
Subject: update or insert if necessary?
I have a situation where I need to update a
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
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: mysql@lists.mysql.com
Sent: Monday, September 26, 2005 1:40 PM
Subject: Re: MySQL 5.0.13-rc has
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.
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.
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
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 PROTECTED]
To: Jeremiah Gowdy [EMAIL PROTECTED]; Brian Dunning
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
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
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 complains
about duplicate primary
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
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
- Original Message -
From: Jeff Smelser [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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 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
implemented already.
Jeremiah Gowdy
Senior Software Engineer
FreedomVOICE Systems
http://www.freedomvoice.com
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
Yep.
- Original Message -
From: Jeff McKeon [EMAIL PROTECTED]
To: Jeremiah Gowdy [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Friday, June 03, 2005 12:11 PM
Subject: RE: mysqlhotcopy
Am I right in assuming that while mysqlhotcopy is running, nobody else
can write to or update
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
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
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:
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
- Original Message -
From: Rafal Kedziorski [EMAIL PROTECTED]
To: Scott Purcell [EMAIL PROTECTED]; mysql@lists.mysql.com
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
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
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
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
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.
-
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
[EMAIL PROTECTED]; Richard Dale [EMAIL PROTECTED];
mysql
Answer is simple. Can't do that.
- Original Message -
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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
doh! need another redbull. :)
- Original Message -
From: Reggie Burnett [EMAIL PROTECTED]
To: 'Jeremiah Gowdy' [EMAIL PROTECTED]; [EMAIL PROTECTED];
mysql@lists.mysql.com
Sent: Friday, May 06, 2005 9:31 AM
Subject: RE: C API : Problem using multi-statements
Jeremiah
I don't use
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 change
Look at the source code of libmysql?
- Original Message -
From: Nikola Skoric [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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
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
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, Sparc64
In
|
++---+---+---+-+--+-+-+
| BillingLog | range | Start | Start | 8 | NULL | 2061431 | Using
where |
++---+---+---+-+--+-+-+
1 row in set (0.05 sec)
Jeremiah Gowdy
Senior Software Engineer
FreedomVOICE Systems
39 matches
Mail list logo