If those servers are yours, it sounds to me that you can run it GPL.
Read this:
http://www.mysql.com/doc/en/Using_the_MySQL_software_for_free_under_GPL.html
Stephen
- Original Message -
From: "Pierre Luguern" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 10, 2004 7:
Hello Jim,
Would you please look at my comments under the thread "Not receiving list
emails", in case that puts further light on this matter.
Thanks,
Stephen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED
Hello,
The MySQL list server sent me nothing for about 24 hours, until just
recently.
It followed my first attempt to use the support.mysql.com website and change
my details there [that might have been just a coincidence].
I started getting messages again soon after I sent a new subscription
mes
Hello Stephane,
I use myisam for reading.
I now use SQL for updating. When I used myisam for updating, tables
sometimes corrupted, and I was unable to work out why.
Currently I am changing programs to use HANDLER syntax not myisam for
reading. This will:
- Save the need for table locking.
- Allo
I agree with Dan.
We looked into this years ago.
We have MANY machines with many tables used this way.
It is easy when you realise that one SQL command can access multiple
databases, using db1.tablea ... db2.tableb syntax.
Stephen
- Original Message -
From: "Dan Greene" <[EMAIL PROTECTED]
Pat's version was better than mine.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello Bob,
- Original Message -
From: "Bob Loeffler" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 26, 2003 10:01 AM
Subject: Replacing text using the Update command?
> Hi all!
>
> I would like to update many records in a table called "pictures" where I
> find a s
Hello Stefaan,
> Stefaan Van Dooren wrote:
> > Hi,
> >
> > I'm trying to install (compile, since there are no binaries for this
> > system) MySQL on an SCO OPenServer 5.0.6 system.
> >
> > Prior to compiling MySQL, I installed the following packages for SCO :
> >
> > FSU Pthreads (ver 3.9)
>
Hello Stefaan,
Stefaan Van Dooren" <[EMAIL PROTECTED]> wrote:
> I'm totally lost now..
>
> As you can (could) see in my previous post, I managed to get MySQL working
> on SCO with "--with-debug" as a configure option.
> Whenever I remove "--with-debug", I can compile and install it, but I
Hello Stefaan,
We have around 80 servers running MySQL 4.0.15 on SCO OpenServer 5.0.5
through 5.0.7.
Here is my make:
CC=gcc CFLAGS="-O3 -mpentium" LDFLAGS=-static CXX=gcc \
CXXFLAGS="-O3 -mpentium -felide-constructors" \
./configure --prefix=/usr/local/mysql \
--enable-thread-safe-cl
UPDATE some_table SET some_field=IF(id = some_id,1,0)
Have fun,
Stephen
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 21, 2003 11:41 AM
Subject: Update optimization?
Hello guys,
Let say:
UPDATE some_table SET some_field=1 WHERE id = some_
Have a look at the MySQL server error log.
It should show messages about Shutting down.
If it does not report the shutdowns, Unix would just be killing it, and that
could be causing, not solving the problems.
MySQL shutdowns might not happen when Unix is shutdown, because sometimes
the rc.d script
> Basically, what I would like to do is associate a human readable label
with
> each column (in the comment field) so that I can automatically generate
> web-based forms for any given table. The script would look at the column's
> metadata, display the appropriate HTML element, and display the
> co
mmend you try (order of preference):
- Rewrite the reports to be set based not row based. Or
- See if HANDLER syntax is quick enough. I think it will be. Or
- See if you can cope with the myisam libraries. Or
- Beef up your hardware and tweak everything.
Good luck,
Stephen Brownlo
"ggelu" <[EMAIL PROTECTED]> wrote:
> --- Amy & Joseph Kormann <[EMAIL PROTECTED]> wrote:
> > Are there any (significant) changes in the C API between MySQL 3.X and
> > 4.X? If so, where are they located.
>
> Yes. Are some changes between ver 3.x and 4.x.If i understand well i
> think you try to f
""Prasanth Krishna"" <[EMAIL PROTECTED]> wrote in message
news:b1eg64$2rqn$[EMAIL PROTECTED]...
> Is there any way to partition MyISAM tables in mysql? i have a huge
> table and want to partition it.
> Do InnoDB tables support partitioning?
> thanks.
The software RAID option for MyISAM sounds like
Hello Paul,
I am only lobbying, not demanding.
Paul Dubois wrote:
> Mmm, how do you know how much effort it would be?
> Have you implemented it?
Ok. IMHO it would be relatively easy for MySQL to implement, judging by my
experience dealing with Monty and his source code (specifically, the myisam
"Egor Egorov" <[EMAIL PROTECTED]> wrote on December 05, 2002:
>
> What do you mean "disable database"?
Ask the MySQL server to Flush it, then not access its tables until further
notice.
> You can't "turn off" the database..
Can this please be written? It offers big benefits for little effort.
hat are declared differently?
> In the last episode (May 20), Stephen Brownlow said:
> > The MySQL online manual says that MySQL cannot use indexes
> > efficiently unless the columns have the same type and the same
> > length.
> >
> > I can see no release notes that this
I understand all of the reasons given by Alexander.
Yet I think that in 99% of cases, it would be best for myisamchk to do as
Mark suggest, and not run when a MySQL server is active.
Safety would be the default.
There could be a special option (--no-safety) for myisamchk to override that
check.
-
The MySQL online manual says that MySQL cannot use indexes efficiently
unless the columns have the same type and the same length.
I can see no release notes that this problem has been fixed.
My question: Is this still a problem?
Here is the extract from the latest manual:
7.29 EXPLAIN Syntax (G
The MySQL online manual says that MySQL cannot use indexes efficiently
unless the columns have the same type and the same length.
I can see no release notes that this problem has been fixed.
My question: Is this still a problem?
Here is the extract from the latest manual:
7.29 EXPLAIN Syntax (G
We have the same problem with MySQL (3.23.36) for SCO OpenServer, in script
mysql.server.
Here is the problem code, showing my workaround.
...
if test -z "$pid_file"
then
# pid_file=$datadir/`@HOSTNAME@`.pid
pid_file=$datadir/`hostname`.pid # changed @HOSTNAME@ to hostname
else
case "$pid_
Hi Matthew,
We had a similar problem that caused us to need to run myisamchk much more
than we wanted to.
It turned out that MySQL was not being shutdown when Unix was.
Symptom: The MySQL server error log did NOT show normal shutdown messages.
Cause 1: The normal method of shutting down MySQL u
24 matches
Mail list logo
