If you don't know the cutoff_date you can simply find it by
SELECT creation FROM tablename ORDER BY creation DESC LIMIT n, 1
which gives you the creation of the n-th newest record and then you
can use Dan's solution
DELETE FROM tablename WHERE creation cutoff_date
HTH,
Dusan
Dan Julson
Hi,
Is there a hardware/software loadbalancer for multiple mysql servers
servicing read transactions?
Mailing-List
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is there a hardware/software loadbalancer for multiple mysql servers
servicing read transactions?
You might want to take a look at www.linuxvirtualserver.org and
www.keepalived.org
Dominik
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Is there a hardware/software loadbalancer for multiple mysql servers
servicing read transactions?
linux lvs project
http://www.linuxvirtualserver.org/
as mysql network connections are tcp then this would work fine for reads
--
MySQL General Mailing List
For list archives:
As I've often thought it would be very useful if MySQL regexp support
included being able to pull out the substring matched (and do regexp
substitutions). Although that could just be my perl sensibilities ;-)
mark
On Tue, 2006-10-03 at 17:27 -0500, mos wrote:
James,
That wasn't too
Problem:
When we run a large query (returns 4000 records) on a firewalled
XServe (OS X 10.4) against Mysql database (outside firewall) on an
AIX (Version 5.2) machine the database server intermittently
generates the following errors:
ERROR 2006 (HY000): MySQL server has gone away
No
Hello Peter
On 2006-10-05 Peter Gershkovich wrote:
Problem:
When we run a large query (returns 4000 records) on a firewalled
XServe (OS X 10.4) against Mysql database (outside firewall) on an
AIX (Version 5.2) machine the database server intermittently
generates the following errors:
I have a table with ~100,000,000 rows. I recently discovered that I
need to start using one of the non-indexed columns in WHERE clauses. As
expected the performance is horrid. I decided to bite the bullet and
create an index (innodb):
mysql show full processlist\G
***
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I am curious what I am doing wrong. I am using mysql-5.0.13, on Solaris.
The error I get, on the first alter table, is:
ERROR 1005 (HY000) at line 70: Can't create table
'./FlashcardProto_production/#sql-151_f5d.frm' (errno: 150)
Any help would be
James, you may have a typo in your SQL, actually in the the frst two
ALTER TABLE statements. You posted:
ALTER TABLE `cardfaces` ADD CONSTRAINT `fk_card_deck` FOREIGN KEY
(`card_id`) references card(`id`);
ALTER TABLE `cards` ADD CONSTRAINT `fk_card_deck` FOREIGN KEY
(`deck_id`)
For this table this is to late... leave it running...
If you want to do this on another table(s)... and in general on huge
loaded MySQL servers I recomend the following...
Create a directory let's say /mnt/mem_fs
Mount in it /dev/shm use tmpfs as filesystem...
Now you have a directory that
I have a primary key set on a table which consists of the combination of the
values: firstname, lastname, and a schedule_id (BIGINT(20))... I have this
so the records in this table do not have duplicates, being that no one
record should have the exact same name and schedule_id identifier.
Ferindo, you can create multiple UNIQUE indexes on a table to enforce
your data requirements.
http://dev.mysql.com/doc/refman/5.0/en/alter-table.html
Dan
On 10/5/06, Ferindo Middleton [EMAIL PROTECTED] wrote:
I have a primary key set on a table which consists of the combination of the
values:
Heya!
This fixed it for me, I didn't set kern.threads.max_groups_per_proc: earlier.
What is the max threads can FreeBSD go for?
Thanks,
-A
- Original Message
From: Ken Menzel [EMAIL PROTECTED]
To: Abdullah Ibn Hamad Al-Marri [EMAIL PROTECTED]; mysql@lists.mysql.com
Cc: [EMAIL
I'm having a problem with my replication settings in my.cnf. I know
it's probably something stupid.
I've got an existing database configured to replicate as follows:
set-variable= binlog-do-db=DatabaseA
set-variable= replicate-do-table=DatabaseA.foo_t
and that replicates that one
I have written a bug tracking system
(http://sourceforge.net/projects/roachphp which is pretty out of date
currently).
It has a feature to regress a CR (change request, previously known as a
bug). That is, if you fix a CR in maint, you can duplicate it to trunk so
that you can test it there too.
apologize for the newbie question.
installed mySQL 4 some time ago, and just played around with it in
terminal. Now that I really need to learn some database, I can't get
it to start in terminal. it autostarts; I can see it in the activity
monitor as a background process. but when I try
At 06:26 PM 10/5/2006, Ferindo Middleton wrote:
I have a primary key set on a table which consists of the combination of the
values: firstname, lastname, and a schedule_id (BIGINT(20))... I have this
so the records in this table do not have duplicates, being that no one
record should have the
Chris, what autostarts is likely the server, 'mysqld' (for mysql
daemon). What you need to start to access the server is a client,
'mysql'.
What command are you issuing? just mysql at the terminal prompt?
It seems odd I know, especially to long-time Mac users, but the
operating system may just
Thanks. I now have this issue where I can't create the unique index on this
table because the email_address is often times blank or unknown for a while
(The front-end_application sets is value to '' (blank) on inserts and
updates if the user doesn't enter it so instead of going in as NULL, the
Hi folks. Any suggestions on the following?
If a student signs up for classes, I don't want them viewing those
classes so they can choose them again. So I want to take out their
'signups' from the master class list.
select classnumber, classnumbersignup
from classes, signups
Hi
--replicate-wild-do-table=db_name.tbl_name
replicates only updates that use the specified table in the given database. If
any wild cald patterns specified, then match the specified database and table
name patterns. Tells the slave thread to restrict replication to statements
where any of
22 matches
Mail list logo