Some months a back I had to firewall port 3306 due to DDoS.
I cannot do this now as a client needs 3306 outside the LAN.
What can I do to prevent DDoS on my MySQL server?
--
Member - Liberal International This is doc...@nl2k.ab.ca
Ici doc...@nl2k.ab.ca God, Queen and country! Beware Anti-Chris
http://cfi.iflywestwind.com/nEACWal3iJ.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
You should drop the 'datetime_sent' off that order by clause, it will return
an error.
Should be
select * from incoming where user_id = 123
union
select * from outgoing where user_id = 123
order by datetime_received;
Always use the column names in the first select for ordering union queries.
J
I think that you can do what you want with a simple union query:
select * from incoming where user_id = 123
union
select * from outgoing where user_id = 123
order by datetime_received, datetime_sent
hth,
Arthur
On Wed, Sep 23, 2009 at 10:02 AM, Warren Windvogel wrote:
> Hi
>
> I have 2tables. 1
Hi
I have 2tables. 1 for incoming & the other for outgoing messages. They
both have columns for the userid & datetime_received/sent. I'd like to
retrieve all records from both tables for a specific user id & order all
the records returned by the two datetime_received/sent fields. Is this
poss
Concurrency Control: How It Really Works
http://forge.mysql.com/wiki/Concurrency_Control:_How_It_Really_Works
This Thursday (September 24th, 14:00 UTC (yes, 1 h later than usually)),
Heikki Tuuri, the father of InnoDB, will give a session on Concurrency
Control: How It Really Works. He'll describe
A very first thought I got is disable the constraint before import and
re-enable after that.
One way could be to set the foreign key checks to false or alter the
constraint and remove the 'cascade delete' part.
It's just a quick brain storm, please verify the goodness of it, I still
need to get my
Hello,
we have two tables associated with a foreign key constraint.
Table A with the primary key and table B with an "on delete cascade" constraint.
We want to delete datasets in Table B if the related dataset in Table A is
deleted - that works.
Now the Problem:
There is a weekly import defined
