[ANNOUNCE] paper covering MySQL

(InnoDB, BerkeleyDB, etc) as well as a more optimized setup. Bear in mind that the scope of the benchmark is limited (not trying to do what TPC does). Regards Antoine -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

how to get access to mysql db with in mysql server

Hello all, I just recieved a mysql server box from another department within my company.. I would like to get the password for the mysql database for mysql.. Is this possible in any other way other then using mysql -u admin -p ? -- Antoine W. Solomon Jr. -- MySQL General Mailing List For

impossible to start mysql

I try to install mysql 3.23 on mandrake 9.0 but I have somme problems first I have this problem /usr/share/rpm-helper/add-service: line 27: [: : integer expression expected a the end of install i saw for mandrake 9.1 a patch so i modified my add-service in rpm- helper but after that a the end of

java , mysql and php

I have an intranet, a database mysql (i admin with phpmyadmin) I use a program java in order to put data in mysql and i want to know if it is possible to put prog java in php page on my intranet ? I want to start my program on the web ? please help! excuse me for my english antoine -- MySQL

RE: Newbie question -- PHP document

En réponse à George Pitcher <[EMAIL PROTECTED]>: > -- Début du message d'origine > Nate, > > The absence of details on the db and table structure prevent > testing. > > However, if you 'View Source' you'll see thet the form isn't > being sent to > any response

authentification intranet

excuse me i send my last e mail in french so i reexplain i have a mandrake 9.1 apache2 mysql 4.1 and phpmyadmin 4.0.1 my problem is : when i give my login and my password in intranet interface, i receive "password not exact" but password is good in database in mysql i use cheklogin.php and secure.

authentification intranet

bonjour a tous, je viens juste de m'inscrire a votre liste. meme si je ne suis que stagiaire et mon experience pas tres longue j'espere tout de meme pouvoir vous aider mon projet de stage est de mettre en place un intranet mon systeme est compose d'un serveru apache2 dun serveur mysql4.1 de phpmy

error connecting to mysql

I have a problem connection from a remote host this is the error I get ERROR 2013: Lost connection to MySQL server during query I am using redhat 8.0 and mysql3.23.54 please help thank you -- Antoine <[EMAIL PROTEC

can't connect to mysql3.23.54

I have a problem connection from a remote host this is the error I get ERROR 2013: Lost connection to MySQL server during query I am using redhat 8.0 and mysql3.23.54 please help thank you -- Antoine <[EMAIL PROTEC

FLUSH TABLES WITH READ LOCK data corruption (the followup)

; '--enable-local-infile' '--enable-assembler' '--disable-shared' '--with-client-ldflags=-all-static' '--with-mysqld-ldflags=-all-static' '--with-innodb' 'CFLAGS=-O2 -mcpu=pentiumpro' 'CXXFLAGS=-O2 -mcpu=pentiumpro -felide-c

bug / feature : privilege inconsistency

, but I do not want them to be able to mess with public tables. On a side note : I still have this corruption problem with backups made with FLUSH TABLES WITH READ LOCK. Quite annoying. Regards Antoine. (Filter stuff :

re: [Fwd: possible problems with FLUSH TABLES WITH READ LOCK]

;); print "Destroying snapshot...\n"; system("umount /backup"); system("lvremove -f /dev/vgdata/backup"); print "Backup successfully done!\n\n"; I check the console output in the mail that cron automatically sends, and everything is correct (no error messa

[Fwd: possible problems with FLUSH TABLES WITH READ LOCK]

essage original Sujet: possible problems with FLUSH TABLES WITH READ LOCK De: "Antoine" <[EMAIL PROTECTED]> Date: Mar, 26 Novembre 2002, 17:27 A: <[EMAIL PROTECTED]> Hi, I am using FLUSH TABLES WITH READ LOCK to get consistent snapshots of my database without shutt

possible problems with FLUSH TABLES WITH READ LOCK

ckup volume is large enough (I print the occupied size at the end of the backup procedure). Well, of course, it may just be the backup tape itself that was screwed up, but it doesn't seem very likely, at least in my opinion, otherwise un-tar-ing it should have failed somewhere. What do yo

Re: MySQL + PHP : 'Commands out of sync; You can't run this command now'

Just replying to myself... After replacing mysql_pconnect() with mysql_connect(), the problems seems gone so far. So chances are it is a bug on the PHP side. Regards Antoine. > Hi, > > I'm having weird errors right now, running MySQL queries from PHP as an > Apache module

MySQL + PHP : "Commands out of sync; You can't run this command now"

queries are launched at the same time by different threads, or nearly. It is MySQL 4.0.4, compiled from source, together with PHP/4.2.3. They are on two different machines. What does this error message mean ? I've never had it before... (and I've been using this setup for a

RE: access db port to mysql

and you can also do it with EMS > MySQL manager. > > If you wanting to view the mysql data in access; you can do this using > myodbc and open it using external data using the ODBC source. > > -Original Message- > From: Antoine [mailto:asolomon15@;nyc.rr.com] > Sen

access db port to mysql

Hello everyone I was wondering if there are any tools that would allow me to port a access database to mysql? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: Performance Question

> I am writing a serverside application in Java which needs to query/search > 200 000 rows and update affected records once every 2 minutes. > As performance/speed is of importance here - and this Table only contains > 5-10 Columns of Integer numbers, I figured that using a HEAP type of table >

AW: Table partitioning functionality

owly varying integer indexes - like timestamps - I recommend you specify PACK_KEYS=1 on table creation, this saves space too. (note : I'm talking about MyISAM here, of course) Good luck, Regards Antoine. >Hi, > >Does MySQL offering a similar functionality as Oracle does with ta

[BUG] Table corrupted by specific sequence (4.0.3-beta)

Description: The following sequence corrupts the table with MySQL 4.0.3-beta. It works fine with 3.23.51. LOCK TABLES t WRITE; DELETE FROM t; OPTIMIZE TABLE t; How to reproduce: - mysql> SELECT version(); ++ | version() | ++ | 4.0.3-beta

Re: LVM snapshots and MySQL ?

Hi, > According to the documentation, you can use: > FLUSH TABLES WITH READ LOCK > for that. > See http://www.mysql.com/doc/en/FLUSH.html > for details Well, that seems perfect. I guess I should have RTFM before ;)) Thanks

LVM snapshots and MySQL ?

deal ;-). Does anyone already use this kind of setup ? Any comments about it ? Thank you Antoine. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the

Re: 4.0.2-alpha slower than 3.23.51 -> record_buffer

8 sec overhead with record_buffer=32M, 0.00 sec with record_buffer=1M. No overhead with 3.23.51. Regards Antoine. (sql,query) - Before posting, please check: http://www.mysql.com/manual.php (the manual) htt

Re: 4.0.2-alpha slower than 3.23.51 -> record_buffer

firm this tomorrow at work However, it's a really strange and annoying behaviour. Nowhere in the documentation is stated something like that, and 3.23 was fine about it. Is it a bug ? Thanks, Antoine. - Before pos

Re: Help : 4.0.2-alpha slower than 3.23.51 :-(

pans a not-so-small dataset. Also, there is not much concurrency and I am not tight on memory (the box has 2 GB). Would it have something to do with the problem ? Regards Antoine. (keywords : sql,query) - Before posting, pl

Help : 4.0.2-alpha slower than 3.23.51 :-(

-rwxr-xr-x1 root root 1260480 Apr 15 15:44 /lib/libc-2.2.5.so -rw-r--r--1 root root 2310808 Apr 15 16:02 /usr/lib/libc.a -rw-r--r--1 root root 178 Apr 15 15:55 /usr/lib/libc.so Configure command: ./configure --localstatedir=/data/mysql --with-innodb

Bad optimization with ENUM ?

roblem : with "state='up'" it fails to recognize that 'up' represents roughly 80% of all rows, and thus a scan of the table should be used instead of the index (the documentation states the index is used only if the estimated number of selected rows is below one third

bug mySQL 3.23.49

sql Antoine Clanché [EMAIL PROTECTED] 0663645239 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EM

Re: bug 11 wysql 3.23.49 win (OS Windows XP)

sql >From: [EMAIL PROTECTED] >To: "Antoine Clanché" <[EMAIL PROTECTED]> >Subject: Re: bug 11 wysql 3.23.49 win (OS Windows XP) >Date: Tue, 28 May 2002 10:32:48 +0200 > >Your message cannot be posted because it appears to be either spam or >simply off topi

Re: (newbie) What's wrong with this READ DATA INFILE?

late to the fact that further concatenating the other lines would break your 40-character limit for 'email'). So I suggest you try to change your separator : mysqlc> load data local infile "c:/temp/e-headhunters.txt&quo

48-bit integers, partial integer indexes ?

MySQL (which is really annoying because application languages like Perl do not necessarily accept integers wider than 32 bits). Thank you Antoine. - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: how to retrieve a hierarchical structure

Hi, A simple way is to make a recursive search by starting from the root, and collecting all ID's from each layer. You need only one query per layer, not one per node. It looks like this : -> start from the desired "directory" : SELECT * FROM table WHERE id_parent IN (8) -> say it returns chil

Re: table type comparison (poor SELECT performance with HEAP tables ?)

Did the machine swap during your tests? 2.4.16, the filesystem is ext3 with noatime. The machine didn't seem to swap (top showed no change in the amount of allocated memory). Yours Antoine. - Before posting, please check:

table type comparison (poor SELECT performance with HEAP tables ?)

The machine is at the same time a production machine but with small loads, and each test was run several times. I can send the test files (4 small PHP scripts ;-)) to the MySQL developpers if they find it interesting. Regards Antoine. -

MERGE Table & DELETE FROM component

nt doesn't seem to me as a big problem. Is it really ? thanx, Antoine -- Antoine PICHOT PGP KEY : http://www-eleves.int-evry.fr/~pichot_a/pgp.txt ICQ : 455751 Port : +33 6 08747743 Tel : +33 1 69362278 - Before p

pb with compressed tables

, with Berkeley DB and InnoDB enabled (however not used). It runs on a dual P3 1GHz with 1GB RAM and a three-disk harware RAID5 SCSI disk array. Thanks in advance for your help Yours Antoine. - Before posting, please chec

Size of DB

Hello, I'm new to MySQL and I was wondering if there was a command that you can issue to see the current size of a mysql database (in kb or MB)? = 'Toine - Before posting, please check: http://www.mysql.com/manual.php (the

Maximum number of columns in a table

Hello, Does any of you know how much columns a MySQl table can handle? Is it fixed or does it depends of some parameters (fields' datatypes, RAM, total table size...)? Thanks DELAUNAY Antoine - Before posting, please

RE: RENAME CRASH MySQL

Read the manual about security and stuff -Original Message- From: Fabien COMBERNOUS [mailto:[EMAIL PROTECTED]] Sent: donderdag 8 maart 2001 15:48 To: Sinisa Milivojevic Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: RENAME CRASH MySQL I'm working with Linux Mandrake 7.0 with MyS

RE: Date query problem (hard one)

but is not very nice.. -Original Message- From: Peter Skipworth [mailto:[EMAIL PROTECTED]] Sent: donderdag 8 maart 2001 9:43 To: Adams, Antoine A SSI-ISES-56 Cc: '[EMAIL PROTECTED]' Subject: Re: Date query problem (hard one) Antione, What's your definition of a week number

Date query problem (hard one)

offcourse this doesn't work.. Anyone any idea's Antoine Adams - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

sql date worries

Hi all, Im kind of strugling with a query for some time now and I need extra input: What is the desired answer from mysql: a date. what is the input: a week number What dat do I need: The date of the monday (week starts at sunday) in the weeknumber. something like: select date(week(10),1)