Hi Jose,
there are only a few reasons why you should NOT use a pre-compiled package:
1. The version of MySQL you want to use (e.g. Alpha-Version) does not exist
for your machine
2. You want to use features not available in the pre-compiled version.
On the other hand there are some very good
test
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is it right to have this result with a 'show slave status'?
(...)
Replicate_do_db: dbname, dbname
(...)
I mean, to see the dbname twice? or there is something wrong in mysql
master or slave config?
I have to put the replicate_do_db variabile in slave config too?
thank you in advance
bye
Folks,
A few months ago, I came here asking for directions on how I could improve
performance of MySQL. Back then, I was using OpenBSD on a dual Opteron 248
with 2GB, LSI MegaRAID 320-1, 15k RPM SCSI discs, MySQL was (still is)
4.0.27, the database is MyISAM, reaching 50GB.
After some
RV, you may find that increasing the size of the key_buffer could have
a negative effect on performance. You want to make sure that there's
enough physical RAM for all the processes on the machine, to avoid
paging/swapping to disk, which is very slow.
Here's a an interesting note:
At 21:39 -0400 10/14/06, Ferindo Middleton wrote:
Is there a way to change the format of date fields MySQL is expecting when
LOADing data from a file? I have no problem with the format MySQL saves the
date but most spreadsheet programs I use don't make it easy to export text
files with date
Hello,
I'm trying to compile some C code with the simple following code (dev-c++):
#include stdio.h
#include stdlib.h
#include windows.h
#include mysql.h
int main(int argc, char *argv[])
{
MYSQL * mysql_con = NULL;
mysql_con = mysql_init(mysql_con);
return 0;
}
As the result, i obtain
Hello,
Did you try to convert the .lib file to a GCC .a library ? See
http://mingw.org/mingwfaq.shtml#faq-msvcdll
If reimp doesn't work, you can try pexports and dlltool. I have an old
batch file I used for older MySQL versions at
http://athanatos.free.fr/EXE/implib.bat
[EMAIL
Hi!
SQL Maestro Group is happy to announce a new version of our powerful GUI
solution for MySQL server administration and database development.
http://www.sqlmaestro.com/products/mysql/maestro/download/
New version features:
1. Support of events and table partitions (MySQL 5.1).
2. The new
I have a field called name which stores a person's first, middle and
last name.
Previously, these names (17800 of them) were entered in the database by
different people so there was no consistency in the format used. There
are now names entered such as:
Smith, John S.
Doe - Jane W.
Doe John
I don't have any suggestions for a script, but I've wrestled with this issue
before in other places. It is very difficult to regularize the format of a
full name:
Johnson, Jr. - Fred
Applewhite-Smith, Pamela
Quimby III, Roger Alan
etc. I suppose it all depends upon how bad the existing data is,
Mark wrote:
I have a field called name which stores a person's first, middle and
last name.
Previously, these names (17800 of them) were entered in the database
by different people so there was no consistency in the format used.
There are now names entered such as:
Smith, John S.
Doe -
On 10/25/06, Mark [EMAIL PROTECTED] wrote:
I have a field called name which stores a person's first, middle and
last name.
Previously, these names (17800 of them) were entered in the database by
different people so there was no consistency in the format used. There
are now names entered such
All;
Am I crazy, or doesn't this have to be an optimizer/explain bug?
SQL interspersed with comments follow...
mysql CREATE TEMPORARY TABLE `table_a` ( `s_id` int(11) NOT NULL
default '0', `r_id` int(11) NOT NULL default '0', `d_id` int
(11) NOT NULL default '0', `status`
Hello everyone,
I'm wondering if there is a way to exit out of a REAPEAT/WHILE loop
iteration in a stored procedure. I think LEAVE will get you out of the
loop completely, but I looking for something like next record.
Thanks,
Waldemar
--
MySQL General Mailing List
For list archives:
At 17:33 -0400 10/25/06, Waldemar Jankowski wrote:
Hello everyone,
I'm wondering if there is a way to exit out of a REAPEAT/WHILE loop
iteration in a stored procedure. I think LEAVE will get you out of
the loop completely, but I looking for something like next record.
Perhaps you want
On Wed, 25 Oct 2006, Paul DuBois wrote:
At 17:33 -0400 10/25/06, Waldemar Jankowski wrote:
Hello everyone,
I'm wondering if there is a way to exit out of a REAPEAT/WHILE loop
iteration in a stored procedure. I think LEAVE will get you out of the
loop completely, but I looking for something
My understanding of what is happening here is this:
The 'rows' column of EXPLAIN output is an estimate of how many rows
MySQL thinks it will likely have to examine in a table to get your
answer. When there's an index, it will hopefully be able to use that
to exmaine a small subset of the rows
18 matches
Mail list logo
