Thanks
Not sure how I'm reading this, but shouldn't the URL be linked to SubCategory
?
- Original Message -
From: Martin Gainty
To: bobsh...@ntlworld.com ; mysql@lists.mysql.com
Cc: john.l.me...@gmail.com
Sent: Friday, September 04, 2009 6:09 PM
Subject: RE: Database
Hi,
After installing mysql-5.1.37 on solaris10, I am getting this message:
../mysql_install_db --user=mysql --ldata=/sqldata
Installing MySQL system tables...
090905 13:10:19 [Warning] option 'max_join_size': unsigned value
184467440737095
51615 adjusted to 4294967295
090905 13:10:19
One word: Backups!
If your potential client must restrict you to one server then your
primary consideration in this design must be backups, this cannot be
stressed enough.
One server with 4GB main memory should be fine for your 24GB database
with small monthly growth and low number of users, you
Thanks you all, I will consider all the suggestion, and I will communicate
with the client. You all are so kind :)
On Sat, Sep 5, 2009 at 6:55 PM, Andrew Braithwaite
andrew.braithwa...@lovefilm.com wrote:
One word: Backups!
If your potential client must restrict you to one server then your
Please forgive my total ignorance.
URL-Category linking ... with Foriegn Keys or Primary Keys ?
Have been trying to create the ER Diagram with MySQL Workbench,
and getting very frustrated.
cheers
- Original Message -
From: Martin Gainty
To: bobsh...@ntlworld.com ;
Hi there,
One simple query took more than 10 minutes. Here is how relevant rows
in the slow query log looks like:
# Time: 090905 10:49:57
# u...@host: root[root] @ localhost []
# Query_time: 649 Lock_time: 0 Rows_sent: 0 Rows_examined: 26758561
use world;
create table rmpdata1 select
I tried creating a soft link to the /usr/local/bin/mysql but that didn't
address the issues I was having. However, following a little more research I
found a discussion of this problem at:
http://stackoverflow.com/questions/1334272/cant-start-mysql-in-mac-os-10-6-s
now-leopard
which said:
YOU
How many rows were added to rmpdata1 table? If it is 13.4 million rows then
it is going to take several minutes to join this many rows from the 2 tables.
Is there a 1:1 relationship between the two tables or a 1:Many? If there is
a 1:1 then I'd recommend joining the two tables into 1 table so
