Re: New Database,

2003-02-14 Thread Maximo Migliari
Its a lot easier asking people than trying to look for yourself isn't it? Well, that is frowned uppon over here. You should ask us questions when you have attempted to find the solution yourself first. http://www.mysql.com click on the documentation link on the header. See, it wasn't so hard!

Re: Configure prob with FreeBSD/Linuxthreads

2003-02-01 Thread Maximo Migliari
;" #define PACKAGE_TARNAME "" #define PACKAGE_VERSION "" #define PACKAGE_STRING "" #define PACKAGE_BUGREPORT "" #define PACKAGE "mysql" #define VERSION "4.0.9-gamma" #define PROTOCOL_VERSION 10 #define DOT_FRM_VERSION 6 #define SYSTEM_

Re: Configure prob with FreeBSD/Linuxthreads

2003-02-01 Thread Maximo Migliari
These are the last two lines in config.log #define MACHINE_TYPE "i386" configure: exit 77 Maximo. At 01:37 PM 31-01-03 -0600, you wrote: In the last episode (Jan 31), Maximo Migliari said: > So, my dear friends, could we conclude that Linux is a more appropriate > platform f

Re: Configure prob with FreeBSD/Linuxthreads

2003-01-31 Thread Maximo Migliari
the following mean: -O -pipe -march=pentiumpro -D__USE_UNIX98 -D_REENTRANT -llthread -llgcc_r -felide-constructors -fno-rtti -fno-exceptions Many thanks, from a n00b FreeBSD admin. Maximo Migliari. At 03:21 PM 30-01-03 -0500, you wrote: > > Because with native threads, enabling the second CP

Character problems

2003-01-30 Thread Maximo Migliari
Platform: windows MySQL version: 4.0.9-gamma PHP version: 4.3.0 Connected through Command Prompt via MySQL client to local MySQL server. Output from a SELECT query: mysql> select * from category; +++---+--+-++ | id | parent | name

Memory optimization (my.cnf options). Please shed some light!

2003-01-23 Thread Maximo Migliari
this. Perhaps Paul Dubois, who is versed in the documentation could shed some light into this matter? Perhaps some of you guys could write what you understand and know, what works for you with regards to memory optimization? Thanks in advance for your help! Maximo Migliari

Memory optimization (my.cnf options). Please shed some light!

2003-01-23 Thread Maximo Migliari
this. Perhaps Paul Dubois, who is versed in the documentation could shed some light into this matter? Perhaps some of you guys could write what you understand and know, what works for you with regards to memory optimization? Thanks in advance for your help! Maximo Migliari

Re: FreeBSD 5.0 Thread Work...

2003-01-20 Thread Maximo Migliari
YES, pretty please, with sugar on top: from now on also make available for us binary distributions of MySQL optimized for FreeBSD 5.0's new threading implementation. There is a very large FreeBSD user base that must not be ignored :) Thanks! Maximo. At 14:20 20/1/2003 -0500, you wrote: Alrighty

Compiling MySQL 4.0.9-gamma under FreeBSD 4.7-Stable with linuxthreads

2003-01-20 Thread Maximo Migliari
Hello there, I'm trying to compile MySQL 4.0.9-gamma under FreeBSD 4.7-Stable with linuxthreads. I installed linuxthreads through the ports system by doing: cd /usr/local/ports/devel/linuxthreads make make install it installed just fine. I downloaded the source distribution of MySQL (not using t

FreeBSD: MySQL crash when importing 148 MB dumpfile

2003-01-17 Thread Maximo Migliari
Problem: I am migrating servers, from a dual PIII-866 Mhz with 384 MB of RAM running Linux to the following server configuration: Dual Athlon 1.5 Ghz 1 GB RAM 2 x 18 GIG SCSI drives. FreeBSD 4.7-Stable MySQL-Max-3.23.54a (ELF) i.e. without linuxthreads - runs on only 1 process. I am trying to i

Re: To BLOB or not to BLOB

2003-01-15 Thread Maximo Migliari
It depends on what kind of comparing you will be doing. Text is case-Insensitive for comparisons, blob is case-Sensitive. Generally I find that for pure text, TEXT type is better. For files and texts that need to be compared case-sensitively, use BLOB. Either way, for images, and any other bin

Upgrading to version 4.

