Re: yum version 5.*
On Wednesday 26 July 2006 22:16, Karl Larsen wrote: I am using Red Hat Fedora Core 4 and I wanted to yum mysql version 5 of any other and find with Core 4 I can yum only mysql version 4. I imagine Core 5 might be able to yum mysql version 5 but not certain of that. Is there a way I can yum the later version? I studied the man for yum but could not see a way to do that. yum works with the repositories it's given, and is merely a fancy front end to the rpm database. You can always download the rpm packages from dev.mysql.com and use yum/rpm to install them. -- Scanned by iCritical. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Need Restore Help
Jesse wrote: Strange it ran just fine here on my 5.0.22-nt with sample MyISAM table `alumni`... Is your table `alumni` MyISAM or Innodb? It is MyISAM. Here are few more pointers: 1. If it is possible *always* try latest version first when solving problems. In your case 5.0.22 I think... You were right. I updatd to 5.0.22, and the restore works just fine now. However, I've got one question. when I do a SELECT version(); now, it returns 5.0.22-community-nt. What is that? Does it make a difference? Did I download the wrong version? 3. For single line CREATE TRIGGER changing DELIMITER wasn't needed actually... but if mandatory I would personally write it like this: Unfortunately, I'm not writing it. I'm dealing with what MySQLDump gives me. Thanks for your help. I think the problem is resolved. Once the 5.0.22-community thing is resolved. Don't know if I should look into this or not. Thanks, Jesse I don't know why they renamed it again ?!? For better explanation and comparison take look here: http://www.mysql.com/network/compare.html http://www.mysql.com/products/database/ http://www.mysql.com/products -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Looking For How test database performans on different hardware
Hello , I want to test Mysql , on Dual Intel Xeon 2MB Cache CPU and Dual AMD Opteron platforms for looking differents which one is better then other ! I found something but I want to asl to list , is there anybody have an experiance about this type tests ! Regards Vahric MUHTARYAN Sistem Mühendisi/System Engineer DorukNet Tel / Phone : +90 212 326 92 00 Fax : +90 212 227 28 11 E-mail : [EMAIL PROTECTED] http://www.doruk.net.tr http://www.doruk.net.tr/english.html Bu e-posta mesajı kişiye özel olup, gizli bilgiler içeriyor olabilir. Eğer bu e-posta mesajı size yanlışlıkla ulaşmışsa, e-posta mesajını kullanıcıya hemen geri gönderiniz ve mesaj kutunuzdan siliniz. Bu e-posta mesajı, hiç bir şekilde, herhangi bir amaç için çoğaltılamaz, yayınlanamaz ve para karşılığı satılamaz. Yollayıcı, bu e-posta mesajının - virüs koruma sistemleri ile kontrol ediliyor olsa bile - virüs içermediğini garanti etmez ve meydana gelebilecek zararlardan doğacak hiçbir sorumluluğu kabul etmez. The information contained in this message is confidential, intended solely for the use of the individual or entity to whom it is addressed and may be protected by professional secrecy. You should not copy, disclose or distribute this information for any purpose. If you are not the intended recipient of this message or you receive this mail in error, you should refrain from making any use of the contents and from opening any attachment. In that case, please notify the sender immediately and return the message to the sender, then, delete and destroy all copies. This e-mail message has been swept by anti-virus systems for the presence of computer viruses. In doing so, however, we cannot warrant that virus or other forms of data corruption may not be present and we do not take any responsibility in any occurrence.
Re: Need Restore Help
I don't know why they renamed it again ?!? For better explanation and comparison take look here: http://www.mysql.com/network/compare.html http://www.mysql.com/products/database/ http://www.mysql.com/products Thank you. Those links were very helpful. I don't know why I can't seem to find anything on the MySQL web site. I looked around for a comparison chart like that, and just couldn't find it. I guess I'm not reading enough. Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Replication vs. Clustering
I think I know the difference, but wanted to make sure. What is the difference between Replication and Clustering? My understanding is that in Replication, changes made on the Master Server are downloaded to a Slave server periodically, and thus, the slave server is up-to-date within a few minutes of the Master server. Am I correct in assuming that in a cluster situation, there are actually multiple servers, all updated at the same time, and if any one goes down, then the others can pick up the slack? Generally (don't need details, but a very general idea), what is involved in setting up each? What would be the cost of doing such for a business who has a mission critical web application accessed from all over the U.S.? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL performing too badly under heavy load - urgent hlp needed
Hello all, Stuck up with a major problem. Urgent hlp required MySQL seems to be performing too bad during heavy load on the server. Queries which normally take around 5 secs to complete are taking more than 1000 secs to complete during load. What could be the reason. Show processlist shows many process in sending data state. All tables are of INNODB type. But we are not running any transactions as yet. The server is clogged due to many httpd requests (150 Max). All the httpd requests are in W state ( means sending response ). What could be causing this. Is it MySQL or is it Apache... Any suggestions would help... Thanks, Ratheesh K J
RE: Replication vs. Clustering
Hello, Your description is fairly accurate and we can boil it down even further... Replication is Asynchronous, Cluster is Synchronous, in regards to how data is replicated. Keep in mind that in Cluster, the MySQL Servers really only act as SQL interfaces for the data in the Cluster, it is the NDB storage engine (Data Nodes) that deal with ensuring that data is replicated and available. I regards to the the setup, there is no special hardware, networking or software requirements for either. Although Replication would require a minimum of two machines, Cluster likely four. Tough to say what the cost would be depending on which option you go with and whether you'd need support as well. Needless to say, it would be many times more economical to go with MySQL then going with something like Oracle or SQL Server. Also note, MySQL and MySQL Replication are fairly ubiquitous for websites, so there are a lot of resources on basic and advanced topologies. For more info on replication see: http://dev.mysql.com/doc/refman/5.0/en/replication.html http://dev.mysql.com/doc/refman/5.0/en/replication-faq.html For Cluster, start with the FAQ if you haven't already: http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster-faq.html Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc -Original Message- From: Jesse [mailto:[EMAIL PROTECTED] Sent: Thursday, July 27, 2006 7:23 AM To: MySQL List Subject: Replication vs. Clustering I think I know the difference, but wanted to make sure. What is the difference between Replication and Clustering? My understanding is that in Replication, changes made on the Master Server are downloaded to a Slave server periodically, and thus, the slave server is up-to-date within a few minutes of the Master server. Am I correct in assuming that in a cluster situation, there are actually multiple servers, all updated at the same time, and if any one goes down, then the others can pick up the slack? Generally (don't need details, but a very general idea), what is involved in setting up each? What would be the cost of doing such for a business who has a mission critical web application accessed from all over the U.S.? Thanks, Jesse -- 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: MySQL performing too badly under heavy load - urgent hlp needed
I doubt apache is to blame. 5 seconds for a query on a website is extremely slow, so if that is your normal results, then you have a problem there already. I've been building database driven websites for around 11 years and i don't think i can remember a single time i went into production with a single query that was slower than 0.1 second, unless it was something very rarely used for administration purposes. From the top of my head i'd say your problem is either a) poor datamodel design which forces slow queries b) poor usage of indexes in the database (use explain to check) c) non-optimized configuration of the server (have you tuned the server parameters to the way you use the server?) d) insufficient hardware for your needs e) any combination of the above Ratheesh K J wrote: Hello all, Stuck up with a major problem. Urgent hlp required MySQL seems to be performing too bad during heavy load on the server. Queries which normally take around 5 secs to complete are taking more than 1000 secs to complete during load. What could be the reason. Show processlist shows many process in sending data state. All tables are of INNODB type. But we are not running any transactions as yet. The server is clogged due to many httpd requests (150 Max). All the httpd requests are in W state ( means sending response ). What could be causing this. Is it MySQL or is it Apache... Any suggestions would help... Thanks, Ratheesh K J -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL performing too badly under heavy load - urgent hlp needed
At 09:38 AM 7/27/2006, Ratheesh K J wrote: Hello all, Stuck up with a major problem. Urgent hlp required MySQL seems to be performing too bad during heavy load on the server. Queries which normally take around 5 secs to complete are taking more than 1000 secs to complete during load. What could be the reason. Show processlist shows many process in sending data state. All tables are of INNODB type. But we are not running any transactions as yet. The server is clogged due to many httpd requests (150 Max). All the httpd requests are in W state ( means sending response ). What could be causing this. Is it MySQL or is it Apache... Any suggestions would help... Thanks, Ratheesh K J So, what have you tried? Give us some information -- knowing which version you are running would be a good start. Are the queries slow if run from the command line? Are there enough threads in Apache? Have you rebuilt your indexes? Dropped them and replaced. Run optimize database? Done a dump and restore? Miles Thompson -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.1.394 / Virus Database: 268.10.4/401 - Release Date: 7/26/2006 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL performing too badly under heavy load - urgent hlp needed
On Thursday 27 July 2006 17:00, Martin Jespersen wrote: I doubt apache is to blame. 5 seconds for a query on a website is extremely slow, so if that is your normal results, then you have a problem there already. I've been building database driven websites for around 11 years and i don't think i can remember a single time i went into production with a single query that was slower than 0.1 second, unless it was something very rarely used for administration purposes. From the top of my head i'd say your problem is either a) poor datamodel design which forces slow queries b) poor usage of indexes in the database (use explain to check) c) non-optimized configuration of the server (have you tuned the server parameters to the way you use the server?) d) insufficient hardware for your needs e) any combination of the above f) not enough memory, that forces major swapping activity -Stathis Ratheesh K J wrote: Hello all, Stuck up with a major problem. Urgent hlp required MySQL seems to be performing too bad during heavy load on the server. Queries which normally take around 5 secs to complete are taking more than 1000 secs to complete during load. What could be the reason. Show processlist shows many process in sending data state. All tables are of INNODB type. But we are not running any transactions as yet. The server is clogged due to many httpd requests (150 Max). All the httpd requests are in W state ( means sending response ). What could be causing this. Is it MySQL or is it Apache... Any suggestions would help... Thanks, Ratheesh K J -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL performing too badly under heavy load - urgent hlp needed
Do a show status and check on what mysql is doing. I would start by looking at: threads_created - if this is high, increase your thread_cache_size. This means MySQL is busy creating and destroying threads instead of reusing them. This can take a toll on the OS. Opened_tables - if this number is high/climbing, MySQL is buys opening and closing tables, which means your table_cache is probably too low. Compare open_tables to table_cache, open_tables should be lower. Show variables will help you see your current settings. Some things can be changed on the fly, like the thread cache, so can can do some things without taking MySQL down. - Original Message - From: Ratheesh K J [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Thursday, July 27, 2006 8:38 AM Subject: MySQL performing too badly under heavy load - urgent hlp needed Hello all, Stuck up with a major problem. Urgent hlp required MySQL seems to be performing too bad during heavy load on the server. Queries which normally take around 5 secs to complete are taking more than 1000 secs to complete during load. What could be the reason. Show processlist shows many process in sending data state. All tables are of INNODB type. But we are not running any transactions as yet. The server is clogged due to many httpd requests (150 Max). All the httpd requests are in W state ( means sending response ). What could be causing this. Is it MySQL or is it Apache... Any suggestions would help... Thanks, Ratheesh K J -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysqlcheck issues
I am using MySQL server 4.1.10 on Windows 2003 Server with MyISAM tables. I have an issue where occasionally an index (MYI) file becomes corrupted. I do not know why this occurs. To combat this issue, I tried running the following command every half-hour: mysqlcheck -Aamov --auto-repair --use-frm This command runs on the host. For some reason, when this command executes, the MySQL service aborts and the MYI for the main table is corrupted. I must then restart the service and repair the affected table. I am at a loss here. I would really like to use the --auto-repair option, but don't understand what is causing the service to abort. Your thoughts? Dirk Bremer - Senior Systems Engineer - ESS/AMS - NISC Lake St. Louis MO - USA Central Time Zone 636-755-2652 fax 636-755-2503 [EMAIL PROTECTED] www.nisc.coop -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
identify process that created the connection
Hello people. Is it possible to find the process that invoked the mysql thread, given a mysql thread id? We have a web application that runs on Linux-Apache-MySQL-PHP; and I sometimes see numerous mysql threads in sleeping mode when I run mytop. I think the sleeping mysql threads could be due to the fact that some of my web-page(s) have obtained a mysql connection, executed their queries, but have not terminated(and have not released the mysql connection also). If I could know the httpd processes that have created these connections, I would be able to find out the pages that are the culprit. Regards, Rithish.
why size of table c united from table a and b are bigger than a+b ?
I run following command : use db1; insert into db2.c select a.a, a.b, a,c, b.d, b,e ... from a left join b on (a.id=b.id); size of table a and table b is: [EMAIL PROTECTED] ls -l ../db1/a.* -rw-rw 1 mysql mysql 9230 May 10 15:41 ../db1/a.frm -rw-rw 1 mysql mysql 880880528 Jul 17 01:15 ../db1/a.MYD -rw-rw 1 mysql mysql 383653888 Jul 17 01:15 ../db1/a.MYI [EMAIL PROTECTED] ls -l ../db1/b.* -rw-rw 1 mysql mysql 11277 May 10 15:47 ../db1/b.frm -rw-rw 1 mysql mysql 1494998192 Jul 17 01:15 ../db1/b.MYD -rw-rw 1 mysql mysql 619606016 Jul 17 01:15 ../db1/b.MYI It has took 16776 seconds , and now the command is still running. the size of table c is [EMAIL PROTECTED] ls -l c.* -rw-rw 1 mysql mysql 11623 Jul 27 05:37 c.frm -rw-rw 1 mysql mysql 4633395200 Jul 27 10:08 c.MYD -rw-rw 1 mysql mysql 165481472 Jul 27 10:08 c.MYI the number of records in a is : 3101692 my question is : why is size of c big? and increase of size of MYI is so slow than MYD? Will sql 'insert into .. select ' write temp data into table c ? It is too slow. Has anyone better methods to do that work? thanks. -- -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
operation with alias
Hi all, it's me again jeje !!! i have a question, i want to do something like this select 10 as a, 1 as b, (a+b) as c; im want to get something like this a | b | c - 10 | 1 | 11 how can i do this... i want to do that becouse i get a big value from a sub big subquery, so i don't want to make again the subquery... thanks a lot -- http://www.obed.org.mx --- blog -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: operation with alias
[snip] i have a question, i want to do something like this select 10 as a, 1 as b, (a+b) as c; im want to get something like this a | b | c - 10 | 1 | 11 how can i do this... i want to do that becouse i get a big value from a sub big subquery, so i don't want to make again the subquery... [/snip] http://www.mysql.com/prepare -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding Foreign Key Fails
On Wed, 2006-07-26 at 08:58 -0400, Jesse wrote: I am trying to add a foreign key to one of my tables. When I execute the following SQL Code: ALTER TABLE `bpa`.`confinvitems` ADD CONSTRAINT `FK_confinvitems_1` FOREIGN KEY `FK_confinvitems_1` (`InvDetID`) REFERENCES `confinvdet` (`ID`) ON DELETE CASCADE; I get the error: MySQL Error Number 1452 Cannot add or update a child row: a foreign key constraint fails (`bpa/#sql-162c_1b`, CONSTRAINT `FK_confinvitems_1` FOREIGN KEY (`InvDetID`) REFERENCES `confinvdet` (`ID`) ON DELETE CASCADE) I have checked, and all the indexes seem to be in place, By that I hope you mean there is an index on confinvitems.InvDetID _and_ confinvdet.ID the data types are exactly the same. There are no duplicate ID's in the ConfInvDet table. Any idea what this error means, and how to fix it? Could be a record in confinvitems that has an InvDetID that doesn't exist in ConfInvDet. Check with something like: SELECT InvDetID FROM confinvitems WHERE InvDetID NOT IN (SELECT ID FROM ConfInvDet); Also if you do a SHOW INNODB STATUS after your failed query you can get more details on the last error. The InnoDB fkey errors reported back tends to be a bit vague, covering all sorts of failures. Looking at the text and sql examples it could be a table name case problem i.e. you refer to `ConfInvDet` in text but `confinvdet` in SQL. Are you on windows (case insensative table names) or a *nix machine (case sensative)? hth, mark -- MARK ADDISON WEB DEVELOPER 200 GRAY'S INN ROAD LONDON WC1X 8XZ UNITED KINGDOM T +44 (0)20 7430 4678 F E [EMAIL PROTECTED] WWW.ITN.CO.UK Please Note: Any views or opinions are solely those of the author and do not necessarily represent those of Independent Television News Limited unless specifically stated. This email and any files attached are confidential and intended solely for the use of the individual or entity to which they are addressed. If you have received this email in error, please notify [EMAIL PROTECTED] Please note that to ensure regulatory compliance and for the protection of our clients and business, we may monitor and read messages sent to and from our systems. Thank You. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Newbie
Hi All, I am very new. I wish to do some exercise before I go to real business. Could anyone advise me any tutorial link or resources for beginner? With best regards, Abu Naser School Of Life Sciences Heriot-Watt University Edinburgh EH14 4AS Email: [EMAIL PROTECTED] Phone: +44(0)1314518265 Fax : +44(0) 131 451 3009
Re: Newbie
Naser, Md Abu wrote: Hi All, I am very new. I wish to do some exercise before I go to real business. Could anyone advise me any tutorial link or resources for beginner? Some tutorials are listed at http://www.artfulsoftware.com/dbresources.html. Also you might want to look at http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch01.html. PB Naser, Md Abu wrote: Hi All, I am very new. I wish to do some exercise before I go to real business. Could anyone advise me any tutorial link or resources for beginner? With best regards, Abu Naser School Of Life Sciences Heriot-Watt University Edinburgh EH14 4AS Email: [EMAIL PROTECTED] Phone: +44(0)1314518265 Fax : +44(0) 131 451 3009 No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.10.4/401 - Release Date: 7/26/2006 No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.10.4/401 - Release Date: 7/26/2006 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Connector/J 5.0.3 Has Been Released
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, MySQL Connector/J 5.0.3 a new version of the Type-IV all-Java JDBC driver for MySQL has been released. This is the first generally-available, production release of Connector/J 5.0. Notice that Connector/J 3.1 has supported all MySQL-5.0 features other than XA, but this is the first generally-available release that synchronizes version numbers with the server (as well as adding support for XA). Version 5.0.3 is suitable for use with any MySQL version including MySQL-4.1, MySQL-5.0 or MySQL-5.1 beta. 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.) Please notice that the download archives are larger than before as we're now shipping the output of our JUnit release tests and resultant code coverage in the docs/release-test-output subdirectory. Features/changes of note in this release: * Support for XA distributed transactions via com.mysql.jdbc.jdbc2.optional.MysqlXADataSource which is an implementation of javax.sql.XADataSource. Notice that depending on whether or not your application server re-uses the same physical XAConnection for a given global transaction, you may have to set the datasource configuration parameter pinGlobalTxToPhysicalConnection to true so that the driver itself will maintain this mapping, which also allows the driver to emulate the JOIN clause to XA START, which the server currently does not support natively. Our current testing shows that this configuration parameter is necessary for BEA WebLogic and IBM WebSphere. JBoss has their own configuration parameter for this, track-connection-by-tx, see http://docs.jboss.org/jbossas/jboss4guide/r5/html/ch7.chapt.html#ch7.xaconf.fig for more information). We also recommend that connection pools that will be backing XAConnections should be configured to test connections on reserve/checkout and not let connections stay idle for long periods of time (ideally not at all), due to the current limitations with XA support in the server as listed here: http://dev.mysql.com/doc/refman/5.0/en/xa-restrictions.html * Loosened synchronization to solve a number of deadlock issues in BUG#18719, BUG#18367, BUG#17709 and BUG#15067. The new strategy basically makes Connection instances threadsafe and thus shareable across threads, and anything else threadsafe, but not necessarily shareable across threads due to JDBC API interactions that can cause non-obvious behavior and/or deadlock scenarios to occur since the JDBC API is not designed to be used from multiple threads at once. Therefore, unless external synchronization is provided, clients should not allow multiple threads to share a given statement or result set. Examples of issues with the API itself not being multi-thread suitable include, but are not limited to race conditions between modifiers and execution and retrieval methods on statements and result sets that are not synchronizable such as ResultSet.get*() and traversal methods, or Statement.execute*() closing result sets without effectively making the driver itself serialized across the board. These changes should not have any effect on normal J(2)EE use cases where only one thread ever uses a connection instance and the objects created by it. * Implementation of Statement.cancel() and Statement.setQueryTimeout(). Both methods require MySQL-5.0.0 or newer server, require a separate connection to issue the KILL QUERY command, and in the case of setQueryTimeout() the driver will create a separate thread should the timer to cancel the query fire to actually login to the server and cancel the statement. * Added support for Connector/MXJ integration via url subprotocol jdbc:mysql:mxj://. As always, we recommend that you check the change log (http://dev.mysql.com/doc/refman/5.0/en/cj-news.html) and Upgrading sections (http://dev.mysql.com/doc/refman/5.0/en/cj-upgrading.html) in the manual before upgrading to be aware of changes in behavior that might affect your application. -Mark - - From the change log (this release includes changes and fixes from versions 3.1.13 and 3.1.14): 07-26-06 - Version 5.0.3 - Fixed BUG#20650 - Statement.cancel() causes NullPointerException if underlying connection has been closed due to server failure. - Added configuration option noAccessToProcedureBodies which will cause the driver to create basic parameter metadata (all parameters reported as VARCHAR(65535) IN/OUT and not named) for CallableStatements when the user does not have access to procedure bodies via SHOW CREATE PROCEDURE or selecting from mysql.proc instead of throwing an
Re: Replication vs. Clustering
It's important to read the How much RAM part if you are running any version lower than 5.1. In 5.0 and lower clusters store all information in memory, which can be a very limiting factor. My experience with replication is that it is fairly quick, in seconds at most rather than minutes. One type of setup that always intrigued me was using the blackhole storage engine to capture the data, then replicating it to store it. This sounds like an excellent setup if you get high bursts of traffic, but don't need to store it in real time. http://dev.mysql.com/doc/refman/5.0/en/blackhole-storage-engine.html Not sure if that would be helpful to you. - Original Message - From: Jimmy Guerrero [EMAIL PROTECTED] To: 'Jesse' [EMAIL PROTECTED]; 'MySQL List' mysql@lists.mysql.com Sent: Thursday, July 27, 2006 8:47 AM Subject: RE: Replication vs. Clustering Hello, Your description is fairly accurate and we can boil it down even further... Replication is Asynchronous, Cluster is Synchronous, in regards to how data is replicated. Keep in mind that in Cluster, the MySQL Servers really only act as SQL interfaces for the data in the Cluster, it is the NDB storage engine (Data Nodes) that deal with ensuring that data is replicated and available. I regards to the the setup, there is no special hardware, networking or software requirements for either. Although Replication would require a minimum of two machines, Cluster likely four. Tough to say what the cost would be depending on which option you go with and whether you'd need support as well. Needless to say, it would be many times more economical to go with MySQL then going with something like Oracle or SQL Server. Also note, MySQL and MySQL Replication are fairly ubiquitous for websites, so there are a lot of resources on basic and advanced topologies. For more info on replication see: http://dev.mysql.com/doc/refman/5.0/en/replication.html http://dev.mysql.com/doc/refman/5.0/en/replication-faq.html For Cluster, start with the FAQ if you haven't already: http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster-faq.html Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc -Original Message- From: Jesse [mailto:[EMAIL PROTECTED] Sent: Thursday, July 27, 2006 7:23 AM To: MySQL List Subject: Replication vs. Clustering I think I know the difference, but wanted to make sure. What is the difference between Replication and Clustering? My understanding is that in Replication, changes made on the Master Server are downloaded to a Slave server periodically, and thus, the slave server is up-to-date within a few minutes of the Master server. Am I correct in assuming that in a cluster situation, there are actually multiple servers, all updated at the same time, and if any one goes down, then the others can pick up the slack? Generally (don't need details, but a very general idea), what is involved in setting up each? What would be the cost of doing such for a business who has a mission critical web application accessed from all over the U.S.? Thanks, Jesse -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL With a HUGE Config
I have a Dell P2800 SERVER WITH: Red Hat AS 4 ( 64 bit machine) 6 GB of RAM Dual Xeon DUALCORE 2.8Ghz with 2MB of L2 Cache I will use MySQl 5.0 and InnoDB, exits a config to use all power of this server ? the developer guys can send-me a config ? Heikki , you can send - me a config too ? Tnks in advance... Any warning to use 64 bit machine ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Select query problem
Barry wrote: Nenad Bosanac schrieb: Hi I have one problem that i can`t resolve. still need advice or is it solved? IF!!! you need IF!! :) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
how to move datadir to a different file system
Everything was installed under / file system ( linux ) need to move all existing databases also to new file system ( say /mysqldata ) Can I simply change in my.cnf and copy files to new location ? Thanks Saurabh
Re: MySQL With a HUGE Config
Dyego Souza Dantas Leal wrote: I have a Dell P2800 SERVER WITH: Red Hat AS 4 ( 64 bit machine) 6 GB of RAM Dual Xeon DUALCORE 2.8Ghz with 2MB of L2 Cache I will use MySQl 5.0 and InnoDB, exits a config to use all power of this server ? the developer guys can send-me a config ? There is a my-huge.cnf included with mysql. Take a look at it. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding Foreign Key Fails
By that I hope you mean there is an index on confinvitems.InvDetID _and_ confinvdet.ID Yes, there is. Could be a record in confinvitems that has an InvDetID that doesn't exist in ConfInvDet. Check with something like: SELECT InvDetID FROM confinvitems WHERE InvDetID NOT IN (SELECT ID FROM ConfInvDet); That was probably it. I did a massive purge of the data yesterday, then I tried to add the Foreign Keys again, and it worked just fine. Also if you do a SHOW INNODB STATUS after your failed query you can get more details on the last error. The InnoDB fkey errors reported back tends to be a bit vague, covering all sorts of failures. Aaah. I had forgotten about that. I was able to find and solve a problem with that one time before. I'll make a special note of that and hopefully remember to do that next time. Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Disable specific storage engines WITHOUT recompiling?
Hi, I know that bdb has --skip-bdb, and innodb has the ability to be disabled at startup but what about federated, csv, archive, etc? My problem is I don't want to recompile and I don't want to carry a different binary version in our local repository just for the one or two machines on which we need to disable these other engines, especially federated. Any advice? Thanks! -- Genius might be described as a supreme capacity for getting its possessors into trouble of all kinds. -- Samuel Butler -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: why size of table c united from table a and b are bigger than a+b ?
chylli wrote: I run following command : use db1; insert into db2.c select a.a, a.b, a,c, b.d, b,e ... from a left join b on (a.id=b.id); Do you have an index on a.id and b.id ? size of table a and table b is: [EMAIL PROTECTED] ls -l ../db1/a.* -rw-rw 1 mysql mysql 9230 May 10 15:41 ../db1/a.frm -rw-rw 1 mysql mysql 880880528 Jul 17 01:15 ../db1/a.MYD -rw-rw 1 mysql mysql 383653888 Jul 17 01:15 ../db1/a.MYI [EMAIL PROTECTED] ls -l ../db1/b.* -rw-rw 1 mysql mysql 11277 May 10 15:47 ../db1/b.frm -rw-rw 1 mysql mysql 1494998192 Jul 17 01:15 ../db1/b.MYD -rw-rw 1 mysql mysql 619606016 Jul 17 01:15 ../db1/b.MYI It has took 16776 seconds , and now the command is still running. the size of table c is [EMAIL PROTECTED] ls -l c.* -rw-rw 1 mysql mysql 11623 Jul 27 05:37 c.frm -rw-rw 1 mysql mysql 4633395200 Jul 27 10:08 c.MYD -rw-rw 1 mysql mysql 165481472 Jul 27 10:08 c.MYI the number of records in a is : 3101692 my question is : why is size of c big? Because you're adding all columns from a and b into it. It is too slow. Has anyone better methods to do that work? Drop the indexes on c and create them at the end. Each row that's being added, it's updating the index at the same time, so that will be your bottleneck. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
allow access to all users within a network..
hi... i'm trying to figure out how to allow all users on machines within my network access to a mysql db... i've tried: grant access all on *.* to '*'@'%' grant access all on *.* to '%'@'%' grant access all on *.* to @'%' with no luck.. thanks -bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
newbie..foreign key clarification
I'm still unsure about foreign keys..even after reading the doc file and Paul Dubois 3rd edition My doubt is...how much constraint is applied.( probably a bad explanation) If i have a table 'Customers' with the primary key being 'CustID' Then i have a table 'LastVisit' with a foreign key 'CustID' btw...i have a Form-SubForm in OO that i'm working with where i have the 2 tables linked should the foreign key 'LastVisit.CustID' only allow values that are in the linked primary field? or will it allow any value that is in the table ' Customers.CustID' ? When i enter any value that doesn't exist in the 'Customers.CustID' column i get the ref. integrity error...BUT i want it to kick ANY value that doesn't relate to the linked parent table out as an error. Pretend i didn't mention OO. -- Grass Cake
Re: newbie..foreign key clarification
Grass Cake wrote: I'm still unsure about foreign keys..even after reading the doc file and Paul Dubois 3rd edition My doubt is...how much constraint is applied.( probably a bad explanation) If i have a table 'Customers' with the primary key being 'CustID' Then i have a table 'LastVisit' with a foreign key 'CustID' btw...i have a Form-SubForm in OO that i'm working with where i have the 2 tables linked should the foreign key 'LastVisit.CustID' only allow values that are in the linked primary field? or will it allow any value that is in the table ' Customers.CustID' ? When i enter any value that doesn't exist in the 'Customers.CustID' column i get the ref. integrity error...BUT i want it to kick ANY value that doesn't relate to the linked parent table out as an error. It will check to make sure the CustID value is in the Customers table. If it's not there, then it will give you an error. If it is there, the insert/update will work fine. It has no way of knowing if you are inserting the right record, all it cares about is that the CustID value is in the other table. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: how to move datadir to a different file system
Hi, If the tables are not in use you can tar -cvzf filename.tar.gz the datadir and move it to the new server, but you should use the same mysql version. Thanks Regards Dilipkumar - Original Message - From: Bhartia, Saurabh [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, July 28, 2006 3:16 AM Subject: how to move datadir to a different file system Everything was installed under / file system ( linux ) need to move all existing databases also to new file system ( say /mysqldata ) Can I simply change in my.cnf and copy files to new location ? Thanks Saurabh ** DISCLAIMER ** Information contained and transmitted by this E-MAIL is proprietary to Sify Limited and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this mail notify us immediately at [EMAIL PROTECTED] Watch the latest updates on Mumbai, with video coverage of news, events, Bollywood, live darshan from Siddhivinayak temple and more, only on www.mumbailive.in Watch the hottest videos from Bollywood, Fashion, News and more only on www.sifymax.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysqlcheck issues
Hi, Instead of mysqlcheck you can use myisamckh to recover the data's. As myisamchk -r -o *.MY* Thanks Regards Dilipkumar - Original Message - From: Dirk Bremer [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Thursday, July 27, 2006 8:32 PM Subject: Mysqlcheck issues I am using MySQL server 4.1.10 on Windows 2003 Server with MyISAM tables. I have an issue where occasionally an index (MYI) file becomes corrupted. I do not know why this occurs. To combat this issue, I tried running the following command every half-hour: mysqlcheck -Aamov --auto-repair --use-frm This command runs on the host. For some reason, when this command executes, the MySQL service aborts and the MYI for the main table is corrupted. I must then restart the service and repair the affected table. I am at a loss here. I would really like to use the --auto-repair option, but don't understand what is causing the service to abort. Your thoughts? Dirk Bremer - Senior Systems Engineer - ESS/AMS - NISC Lake St. Louis MO - USA Central Time Zone 636-755-2652 fax 636-755-2503 [EMAIL PROTECTED] www.nisc.coop -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] ** DISCLAIMER ** Information contained and transmitted by this E-MAIL is proprietary to Sify Limited and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this mail notify us immediately at [EMAIL PROTECTED] Watch the latest updates on Mumbai, with video coverage of news, events, Bollywood, live darshan from Siddhivinayak temple and more, only on www.mumbailive.in Watch the hottest videos from Bollywood, Fashion, News and more only on www.sifymax.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Mysqlcheck issues
The trouble with myisamchk is that it requires the server to be offline. This may not be suitable. Do you have a bad area on the disk? The easiest way would be to stop the server briefly, rename the index thus keeping it occupying the potentially bad part of the disk and recreate the index. This would at least take the disk out of the equation if the problem re-occurs. 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: Dilipkumar [mailto:[EMAIL PROTECTED] Sent: Friday, 28 July 2006 1:07 PM To: Dirk Bremer; mysql@lists.mysql.com Subject: Re: Mysqlcheck issues Hi, Instead of mysqlcheck you can use myisamckh to recover the data's. As myisamchk -r -o *.MY* Thanks Regards Dilipkumar - Original Message - From: Dirk Bremer [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Thursday, July 27, 2006 8:32 PM Subject: Mysqlcheck issues I am using MySQL server 4.1.10 on Windows 2003 Server with MyISAM tables. I have an issue where occasionally an index (MYI) file becomes corrupted. I do not know why this occurs. To combat this issue, I tried running the following command every half-hour: mysqlcheck -Aamov --auto-repair --use-frm This command runs on the host. For some reason, when this command executes, the MySQL service aborts and the MYI for the main table is corrupted. I must then restart the service and repair the affected table. I am at a loss here. I would really like to use the --auto-repair option, but don't understand what is causing the service to abort. Your thoughts? Dirk Bremer - Senior Systems Engineer - ESS/AMS - NISC Lake St. Louis MO - USA Central Time Zone 636-755-2652 fax 636-755-2503 [EMAIL PROTECTED] www.nisc.coop -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] ** DISCLAIMER ** Information contained and transmitted by this E-MAIL is proprietary to Sify Limited and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this mail notify us immediately at [EMAIL PROTECTED] Watch the latest updates on Mumbai, with video coverage of news, events, Bollywood, live darshan from Siddhivinayak temple and more, only on www.mumbailive.in Watch the hottest videos from Bollywood, Fashion, News and more only on www.sifymax.com -- 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: allow access to all users within a network..
bruce wrote: hi... i'm trying to figure out how to allow all users on machines within my network access to a mysql db... i've tried: grant access all on *.* to '*'@'%' grant access all on *.* to '%'@'%' grant access all on *.* to @'%' with no luck.. What errors do you get when you try to connect? Have you got mysql listening for network connections? comment out: skip-networking in your my.cnf file and restart mysql. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysqlcheck issues
Dirk Bremer wrote: I am using MySQL server 4.1.10 on Windows 2003 Server with MyISAM tables. I have an issue where occasionally an index (MYI) file becomes corrupted. I do not know why this occurs. To combat this issue, I tried running the following command every half-hour: mysqlcheck -Aamov --auto-repair --use-frm This command runs on the host. For some reason, when this command executes, the MySQL service aborts and the MYI for the main table is corrupted. I must then restart the service and repair the affected table. Do you get any errors in the logfiles? Not sure why that would be corrupting the database tables, what user are you running this as (root, mysql) ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: identify process that created the connection
This blog may help, http://www.xaprb.com/blog/2006/07/23/how-to-track-what-owns-a-mysql-connection/ Cheers, Ravi Rithish Saralaya wrote: Hello people. Is it possible to find the process that invoked the mysql thread, given a mysql thread id? We have a web application that runs on Linux-Apache-MySQL-PHP; and I sometimes see numerous mysql threads in sleeping mode when I run mytop. I think the sleeping mysql threads could be due to the fact that some of my web-page(s) have obtained a mysql connection, executed their queries, but have not terminated(and have not released the mysql connection also). If I could know the httpd processes that have created these connections, I would be able to find out the pages that are the culprit. Regards, Rithish. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: why size of table c united from table a and b are bigger than a+b ?
Chris [EMAIL PROTECTED] writes: chylli wrote: I run following command : use db1; insert into db2.c select a.a, a.b, a,c, b.d, b,e ... from a left join b on (a.id=b.id); Do you have an index on a.id and b.id ? size of table a and table b is: [EMAIL PROTECTED] ls -l ../db1/a.* -rw-rw 1 mysql mysql 9230 May 10 15:41 ../db1/a.frm -rw-rw 1 mysql mysql 880880528 Jul 17 01:15 ../db1/a.MYD -rw-rw 1 mysql mysql 383653888 Jul 17 01:15 ../db1/a.MYI [EMAIL PROTECTED] ls -l ../db1/b.* -rw-rw 1 mysql mysql 11277 May 10 15:47 ../db1/b.frm -rw-rw 1 mysql mysql 1494998192 Jul 17 01:15 ../db1/b.MYD -rw-rw 1 mysql mysql 619606016 Jul 17 01:15 ../db1/b.MYI It has took 16776 seconds , and now the command is still running. the size of table c is [EMAIL PROTECTED] ls -l c.* -rw-rw 1 mysql mysql 11623 Jul 27 05:37 c.frm -rw-rw 1 mysql mysql 4633395200 Jul 27 10:08 c.MYD -rw-rw 1 mysql mysql 165481472 Jul 27 10:08 c.MYI the number of records in a is : 3101692 my question is : why is size of c big? but size of c a+b now, now c is about 5G, and a+b is about 2.3G Because you're adding all columns from a and b into it. It is too slow. Has anyone better methods to do that work? Drop the indexes on c and create them at the end. thanks for your help. I'll do like what you said in the following work. Each row that's being added, it's updating the index at the same time, so that will be your bottleneck. -- 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: why size of table c united from table a and b are bigger than a+b ?
chylli [EMAIL PROTECTED] writes: Chris [EMAIL PROTECTED] writes: Because you're adding all columns from a and b into it. It is too slow. Has anyone better methods to do that work? Drop the indexes on c and create them at the end. Each row that's being added, it's updating the index at the same time, so that will be your bottleneck. will adding index last after inserting take also VERY LONG time ? Hope it won't. -- Thanks Regards Chylli -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: why size of table c united from table a and b are bigger than a+b ?
The default charset of c is utf8, and that of a and b is latin1. Maybe charset cause size of table increased? -- Thanks Regards Chylli -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
is INNER join so much slower than LEFT join ?
Hi List, I have the 2 MyISAM tables using mySQL version 5.0.15-NT: Table countries: `ID` smallint unsigned NOT NULL default '0', `Code` char(2) default NULL, `Name` char(30) default NULL, ... PRIMARY KEY (`ID`) Table data `Country1` smallint unsigned NOT NULL default '0', `Country2` smallint unsigned NOT NULL default '0', ... KEY `Country1` (`Country1`), KEY `Country2` (`Country2`) When I run then next query with LEFT join is takes approx 1 minute. UPDATE data AS db LEFT JOIN countries AS c1 ON db.Country1=c1.ID LEFT JOIN countries AS c2 ON db.Country2=c2.ID SET db.Expr = ...; But when I run it with INNER join is takes more than 2 hours !!! In both cases the query applies to 9.571.220 rows matched with 0 changed. Any idea why INNER join is so much slower ? TIA, Cor
Re: is INNER join so much slower than LEFT join ?
On Fri, 2006-07-28 at 07:08 +0100, C.R.Vegelin wrote: But when I run it with INNER join is takes more than 2 hours !!! In both cases the query applies to 9.571.220 rows matched with 0 changed. Any idea why INNER join is so much slower ? Inner Joins joins everything, it's like a cartesian joins Left joins will omit annything which does not exist on the Right side of the table.(meaning table data) -- Ow Mun Heng [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Need help on mysql crashing.
Hi, My mysql is crashing. Below table has the values it logs in the .err file before restarting. I am using the large.cnf file. The parameters I have changed are below. Rest are default values. #for performance SSR log=/var/log/mysql-queries.log join_buffer_size=1M max_connections=300 query_cache_size=64M query_cache_limit=2M #for performance SSR ERROR LOG TABLE === KBS : key_buffer_size RBS : read_buffer_size MUC : max_used_connections MC : max_connections TC : threads_connected All values are in KB. == TimeKBS RBS MUC MC TC TOTAL == 10:12:17268435456 1044480 251 300 197 875341 10:44:42268435456 1044480 209 300 158 875341 11:38:56268435456 1044480 176 300 124 875341 12:42:32268435456 1044480 187 300 134 875341 13:52:07268435456 1044480 152 300 96 875341 14:44:58268435456 1044480 154 300 106 875341 15:07:00268435456 1044480 150 300 94 875341 15:42:41268435456 1044480 150 300 100 875341 17:01:44268435456 1044480 162 300 101 875341 17:29:32268435456 1044480 133 300 81 875341 01:04:39268435456 1044480 155 300 107 875341 01:44:27268435456 1044480 190 300 139 875341 03:10:32268435456 1044480 185 300 120 875341 04:14:23268435456 1044480 276 300 220 875341 04:33:57268435456 1044480 204 300 152 875341 04:58:44268435456 1044480 233 300 179 875341 05:43:09268435456 1044480 265 300 213 875341 06:13:44268435456 1044480 210 300 155 875341 07:08:56268435456 1044480 186 300 133 875341 07:44:21268435456 1044480 250 250 203 773142 08:43:03268435456 1044480 250 250 195 773142 09:00:13268435456 1044480 193 250 142 773142 09:18:56268435456 1044480 286 300 235 875341 09:38:14268435456 1044480 211 300 152 875341 09:59:23268435456 1044480 181 300 116 875341 10:55:17268435456 1044480 196 300 137 875341 11:17:44268435456 1044480 154 300 99 875341 12:14:36268435456 1044480 147 300 87 875341 12:33:16268435456 1044480 214 300 162 875341 13:06:38268435456 1044480 189 300 124 875341 14:21:07268435456 1044480 164 300 100 875341 14:54:37268435456 1044480 167 300 116 875341 15:43:06268435456 1044480 130 300 69 875341 16:24:04268435456 1044480 134 300 68 875341 17:37:24268435456 1044480 126 300 78 875341 == -Sunil Sunder Raj -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]