Re: Strange performance problem

It's possibly a DNS problem (reverse DNS exactly). Best regards.

Re: Help needed to tune Innodb on ZFS (on Solaris)

Hi all, You can read this article, written by a SUN benchmarking guru (hi Dimitri :) ). Best regards. Web link : http://dimitrik.free.fr/db_STRESS_BMK_Part2_ZFS.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Very slow connexion

Hi, This problem is specific to the WAN connexion, not to the LAN connexion. I've a Sun Fire 880, 8 Go RAM, Solaris 8 and MySQL 4.0.13 64 bits. The first connexion to the database is about 15s to 30s (too slow). Is there a known problem about MySQL connexion (paramaters, bugs ;-) ) or is it a

Best performance : 32 bit or 64 bit MySQL on Solaris 8

Hi, I've a SunFire V880 (4 proc., 8 Gb RAM) on Solaris 8. Which is the best solution (speed, security, ...) : the 32 bit or the 64 bit MySQL binaries ? Thank's Best regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Large file : InnoDB or MyISAM

Hi to all, I will have to do with a very big file (approx 600 millions of records). Which is the best table handler for this king of table : InnoDB or MyISAM (many INSERT and MANY SELECT, no UPDATE - statistics file). Best regards. -- MySQL General Mailing List For list archives:

Solaris, InnoDB and raw devices

Hi, I try to use raw devices with innoDB and i have some problems. First, after modifying my.cnf file, and restarted mysql, i received an error 13. The solution was to start mysql with the root user (baaah !). I think it is a temporary solution. BUT, now, i have an error 5 with innodb. my.cnf

InnoDB and disks scheme

Hi, hardware : Sun v880 4 CPUs, 8Go RAM, 3 disks (73Go each ; 1 for the system, 2 for datas, logs and dumps) software : Solaris 8, mySQL 3.23.54 (+innoDB) database : approx 40 Go of dataspace (2 or 3 tables of 1 or 2 millions of rows) ; many selects, inserts and few updates Question : what is

Errors compiling mySQL 4.0.4 on Solaris 8 with Forte 7.

Hi, I have these errors when compiling mySQL 4.0.4 on Solaris 8 using Forte C v7. Somme can help me please ? I use these compilation options : CC=cc CFLAGS=-Xa -fast -xO4 -native -xstrconst -mt \CXX=CC CXXFLAGS=-noex -xO4 -mt \./configure --prefix=/usr/local/mysql --enable-assembler Error

Compiling mySQL on Solaris 8

Is someone succeed in compiling mySQL 3.23.x and 4.0.x on Solaris 8 (and how to do it - especialy with SunOne C compiler - ak Forte C v7). Sinceraly. - Before posting, please check: http://www.mysql.com/manual.php (the

Compiling MySQL 3.23.52 and 4.0.x on HPUX 11

Products use : B3913DB HP aC++ Compiler (S800) version C.03.33.01 B3901BA HP C/ANSI C Developer's Bundle for HP-UX 11.i(S800) GNU makeversion 3.79.1.2001-06-12 Procedure : ./configure --prefix=/usr/local/mysql --with-innodb Modifying these files : config.h: add this line #define

Compiling mySQL 3.23.52 and 4.0.x on Solaris 8

Is there a solution to compile mySQL on Solaris 8 SPARC using Forte v7 (Sun native C Compiler v7). Sinceraly. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

MySQL (InnoDB tables) and HP-UX or Solaris

Hi, Which is the best solution ? I use MySQL (exclusively with large InnoDB tables - 150 to 200 tables, 3 or 4 of them with 200 000 lines per day, approx. 40 to 80 Go of datas). I must switch my system to UNIX. So, what is the best solution, HP-UX or Solaris ? Thank's

HPUX and mySQL-MAX

I search mySQL-MAX on the mySQL web site and just found mySQL binaries (not mySQL-MAX binaries). Is InnoDB table handler compatible with HPUX (10.20 or higher) ? Friendly. - Before posting, please check:

Read previous record with C API

Can someone tell me how to find the previous record in C (with mySQL API function). I do a SELECT statement, read it with mysql_store_result(), read the first record with mysql_fetch_row(), the next record with mysql_fetch_row(), etc.. . But what about reading the previous record ? (sorry for my