2003-01-13 Thread Maximo Migliari
In the MySQL manual, under http://www.mysql.com/doc/en/Upgrading-from-3.23.html it says: --- The old C API functions mysql_drop_db, mysql_create_db, and mysql_connect are not supported anymore, unless you compile MySQL with CFLAGS=-DUSE_OLD_FUNCTIONS. Instead of doing this, it is prefera

Re: Version 4 "safe" to use?

2003-01-10 Thread Maximo Migliari
Cool, you work for Yahoo? I'd love to know the extent to which Yahoo uses PHP and MySQL these days. What is the average queries/sec that you are getting with MySQL - what server setup, etc? Maximo. At 17:12 9/1/2003 -0800, you wrote: On Thu, Jan 09, 2003 at 01:51:20PM -0300, Maximo Mig

Re: Version 4 "safe" to use?

2003-01-09 Thread Maximo Migliari
What were the main benefits that you noticed straight away before adapting your code to use the new features that MySQL 4 offers? Does the query cache make a big difference? Do you have any benchmarks, even off your head? Maximo. At 09:47 8/1/2003 -0800, you wrote: On Wed, Jan 08, 2003 at 09:0

Re: InnoDB vs. MySQL performance Issue

2003-01-06 Thread Maximo Migliari
such, has its own memory settings... so if you convert everything to InnoDB, allocate more memory to it, and less memory to MyISAM. Maximo. At 20:05 6/1/2003 +0200, you wrote: Maximo Migliari wrote: Sameh, The right table manager to use (MyISAM or InnoDB) really depends on the type of work yo

Re: InnoDB vs. MySQL performance Issue

2003-01-06 Thread Maximo Migliari
e physical hard drive to seek up the data and spit it out to MySQL. Hope this helps! Maximo Migliari. At 19:28 6/1/2003 +0200, you wrote: Gelu Gogancea wrote: Hi, I'm sure that all the people from this list RESPECT in what you believe or in values which are considered by you to be invio

Change log

2002-12-19 Thread Maximo Migliari
Hello there, I would like to know where I can find the change log for the new versions of MySQL. For example, just recently .54 was released, and then .54a. There is a ChangeLog file in the distribution, but at least to me, it is TOTALLY incomprehensible. Isn't there a simple file that says s

Help me optimize my query

2002-11-21 Thread Maximo Migliari
s, but none of the update/insert queries are using transactions. Thanks a bunch! Maximo Migliari. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list ar

Re: mysql server hardware

2002-11-13 Thread Maximo Migliari
Where can I get a "tuning guide" for MySQL (MyISAM and InnoDB)... memory-wise and son on? At 11:11 13/11/02 -0800, you wrote: On Tue, Nov 12, 2002 at 11:22:11PM -0800, Devore, Jacob wrote: > > Can any of you point me to documentation or have a quick summary of > how beefy to make a mysql server.

MySQL load problems.

2002-11-13 Thread Maximo Migliari
Hello all, I've been having some problems with MySQL crashing. I use a mixture of MyISAM and InnoDB tables, but most of the data is under InnoDB tables. My web applications all do relatively complex join queries. Almost all fields in the WHERE clauses of queries are indexed. I'm running Red

MySQL load problems.... almost forgot

2002-11-13 Thread Maximo Migliari
Almost forgot to say, I'm running mysql with the following command: ./safe_mysql --user=mysql --skip-networking --skip-locking --log-slow-queries - Before posting, please check: http://www.mysql.com/manual.php (the manual)

MySQL load problems.

2002-11-13 Thread Maximo Migliari
Hello all, I've been having some problems with MySQL crashing. I use a mixture of MyISAM and InnoDB tables, but most of the data is under InnoDB tables. My web applications all do relatively complex join queries. Almost all fields in the WHERE clauses of queries are indexed. I'm running Red

MySQL load problems.... almost forgot

2002-11-13 Thread Maximo Migliari
Almost forgot to say, I'm running mysql with the following command: ./safe_mysql --user=mysql --skip-networking --skip-locking --log-slow-queries - Before posting, please check: http://www.mysql.com/manual.php (the manual)

MySQL 3.23.53 - Error changing user to mysql

2002-10-15 Thread Maximo Migliari
I've upgraded from MySQL-max 3.23.52 to MySQL-max 3.23.53 I'm running Linux, kernel version 2.4.17 I tried installing the binary version of MySQL, and followed all the steps under: http://www.mysql.com/doc/en/Installing_binary.html as I've always done for all my versions of mysql. when I ran .