Thanks a lot
On Mon, Apr 7, 2008 at 10:59 AM, Rob Wultsch <[EMAIL PROTECTED]> wrote:
> On Sun, Apr 6, 2008 at 9:57 PM, Eric Bergen <[EMAIL PROTECTED]>
> wrote:
> > I don't see what the issue is. As Jay said the row counts in explain
> > outputs are estimates. When running an explain query MySQL
Hi!
Im Cluster with 1 mgm, 1 sql and 1 nd on the same machine.
i have 2Gb on ram. enough hd.
my config.ini
[NDBD DEFAULT]
NoOfReplicas=1
DataMemory=170M
IndexMemory=64M
MaxNoOfAttributes=1
MaxNoOfConcurrentOperations=20
datadir=/var/db/mysql/
[TCP DEFAULT]
portnumber=2202
SendBufferMem
I have a complex application under re-development, and am stuck on the
data model which is almost certainly wrong. The application is designed
to handle clinical requests coming into a hospital records system. A
request concerns a single patient, and can come from a hospital or a GP
(general pr
Baron Schwartz wrote:
Hi,
This is a fine place to ask such questions.
(In general you can just ask first, and people will tell you if you're
off-topic).
OK, thanks - I've posted the details to a new subject earlier today but
it doesn't seem to have showed up yet.
--
Richard Jones
--
My
Hey Baron,
Your blog post was quite informative; your suggestion to use a
combination of merged MyISAM tables and InnoDB for the live partition
made a lot of sense, and it sounds like the path I'll need to follow.
I appreciate the information!
Baron Schwartz wrote:
Hi,
I'll just address th
Kaushal,
When you set it to MASTER/MASTER replication then everything that happens on
the
MASTER happens on the SLAVE. Remember they are both master and slave.
My situation is as fallows, I have 2 node (servers) and I have then
configured for
HA (high availability) failover. When node 1 goes
On Tue, Apr 8, 2008 at 12:14 AM, Kaushal Shriyan <[EMAIL PROTECTED]>
wrote:
> On Tue, Apr 8, 2008 at 12:02 AM, Néstor <[EMAIL PROTECTED]> wrote:
>
> > Kaushal,
> >
> > That worked. I found out that my problem was that my firewall was not
> > allowing my to computers to talk to each other on port
On Tue, Apr 8, 2008 at 12:02 AM, Néstor <[EMAIL PROTECTED]> wrote:
> Kaushal,
>
> That worked. I found out that my problem was that my firewall was not
> allowing my to computers to talk to each other on port 3306. I use the
> link you sent but this are th eoriginal links I used:
> 1) Master/S
Kaushal,
That worked. I found out that my problem was that my firewall was not
allowing my to computers to talk to each other on port 3306. I use the
link you sent but this are th eoriginal links I used:
1) Master/Slave replication
http://crazytoon.com/2008/01/29/mysql-how-do-you-set-up-maste
On Mon, Apr 7, 2008 at 1:24 AM, Moon's Father <[EMAIL PROTECTED]> wrote:
> Schema is a collection of databases.
A schema is a definition of tables & fields and their relationship.
Kevin.
--
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubs
You can use that table to generate any sequence of things.
mysql> SELECT DATE_SUB(DATE_SUB(CURRENT_DATE, INTERVAL i MONTH),
INTERVAL DAYOFMONTH(CURRENT_DATE) -1 DAY) AS Date FROM integers;
++
| Date |
++
| 2008-04-01 |
| 2008-03-01 |
| 2008-02-01 |
| 2008-01-01 |
| 20
Baron Schwartz wrote:
Hi Ed,
On Thu, Apr 3, 2008 at 3:32 PM, Ed W <[EMAIL PROTECTED]> wrote:
Hi
Up until version 5.0.44 (on linux) it appeared that you could do stuff like
deliberately insert a NULL into a NOT NULL varchar field and it would be
silently converted to an empty string. Simil
According to what?
From what you can read in Robert Sheldon "SQL: A Beginner's Guide", page 35:
"As you might have noticed, nowhere in the structure of the SQL environment or
a catalog is there
mention of a database. The reason for this is that nowhere in the SQL:1999
standard is the ter
Schema is a collection of databases.
On Fri, Mar 28, 2008 at 6:00 PM, Nanni Claudio <
[EMAIL PROTECTED]> wrote:
> I know I am a little late.
> From my experience with Oracle Database:
>
> ORACLE MYSQL(equivalent)
> ---
> DAT
Am Montag, den 07.04.2008, 11:22 +0530 schrieb Kaushal Shriyan:
> is this a correct documentation
> http://howtoforge.com/mysql_master_master_replication for Master Slave
> Replication
No, it's not. As the title says, it describes Master-Master replication,
not Master-Slave replication.
Just use
On Mon, Apr 7, 2008 at 11:58 AM, Kaushal Shriyan
<[EMAIL PROTECTED]> wrote:
>
> On Mon, Apr 7, 2008 at 11:32 AM, Néstor <[EMAIL PROTECTED]> wrote:
> > Kaushal,
> >
> >
> > I will try it tomorrow to see if it works. It is similar to something I
> > tried
> > a couple of weeks ago and it work
16 matches
Mail list logo