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 new mysql connect. I appreciate any help or suggestions. Thanks in advance. Kind regards Marco Schierhorn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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]
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 favourite server-side-language there may be other functions for persistant database-connections. hth, TomH -- PROSOFT EDV-Loesungen GmbH Co. KG http://www.proSoft.org St.-Kassians-Platz 6, D-93047 Regensburg [EMAIL PROTECTED] Geschaeftsfuehrer: Axel-Wilhelm Wegmannphone: +49 941 / 78 88 7-121 AG Regensburg HRA 6608 USt.183/68311 cellphone: +49 171 / 40 54 777 -- -Original Message- From: ESV Media GmbH [mailto:[EMAIL PROTECTED] Sent: Saturday, January 14, 2006 12:06 PM To: mysql@lists.mysql.com Subject: 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 new mysql connect. I appreciate any help or suggestions. Thanks in advance. Kind regards Marco Schierhorn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 -- 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
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 for your help Marco Tom Horstmann wrote: 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 favourite server-side-language there may be other functions for persistant database-connections. hth, TomH -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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...please RTFM: First, when connecting, the function would first try to find a (persistent) link that's already open with the same host, username and password. If one is found, an identifier for it will be returned instead of opening a new connection. Second, the connection to the SQL server will not be closed when the execution of the script ends. Instead, the link will remain open for future use (mysql_close() will not close links established by mysql_pconnect()). ( http://www.php.net/manual/en/function.mysql-pconnect.php ) Regards, TomH -- PROSOFT EDV-Loesungen GmbH Co. KG http://www.proSoft.org St.-Kassians-Platz 6, D-93047 Regensburg [EMAIL PROTECTED] Geschaeftsfuehrer: Axel-Wilhelm Wegmannphone: +49 941 / 78 88 7-121 AG Regensburg HRA 6608 USt.183/68311 cellphone: +49 171 / 40 54 777 -- -Original Message- From: ESV Media GmbH [mailto:[EMAIL PROTECTED] Sent: Saturday, January 14, 2006 4:27 PM To: mysql@lists.mysql.com Subject: Reload Problem - Mass-Reload crashes DB Thanks for your quick reply. Thanks a lot for your help Marco Tom Horstmann wrote: 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 favourite server-side-language there may be other functions for persistant database-connections. hth, TomH -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 I do this. What am I missing? This is MySQL 4.1.7. Thanks Fletcher -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 statement. Both your statements apply to the same account, so the password in the second statement simply replaces the existing password, as you've discovered. 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 I do this. What am I missing? This is MySQL 4.1.7. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- 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 several seconds - and that's much to slow for my application. To increase the speed, I have splitted the table into 50 parts (table-01, table-02 and so on) and my application is rotating through this tables. For speed reasons it's ok. But now I need to export the top one hundred of Qty values of each table into another summary table and, of course, are trying to do the same on duplicate key update thing. I know that it is mathematically nonsense but it is exact enough for my purposes, because the top one hundred values are very big and the other Qty values are very small... By now, I'm sending 50 insert into summarytable select * from table-xx on duplicate key update commands. After explaining my details, I would like to know, if there is a possibility of a command like insert into summarytable select * from `table-01` union select * from `table-02` union select * from `table-02` on duplicate key update Qty ... I have tried a lot of possibilities, but nearly all caused a sql error message, the other ones did not do what i want... Is any one out there who has a good idea of how I can do this in one command ? Thanks in advance for any possible help Detlev
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]
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 execute MySQL I need run this command: shell /usr/local/bin/mysqld_safe but when I execute them nothing happend. Just this error appear Starting mysqld daemon with databases from /usr/local/var STOPPING server from pid file /usr/local/var/SPL.pid 060114 18:12:04 mysqld ended ¿Anybody knows how to solve it? I have another doubt. How I can setup MySQL for Stara automatically when I restart my Linux Server? I installed Apache and MySQL in the same way, but when I restart the OS, I need to run this two command for start process: shell /usr/local/bin/mysqld_safe (this for MysQL not working yet) shell /usr/local/apache2/bin/apachectl start (this for Apache working fine) I know that in Linux exists a way to do this but not know how to setup. If any can help me I thank every day Ah!!! My Linux Distro is Debian Sarge 3.1 Stable Best, ReynierPM 4to. año Ing. Informática Usuario registrado de Linux: #310201 * El programador superhéroe aprende de compartir sus conocimientos. Es el referente de sus compañeros. Todo el mundo va a preguntarle y él, secretamente, lo fomenta porque es así como adquiere su legendaria sabiduría: escuchando ayudando a los demás... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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_buffer_size to 25%-50% of the overall system memory. The comments for the innodb_buffer_pool_size say that it can be set to 50%-80% of the overall system memory. Maybe I don't understand exactly the difference between the two because I don't understand why they have different memory recommendations. Is there any FAQs on the my.cnf file? How would you set these two variables if you had an even mix of isam and innodb tables? Where can I learn more about tweaking the my.cnf file? The mysql online documentation is good, but I need a more basic description of these two variables and all the other my.cnf settings. Thanks, Grant - Yahoo! Photos Got holiday prints? See all the ways to get quality prints in your hands ASAP.