Backup DB using VeriTas
Using this tool (VeriTas Backup Exec for windows server v9.1) to backup the database crashes MySQLd-nt, has anyone else come across this issue at all? regards
Re: Table Lock issue on insert
John, this SQL statement: INSERT INTO USERS_PER_HOUR SELECT count( DISTINCT ( CUID ) ),`TV_LOG_DATE`,`TV_LOG_TIME`, INTERFACE_ID FROM `TV_LOG_ALL` group by 2,3; sets locks on all the records it scans in TV_LOG_ALL. If you have a small buffer pool, then the InnoDB lock table may indeed grow so big that it does not fit in the buffer pool. The default size of the buffer pool is just 8 MB. Fix: modify my.cnf and increase innodb_buffer_pool_size. But do not make it bigger than about 70 % of your computer's RAM. Best regards, Heikki Oracle Corp./Innobase Oy InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php - Original Message - From: Danny Stolle [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Monday, January 02, 2006 9:31 PM Subject: Re: Table Lock issue on insert Hi John, I have looked around a bit and you might be interested in this part: InnoDB: Do not intentionally crash mysqld if the buffer pool is exhausted by the lock table; return error 1206 instead ... check this link: http://dev.mysql.com/doc/refman/4.1/en/news-4-1-8.html it is quite interesting and i am trying to get this error on my mysql databases by changing the bufferpool and inserting a lot of data; Best regards, Danny Brittingham, John wrote: They are InnoDB and max_write_lock_count=4294967295. The same thing happens when I create a copy of the table. -Original Message- From: Danny Stolle [mailto:[EMAIL PROTECTED] Sent: Saturday, December 31, 2005 2:59 AM To: Brittingham, John; mysql@lists.mysql.com Subject: Re: Table Lock issue on insert Hi John, What kind of engine are you using on your table? MyIsam or InnoDB or are you using merged tables? If you query your system variables what is your max_write_lock_count? If you create a copy of the table: mysqlcreate table cp1 like USERS_PER_HOUR; and you try the insert again; is the error gone? Danny Brittingham, John wrote: I am having trouble with table lock. The query is as follows: INSERT INTO USERS_PER_HOUR SELECT count( DISTINCT ( CUID ) ),`TV_LOG_DATE`,`TV_LOG_TIME`, INTERFACE_ID FROM `TV_LOG_ALL` group by 2,3; I keep getting this error: #1206 - The total number of locks exceeds the lock table size How do I fix this? -- 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: removing ibdata1 if some/all tables are not InnoDB?
Carl, InnoDB does purge deleted rows from the ibdata files. Certain PostgreSQL advocates have been spreading a claim that InnoDB would not do that, but the claim is false. If your ibdata file keeps growing indefinitely, please check with SHOW INNODB STATUS that you do commit all your transactions. If a transaction stays open for months, then the purge cannot remove deleted rows. If you convert ALL your tables from InnoDB to MyISAM, then you can remove the ibdata files and ib_logfiles. If you put skip-innodb to my.cnf, then those files will not be created again. Best regards, Heikki Oracle Corp./Innobase Oy InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php - Original Message - From: Alex [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Tuesday, January 03, 2006 6:55 AM Subject: Re: removing ibdata1 if some/all tables are not InnoDB? HI Carl, The ibdata file growth can be stopped by removing the autoextend keyword in the my.cnf file. In your my.cnf file the entry might be innodb_data_file_path = ibdata1:256M:autoextend If you want to stop the growth of that file and add another file then this is what you want to do. 1. Stop the mysql server 2. Get the size of the ibdata1 file in MB (Lets say its 5600MB in size) 3. edit the my.cnf file and replace innodb_data_file_path = ibdata1:256M:autoextend with innodb_data_file_path = ibdata1:5600M;ibdata2:256M:autoextend 4. Start the server. This will stop that file from growing and a new file will be added that can pushed on to a different disk and symlinked into the ibdata directory. Data growth is a problem in all table types. Even if you migrate to MyISAM you need space. See whether there is log_bin turned on the server. If so there might be lots of bin log files that you can do a cleanup on. Bin logs occupy a great deal of space. Thanx Alex, MySQL DBA Yahoo! On Tue, 03 Jan 2006 08:28:24 +0530, Carl Brewer [EMAIL PROTECTED] wrote: Hello, I'm stuck with a rapidly decreasing amount of available disk space and a requirement to keep a lid on the size of our databases. We're using MySQL 4.1.12 as bundled with RHEL ES 4. We do a lot of transactions keeping short term track of webserver sessions, which we don't need to keep logs of for very long. I have a number of databases, almost all of which are using MyISAM or HEAP, and one database using InnoDB. As such (or at least, as I understand it) we have a ibdata1 file that will grow forever and AFAIK there's no way to stop it growing forever for as long as we have that InnoDB database. Am I correct? I'm no MySQL guru, my parsing of TFM and googling around and finding bug and feature requests for ibdata1 purging suggests that this is the case. If so, if I drop the InnoDB database, stop mysqld, delete (UNIX filesystem) the imdata1 file, restart mysqld and import a (modified to be MyISAM) dumped copy of the InnoDB database, will that work without damaging anything and then not leave me with another infinatly growing imdata1 file? Am I correct in assuming that InnoDB databases are meant for sites where disk space is not ever likely to be an issue, and MyISAM is a more suitable database engine for our much tighter disk space situation? I may have missed a section of the doco that discusses why one would choose an engine over another? Thanks for any advice, Carl -- 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]
character_set_client in v4.1
Hello list I've just install v4.1. Every thing works fine exept SQLyong shows all non-latin characters as question marks and the old Mysql-Front can't connect with tables after mysql_fix_privilege_tables. How can I change character_set_client=greek or UTF8 than to latin? I thing this will solve my problem Is that right? Thank you -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
logging issue
System: Red hat 7.2 My SQL modules: MySQL-devel-4.0.13-0 php-mysql-4.1.2-7.2.6 MySQL-shared-3.23.55-1 MySQL-server-4.0.13-0 MySQL-client-4.0.13-0 CAMysql-9.0-220 Msql-Mysql-DBI-perl-bin-1.1823-1 I would like to log or turn on the facility to do a verbose logging to troubleshoot an issue I'm having with a program on another (mail) server trying to access the mysql server. From the mail server I can issue the following: mysql -h 192.168.10.4 -u mailwatch -p and enter the password and it connects. Yet from within the initial program it does not work and in the mail logs it has: Jan 3 18:19:31 mail MailScanner[11376]: Unable to initialise database connection: Can't connect to MySQL server on '192.168.10.4' (110) I've ask the mailscanner list, the mailwatch list and the postfix list and we are not getting anywhere. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: REVOKE GRANT OPTION - is that possible?
# mysqlmgr add database www1 # mysqlmgr add user www1 password xxx # mysqlmgr allow user www1 database www1 read write define I suppose in some cases this is OK, and I'm sure you will test thoroughly! :-) One thing to bear in mind is that if you define a user and then revoke his privileges, his account details details will still persist in the user Grant table. This may not be a worry to you since he cannot get at any database resource. To remove any trace of him, you must delete him from the user table. (if you're playing with MySQL 5.0 then DROP USER is the ticket). Final thing, as you're a MySQL admin type writing an access control app, you want to know when the priv changes take effect. You will probably find this info useful: http://dev.mysql.com/doc/refman/5.0/en/privilege-changes.html Hope that helps, Imran Chaudhry -- http://www.EjectDisc.com Get your Digital Identity - Domain Names, Web Space, E-mail More! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL server has gone away ??
I have been using mysql client for some time when I got this error: mysql select * from mytable; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... ERROR 1045 (28000): Access denied for user 'username'@'my.ip.addr' (using password: YES) ERROR: Can't connect to the server mysql quit Bye $ mysql -h sql -u sqluser -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6669 to server version: 4.1.8-standard MySQL is running on a server and I have to go through a firewall to reach it. Any reason why this happens? Should I be worried? -- Jørn Dahl-Stamnes homepage: http://www.dahl-stamnes.net/dahls/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: removing ibdata1 if some/all tables are not InnoDB?
Heikki Tuuri wrote: Carl, InnoDB does purge deleted rows from the ibdata files. Certain PostgreSQL advocates have been spreading a claim that InnoDB would not do that, but the claim is false. Could You explain more about reusing space previously taken by deleted rows? Is this concept similar to Oracle's concepts in this regard ? Regards Remigusz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Replication A-B-C - changes on B are not replicated to C
Hi all I followed Gleb's advice (see below), removed all filters, restarted the db servers - same behaviour. Still replications work if there are changes made on A. Then these changes are replicated A-B-C. When making changes on B, i can see them in the bin-log on B and the relay-log of C but they are not written to the db on C. Since there are no filters on C (anymore) and the replication with changes on A works, i just don't understand where the problem could be. There also are no error messages in the err log. Everything seems else to work fine. Is there any way to get a more detailed logging of what is happening during the replication (kind of debug information)? To make sure that the replicated SQL queries are ok i put them out of the relay bin of C and issued them to the db on C using MySQLQueryBrowser. That worked fine. Another funny thing is, when i issue LOAD DATA FROM MASTER on C it loads all data from master B inclusive all changes that have been made on B which were not replicated before. My conclusion so far: The data is in the relay-log on C but it's not put into the database for some reason. I simply have no clue what reason it could be. In fact i'm a little bit confused right now so any help is very welcome. Greetings Frank From: Glebnbsp;PaharenkoDate: December 28 2005 4:01pm Subject: Re: Replication A-B-C - changes on B are not replicated to C Hello. So now my question is: is it basically possible to do this or doesn't mysql replication mechanism support this setup? If it is possible: Any idea where the problem could be? If it's not possible: any idea for a different setup that would allow to this? You should localize the problem. Research binary logs on B and check if the statement which is not replicated is stored. In case it is stored , research relay logs on C. Remove filters if they're present on C to find out if the problem in them. _ From: Frank Fischer [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 28, 2005 3:44 PM To: 'mysql@lists.mysql.com' Subject: Replication A-B-C - changes on B are not replicated to C Hi all i have a question related to replication on 4.0.x. I have the following setup: A - B - C A is a Master and writes all changes to its binlog (meaning there is no filter set). B acts as Slave from A and as Master for C. As a Slave B has filters set, so not every change of every database and table is beeing replicated from the relaylog. As Master there are also filters set, so not every database is written to the binlog. On B log-slave-updates is set. C replicates as a Slave of B and also has filters set, so not every database and table is replicated from B. Now, there is a table system.subscribers. This table exists on A, B and C. This table is based on MyISAM, so i started the replication on B by calling LOAD DATA FROM Master. Same on C. This worked so far. Now when i change a record in the subscribers table, the changes are replicated from A to B and from B to C. That also works as expected. But now there is a field in the subscribers table, that will NEVER be changed on A but has to be changed on B. When i do such a change on B, i expect this change to be replicated to C but this does not happen. So now my question is: is it basically possible to do this or doesn't mysql replication mechanism support this setup? If it is possible: Any idea where the problem could be? If it's not possible: any idea for a different setup that would allow to this? Thanks a lot for your help. Kind regards Frank
Problem installing MySQL 5.0
Hello everybody, This is the first time I try to install MySQL 5.0, I think I followed the steps showed by the documentation in the right way, but when I run the command: rpm -i MySQL-server-Version-.i386.rpm I get back the error: error: Failed dependencies: perl(DBI) is needed by MySQL-server-standard-5.0.18-0.rhel3 I am trying to install MySQL on this platform: - CPU:AMD Athlon 800 Mhz - Operating System: Linux Fedora core 2, release 2.6.5-1.358 The packages I have downloaded are: - MySQL-server-standard-5.0.18-0.rhel3.i386.rpm - MySQL-client-standard-5.0.18-0.rhel3.i386.rpm After the error, I found a few information on internet about perl(DBI), so I downloaded it and installed it on my system. The test step (make test) ended with error 355 (??), but I run anyway make install which ended without problems, I think. At this point I do not know what to do, so I need your help to solve this problem. Greetings Francesco Vincenti * *
RE: need to upgrade
The online documentation would be a good place to start. http://dev.mysql.com/doc/refman/4.1/en/upgrade.html -Original Message- From: Jon Miller [mailto:[EMAIL PROTECTED] Sent: Sunday, January 01, 2006 7:44 PM To: mysql@lists.mysql.com Subject: need to upgrade I need to upgrade MySQL from a RH7.2 server to either a Suse Enterprise 9.2 or Debian 3.1 server. I understand that the only way to get the data from the RH7.2 server is via mysqldump. Are there any gotchas or issues doing this? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] INFORMATION IN THIS MESSAGE, INCLUDING ANY ATTACHMENTS, IS INTENDED FOR THE PERSONAL AND CONFIDENTIAL USE OF THE INTENDED RECIPIENT(S) NAMED ABOVE. If you are not an intended recipient of this message, or an agent responsible for delivering it to an intended recipient, you are hereby notified that you have received this message in error, and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you received this message in error, please notify the sender immediately, delete the message, and return any hard copy print-outs. This message has been scanned for viruses by McAfee's Groupshield. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: removing ibdata1 if some/all tables are not InnoDB?
InnoDB does purge deleted rows from the ibdata files. Certain PostgreSQL advocates have been spreading a claim that InnoDB would not do that, but the claim is false. If your ibdata file keeps growing indefinitely, please check with SHOW INNODB STATUS that you do commit all your transactions. If a transaction stays open for months, then the purge cannot remove deleted rows. If you convert ALL your tables from InnoDB to MyISAM, then you can remove the ibdata files and ib_logfiles. If you put skip-innodb to my.cnf, then those files will not be created again. I don't think there is a question as to whether or not InnoDB will purge data and re-use space, the question is whether or not the ibdata files will be shrunk when that space is purged. My understanding (and experience) has always shown that ibdata files - while they may purge and re-use unused space, will not shrink themselves based on the actual space usage. Is that not correct? I.e., if I have 100 MB of table data, and say - delete 6 tables (which would result in InnoDB recovering all that space), that results in only 10MB of space being used, the file will be re-sized to 10MB - or something smaller than 100 MB. The practical example would be if I were to accidentally add 1GB of data to my InnoDB tablespace, and then remove it. Would my total ibdata file sizes total less than 1GB of space (now I'm just using 100MB)? If that were the case it would be a simple matter of switching to 'tablespace per table', migrating the data to the individual tables (which would shrink the ibdata files), re-structuring the ibdata files (to use other partitions, etc.) an the moving the data back into the tablespace. Thanks -- Chander Ganesan Open Technology Group, Inc. One Copley Parkway, Suite 210 Morrisville, NC 27560 Phone: 877-258-8987/919-463-0999 http://www.otg-nc.com Best regards, Heikki Oracle Corp./Innobase Oy InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php - Original Message - From: Alex [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Tuesday, January 03, 2006 6:55 AM Subject: Re: removing ibdata1 if some/all tables are not InnoDB? HI Carl, The ibdata file growth can be stopped by removing the autoextend keyword in the my.cnf file. In your my.cnf file the entry might be innodb_data_file_path = ibdata1:256M:autoextend If you want to stop the growth of that file and add another file then this is what you want to do. 1. Stop the mysql server 2. Get the size of the ibdata1 file in MB (Lets say its 5600MB in size) 3. edit the my.cnf file and replace innodb_data_file_path = ibdata1:256M:autoextend with innodb_data_file_path = ibdata1:5600M;ibdata2:256M:autoextend 4. Start the server. This will stop that file from growing and a new file will be added that can pushed on to a different disk and symlinked into the ibdata directory. Data growth is a problem in all table types. Even if you migrate to MyISAM you need space. See whether there is log_bin turned on the server. If so there might be lots of bin log files that you can do a cleanup on. Bin logs occupy a great deal of space. Thanx Alex, MySQL DBA Yahoo! On Tue, 03 Jan 2006 08:28:24 +0530, Carl Brewer [EMAIL PROTECTED] wrote: Hello, I'm stuck with a rapidly decreasing amount of available disk space and a requirement to keep a lid on the size of our databases. We're using MySQL 4.1.12 as bundled with RHEL ES 4. We do a lot of transactions keeping short term track of webserver sessions, which we don't need to keep logs of for very long. I have a number of databases, almost all of which are using MyISAM or HEAP, and one database using InnoDB. As such (or at least, as I understand it) we have a ibdata1 file that will grow forever and AFAIK there's no way to stop it growing forever for as long as we have that InnoDB database. Am I correct? I'm no MySQL guru, my parsing of TFM and googling around and finding bug and feature requests for ibdata1 purging suggests that this is the case. If so, if I drop the InnoDB database, stop mysqld, delete (UNIX filesystem) the imdata1 file, restart mysqld and import a (modified to be MyISAM) dumped copy of the InnoDB database, will that work without damaging anything and then not leave me with another infinatly growing imdata1 file? Am I correct in assuming that InnoDB databases are meant for sites where disk space is not ever likely to be an issue, and MyISAM is a more suitable database engine for our much tighter disk space situation? I may have missed a section of the doco that discusses why one would choose an engine over another? Thanks for any advice, Carl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General
Re: Problem installing MySQL 5.0
You can force the installation (--nodeps) when installing the RPM package. Even if you build DBI (and not install it from RPM) it won't be in the RPM database, and you'll get the same error. You should be able to get a FC2 RPM for the DBI module - download that RPM and install it, then install MySQL - that would be the easiest course of action... -- Chander Ganesan Open Technology Group, Inc. One Copley Parkway, Suite 210 Morrisville, NC 27560 Phone: 877-258-8987/919-463-0999 http://www.otg-nc.com Francesco Vincenti wrote: Hello everybody, This is the first time I try to install MySQL 5.0, I think I followed the steps showed by the documentation in the right way, but when I run the command: rpm -i MySQL-server-Version-.i386.rpm I get back the error: error: Failed dependencies: perl(DBI) is needed by MySQL-server-standard-5.0.18-0.rhel3 I am trying to install MySQL on this platform: - CPU:AMD Athlon 800 Mhz - Operating System: Linux Fedora core 2, release 2.6.5-1.358 The packages I have downloaded are: - MySQL-server-standard-5.0.18-0.rhel3.i386.rpm - MySQL-client-standard-5.0.18-0.rhel3.i386.rpm After the error, I found a few information on internet about perl(DBI), so I downloaded it and installed it on my system. The test step (make test) ended with error 355 (??), but I run anyway make install which ended without problems, I think. At this point I do not know what to do, so I need your help to solve this problem. Greetings Francesco Vincenti * * -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySql 5 replacement for computed default column value
In article [EMAIL PROTECTED], Daniel Kasak [EMAIL PROTECTED] writes: Bryan Cantwell wrote: Trying to migrate to MySql 5 from Sybase asa. I have a tables that have column values that are calculated based on other columns in the table. How can I accomplish the same in MySql? This sounds a job for a trigger - an insert trigger. I haven't used triggers in mysql, so I can't help you with exactly how to do it. If SELECT performance is good enough, a VIEW would probably be easier. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: logging issue
Jon Miller wrote: System: Red hat 7.2 My SQL modules: MySQL-devel-4.0.13-0 php-mysql-4.1.2-7.2.6 MySQL-shared-3.23.55-1 MySQL-server-4.0.13-0 MySQL-client-4.0.13-0 CAMysql-9.0-220 Msql-Mysql-DBI-perl-bin-1.1823-1 I would like to log or turn on the facility to do a verbose logging to troubleshoot an issue I'm having with a program on another (mail) server trying to access the mysql server. From the mail server I can issue the following: mysql -h 192.168.10.4 -u mailwatch -p and enter the password and it connects. Yet from within the initial program it does not work and in the mail logs it has: Jan 3 18:19:31 mail MailScanner[11376]: Unable to initialise database connection: Can't connect to MySQL server on '192.168.10.4' (110) I've ask the mailscanner list, the mailwatch list and the postfix list and we are not getting anywhere. If you're not using SSL, I'd recommend that you fire up ethereal on the client or the server . You can have ethereal show you the entire conversation - should help you filter out several different types of problems that could occur. A lot of things could be happening outside of what MySQL would see (for example, the mailscanner could be trying to connect to the wrong port on the server - the (110) makes me wonder if it's trying to connect to port 110). This would help diagnose a lot of those. -- Chander Ganesan Open Technology Group, Inc. One Copley Parkway, Suite 210 Morrisville, NC 27560 Phone: 877-258-8987/919-463-0999 http://www.otg-nc.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: need to upgrade
Yes, potentially there are gotchcas. It all depends on your current MySQL server version and the version you are upgrading to. Assuming you are upgrading 3.23 to 4.0, what I would do is look at the official documentation regarding upgrades from exactly this scenario: http://dev.mysql.com/doc/refman/4.1/en/upgrading-from-3-23.html I think you'll find the upgrade pretty painless from a data point of view, but you will need to heed the changes to the GRANT tables. Imran Chaudhry -- http://www.EjectDisc.com Get your Digital Identity - Domain Names, Web Space, E-mail More! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Exporting utf-8 data problems
MySQL List, I have recently switched over from Windows to Ubuntu Linux, in order to emulate as much as possible the environment I have on my web hosting service. The goal is to be able to develop and test my web sites more completely at home before uploading them. I have successfully installed Apache, PHP, and MySQL (Most of which came by default when installing Ubuntu). I'm comfortable writing PHP and MySQL code in a web page, but I am very much a beginner in MySQL set up and maintenance. I have all the PHP and HTML files downloaded, and now my next step is to copy the databases from my web hosting service to my home machine. A lot of my database data is bilingual, English and Japanese. I try at every turn to store and retrieve all data in UTF-8 format. Using phpMyAdmin on my virtual hosting service, I exported my database information to a text file, which I then opened on my local machine, again through the phpMyAdmin interface. It mostly worked. All the tables and their contents were inserted into the home version of the database. However, when viewing the web pages where content is dynamically called from the database, all the Japanese text appears on my home machine as a series of question marks. So far as I know, I selected to use utf-8 encoding at every available opportunity. I'm wondering if the problems came when saving to a plain text file. Can anyone recommend the best way to preserve text encoding methods when copying a database from one machine to another? Any advice is much appreciated. Thank you. -- Dave M G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: logging issue
Morning Jon, You will not be too successful in using MySQL logging to trace this. You need to be able to connect to the server at the very least before this would help. I don't know much about MailScanner but I would be checking a couple of things, 1) do you have a firewall in place? is the port (generally 3306) open? and 2) is there a configuration file for MailScanner that has been set up correctly? This sounds more like a network issue rather than a MySQL problem. Are you able to ping 192.168.10.4 from the MailScanner box? Can you telnet to it? You could use tcpdump or similar to check the network conversations. Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +618 8408 4273 _/ _/ _/_/_/ Mobile: 0417 268 665 *_/ ** ** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia invent --- -Original Message- From: Jon Miller [mailto:[EMAIL PROTECTED] Sent: Tuesday, 3 January 2006 9:03 PM To: mysql@lists.mysql.com Subject: logging issue System: Red hat 7.2 My SQL modules: MySQL-devel-4.0.13-0 php-mysql-4.1.2-7.2.6 MySQL-shared-3.23.55-1 MySQL-server-4.0.13-0 MySQL-client-4.0.13-0 CAMysql-9.0-220 Msql-Mysql-DBI-perl-bin-1.1823-1 I would like to log or turn on the facility to do a verbose logging to troubleshoot an issue I'm having with a program on another (mail) server trying to access the mysql server. From the mail server I can issue the following: mysql -h 192.168.10.4 -u mailwatch -p and enter the password and it connects. Yet from within the initial program it does not work and in the mail logs it has: Jan 3 18:19:31 mail MailScanner[11376]: Unable to initialise database connection: Can't connect to MySQL server on '192.168.10.4' (110) I've ask the mailscanner list, the mailwatch list and the postfix list and we are not getting anywhere. Thanks -- 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: Problem installing MySQL 5.0
Hello Chander, thank you very much. I tried to do in your way ad the installation works! I downloaded the perl(DBI) .rpm and I installed it the first time using the command: rpm -Uvh perl-DBI-1.50-1.i386.rpm but I got back an error about one glibc library not founded, so I use this format: rpm -Uvh --nodeps perl-DBI-1.50-1.i386.rpm and the installation finished without problems. Then, I installed both MySQL-server-standard-5.0.18-0 .rhel3.i386.rpm, with which I have had the problem, and MySQL-client-standard-5.0.18-0.rhel3.i386.rpm and all went in the right way. Greetings Francesco Vincenti
Are these db stats normal?
I used phpMyAdmin to look at the stats for my MySQL server. here's what they show... http://www.2-bit-toys.com/db_info/server_status.html What concerns me mainly are the stats at the top-right...'Failed attempts' and 'Aborted.' When would these situations occur? Is it normal to see these? I'm using PHP's mysql_pconnect for all my scripts. Could this be causing the failed/aborted attempts? What is not clear in the documentation is whether mysql_pconnect will open another connection if the current one is in use. -James
MySQL Connector/J 5.0.0 Beta Has Been Released
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL Connector/J 5.0.0 Beta, a new version of the Type-IV all-Java JDBC
driver for MySQL has been released. You will notice that there is a new
version numbering scheme for this release that more closely aligns with
the server version that the JDBC driver is intended to be used with. You
will soon see new base version numbers for all new connectivity
libraries released by MySQL, including Connector/Net, Connector/ODBC and
Connector/MXJ. Hopefully this will help alleviate the common question of
Which driver version should I use with my MySQL server?.
Version 5.0.0 is a development release based on code from the stable
tree. It is essentially Connector/J 3.1.13 with support for XA back
ported from the Connector/J 3.2 branch, as well as some internal
refactorings to support JDBC-4.0 features.
New features that are included:
* Support for Connector/MXJ integration via url subprotocol
jdbc:mysql:mxj://.
* XA Distributed Transactions via the
com.mysql.jdbc.jdbc2.optional.MysqlXADataSource implementation of
javax.sql.XADataSource.
* Statement.cancel() and Statement.setQueryTimeout().
Connector/J 5.0.0 is suitable for use with any MySQL version including
MySQL-4.1, MySQL-5.0 or MySQL-5.1.
We expect that Connector/J 5.0 will soon stabilize, as the majority of
the codebase is from Connector/J 3.1 which is a generally available
release, with largely non-disruptive new functionality added (namely XA)
to the 5.0 codebase (which is also why this is a beta release out of
the gate).
It is now available in source and binary form from the Connector/J
download pages at http://dev.mysql.com/downloads/connector/j/5.0.html
and mirror sites (note that not all mirror sites may be up to date at
this point of time - if you can't find this version on some mirror,
please try again later or choose another download site.)
-Mark
- From the changelog:
12-23-05 - Version 5.0.0-beta
- - XADataSource implemented (ported from 3.2 branch which won't be
released as a product). Use
com.mysql.jdbc.jdbc2.optional.MysqlXADataSource as your datasource
class name in your application server to utilize XA transactions in
MySQL-5.0.10 and newer.
- - PreparedStatement.setString() didn't work correctly when sql_mode on
server contained NO_BACKSLASH_ESCAPES, and no characters that needed
escaping were present in the string.
- - Attempt detection of the MySQL type BINARY (it's an alias, so this
isn't always reliable), and use the java.sql.Types.BINARY type mapping
for it.
- - Moved -bin-g.jar file into separate debug subdirectory to avoid
confusion.
- - Don't allow .setAutoCommit(true), or .commit() or .rollback() on an
XA-managed connection as-per the JDBC specification.
- - If the connection useTimezone is set to true, then also respect
timezone conversions in escape-processed string literals (e.g. {ts
...} and {t ...}).
- - Return original column name for RSMD.getColumnName() if the column was
aliased, alias name for .getColumnLabel() (if aliased), and original
table name for .getTableName(). Note this only works for MySQL-4.1 and
newer, as older servers don't make this information available to clients.
- - Setting useJDBCCompliantTimezoneShift=true (it's not the default)
causes the driver to use GMT for _all_ TIMESTAMP/DATETIME timezones, and
the current VM timezone for any other type that refers to timezones.
This feature can not be used when useTimezone=true to convert between
server and client timezones.
- - Add one level of indirection of internal representation of
CallableStatement parameter metadata to avoid class not found issues on
JDK-1.3 for ParameterMetadata interface (which doesn't exist prior to
JDBC-3.0).
- - Added unit tests for XADatasource, as well as friendlier exceptions
for XA failures compared to the stock XAException (which has no messages).
- - Fixed BUG#14279 - Idle timeouts cause XAConnections to whine about
rolling themselves back
- - Added support for Connector/MXJ integration via url subprotocol
jdbc:mysql:mxj://.
- - Removed Java5-specific calls to BigDecimal constructor (when result
set value is '', (int)0 was being used as an argument in-directly via
method return value. This signature doesn't exist prior to Java5.)
- - Moved all SQLException creation to a factory method in SQLError,
groundwork for JDBC-4.0 SQLState class-based exceptions.
- - Added service-provider entry to META-INF/services/java.sql.Driver for
JDBC-4.0 support.
- - Return [VAR]BINARY for RSMD.getColumnTypeName() when that is
actually the type, and it can be distinguished (MySQL-4.1 and newer).
- - When fix for BUG#14562 was merged from 3.1.12, added functionality for
CallableStatement's parameter metadata to return correct information for
.getParameterClassName().
- - Fuller synchronization of Connection to avoid deadlocks when using
multithreaded frameworks that multithread a single connection (usually
not recommended, but the JDBC spec allows it
Re: MySql 5 replacement for computed default column value
Harald Fuchs wrote: In article [EMAIL PROTECTED], Daniel Kasak [EMAIL PROTECTED] writes: Bryan Cantwell wrote: Trying to migrate to MySql 5 from Sybase asa. I have a tables that have column values that are calculated based on other columns in the table. How can I accomplish the same in MySql? This sounds a job for a trigger - an insert trigger. I haven't used triggers in mysql, so I can't help you with exactly how to do it. If SELECT performance is good enough, a VIEW would probably be easier. The advantage of a trigger is that it only runs when the data is inserted ( and possibly updated ). Depending on the use of the database, you may have a situation where the data is inserted and then selected from multiple times - that's at least the usage pattern we have here. In this case, you're better off with a stored procedure. Also keep in mind that the title of the post said 'default', indicating that the fields in question might take on a different value to the calculated one. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Which Engine?
I need some advice re my choice of a storage engine for transaction-safe processing and including tables that are not transaction-safe within transactions. The problem: We need to insert related records into several different tables and be sure that all the insertions succeeded. It seems that transactions are the recommended way of achieving this and I was thinking of using InnoDB tables. However, I'm not sure if that is the best engine to use - can anyone give me reasons for selecting a specific transaction-safe engine? Also, some of my insertions will involve the mySQL tables (creation of a new user and granting privileges, for example). According to the manuals, those tables use the myISAM engine and can not be changed to any other engine. What is the best way to handle insertion errors on myISAM tables? I had planned to test for an error after each operation and, if one occurred, manually undo whatever previous operations had already succeeded. That's a lot of work if the operation involves multiple tables and I'd like to know if there is a better alternative. Finally, if I do handle errors manually, what should I do if there is an error in the error handler? For example, suppose I've inserted one record and then an error prevents insertion of the related record so that I have to delete the previously inserted record. Is it possible for the delete to fail? If so, I'll have a partial transaction that can't be completed and can't be undone - what should I do to clean up? Thanks for the help, -- John Hoover [EMAIL PROTECTED] 301-890-6932 (H) 202-767-2335 (W) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Which Engine?
John Hoover [EMAIL PROTECTED] wrote on 12/31/2005 04:18:34 PM: I need some advice re my choice of a storage engine for transaction- safe processing and including tables that are not transaction-safe within transactions. The problem: We need to insert related records into several different tables and be sure that all the insertions succeeded. It seems that transactions are the recommended way of achieving this and I was thinking of using InnoDB tables. However, I'm not sure if that is the best engine to use - can anyone give me reasons for selecting a specific transaction-safe engine? Also, some of my insertions will involve the mySQL tables (creation of a new user and granting privileges, for example). According to the manuals, those tables use the myISAM engine and can not be changed to any other engine. What is the best way to handle insertion errors on myISAM tables? I had planned to test for an error after each operation and, if one occurred, manually undo whatever previous operations had already succeeded. That's a lot of work if the operation involves multiple tables and I'd like to know if there is a better alternative. Finally, if I do handle errors manually, what should I do if there is an error in the error handler? For example, suppose I've inserted one record and then an error prevents insertion of the related record so that I have to delete the previously inserted record. Is it possible for the delete to fail? If so, I'll have a partial transaction that can't be completed and can't be undone - what should I do to clean up? Thanks for the help, -- John Hoover [EMAIL PROTECTED] 301-890-6932 (H) 202-767-2335 (W) You are going to need to setup your own application-level locking scheme and rollback procedures if you don't want to use or cannot use the locking and transaction support built into InnoDb. For the tables that do not support transactions (because they are MyISAM or something else) you will probably need to take snapshots of the initial state of each table, ensuring that no other process tries to update or insert to that table while you have it snap-shotted (or you will invalidate the OTHER process should you need to roll back). The table-wide locks are generally good enough for that kind of protection but they are performance killers if you have any sort of concurrency or if your transaction takes too long. I would strongly recommend NOT using the mysql tables for your application's security needs. I would roll my own application-level permission tables and use them to control access through the front end. Generally, my end users do not get direct read-write access to the tables behind any application. They may get read-only access but that's through their own accounts, not the accounts I use to access the DB with from the application itself. If you still need to create user accounts on the fly, stick with the GRANT and REVOKE statements and do that part of the processing either first or last (outside of your other transactions) That way you can know for sure if you got the account changed or not either before you start the transaction or just before you commit or rollback. Lookup and be aware that certain commands contain an implicit COMMIT when they are executed so your transaction may end earlier than you planned if you use one of those commands. These are usually data definition statements (ALTER TABLE, etc) but it's better for you if you know them all. Sorry I can't be more specific but it's time to blast and dinner is waiting. Cheers! Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Are these db stats normal...part 2
I just issued a show status query and the numbers are what MySQL returns. Strange. Failed attempts (aka aborted_clients) : 8154 Aborted (aka Aborted_connects): 319 Total (aka Connections) : 4626 So phpMyAdmin is basing the % calculations on these numbers, that's why we see the weird percentage. The aborted_clients and the aborted_connects concern me, but the applications seem to be working fine! I found the following: http://dev.mysql.com/doc/refman/4.1/en/communication-errors.html My scripts are using mysql_pconnect(), so I don't call mysql_close() (they list not calling mysql_close() as a possible cause for seeing Aborted_clients increment.) They also said...The max_allowed_packet variable value is too small or queries require more memory than you have allocated for mysqld. See Section A.2.9, Packet too large. I haven't tested this but we never encountered this when we were testing with large data in development. I'm looking at the data heavy tables in production and they average 140K per row...which is not even close to the 1MB max_allowed_packet default limit. Any ideas? Anybody else encounter this? -James
Lost Connection executing query
Howdy all, First off, We're running 5.0.15. Theres a particular update statement that we run that updates data in several tables. On our mac OSX test server (also running 5.0.15) the query executes quickly and without any errors or warnings. On our linux box, which is our production box, we get the following error as soon as the query is executed: ERROR 2013 (HY000): Lost connection to MySQL server during query The databases have a similar amount of data in them. I've googled on the error but mostly get pages containing questions about the error when generated by stored procedures and mostly on 5.0.3. We're not using stored procedures. This is just a straight-up query. Here's the query: UPDATE customer_indicator INNER JOIN customer_search_pref ON customer_search_pref.customer_id = customer_indicator.customer_id AND customer_search_pref.office_id = customer_indicator.office_id LEFT JOIN contact_log ON contact_log.customer_id = customer_indicator.customer_id LEFT JOIN sent ON sent.pref_id = customer_search_pref.pref_id SET customer_indicator.office_id = 33, customer_search_pref.office_id =33, customer_indicator.agent_id = 105, sent.office_id = 33, contact_log.office_id = 33, customer_indicator.next_message_id = 4403 WHERE customer_indicator.customer_id = 78437 AND customer_indicator.office_id = 34; The approximate sizes of the tables involved are: customer_indicator: 40K records customer_search_pref: 45K contact_log: 390K sent: 20M (million) So my question is, what are some possible causes of this error? Why would trying to execute this query cause the connection to be lost? Why would the query work fine on our mac system and fail on the prodcution box? Thanks, Tripp __ Yahoo! DSL Something to write home about. Just $16.99/mo. or less. dsl.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Help...I am desparate
I am trying to start mysql and I keep getting the following error. There is no other server or anything else using port 1000. I have checked netstat and the port is not active. 60103 15:54:02 mysqld started 060103 15:54:02 InnoDB: Started; log sequence number 0 386242 060103 15:54:02 [ERROR] Can't start server: Bind on TCP/IP port: Permission denied 060103 15:54:02 [ERROR] Do you already have another mysqld server running on port: 1000 ? 060103 15:54:02 [ERROR] Aborting 060103 15:54:02 InnoDB: Starting shutdown... 060103 15:54:04 InnoDB: Shutdown completed; log sequence number 0 386242 060103 15:54:04 [Note] /usr/sbin/mysqld: Shutdown complete 060103 15:54:04 mysqld ended My /etc/my.cnf file is: [EMAIL PROTECTED] v3src]$ more /etc/my.cnf [mysqld] datadir=/home/iepm/mysql socket=/home/iepm/mysql/mysql.sock port=1000 [mysqld.server] datadir=/home/iepm/mysql socket=/home/iepm/mysql/mysql.sock port=1000 [client] socket=/home/iepm/mysql/mysql.sock port=1000 The system had crashed and burned because of a disk error so I have loaded it with the following rpms [EMAIL PROTECTED] v3src]$ rpm -qa | grep -i mysql MySQL-client-standard-5.0.18-0.rhel3 MySQL-server-standard-5.0.18-0.rhel3 MySQL-standard-debuginfo-5.0.18-0.rhel3 MySQL-shared-standard-5.0.18-0.rhel3 MySQL-devel-standard-5.0.18-0.rhel3 The machine is running: Linux socrates.xxx.xxx.xxx 2.4.21-27.0.2.ELsmp #1 SMP Tue Jan 18 19:25:35 CST 2005 i686 i686 i386 GNU/Linux And the release is: [EMAIL PROTECTED] v3src]$ more /etc/redhat-release Scientific Linux SL Release 3.0.4 (SL) [EMAIL PROTECTED] v3src]$ I have not been able to load the perl DBD bundle either. I do: /usr/bin/perl -MCPAN -e 'install::DBD::mysql' and it complains because the server isn't running. I actually am having this problem also on a system running mysql Ver 14.7 Distrib 4.1.10, for pc-linux-gnu (i686) It will not sucessfully install the perl bundle there. I have run into these problems several times in the past, and eventually tried everything I have tried today, and something usually breaks it loose...but I have had no luck for several days now. Any help you can provide will be greatly appreciated. Connie Logg Connie Logg, Network Analyst Stanford Linear Accelerator Center ph: 650-926-2879 Happiness is found along the way, not at the end of the road, and 'IF' is the middle word in life. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Help...I am desparate
Hi Connie, 060103 15:54:02 [ERROR] Can't start server: Bind on TCP/IP port: Permission denied 060103 15:54:02 [ERROR] Do you already have another mysqld server running on port: 1000 ? You can't bind to a port less than 1024 unless you're running as root. I suspect that's the problem here. Try another port, higher than 1024. I'm kind of curious why you aren't running it on the standard 3306? Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Help...I am desparate
I was asked (told) by my security people to use a port 1024. I am running with 1000 other places, and was running with 1000 on both of these machines. -Original Message- From: Jeremy Cole [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 03, 2006 4:25 PM To: Logg, Connie A. Cc: mysql@lists.mysql.com Subject: Re: Help...I am desparate Hi Connie, 060103 15:54:02 [ERROR] Can't start server: Bind on TCP/IP port: Permission denied 060103 15:54:02 [ERROR] Do you already have another mysqld server running on port: 1000 ? You can't bind to a port less than 1024 unless you're running as root. I suspect that's the problem here. Try another port, higher than 1024. I'm kind of curious why you aren't running it on the standard 3306? Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Database slows down when mass users logging on
Hi everyone I run a relatively popular forum that gets overloaded on match days. On normal days, the site is coping fine, but when there are plenty of users on the forum (about 50-70 odd) the load goes up and the site crawls, before crashing, and the server rebooted The forum software is phpBB. The URL is: http://www.arsenal-mania.com/ On normal days though with about the same amount of users, the site is fine. The site is running on: AMD Athlon 64 3000+ 1GB 400MHz DDR RAM CentOS 3.62 mySQL 5.0.17 I am assuming that the reason the site is slowing down is because when a match ends, people are logging on to the site to check full-time scores, and this creates a number of database connections simultaneously. This is what I have in my my.cnf file: [mysqld] set-variable = max_connections=500 set-variable = max_user_connections=350 set-variable = long_query_time=5 set-variable = thread_cache_size=40 set-variable = wait_timeout=20 query_cache_size = 20M safe-show-database log_error = /var/log/mysql_error.log log-slow-queries = /var/log/mysql_slow_queries.log Short of increasing the amount of physical RAM, I am hoping to explore configuration options beforehand. If anyone has any ideas I can try out, I'd appreciate it if you could please let me know. I can provide more stats if necessary! Thanks in advance. -- Jonathan Chong http://www.arsenal-now.com/ http://www.arsenal-mania.com/ http://www.ashburrn.com/ http://www.jonathan-chong.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Help...I am desparate
Logg, Connie A. wrote: I was asked (told) by my security people to use a port 1024. I am running with 1000 other places, and was running with 1000 on both of these machines. -Original Message- From: Jeremy Cole [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 03, 2006 4:25 PM To: Logg, Connie A. Cc: mysql@lists.mysql.com Subject: Re: Help...I am desparate Hi Connie, 060103 15:54:02 [ERROR] Can't start server: Bind on TCP/IP port: Permission denied 060103 15:54:02 [ERROR] Do you already have another mysqld server running on port: 1000 ? You can't bind to a port less than 1024 unless you're running as root. I suspect that's the problem here. Try another port, higher than 1024. I'm kind of curious why you aren't running it on the standard 3306? Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 This might work... 1. Follow the steps in http://dev.mysql.com/doc/refman/4.1/en/changing-mysql-user.html 2. Run the mysql init script as root. However, if MySQL drops privileges before binding to its sockets, then it won't work. I'm afraid I don't know that much about MySQL's internals. --Ludwig -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
question about sql security
I refer a question about sql security option of create procedure syntax at 2005-12. But i can't quite understood with that answer. Can you give me a example to describe the effect of set sql security option ?
Re: Database slows down when mass users logging on
Hi, Please provide details like what tables are you using, the entire my.cnf and the information from the mysqld.err when the crashes occurred. --Alex On Wed, 04 Jan 2006 06:11:24 +0530, Jonathan Chong [EMAIL PROTECTED] wrote: Hi everyone I run a relatively popular forum that gets overloaded on match days. On normal days, the site is coping fine, but when there are plenty of users on the forum (about 50-70 odd) the load goes up and the site crawls, before crashing, and the server rebooted The forum software is phpBB. The URL is: http://www.arsenal-mania.com/ On normal days though with about the same amount of users, the site is fine. The site is running on: AMD Athlon 64 3000+ 1GB 400MHz DDR RAM CentOS 3.62 mySQL 5.0.17 I am assuming that the reason the site is slowing down is because when a match ends, people are logging on to the site to check full-time scores, and this creates a number of database connections simultaneously. This is what I have in my my.cnf file: [mysqld] set-variable = max_connections=500 set-variable = max_user_connections=350 set-variable = long_query_time=5 set-variable = thread_cache_size=40 set-variable = wait_timeout=20 query_cache_size = 20M safe-show-database log_error = /var/log/mysql_error.log log-slow-queries = /var/log/mysql_slow_queries.log Short of increasing the amount of physical RAM, I am hoping to explore configuration options beforehand. If anyone has any ideas I can try out, I'd appreciate it if you could please let me know. I can provide more stats if necessary! Thanks in advance. -- Jonathan Chong http://www.arsenal-now.com/ http://www.arsenal-mania.com/ http://www.ashburrn.com/ http://www.jonathan-chong.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
