How to Backup the Database using Script
Hi Everyone, I am trying to backup a database regularly, without using Administrator tool in mysql, Can anyone help to write a scipt regarding backup database. -Thanks in Advance Ganeswar
Server just hangs when executing a query
We had a bit of a scare yesterday when one of our scripts just hung indefinitely. We nailed it down to a query in the script. When we executed the query manually, it hung as well. We ended up having to restart MySQL which for some reason fixed it. Some background: We're running MySQL 4.0.25. Shortly before this we shut down many of our scripts because we were taking a snapshot for a replication slave. Does anyone have any ideas as to why this happened, and why restarting the server fixed it? I'm wondering if when we shut down our scripts one of them had a lock open and the lock just stayed open. This sounds far fetched but I don't really have any other theories as of now :/ thanks, M -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: help with group by
works perfectly, i didn't know you could use multiple columns in the group by. thanks a bunch! Michael Dykman wrote: try this: select accepted_by, problem_type, count(*) from form where problem_type is not NULL AND problem_type != 'Test' AND accepted_by is not null group by accepted_by, problem_type -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: help with group by
try this: select accepted_by, problem_type, count(*) from form where problem_type is not NULL AND problem_type != 'Test' AND accepted_by is not null group by accepted_by, problem_type On Wed, Oct 28, 2009 at 12:05 PM, Adam Williams wrote: > I've written a helpdesk ticket problem and am working on the statistics > module. I'm having problems with group by. For instance, I want to get the > count of the number of different problem types, by how many were solved by > each person. This is my statement: > > mysql> select distinct accepted_by, problem_type, count(*) from form where > ((problem_type is not NULL) && (problem_type != 'Test') && (accepted_by is > not null)) group by problem_type; > +-+-+--+ > | accepted_by | problem_type | count(*) | > +-+-+--+ > | awilliam | Computer Hardware | 13 | > | awilliam | Computer Peripheral | 16 | > | awilliam | Computer Software | 138 | > | awilliam | Delete User | 4 | > | smccoy | Networking | 17 | > | awilliam | New User | 6 | > | jomiles | Printer | 21 | > | awilliam | Server | 47 | > | sokolsky | Telephone | 6 | > +-+-+--+ > 9 rows in set (0.00 sec) > > But it is leaving out two of the support staff, and smccoy and jomiles have > also solved Computer Software problems, but it's only showing awilliam as > solving Computer Software problems. I think its just showing accepted_by's > values by first occurrence of accepted_by on problem_type. Here's the two > users its not even showing: > > mysql> select accepted_by, problem_type, count(*) from form where > (accepted_by = 'ehynum') group by problem_type; > +-+-+--+ > | accepted_by | problem_type | count(*) | > +-+-+--+ > | ehynum | Computer Peripheral | 1 | > | ehynum | Computer Software | 5 | > | ehynum | Telephone | 1 | > +-+-+--+ > 3 rows in set (0.00 sec) > > mysql> select accepted_by, problem_type, count(*) from form where > (accepted_by = 'dbrooks') group by problem_type; > +-+-+--+ > | accepted_by | problem_type | count(*) | > +-+-+--+ > | dbrooks | Computer Peripheral | 2 | > | dbrooks | Computer Software | 9 | > | dbrooks | Networking | 2 | > | dbrooks | Printer | 3 | > | dbrooks | Server | 3 | > +-+-+--+ > 5 rows in set (0.01 sec) > > but what I really need is an SQL statement that would return this, but I'm > at a loss as to what that would be: > > > +-+-+--+ > | accepted_by | problem_type | count(*) | > +-+-+--+ > | awilliam | Computer Hardware | 6 | > | awilliam | Computer Peripheral | 7 | > | awilliam | Computer Software | 64 | > | awilliam | Delete User | 4 | > | awilliam | Networking | 10 | > | awilliam | New User | 5 | > | awilliam | Printer | 4 | > | awilliam | Server | 33 | > | awilliam | Telephone | 1 | > | awilliam | Test | 1 | > | dbrooks | Computer Peripheral | 2 | > | dbrooks | Computer Software | 9 | > | dbrooks | Networking | 2 | > | dbrooks | Printer | 3 | > | dbrooks | Server | 3 | > | ehynum | Computer Peripheral | 1 | > | ehynum | Computer Software | 5 | > | ehynum | Telephone | 1 | > | jomiles | Computer Hardware | 5 | > | jomiles | Computer Peripheral | 6 | > | jomiles | Computer Software | 44 | > | jomiles | Networking | 1 | > | jomiles | Printer | 12 | > | jomiles | Server | 7 | > | smccoy | Computer Hardware | 2 | > | smccoy | Computer Software | 15 | > | smccoy | Networking | 4 | > | smccoy | New User | 1 | > | smccoy | Printer | 2 | > | smccoy | Server | 4 | > | sokolsky | Computer Software | 1 | > | sokolsky | Telephone | 4 | > +-+-+--+ > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com > > -- - michael dykman -
help with group by
I've written a helpdesk ticket problem and am working on the statistics module. I'm having problems with group by. For instance, I want to get the count of the number of different problem types, by how many were solved by each person. This is my statement: mysql> select distinct accepted_by, problem_type, count(*) from form where ((problem_type is not NULL) && (problem_type != 'Test') && (accepted_by is not null)) group by problem_type; +-+-+--+ | accepted_by | problem_type| count(*) | +-+-+--+ | awilliam| Computer Hardware | 13 | | awilliam| Computer Peripheral | 16 | | awilliam| Computer Software | 138 | | awilliam| Delete User |4 | | smccoy | Networking | 17 | | awilliam| New User|6 | | jomiles | Printer | 21 | | awilliam| Server | 47 | | sokolsky| Telephone |6 | +-+-+--+ 9 rows in set (0.00 sec) But it is leaving out two of the support staff, and smccoy and jomiles have also solved Computer Software problems, but it's only showing awilliam as solving Computer Software problems. I think its just showing accepted_by's values by first occurrence of accepted_by on problem_type. Here's the two users its not even showing: mysql> select accepted_by, problem_type, count(*) from form where (accepted_by = 'ehynum') group by problem_type; +-+-+--+ | accepted_by | problem_type| count(*) | +-+-+--+ | ehynum | Computer Peripheral |1 | | ehynum | Computer Software |5 | | ehynum | Telephone |1 | +-+-+--+ 3 rows in set (0.00 sec) mysql> select accepted_by, problem_type, count(*) from form where (accepted_by = 'dbrooks') group by problem_type; +-+-+--+ | accepted_by | problem_type| count(*) | +-+-+--+ | dbrooks | Computer Peripheral |2 | | dbrooks | Computer Software |9 | | dbrooks | Networking |2 | | dbrooks | Printer |3 | | dbrooks | Server |3 | +-+-+--+ 5 rows in set (0.01 sec) but what I really need is an SQL statement that would return this, but I'm at a loss as to what that would be: +-+-+--+ | accepted_by | problem_type| count(*) | +-+-+--+ | awilliam| Computer Hardware |6 | | awilliam| Computer Peripheral |7 | | awilliam| Computer Software | 64 | | awilliam| Delete User |4 | | awilliam| Networking | 10 | | awilliam| New User|5 | | awilliam| Printer |4 | | awilliam| Server | 33 | | awilliam| Telephone |1 | | awilliam| Test|1 | | dbrooks | Computer Peripheral |2 | | dbrooks | Computer Software |9 | | dbrooks | Networking |2 | | dbrooks | Printer |3 | | dbrooks | Server |3 | | ehynum | Computer Peripheral |1 | | ehynum | Computer Software |5 | | ehynum | Telephone |1 | | jomiles | Computer Hardware |5 | | jomiles | Computer Peripheral |6 | | jomiles | Computer Software | 44 | | jomiles | Networking |1 | | jomiles | Printer | 12 | | jomiles | Server |7 | | smccoy | Computer Hardware |2 | | smccoy | Computer Software | 15 | | smccoy | Networking |4 | | smccoy | New User|1 | | smccoy | Printer |2 | | smccoy | Server |4 | | sokolsky| Computer Software |1 | | sokolsky| Telephone |4 | +-+-+--+ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: START TRANSACTION COMMIT ROLLBACK
There seems to be some confusion about 'multi-db'.Within a single MySQL instance, assuming that all your tables are a transactional type (InnoDB isn't the only one), you don't have to do anything special to cross database boundaries. XA is required if you plan to spread your transactions out across multiple database instances. Right, makes sense, thanks for clearing that up. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! Database questions? Check the forum: http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: START TRANSACTION COMMIT ROLLBACK
There seems to be some confusion about 'multi-db'.Within a single MySQL instance, assuming that all your tables are a transactional type (InnoDB isn't the only one), you don't have to do anything special to cross database boundaries. XA is required if you plan to spread your transactions out across multiple database instances. - michael On Wed, Oct 28, 2009 at 10:08 AM, Paul DuBois wrote: > If all the tables are InnoDB, XA isn't needed. It doesn't matter whether all > tables are in the same database. > > On Oct 28, 2009, at 5:48 AM, Martijn Tonies wrote: > >> Ah, works for InnoDB I see. >> >> Nice. >> >> >> With regards, >> >> Martijn Tonies >> Upscene Productions >> http://www.upscene.com >> >> Download Database Workbench for Oracle, MS SQL Server, Sybase SQL >> Anywhere, MySQL, InterBase, NexusDB and Firebird! >> >> Database questions? Check the forum: >> http://www.databasedevelopmentforum.com >> >> >> Looks to me we should use XA transaction syntax instead. Check this: >> >> >> http://dev.mysql.com/doc/refman/5.0/en/xa.html >> >> Thanks, >> YY >> >> >> >> 2009/10/28 Martijn Tonies >> >> Michael, >> >> Does MySQL support multi-db transactions? >> >> With regards, >> >> Martijn Tonies >> Upscene Productions >> http://www.upscene.com >> >> Download Database Workbench for Oracle, MS SQL Server, Sybase SQL >> Anywhere, MySQL, InterBase, NexusDB and Firebird! >> >> Database questions? Check the forum: >> http://www.databasedevelopmentforum.com >> >> >> >> >> That is correct. Many db interfaces off programmatic abstractions of >> these facilities, but you may certainly just issue the statments. >> >> START TRANSACTION >> >> INSERT that >> UPDATE that >> >> on success: COMMIT >> >> on error: ROLLBACK >> >> - michael dykman >> >> >> >> On Wed, Oct 28, 2009 at 12:07 AM, Mosaed AlZamil >> wrote: >> >> Hello Everyone, >> I am a newbie using innodb. >> How can I implement START TRANSACTION COMMIT ROLLBACK when I need to >> update >> two tables >> that are located in two different databases. Would a single START >> TRANSACTION be sufficient ? >> Any help would be appreciated. >> TIA >> Mos >> >> >> >> >> >> -- >> - michael dykman >> - mdyk...@gmail.com >> >> "May you live every day of your life." >> Jonathan Swift > > -- > Paul DuBois > Sun Microsystems / MySQL Documentation Team > Madison, Wisconsin, USA > www.mysql.com > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com > > -- - michael dykman - mdyk...@gmail.com "May you live every day of your life." Jonathan Swift -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: START TRANSACTION COMMIT ROLLBACK
If all the tables are InnoDB, XA isn't needed. It doesn't matter whether all tables are in the same database. On Oct 28, 2009, at 5:48 AM, Martijn Tonies wrote: Ah, works for InnoDB I see. Nice. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! Database questions? Check the forum: http://www.databasedevelopmentforum.com Looks to me we should use XA transaction syntax instead. Check this: http://dev.mysql.com/doc/refman/5.0/en/xa.html Thanks, YY 2009/10/28 Martijn Tonies Michael, Does MySQL support multi-db transactions? With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! Database questions? Check the forum: http://www.databasedevelopmentforum.com That is correct. Many db interfaces off programmatic abstractions of these facilities, but you may certainly just issue the statments. START TRANSACTION INSERT that UPDATE that on success: COMMIT on error: ROLLBACK - michael dykman On Wed, Oct 28, 2009 at 12:07 AM, Mosaed AlZamil > wrote: Hello Everyone, I am a newbie using innodb. How can I implement START TRANSACTION COMMIT ROLLBACK when I need to update two tables that are located in two different databases. Would a single START TRANSACTION be sufficient ? Any help would be appreciated. TIA Mos -- - michael dykman - mdyk...@gmail.com "May you live every day of your life." Jonathan Swift -- Paul DuBois Sun Microsystems / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Open Tables
Will Generally this means you need to look at the schema design of your database system If you are running a simple contact Database for Mom and Pop store and you have connections to 100 tables open then you would want to take a more serious look at the schema you are using to merge information from spurious one off tables..this process is called de-normalisation.. the effort would be to take the most often requested column of a table and integrate that columns definition and data into the driver table to reduce the IO and any possible contention of a join condition if on the other hand you are running a enterprise portal with 1000 requests/second with just a few tables open you would want to normalise the data and separate the columns into other tables so as to place those columns into discrete tables which would be created/named based on functionality..associations between tables should always be unique and may involve concatenated columns the most famous example is OrderLine Item which consists of OrderID from Order-Header and OrderLineItemID i hope this addresses your requirement Martin Gainty __ Verzicht und Vertraulichkeitanmerkung Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. > Subject: Open Tables > From: sangpr...@gmail.com > To: mysql@lists.mysql.com > Date: Wed, 28 Oct 2009 18:59:44 +0700 > > I saw so many open tables in my server, is it dangerous? And if I > execute flush tables what does it impacts to the open tables? Thx. > > > > > Willy > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=mgai...@hotmail.com > _ Windows 7: Simplify your PC. Learn more. http://www.microsoft.com/Windows/windows-7/default.aspx?ocid=PID24727::T:WLMTAGL:ON:WL:en-US:WWL_WIN_evergreen1:102009
Open Tables
I saw so many open tables in my server, is it dangerous? And if I execute flush tables what does it impacts to the open tables? Thx. Willy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: START TRANSACTION COMMIT ROLLBACK
Ah, works for InnoDB I see. Nice. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! Database questions? Check the forum: http://www.databasedevelopmentforum.com Looks to me we should use XA transaction syntax instead. Check this: http://dev.mysql.com/doc/refman/5.0/en/xa.html Thanks, YY 2009/10/28 Martijn Tonies Michael, Does MySQL support multi-db transactions? With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! Database questions? Check the forum: http://www.databasedevelopmentforum.com That is correct. Many db interfaces off programmatic abstractions of these facilities, but you may certainly just issue the statments. START TRANSACTION INSERT that UPDATE that on success: COMMIT on error: ROLLBACK - michael dykman On Wed, Oct 28, 2009 at 12:07 AM, Mosaed AlZamil wrote: Hello Everyone, I am a newbie using innodb. How can I implement START TRANSACTION COMMIT ROLLBACK when I need to update two tables that are located in two different databases. Would a single START TRANSACTION be sufficient ? Any help would be appreciated. TIA Mos -- - michael dykman - mdyk...@gmail.com "May you live every day of your life." Jonathan Swift -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=m.ton...@upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=yuan4...@gmail.com
ANN: Free Database Workbench 3.4.1 Lite released
Upscene Productions releases a new version of " Database Workbench Lite " There are editions available for MySQL, Firebird and InterBase. What is Database Workbench? Database Workbench Pro is a cross database development environment for database administrators and developers. It supports tools for cross database development like Schema Migration and Compare tools, DataPump, single IDE for multiple DBMSses and much more. Database Workbench Lite is the somewhat limited but free version of Database Workbench, available for MySQL, Firebird and InterBase, see http://www.upscene.com/products.dbw.featurematrix.php This free version can be downloaded from http://www.upscene.com/downloads.php With regards, Martijn Tonies Upscene Productions -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: START TRANSACTION COMMIT ROLLBACK
Looks to me we should use XA transaction syntax instead. Check this: http://dev.mysql.com/doc/refman/5.0/en/xa.html Thanks, YY 2009/10/28 Martijn Tonies > Michael, > > Does MySQL support multi-db transactions? > > With regards, > > Martijn Tonies > Upscene Productions > http://www.upscene.com > > Download Database Workbench for Oracle, MS SQL Server, Sybase SQL > Anywhere, MySQL, InterBase, NexusDB and Firebird! > > Database questions? Check the forum: > http://www.databasedevelopmentforum.com > > > > > That is correct. Many db interfaces off programmatic abstractions of > these facilities, but you may certainly just issue the statments. > > START TRANSACTION > > INSERT that > UPDATE that > > on success: COMMIT > > on error: ROLLBACK > > - michael dykman > > > > On Wed, Oct 28, 2009 at 12:07 AM, Mosaed AlZamil > wrote: > >> Hello Everyone, >> I am a newbie using innodb. >> How can I implement START TRANSACTION COMMIT ROLLBACK when I need to >> update >> two tables >> that are located in two different databases. Would a single START >> TRANSACTION be sufficient ? >> Any help would be appreciated. >> TIA >> Mos >> >> > > > -- > - michael dykman > - mdyk...@gmail.com > > "May you live every day of your life." > Jonathan Swift > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=m.ton...@upscene.com > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=yuan4...@gmail.com > >
Re: START TRANSACTION COMMIT ROLLBACK
Michael, Does MySQL support multi-db transactions? With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! Database questions? Check the forum: http://www.databasedevelopmentforum.com That is correct. Many db interfaces off programmatic abstractions of these facilities, but you may certainly just issue the statments. START TRANSACTION INSERT that UPDATE that on success: COMMIT on error: ROLLBACK - michael dykman On Wed, Oct 28, 2009 at 12:07 AM, Mosaed AlZamil wrote: Hello Everyone, I am a newbie using innodb. How can I implement START TRANSACTION COMMIT ROLLBACK when I need to update two tables that are located in two different databases. Would a single START TRANSACTION be sufficient ? Any help would be appreciated. TIA Mos -- - michael dykman - mdyk...@gmail.com "May you live every day of your life." Jonathan Swift -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=m.ton...@upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Req. suitable .cnf file for Server used by 2000 users daily
mysql is successfull in login with same user and password but when the same user and password is given at mysqltuner end it always shows the same error "[!!] Attempted to use login credentials, but they were invalid." Thanks Jeetendra Ranjan SynapseIndia http://www.synapse.in I.T. Outsourcing @ Peace of Mind - Original Message - From: "Bruce Ferrell" To: "Jeetendra Ranjan" Cc: Sent: Tuesday, October 20, 2009 9:27 PM Subject: Re: Req. suitable .cnf file for Server used by 2000 users daily this error indicates either root doesn't have sufficient privilege or the password entered was bad. try running it this way: ./mysqltuner.pl --user root --pass Jeetendra Ranjan wrote: Hi, I run the mysqltuner at my server as below and i got error like below. [r...@127 /]# ./mysqltuner.pl >> MySQLTuner 1.0.1 - Major Hayden >> Bug reports, feature requests, and downloads at http://mysqltuner.com/ >> Run with '--help' for additional options and output filtering Please enter your MySQL administrative login: root Please enter your MySQL administrative password: [!!] Attempted to use login credentials, but they were invalid. On some other server this script is running absolutely fine without any change in mysqltuner.pl. Please guide me how can i run this script Thanks & Regards Jeetendra Ranjan - Original Message - From: "Bruce Ferrell" To: Cc: Sent: Thursday, October 15, 2009 12:20 PM Subject: Re: Req. suitable .cnf file for Server used by 2000 users daily Have a look at mysqltuner. It reads the stats from a running mysql instances and makes suggestions for what can be changed http://blog.mysqltuner.com/ Gavin Towey wrote: Hi, This script might help with some tuning suggestions, run it after you have some production traffic running against your database. https://launchpad.net/mysql-tuning-primer Also you should enable the slow query log, so you can capture queries to be optimized: http://dev.mysql.com/doc/mysql/en/Slow_query_log.html http://dev.mysql.com/doc/refman/5.0/en/mysql-indexes.html Regards, Gavin Towey -Original Message- From: jeetendra.ran...@sampatti.com [mailto:jeetendra.ran...@sampatti.com] Sent: Wednesday, October 14, 2009 3:21 AM To: mysql@lists.mysql.com Subject: Req. suitable .cnf file for Server used by 2000 users daily Hi, Will you plesae guide me ? We are about to launch one website whose database is in MySQL. I am very exited about the server setting specially about .cnf file. I have below hardware and .cnf details. Will you please guide me is the .cnf file details sufficient to support current hardware. Initially 2000 users will visit this site everyday. Hardware and OS * Operating System : Red Hat Fedora Core 8 Processor : Intel Core 2 Quad - 2.83 GHz, RAM : 4 GB Total Disk Space : 600 GB (300 GB usable) RAID : RAID1 Disk Drive(s) : 300 GB (Drive #1), 300 GB (Drive #2) Bandwidth Quota : 500 GB Firewall : PIX 501 Version : 5.0.81-community-log Version_comment : MySQL Community Edition (GPL) Version Compile Machine : i686 Version Compile OS : pc-linux-gnu my.cnf details *** [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 key_buffer = 16M key_buffer_size=4M sort_buffer_size=2M query_cache_size=64M log-bin log_queries_not_using_indexes=1 long_query_time=1 log_slow_queries=slowQry.log join_buffer_size=4M max_connections=150 max_allowed_packet = 32M table_cache = 256 net_buffer_length = 8K read_buffer_size = 2M read_rnd_buffer_size = 2M myisam_sort_buffer_size = 8M thread_stack=5M thread_cache_size=128M connect_timeout=30 query_cache_limit=32M log-error # Comment the following if you are using InnoDB tables innodb_data_home_dir = /var/lib/mysql/ innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /var/lib/mysql/ # You can set .._buffer_pool_size up to 50 - 80 % # of RAM but beware of setting memory usage too high innodb_buffer_pool_size = 4M innodb_additional_mem_pool_size = 2M # Set .._log_file_size to 25 % of buffer pool size innodb_log_file_size = 16M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid Thanks in advance Regards Jeetendra Ranjan The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -- MySQL General Mailing List F