key_buffer_size vs innodb_buffer_pool_size

Hi, After reading through the example my.cnf files (large, huge, etc), I started to wonder what the difference was between the isam key_buffer_size and the innodb innodb_buffer_pool_size. I realize that they are two different table types, but some of the docs says to set the key_b

MySQL 5.0.15 in Linux OS

Hi list: Recently I download MySQL source from MySQL.com site for install it in my Linux Server. I follow the standard procedure for it, means: shell> ./configure shell> make shell> make install I read the online documentation looking if I need some configuration changes and see that for execut

doc for administration mysql

Hello all, Wich are the best doc for (mysql administration) beginners Thank you -- Bayrouni Email: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Insert into table select * ... union

Hello, I'm collecting data into a very simple table with one varchar(100) field ("myValue") and one int(10) field ("Qty"). I'm doing this with a simple "insert into . on duplicate key update qty = qty +1". After the table has reached a count of several 10 million records every insert takes

Re: one user, multiple passwords

At 12:00 -0600 1/14/06, Fletcher Mattox wrote: Hi, Is it possible for one user to have more than one password; one for each database? My naive attempt at this was No. An "account" in MySQL is defined the by combination of username and hostname that you specify after the TO in the grant statem

one user, multiple passwords

Hi, Is it possible for one user to have more than one password; one for each database? My naive attempt at this was GRANT ALL ON db1.* TO 'fletcher'@'%' IDENTIFIED BY pass1 GRANT ALL ON db2.* TO 'fletcher'@'%' IDENTIFIED BY pass2 But I find that pass2 replaces pass1 on db1 when

RE: [OT] Reload Problem -> "Mass-Reload" crashes DB

> We use PHP. > I´ll try it with mysql_pconnect(); > I´ve already thought about it. > What happens, when we´ve several 1000 Users online. Doesn´t > it open too many connections ? > mysql_connect closes every connection after using. > Does mysql_pconnect() the same ? I think, it's in the docs...pl

Reload Problem -> "Mass-Reload" crashes DB

Thanks for your quick reply. We use PHP. I´ll try it with mysql_pconnect(); I´ve already thought about it. What happens, when we´ve several 1000 Users online. Doesn´t it open too many connections ? mysql_connect closes every connection after using. Does mysql_pconnect() the same ? Thanks a lot

Re: working on Microsoft® Windows Server™ 2003

- Original Message - > hi, > > can new mysql work on Microsoft® Windows Server™ 2003 > > regards > > prao > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > Yes Terry Riley

RE: Reload Problem -> "Mass-Reload" crashes DB

Dear Marco, i'm not sure, this can be solved by MySQL itself, but if you're e.g. using php you may try to use mysql_pconnect () instead of mysql_connect (). Please see http://www.php.net/manual/en/function.mysql-pconnect.php and http://www.php.net/manual/en/function.mysql-connect.php In your favo

working on Microsoft® Windows Server™ 2003

hi, can new mysql work on Microsoft® Windows Server™ 2003 regards prao -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Reload Problem -> "Mass-Reload" crashes DB

Hey, we´ve on 2 website the problem, that if you hit a several times F5 or hold it down to reload the site, MySQL opens many connections and breaks down after a while. How can we prevent this ? I close every MySQL Session and i do an if-statement ( if there´s any open connect ) before i open a