Re: if there're a tool which can replace mysql-proxy?
Hello, One additional note in regards to learning more about the current state of MySQL Proxy and connecting with Proxy developers... Check out the Simulating Workload with MySQL Proxy webinar on April 2, with Giuseppe Maxia, MySQL Community Lead and Diego Medina, Quality Assurance Engineer @ Sun who will be talking about Proxy in general, but also some advanced topics. Thanks, -- Jimmy Mark Matthews wrote: On Mar 24, 2009, at 8:06 AM, Claudio Nanni wrote: Question: Hello Claudio, my company tried the mysql-proxy about one year ago(may be more) but could not use it for not being multithreaded. They say they spoke to the 'mysql-proxy' developer. Is this still true? Are there any limitation on using mysql proxy on a high load production server? It's still not multi-threaded, but work is progressing in this area, see: https://lists.launchpad.net/mysql-proxy-discuss/msg00041.html There are people using it on high-load production servers, for various flavors of high load. How much impact *any* proxy will have depends a lot on the type of workload you run through it, and what you do with the data while it's in the proxy itself, since what's going to hurt you performance-wise is directly related to latency, caused by the extra network hop, and anything else you do that delays the data being forwarded. Will it be completely(almost) transparent? Once again, that depends on what you do to the data flowing through it. The only major non-transparent part of the proxy is the permissions system, in that clients connecting through the proxy will always *appear* to be connecting *from* the proxy from mysqld's point of view, since there is no way to forward the client address to mysqld itself. For proxy-related questions, you'll probably get more detailed, quicker responses if you join the launchpad project's mailing list at: https://launchpad.net/~mysql-proxy-discuss If you're considering using mysql-proxy, I highly recommend tracking the project via the mailing list and staying in touch with the developers and the community, to both get a better idea if it's going to work for your situation in it's current (and always changing) state, and also to provide input into the direction of the developers. Best regards, -Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: if there're a tool which can replace mysql-proxy?
Forgot to post the URL in the event you are interested: http://www.mysql.com/news-and-events/web-seminars/display-306.html -- Jimmy Jimmy Guerrero wrote: Hello, One additional note in regards to learning more about the current state of MySQL Proxy and connecting with Proxy developers... Check out the Simulating Workload with MySQL Proxy webinar on April 2, with Giuseppe Maxia, MySQL Community Lead and Diego Medina, Quality Assurance Engineer @ Sun who will be talking about Proxy in general, but also some advanced topics. Thanks, -- Jimmy Mark Matthews wrote: On Mar 24, 2009, at 8:06 AM, Claudio Nanni wrote: Question: Hello Claudio, my company tried the mysql-proxy about one year ago(may be more) but could not use it for not being multithreaded. They say they spoke to the 'mysql-proxy' developer. Is this still true? Are there any limitation on using mysql proxy on a high load production server? It's still not multi-threaded, but work is progressing in this area, see: https://lists.launchpad.net/mysql-proxy-discuss/msg00041.html There are people using it on high-load production servers, for various flavors of high load. How much impact *any* proxy will have depends a lot on the type of workload you run through it, and what you do with the data while it's in the proxy itself, since what's going to hurt you performance-wise is directly related to latency, caused by the extra network hop, and anything else you do that delays the data being forwarded. Will it be completely(almost) transparent? Once again, that depends on what you do to the data flowing through it. The only major non-transparent part of the proxy is the permissions system, in that clients connecting through the proxy will always *appear* to be connecting *from* the proxy from mysqld's point of view, since there is no way to forward the client address to mysqld itself. For proxy-related questions, you'll probably get more detailed, quicker responses if you join the launchpad project's mailing list at: https://launchpad.net/~mysql-proxy-discuss If you're considering using mysql-proxy, I highly recommend tracking the project via the mailing list and staying in touch with the developers and the community, to both get a better idea if it's going to work for your situation in it's current (and always changing) state, and also to provide input into the direction of the developers. Best regards, -Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL Guru Needed!!
Hello, Depending on your budget and SLA needs, check out the support offerings available directly from MySQL/Sun. http://www.mysql.com/products/enterprise/features.html -- Jimmy bruce wrote: Hi. I've got a situation where I need to reach out/talk to a mysql guru every now and then. For the most part, the questions are probably 5-10 minutes for the right person, but they might take me hours/days to cobble together a good solution. (I'm not a mysql guru!!) As an example, I have a situation now where I've been trying to figure out a solution for a day now... I'm looking for someone that I can talk to periodically if I have questions. I'm willing to drop something in a paypal acct for this function. Posting to the email list, or the IRC chat isn't always expedient for my needs. Thanks -bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Question on replication
Hello, Check out: --replicate-do-db=db_name http://dev.mysql.com/doc/refman/5.0/en/replication-options.html -- Jimmy Kandy Wong wrote: Hi, Is there a replication setup method just to replicate a specific database not all the databases or exclude a specific database not to be replicated? Thank you. Kandy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: recommended high availability setups
Hello, It isn't without its pros and cons (just like any other HA solution), but you might want to check out DRBD. http://dev.mysql.com/doc/refman/5.1/en/faqs-mysql-drbd-heartbeat.html -- Jimmy Bryan Irvine wrote: What's the recommended method for high-availability setups? I've currently got a master-master replication setup that I'm testing but it doesn't quite seem as complete a solution as I had pictured. When a failed server comes back online you still have to manually add it based off of the line numbers/binlog correct? And adding a new DB requires reloading the MySQL server? I've been looking around at other technologies as well like linux-ha. What are other people using for systems that have to be up 100% of the time but aren't complete nightmares to manage? TIA! -Bryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Securing the Data
Hello, http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html discusses some available encrypt and decrypt functions native to MySQL. -- Jimmy Sujatha S wrote: Thanks for the update. Is there any method to encrypt the data on mysql? Regards, Suja On 1/11/08, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: You can limit access to tables in a database using a specific login.. Read on GRANT -Original Message- From: Sujatha S [mailto:[EMAIL PROTECTED] Sent: Thursday, January 10, 2008 3:06 PM To: mysql@lists.mysql.com Subject: Securing the Data Hello, Is it possible to encrypt data on mysql database. I have the following requirement. We have a development team, which will be involved in payroll system. They will update the salary information of all the employees in mysql database. Due to this the members in development team have the rights to access the payroll table, were they can see the salary of others employee and many more information of employee. My question is , do we have any secure method to protect the data. Like storing the data on encrypted format in mysql database. Also, do we have any other possible methods to restrict the development team from access on the data's Regards, Suja This message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom it is addressed. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. FXDirectDealer, LLC reserves the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal confirmation. FXDirectDealer, LLC is not responsible for any recommendation, solicitation, offer or agreement or any information about any transaction, customer account or account activity contained in this communication. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Circular replication
Hello, EDS and MySQL are having a webinar on the subject of circular replication today. Check out: http://www.mysql.com/news-and-events/web-seminars/index.html If you can't make it today, it will be archived in the On-Demand section. -- Jimmy Alex Arul Lurthu wrote: Chain replication is fine as long as reading stale data from the last slave in your chain is ok. the staleness depends on the write throughput and capacity of the intermediate slaves. But Chain replication with circular replication is a definite no no in prod since if any intermediate fails, you will not be able to restore it easily and the data goes out of sync. On Dec 5, 2007 12:31 AM, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote: Hi All, Is circular replication or chain replication is suitable for production environment. Whether any testing has been done. If yes then, Please let me know. There is any other issue related to circular replication. Thanks -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road, Secunderabad. Pin Code: 53 Office Number: 040-66489771 Mob: 9912924044 URL: ed-ventures-online.com Email-id: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: hardware clusters
Hello, If you have not already done so, check out the Cluster Eval Guide which has some tips which may assist you in your process. Much of the content was put together by the professional services group here at MySQL. http://www.mysql.com/why-mysql/white-papers/mysql_cluster_eval_guide.php Also, there is a cluster specific list: [EMAIL PROTECTED] Jimmy Guerrero Sr Product Manager MySQL, Inc Houston, TX Ricardo Oliveira wrote: Hi, As usual, everything is heavilly dependant on your specific scenario. Anyway, as a rule of thumb, databases benefit a LOT from RAM, and storage nodes benefit from I/O (more, faster disks). Regards, Ricardo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 64 bit build for Windows?
Hello, http://dev.mysql.com/downloads/mysql/5.0.html#winx64 Let me know if that helps. -- Jimmy James Eaton wrote: Is there a 64 bit build of MySQL 5.0 available for Windows Server 2003 64 bit edition? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL cluster for windows
Hello, I think you are asking what is the last version of Cluster that supported Windows. No MySQL release of the Cluster product has ever supported Windows. (We are talking pre-MySQL acquisition days when Cluster was supporting Windows.) MySQL versions 4.1, 5.0 and 5.1 all support Cluster on Mac- Linux - Unix platforms. (Just not Windows) Hope that helps, Jimmy Rolando Edwards wrote: What was the last release of MySQL 5.0.x that supported Cluster ??? - Original Message - From: Jimmy Guerrero [EMAIL PROTECTED] To: C K [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Wednesday, June 20, 2007 5:43:28 PM (GMT-0500) America/New_York Subject: Re: MySQL cluster for windows Hello, MySQL Cluster on Windows will not be available in version 5.1. Older versions of the product used to run on Windows, but the interest was low and the code has suffered from bit rot as a result. We are really waiting and seeing for the interest to pick up before allocating resources to do a new port and maintain it. This actually would be great community project for anyone that is up for it. -- Jimmy C K wrote: I have read some where that MySQL cluster will be available in 5.1 release, will it? Is there some progress in this regard? Thanks CPK -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL cluster for windows
Hello, Great, it looks like we have some interest here for Cluster on Windows! However, resources are pretty tight right now and we have not prioritized Cluster for Windows, at least not for 5.1 or 6.0. Again, this is a great community project for anyone that is up for attempting to port Cluster to Windows. -- Jimmy Yi, Ung wrote: I would be interested in cluster for windows. At least at our shop, we consider Windows servers easier to deploy so if we can have HA option for windows/mysql it'll be great. Thanks, Yi -Original Message- From: Rolando Edwards [mailto:[EMAIL PROTECTED] Sent: Thursday, June 21, 2007 9:42 AM To: Jimmy Guerrero Cc: mysql@lists.mysql.com; C K Subject: Re: MySQL cluster for windows What was the last release of MySQL 5.0.x that supported Cluster ??? - Original Message - From: Jimmy Guerrero [EMAIL PROTECTED] To: C K [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Wednesday, June 20, 2007 5:43:28 PM (GMT-0500) America/New_York Subject: Re: MySQL cluster for windows Hello, MySQL Cluster on Windows will not be available in version 5.1. Older versions of the product used to run on Windows, but the interest was low and the code has suffered from bit rot as a result. We are really waiting and seeing for the interest to pick up before allocating resources to do a new port and maintain it. This actually would be great community project for anyone that is up for it. -- Jimmy C K wrote: I have read some where that MySQL cluster will be available in 5.1 release, will it? Is there some progress in this regard? Thanks CPK -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Getting list of queries run against a database
Hello, To get started, have you tried enabling the slow query log? http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html The slow query log can be used to find queries that take a long time to execute and are therefore candidates for optimization. Jimmy Guerrero Sr Product Manager MySQL, Inc Houston, TX Ben Edwards wrote: We are having a problem with out mysql database (4.2) and think we may have indexes missing. What we are trying to do is find out the most popular queries that run. We know there are not may and that they are relatively simple. Does anyone know of a tool that allows us to see what queries (i.e. via a log file) are/have been run against the database. If it counts how may times/how much resources each query uses that would be good. The icing on the cake would be a prog that told us what queries were doing full table scans and other expensive operations. Regards, Ben -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL cluster for windows
Hello, MySQL Cluster on Windows will not be available in version 5.1. Older versions of the product used to run on Windows, but the interest was low and the code has suffered from bit rot as a result. We are really waiting and seeing for the interest to pick up before allocating resources to do a new port and maintain it. This actually would be great community project for anyone that is up for it. -- Jimmy C K wrote: I have read some where that MySQL cluster will be available in 5.1 release, will it? Is there some progress in this regard? Thanks CPK -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Master-Slave System Using Different Versions of MySQL
Hello, Did you already check: http://dev.mysql.com/doc/refman/5.0/en/replication-compatibility.html You cannot replicate from a master that uses a newer binary log format to a slave that uses an older format (for example, from MySQL 5.0 to MySQL 4.1.) Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc Houston, TX [EMAIL PROTECTED] wrote: There was a comment this week about a v5 master having problems connecting to a v4 slave, or vice versa. Can someone shed some light on this issue. A manual reference is good, too. Thanks, David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MYSQL data replication
Hello, Hmmm, I just reread your post and noticed the requirement of 50-60 slaves hanging off a single master. DRBD would NOT be the right solution here. -- Jimmy Jimmy Guerrero wrote: Hello, Although you state that there is no requirement for near real time synchronization, an alternative might be to look into DRBD. Which if you are not familiar with, is block-level replication. See: http://www.mysql.com/products/enterprise/drbd.html Combining DRBD with Linux Heartbeat also gives you failover capabilities. Mohd posted a blog on his experience yesterday. See: http://blog.irwan.name/?p=118 Jimmy Guerrero Sr Product Manager MySQL, Inc Houston, TX sol beach wrote: I have limited experience with MYSQL replication; which is why I am hoping others with more experience can answer a question or two. Let's say I have a MASTER MYSQL database. Let's say there are 50 - 60 other systems where I'd like to have MYSQL running on these slave systems. These slave systems need to be kept in synch with the Master, but it does NOT need to be anywhere near real time. The data in the slaves could lag as much a an hour or two. The amount of data in total in the MASTER is in the range of 100MB - 250MB The rate of changes to the data is in the range 2000 - 5000 DML per 24 hour day. We control the application so we can/will include date/time each record is created or modified. You can assume that no records ever get physically deleted; only INSERT UPDATE (no DELETE). What are some alternative ways to keep the slave systems current? TIA HAND! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MYSQL data replication
Hello, Although you state that there is no requirement for near real time synchronization, an alternative might be to look into DRBD. Which if you are not familiar with, is block-level replication. See: http://www.mysql.com/products/enterprise/drbd.html Combining DRBD with Linux Heartbeat also gives you failover capabilities. Mohd posted a blog on his experience yesterday. See: http://blog.irwan.name/?p=118 Jimmy Guerrero Sr Product Manager MySQL, Inc Houston, TX sol beach wrote: I have limited experience with MYSQL replication; which is why I am hoping others with more experience can answer a question or two. Let's say I have a MASTER MYSQL database. Let's say there are 50 - 60 other systems where I'd like to have MYSQL running on these slave systems. These slave systems need to be kept in synch with the Master, but it does NOT need to be anywhere near real time. The data in the slaves could lag as much a an hour or two. The amount of data in total in the MASTER is in the range of 100MB - 250MB The rate of changes to the data is in the range 2000 - 5000 DML per 24 hour day. We control the application so we can/will include date/time each record is created or modified. You can assume that no records ever get physically deleted; only INSERT UPDATE (no DELETE). What are some alternative ways to keep the slave systems current? TIA HAND! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL Licensing
Hello, I would recommend posting your question in the Licensing Fourm: http://forums.mysql.com/list.php?4 Also, please refer to our FAQ: http://www.mysql.com/company/legal/licensing/ Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc -Original Message- From: I have a question [mailto:[EMAIL PROTECTED] Sent: Friday, November 10, 2006 12:48 PM To: mysql@lists.mysql.com Subject: MySQL Licensing It is my understanding that MySQL provides two kind of licensing (a) GPL license for free download (b) OEM - commercial license for fee. Question is- Can OEM develop software using MySQL, create database desiged for MySQL. However, during distribution cirmvent commercial license by telling customers to download MySQL GPL version? Should this be legally allowed? Does MySQL take any action on such issues? -- View this message in context: http://www.nabble.com/MySQL-Licensing-tf2609653.html#a7282977 Sent from the MySQL - General mailing list archive at Nabble.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: MySQL on a ram disk?
Hello, Depending on the characteristics of the data and baring dependencies on specific features like FKs or complex JOINs, you may want to take a look at MySQL Cluster. MySQL Cluster supports in-memory and disk-based databases. So, it may give you the high-performance characteristics you are looking for, with the added benefit of high availability. More info at: http://www.mysql.com/products/database/cluster/ Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc -Original Message- From: Ryan Stille [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 08, 2006 8:22 AM To: mysql@lists.mysql.com Subject: MySQL on a ram disk? We have an intense data process that runs every few minutes, clearing and then loading a database with thousands of records of data, which are then queried on from a website. The periodic load takes about 20 seconds. Some of the front end select queries take a second or two. This is all running on MSSQL, and we are wondering if we could find any speed improvements by moving to MySQL, possibly running on a ram disk. Any input appreciated. Thanks, -Ryan -- 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: MyISAM vs InnoDB
Hello, Although the number of records is a consideration to weigh in your decision, there are many other (perhaps more important) factors to consider. For example, do you need foreign keys? transactions? row-level locks?...then InnoDB is your choice. Perhaps with more details concerning the characteristics of the data and your applications requirements, folks may be able to better help you with a design choice. Storage limits, efficiency in how space and memory is used, bulk insert speed, etc. might be other factors to consider. Take a look at: http://dev.mysql.com/doc/refman/5.0/en/storage-engines.html Thanks, Jimmy Guerrero MySQL, Inc -Original Message- From: Francis [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 31, 2006 2:25 PM To: mysql@lists.mysql.com Subject: MyISAM vs InnoDB Hi list, Question about MyISAM vs InnoDB ? What is the best to use, I have a large table contain around 10 millons of records. What is the best for me ? Use MyISAM or InnoDB ? Ty for reply ? -- 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: Encryption
Hello, Have you taken a look at: http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html That might give you a good start. Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc -Original Message- From: Cummings, Shawn (GNAPs) [mailto:[EMAIL PROTECTED] Sent: Friday, September 29, 2006 8:14 AM To: mysql@lists.mysql.com Subject: Encryption Is there a simple way to encrypted data as it's being stored in a table? And then easily decrypted when it's queried? Sample syntaxs if available - thanks in advance. -- 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: where are the .MYI and .MYD files?
Hello, A default install should drop data and databases into C:\Program Files\MySQL\MySQL Server 5.0.\data If you run something like: mysql CREATE DATABASE test1; Query OK, 1 row affected (0.00 sec) mysql USE test1; Database changed mysql CREATE TABLE t (i INT) ENGINE = MYISAM; Query OK, 0 rows affected (0.10 sec) Then go to C:\Program Files\MySQL\MySQL Server 5.0.\data\test1 Do you see the following in that directory? T.frm T.myd T.myi The files aren't hidden or anything. If you are trying to copy a database/tables from one machine to another, check out: http://dev.mysql.com/doc/refman/5.0/en/upgrading-to-arch.html Jimmy Guerrero Sr Product Manager MySQL, Inc -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, September 07, 2006 4:32 PM To: mysql@lists.mysql.com Subject: where are the .MYI and .MYD files? I've installed MySQL, created a database and tables and then loaded fields into them. I use the command line client and can see the fields, use the select command and every thing is OK, but when I look for the table files in the data directory, only the .frm ones appear, not the .MYI or MYD. Where could they be?. I've copied the data files in a flash memory and tried to see the tables fields in another computer with the same server version and platform and get the db_name.tb_name table doesn't exist error message. However when I run the show tables command, the command line shows me the list of the tables... In summary, I only can work with my database meanwhile don't restart Windows. Can anybody help me? Thanks in advance. MySQL server version: 5.0.19-nt Microsoft Windows Xp Professional version 2002 SP2. Misingo -- 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: How to draw data model diagrams from existing schema?
Hello, Check out MySQL Workbench (Part of the MySQL GUI Tools Bundle) if you haven't already done so: http://dev.mysql.com/downloads/gui-tools/5.0.html Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc -Original Message- From: news [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Wilson Sent: Wednesday, August 30, 2006 1:58 PM To: mysql@lists.mysql.com Subject: How to draw data model diagrams from existing schema? I've spent the last month building a fairly elaborate database with lots of foreign keys. I want to draw a diagram that maps the relationships between all the tables, but I haven't found any software that can do that. Does anyone have any suggestions? I want to draw a picture with a box for each table with links to all the other tables. TIA Matt -- A better way of running series of SAS programs: http://overlook.homelinux.net/wilsonwiki/SasAndMakefiles -- 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: Web Seminar Events
Hello, Although I can't speak to the timing of the newsletter getting sent out. A list of upcoming webinars can be found at: http://www.mysql.com/news-and-events/web-seminars/ Feel free to respond to me privately any suggestions for future topics of interest and we'll try to make them happen. Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc -Original Message- From: Jesse [mailto:[EMAIL PROTECTED] Sent: Friday, August 25, 2006 12:13 PM To: MySQL List Subject: Web Seminar Events Why is it that the Newsletter goes out after the Web Seminar's have already occurred. There have been several that I would have liked to see, but I got the news letter a day after the event occurred. It would be nice to know at least a day ahead of time when these things are going to happen. Is there another list somewhere of scheduled Web Seminars? 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: Moving Databases from v4.0.23 to v5.0.24
Hello, REPEAT is indeed a reserved word in MySQL in 5.0 http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html Jimmy Guerrero Sr Product Manager MySQL, Inc -Original Message- From: Kurt Cypher [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 09, 2006 3:13 PM To: mysql@lists.mysql.com Subject: Moving Databases from v4.0.23 to v5.0.24 I'm in the process of setting up mysql v5.0.24 on a new server. The server it's replacing is running mysql v4.0.23. I've run mysqldump to get a text file of SQL statements to read into mysql on the new server, and everything seems to work fine until it gets to a particular section of the mysqldump output. I turned on logging on the new server, and found that the last few lines in the log look like (preceded by literally hundreds of similar INSERT INTO lines): 1 Query INSERT INTO permission VALUES (80,80,'W') 1 Query DROP TABLE IF EXISTS repeat 1 Quit I checked a little earlier in the log, and found plenty of lines where the DROP TABLE command had worked fine for other table names. It would appear that it's getting ready to create a table called repeat and bombing. Looking at a text file containing the mysqldump output, I find that there are plenty of lines of SQL after the repeat statement. I'm thinking repeat might be a reserved word in mySQL v5.0.24, especially after the following test: mysql DROP TABLE IF EXISTS repeat; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'repeat' at line 1 mysql DROP TABLE IF EXISTS permission; ERROR 1046 (3D000): No database selected That would seem to indicate that v5.0.x of mysql expects repeat to be something special. If this is the case, then it would seem that we would need to rename this table in order for the database to work with mysql v5.0.24, no matter what method I use to transfer the data. Am I on the right track, or am I missing something obvious? Thanks, Kurt -- Kurt Cypher Senior Systems Programmer, CaTS Wright State University -- 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: 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 Cluster
Hello, MySQL Cluster has been available since version 4.1. For production purposes we recommend the GA version of 5.0. For the testing of new features (Disk-Data, Replication, etc) take a look at the latest 5.1 version. Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc -Original Message- From: Kaushal Shriyan [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 8:33 AM To: mysql@lists.mysql.com Subject: Re: MySQL Cluster On 7/25/06, Kaushal Shriyan [EMAIL PROTECTED] wrote: On 7/25/06, Kaushal Shriyan [EMAIL PROTECTED] wrote: Hi ALL I want to implement MySQL Cluster, are there any step by step guide to implement it Thanks and Regards Kaushal Hi Is cluster suite is available only in version of MySQL 5 and above. Regards Kaushal Hi ALL Is cluster suite is available only in version of MySQL 5 and above. Regards Kaushal -- 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: Synro MySQL databases
Hello, Does this change need to occur at exactly the same moment? Might want to take a look at replication for starters if you are not familiar with the technology. http://dev.mysql.com/doc/refman/5.0/en/replication.html SQLyog also offers some interesting synching http://www.webyog.com/sqlyog/index.php Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc -Original Message- From: Brian E Boothe [mailto:[EMAIL PROTECTED] Sent: Monday, July 24, 2006 10:16 AM To: MySQL List Subject: Synro MySQL databases HI all i have a question, I have A server MySQL database in our office location that stores Contact information / inventory etc... and also we have a Internet Site NOw what id like to perform is Whenver Someone changes something in the office to our Database, it also changes on our website ,, how do i do 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: mysql + LVS
Hello, Just to make sure we separate the two... mysql cluster that preforms reads on all the slaves, and writes only on the master. The above can be used to describe a typical use case for MySQL Replication. In a MySQL Cluster there is no need to load-balance your reads and writes. Thanks, Jimmy Guerrero MySQL, Inc -Original Message- From: Winn Johnston [mailto:[EMAIL PROTECTED] Sent: Monday, July 24, 2006 3:26 PM To: mysql@lists.mysql.com Subject: mysql + LVS How stable has it become to run an instance of mysql ontop of a LVS cluster to produce a massively parrallel system to be used for huge databases? Back in the day i remember tyring to do it with mosix, not sure where they are now a days. but either way i am looking for some current information on the subject. I know this differs from the idea that you can have a mysql cluster that preforms reads on all the slaves, and writes only on the master. thanks winn johnston __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.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: Anyone interested in a 4gl compiler ?
Hello, Have you taken a look at MySQL Forge? http://forge.mysql.com/ Great place check out other projects or users working on projects who may be interested in what your working on. Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc -Original Message- From: Mike Aubury [mailto:[EMAIL PROTECTED] Sent: Friday, July 21, 2006 8:53 AM To: mysql@lists.mysql.com Subject: Anyone interested in a 4gl compiler ? Hi there, I'm the lead developer on Aubit4GL (http://aubit4gl.sourceforge.net) which is a 4gl compiler used for writing database centric applications based on the original Informix-4GL language.. I'm just wondering what the appetite is like out there for a mysql compatible version (we've got a very simple mysql connector already, as well as postgres, ODBC). -- Mike Aubury -- 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: udf configuration
Hello, If you have not already done so, you may also try the MySQL forum for UDFs at: http://forums.mysql.com/list.php?118 Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc -Original Message- From: Yong Lee [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 19, 2006 6:10 PM To: mysql@lists.mysql.com Subject: udf configuration Hi all, I hope I have hit the right group for this question. I would like to create a UDF that is configurable at run time. Similar to how mysql can use variables defined in the /etc/my.cnf file, I'd like my UDF to make use of configuration parameters that can be set at run time. I'm wondering if this is possible and what strategy to take to implement this, ie: a mechanism to have mysql or the UDF read something once and then have the UDF able to refer back to it everytime it is run. I know I could read a file in the _init function, but this seems very wasteful to read a file every time the function is being used. Any thoughts on this would be appreciated. thanks, Yong. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Books on MySQL 5
Hello, You might want to check out Guy Harrison's book on SP's. http://www.amazon.com/gp/product/0596100892/102-8915813-3282553?v=glancen=2 83155 Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc -Original Message- From: Chris White [mailto:[EMAIL PROTECTED] Sent: Friday, June 09, 2006 2:16 PM To: mysql@lists.mysql.com Subject: Books on MySQL 5 As always, thanks ahead of time for all responses. The company I work for is currently looking at getting literature on MySQL 5, more specifically, what's different in new MySQL features from the SQL standard. By this I mean things such as Stored Procedures, Foreign Keys, and anything else I might have missed. I know there's: Beginning MySQL Database Design and Optimization: From Novice to Professional (Apress, 2004) And it does say it covers MySQL5, I'm just not sure to what extent. -- Chris White PHP Programmer/DB Virus Interfuel -- 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: How To Pronounce MySQL
Hello, I'll take the easy way out and quote http://dev.mysql.com/doc/refman/5.0/en/what-is.html The official way to pronounce MySQL is My Ess Que Ell (not my sequel), but we don't mind if you pronounce it as my sequel or in some other localized way. Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Thursday, June 08, 2006 7:36 AM To: Jesse; MySQL List Subject: RE: How To Pronounce MySQL [snip] This may be a really stupid question, but I hate looking stupid if I can avoid it. :-) I have been using Microsoft SQL Server for a while, and I'm now trying to switch all our applications over to use MySQL. Microsoft SQL Server is pronounced Sequel Server. Is MySQL pronounced My Sequel, or is it pronounced My S-Q-L? I mean, generally speaking? [/snip] ** POTENTIAL HOLY WAR ALERT! ** We flip back and forth here, dependent on how fast the conversation is going. Pure database guys want everyone to say, ess que ell, recently though I have even heard a lot of them saying, sequel. YMMV. ** END ALERT! ** -- 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 Server
Hello, Is there a particular reason you need to be working with version 3.23 (besides it being part of the RHL distro?) You might want to start with version 5.0 or 4.1. http://dev.mysql.com/downloads/ Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc -Original Message- From: Kaushal Shriyan [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 07, 2006 9:05 AM To: mysql@lists.mysql.com Subject: MySQL Server Hi ALL I have RHL 9.0 installed on my box, and I have installed mysql-3.23.54a-11.i386.rpm mysql-server-3.23.54a-11.i386.rpm, due to some reason i deleted the folders from /var/lib/mysql, I mean mysql and test folder located under /var/lib/mysql I have re-installed the package mysql and mysql-server package but i am not able to see the test and mysql database which comes by default while installing mysql and mysql-server package. Any help will be really appreciated Thanks Kaushal -- 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 (GPL License)
Hello, If you are still unsure about the licensing, this may help... http://www.mysql.com/company/legal/licensing/ http://www.mysql.com/company/legal/licensing/faq.html There are also related links off to the right concerning the Open Source License and Commercial License. Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc -Original Message- From: Michael Louie Loria [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 07, 2006 8:42 PM To: mysql@lists.mysql.com Subject: Re: MySQL (GPL License) Ok thanks, I'm somehow clarified. Mic Douglas Sims wrote: I believe that if you are only using MySQL for your company's internal needs, whether from a web server or for deployment to other company-owned locations, you don't need a commercial license. For example, if your company owns fifiteen stores, you could set up a MySQL-based point-of-sale system at each one without needing a commercial license. You only need to release your source code if you release your compiled code. Also, I believe the GPL requirement for sharing only applies if you have modified MySQL's object code, i.e. compiled your code into it or it into your code or linked object code to it. If you are simply installing it as a database and communicating to it through DBI or ODBC or some other means which uses sockets or ports, you don't need to release your code under the GPL. Thus, you hardly ever need to purchase a commercial license. Please note that this is just my understanding. I hope someone will correct if I have misstated anything here. However, it is very reasonable and desirable to support MySQL as a company, as they save us all tons of money over Oracle, MS-SQL, etc., in addition to providing an excellent product. So even if you don't need the commercial license, if your company depends upon MySQL, buying a commercial license, paying for training, attending conferences, or buying lots of t-shirts is nice. Douglas Sims [EMAIL PROTECTED] On Jun 7, 2006, at 7:58 PM, Logan, David (SST - Adelaide) wrote: Hi Michael, I believe you can purchase a commercial license taking away the GPL provisions from your software if you do not wish to GPL your own software. You can enquire on the MySQL website. 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: Michael Louie Loria [mailto:[EMAIL PROTECTED] Sent: Thursday, 8 June 2006 9:45 AM To: mysql@lists.mysql.com Subject: MySQL (GPL License) Hello, I would like to inquire about the GPL License used by MySQL. Here's our scenario We developed our owned software needed by our operations using MySQL community edition under Windows platform. GPL says that we should distribute/share the source code. But I think it isn't even of interest or beneficial to others because it was done on the company specs. If we were required to distribute/share our source code. What distribution methods can be used? like uploading the source code in a site? or when someone walks in and asks for the source code, we should share it to them. Thanks, I just need to have some clarifications about the GPL Mic -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Passwords in Mysql5.x
Hello, Have you taken a look at the following sections in the manual? http://dev.mysql.com/doc/refman/5.0/en/user-names.html http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc -Original Message- From: Shivaji S [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 06, 2006 1:30 PM To: mysql@lists.mysql.com Subject: Passwords in Mysql5.x Hi, what type of password algorithum does mysql 5.x uses for encrypting passwords? and how does these algorithum keeps the password in secure. Regards, Shivaji. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL documentor - not MySQL Workbench
Hello, Although not open-source, our partner Embarcadero Technologies offers one of the best ER tools out there for design, diagraming, documentation and reverse/forward engineering. ERStudio www.embarcadero.com/products/erstudio/index.html Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc -Original Message- From: Miles Thompson [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 9:52 AM To: MySQL List Subject: MySQL documentor - not MySQL Workbench Is there a tool, preferably open source, that can read database schema scripts (for lack of a better term) or connect to the database, and generate a diagram? This for a MySQL 5.x database. I've been working with MySQL Workbench, and if I used it as a dumb device it was OK. As soon as I started adding foreign keys - BLOOM! BLOOM! - lines and labels everywhere. The schema code it generated need a lot of editing as well. This is expecting rather a lot, but thought I would ask. Regards - Miles Thompson -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.1.394 / Virus Database: 268.8.0/353 - Release Date: 5/31/2006 -- 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 Clustering
Hello, We are aware that some user require FK's and would like to see them supported in MySQL Cluster. We are hoping to offer this functionality initially through the MySQL interface (not the NDB API) some time next year. Look for announcements on the MySQL Cluster forum and mailing list for it's availability. Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc -Original Message- From: Ben Clewett [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 30, 2006 6:48 AM To: mysql@lists.mysql.com Subject: MySQL Clustering Dear MySQL, I am interested in clustering for MySQL. This claims to offer the redundancy scalability and performance we require. One thing I am really disappointed at is that clustering seems not to offer much Referential Integrity (RI). Specifically, Foreign Key References. For better or for worse we have always used RI, therefore have come to expect this in our programs and administration tools. It's therefore an absolute necessity. May I ask if any member know whether this is planned, and if so, what sort of time periods? Thanks, Ben. -- 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: possible to select from multiple databases?
Hello, Have you taken a look at the FEDERATED storage engine? http://dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html It is a storage engine that accesses data in tables of remote databases rather than in local tables. Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc -Original Message- From: Bing Du [mailto:[EMAIL PROTECTED] Sent: Friday, May 05, 2006 4:09 PM To: mysql@lists.mysql.com Subject: possible to select from multiple databases? Hello, I have two separate databases that I need to query data from. In the following SELECT statement, 'title' and 'db_entry_name' are in database1, and 'projectID' is in database2. If they were in one database, this SELECT should work. How should I tweak it to get data from both database1 and database2? Is that even possible in single SELECT? SELECT title, db_entry_num, projectID FROM account_info, ResearchProjects WHERE ResearchProjects.IDNo = $idno AND account_info.db_entry_num = ResearchProjects.projectID Thanks in advance, Bing -- 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 cluster info~
Hello, MySQL 5.0 Cluster is an in-memory database. Meaning that the entire database (tables, indexes, etc.) must fit in RAM along with your other OS and application processes. In 5.1, we have introduced disk-based data support. Note, that although data can now be stored on disk, indexes must still reside in memory. Might be worth checking out, however 55 GB is def. on the large size for a MySQL Cluster configuration. Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com -Original Message- From: Mohammed Abdul Azeem [mailto:[EMAIL PROTECTED] Sent: Monday, March 20, 2006 9:33 PM To: mysql@lists.mysql.com Subject: ~Mysql cluster info~ Hi, Iam new to clustering in mysql. I went through the reference manual 5.0 and found that the RAM memory requirements for implementing a cluster is almost twice the size of the database. My problem is i have a database which is 55GB. So does it mean that i need to have 110 GB RAM memory ? Can anyone let me know whether it is possible for me to configure a cluster for such a huge database. If yes, how am i suppose to proceed ( regarding memory requirements ). Thanks in advance, Abdul. This email has been Scanned for Viruses! www.newbreak.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: ~Mysql cluster info~
Hello, Not at this time, currently 5.1 is in Beta. We should see a release candidate soon, but I can't commit to a specific date at this time. Thanks, Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA -Original Message- From: Mohammed Abdul Azeem [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 21, 2006 9:30 PM To: Jimmy Guerrero Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: RE: ~Mysql cluster info~ Hello Jimmy, Do we have a production release of MYSQL cluster 5.1 ? If yes please let me know the path from where i can download the same. Thanks in advance, Abdul. On Tue, 2006-03-21 at 07:16 -0600, Jimmy Guerrero wrote: Hello, MySQL 5.0 Cluster is an in-memory database. Meaning that the entire database (tables, indexes, etc.) must fit in RAM along with your other OS and application processes. In 5.1, we have introduced disk-based data support. Note, that although data can now be stored on disk, indexes must still reside in memory. Might be worth checking out, however 55 GB is def. on the large size for a MySQL Cluster configuration. Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com -Original Message- From: Mohammed Abdul Azeem [mailto:[EMAIL PROTECTED] Sent: Monday, March 20, 2006 9:33 PM To: mysql@lists.mysql.com Subject: ~Mysql cluster info~ Hi, Iam new to clustering in mysql. I went through the reference manual 5.0 and found that the RAM memory requirements for implementing a cluster is almost twice the size of the database. My problem is i have a database which is 55GB. So does it mean that i need to have 110 GB RAM memory ? Can anyone let me know whether it is possible for me to configure a cluster for such a huge database. If yes, how am i suppose to proceed ( regarding memory requirements ). Thanks in advance, Abdul. This email has been Scanned for Viruses! www.newbreak.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] This email has been Scanned for Viruses! www.newbreak.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Visual database design system
Hello, Might want to check out ERStudio from Embarcadero Technologies. http://www.embarcadero.com/products/erstudio/ Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA -Original Message- From: Adi [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 9:53 AM To: mysql@lists.mysql.com Subject: Visual database design system I am looking for a tool to integrate with mysql...I have tried DBDesigner and would like to get my hands on software that is equivalent or better than DBDesigner...any suggestions? FYI: I have had some problems with importing, printing etc with DBDesigner... Thanks in advance... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Performance of MEMORY/HEAP-tables compared to mysql-cluster?
Hello, Another consideration besides the performance aspects, are the characteristics between MEMORY and the NDB storage engines. (You'll be gaining or losing functionality depending on how you look at it.) Briefly: MEMORY - in memory, table locks, hash B-tree indexes, no disk i/o or persistence NDB - in memory, supports transactions, persistence, row-level locks, hash T-tree indexes Also, moving to cluster means more machines, and as stated by Kishore, Cluster really buys you scalability, not necessarilly performance right off the bat (unless you plan on using the NDB API to access data.) As, Sherri suggests another storage engine might be a better play here. Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX -Original Message- From: sheeri kritzer [mailto:[EMAIL PROTECTED] Sent: Friday, January 27, 2006 11:11 AM To: Jan Kirchhoff Cc: mysql@lists.mysql.com Subject: Re: Performance of MEMORY/HEAP-tables compared to mysql-cluster? Why are you using a heap table? My company has tables with much more information than that, that get updated much more frequently. We use InnoDB tables, with very large buffer sizes and have tweaked which queries use the cache and which don't, on a system with lots of RAM (10Gb). Basically we've set it up so everything is in memory anyway. Perhaps a similar setup would help for you? Sincerely, Sheeri Kritzer On 1/27/06, Jan Kirchhoff [EMAIL PROTECTED] wrote: Hi, Did anybody ever benchmark heap-tables against a cluster? I have a table with 900.000 rows (40 fields, CHARs, INTs and DOUBLEs, Avg_row_length=294) that gets around 600 updates/sec (grouped in about 12 extended inserts a minute inserting/updating 3000 rows each). This is currently a HEAP-table (and get replicated onto a slave, too). I experience locking-problems on both the master and the slave, queries that usually respond within 0.0x seconds suddenly hang and take 10 seconds or sometimes even longer. I wonder if a cluster setup would give me any speedup in this issue? I will be doing some benchmarking myself next week, but It would be very helpful if anybody could share experiences with me so I don't have to start from scratch... It is difficult and very time-consuming to set up a test-suite comparable to our production systems... Any tips will help! Thanks! regards Jan -- 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]
RE: 4 GIG Limitation
Hello, Check out http://dev.mysql.com/doc/refman/5.0/en/table-size.html Also, not sure if it's a typo but MySQL 11.8 is a ways off. Did you mean 4.1 or 5.0? Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA Phone: (713) 636-9239 -Original Message- From: Adnan [mailto:[EMAIL PROTECTED] Sent: Friday, January 27, 2006 3:39 PM To: mysql@lists.mysql.com Subject: 4 GIG Limitation Greetings, I recently was told that MYSQL has a 4 GIG size limitation. I am not sure if this is for a table size or for the actual size of the database itself. Is there such a limatation for MYSQL 11.18 running on RedhatAS 3? Thanks, asadiq -- 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: Collect SQL Statements
Hello, MySQL has a few logs that can assist you in capturing statements: 1. The query log shows client connections and executed statements 2. The binary log shows all statements that change data (also used for replication) 3. The slow log shows all queries that took more than long_query_time seconds to execute or didn't use indexes See http://dev.mysql.com/doc/refman/5.0/en/log-files.html for more info on setting up and analyzing these logs. Thanks, Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA -Original Message- From: Moeller, Thorsten, AO [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 25, 2006 9:15 AM To: mysql@lists.mysql.com Subject: Collect SQL Statements Hi, is there a possibility to collect the sql statements issued to a mysql db to analyse them?? perhaps there is an extra tool or script for this?? Thanks for any suggestions! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL database design documentation
Hello, Two admin tools to check out if you haven't already... PHP, you can try PHPMyAdmin - http://www.phpmyadmin.net/home_page/index.php Non-PHP, try MySQL's GPL MySQL Administrator - http://dev.mysql.com/downloads/administrator/index.html However, they too may not be suitable for remote admin depending on your setup and security needs. Thanks, Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA Phone: (713) 636-9239 -Original Message- From: Maurice van Peursem [mailto:[EMAIL PROTECTED] Sent: Thursday, January 05, 2006 3:37 PM To: mysql@lists.mysql.com Subject: MySQL database design documentation Hi, I'm sure this is a stupid question, but I haven't been able to find it myself. Surely there must be a free PHP utility to web-administrate a MySQL database? I use CocoaMySQL (http://cocoamysql.sourceforge.net/) on my own Mac, but it isn't suitable for online databases. Can anyone lead me in the right direction? Thanks, Maurice van Peursem The Netherlands -- 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: Report tool - Mysql
Hello, Depending the level of sophistication you require, you might want to take a look at: - JasperSoft (Open Source) - Crystal Reports - If you're running Microsoft Reporting Services somewhere in your shop, I think you can use it to plug into any JDBC compliant DB, but I might be wrong. If it's reports/documentation about your DB you are after you might want to check out Embarcadero's ERStudio, which is imho the best ERD tool on the market. Thanks, Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA -Original Message- From: Darryl Hoar [mailto:[EMAIL PROTECTED] Sent: Friday, December 16, 2005 2:59 PM To: mysql@lists.mysql.com Subject: Report tool - Mysql Greetings, I need to get a tool to create reports using mysql databases. It would be great if the resultant reports could be run by themselves (not inside the report development environment). Anybody have any recommendations ? thanks, Darryl -- 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: how to create binary logging for a database
Hello, The reference manual is great place to start for this type of information. http://dev.mysql.com/doc/refman/5.0/en/binary-log.html --log-bin[=file_name] is the mysqld startup command. Thanks, Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA Phone: (713) 636-9239 -Original Message- From: prathima rao [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 14, 2005 6:04 AM To: mysql@lists.mysql.com Subject: how to create binary logging for a database hello, how can i create a binary log in a new database - Original Message - From: Adam Lipscombe [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: 14/12/2005 3:50 PM Subject: Mysqldump INSERT statements (Was Mysqldump line endings) (--result-file) option to save your output but use the output redirector to map the output of mysqldump to a file you specify, you will get the CRLF line endings you seek. Many thanks. One more thing: by default mysqldump uses --extended-insert=TRUE. This results in all the VALUES data being on one line. IF the table has much data this produces very long lines when viewed in a text editor. (WordPad crashes!) If --extended-insert=FALSE then multiple INSERT statements are used. IS there any way to have 1 INSERT statement with each subsequent data line on a separate line? E.g. : INSERT INTO t1 VALUES (1,2,3), (1,4,5), (1,6,7); TIA - Adam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.371 / Virus Database: 267.13.13/199 - Release Date: 13/12/2005 -- 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: Store Procedures
Hola, Una introducción basica y ejemplos se pueden encontrar aquí: http://www.quest-pipelines.com/newsletter-v6/0105_D.htm http://www.quest-pipelines.com/newsletter-v6/0205_D.htm Tambien aqui: http://www.databasejournal.com/features/mysql/article.php/3525581 Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA -Original Message- From: ElkinFernando Ortiz [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 14, 2005 7:44 AM To: mysql@lists.mysql.com Subject: Store Procedures Please, I'm working with MySql 5. I need examples for store procedures for evaluate Syntax. Por favor, Trabajo con MySql5. Para atender unos requerimientos de programacion, estoy estudiando procedimientos almacenados y quisiera que alguno de ustedes me facilitaran ejemplos de estos, si los pueden compartir, no importa su complejidad. Mi direccion privada es [EMAIL PROTECTED] Mil Gracias por su colaboracion. Elkin Ortiz Medellin, Colombia -- 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: MySQL5
Hello, 1. The MySQL 5.0 client programs can be downloaded from the below link...(not sure what platform your on): http://dev.mysql.com/downloads/mysql/5.0.html 2. The mysqladmin client ships with 5.0, so you should be able to invoke it from the command line. shell mysqladmin [options] command [command-options] 3. If you are interestd in the graphical tools we offer, you can find the links at: http://dev.mysql.com/downloads/ The Administrator, Query Browser and Migration Toolkit are available for download on that page. Thanks, Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA -Original Message- From: Brian E Boothe [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 13, 2005 10:30 PM To: mysql@lists.mysql.com Subject: MySQL5 I've Installed - uninstalled - reinstalled Mysql-5 Three Times on a extra machine I had laying around , and I have a few questions because of trouble's I've had and here they are I had trouble with phpmyadmin,(just wont Login or work at all) it's says to upgrade my Client's Were are the Client Installs in this ver???) like MySQL 4.0.24 the best ver in my oppion ,, Were are the tools? Like MySQLadmin that's Included in MySQL 4.0.24 , And for god sake what ver of PHP do I have to run with MySQL5, geesh what a pain in the ass,, can someone help me -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: to track the changes in database mySQL
Hello, Something to keep in the back of your mind, is in the latter part of next year we will be enabling the option to log all/some DDL, DCL, SELECTs, DML and Server Admin commands and its associated ID, IP, timestamp, etc. At that point you'll be able to filter, sort or delete audit data to suit your needs. Thanks, Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA -Original Message- From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] Sent: Monday, December 12, 2005 11:14 PM To: Satyanarayana_Kesani; mysql@lists.mysql.com Subject: RE: to track the changes in database mySQL Hi Satya, You might like to look at triggers here http://dev.mysql.com/doc/refman/5.0/en/triggers.html You can set a trigger to go off at any of the events you have noted below. This would allow you to log the userid and any other relevant information you need. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Satyanarayana_Kesani [mailto:[EMAIL PROTECTED] Sent: Tuesday, 13 December 2005 3:13 PM To: mysql@lists.mysql.com Subject: to track the changes in database mySQL Hi all, I got this mail Id from mySQL lists.I would like to request you for one help. Actually I need to track the changes(UPDATE,INSERT,DELETE and others) done on the database in mySQL by different users. I need to know which user has done what changes . I am using mySQL 5.0.16-nt. I would like to know how I can create binary log or some other log for the same? Could you please help me on this? Thanks in advance ThanksRegards, Satya DISCLAIMER: This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. -- 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: to track the changes in database mySQL
Hello, Yes, the binary log will probably get the job done if its just data modifications you're after and you're archiving those logs to suit your needs. However if you'd like to also track other things like SELECTs, enabling the general query log might be a better option. Starting MySQL with the --log option will create the query log. Note, there are some important differences between the bin and query log. See http://dev.mysql.com/doc/refman/5.0/en/query-log.html for more info. Thanks, Jimmy -Original Message- From: Satyanarayana_Kesani [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 13, 2005 7:28 AM To: Jimmy Guerrero; Logan, David (SST - Adelaide); mysql@lists.mysql.com Subject: RE: to track the changes in database mySQL Thanks Jimmy, I would like to get one thing clarified from you is: Am I able to create a binary log (may be some other log) to know the changes done on my database(any updations,deletion of records,addition of new records) in MySQL by different users? Thanks a lot, Satyanarayana Reddy From: Jimmy Guerrero [mailto:[EMAIL PROTECTED] Sent: Tue 12/13/2005 6:44 PM To: 'Logan, David (SST - Adelaide)'; Satyanarayana_Kesani; mysql@lists.mysql.com Subject: RE: to track the changes in database mySQL Hello, Something to keep in the back of your mind, is in the latter part of next year we will be enabling the option to log all/some DDL, DCL, SELECTs, DML and Server Admin commands and its associated ID, IP, timestamp, etc. At that point you'll be able to filter, sort or delete audit data to suit your needs. Thanks, Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA -Original Message- From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] Sent: Monday, December 12, 2005 11:14 PM To: Satyanarayana_Kesani; mysql@lists.mysql.com Subject: RE: to track the changes in database mySQL Hi Satya, You might like to look at triggers here http://dev.mysql.com/doc/refman/5.0/en/triggers.html You can set a trigger to go off at any of the events you have noted below. This would allow you to log the userid and any other relevant information you need. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Satyanarayana_Kesani [mailto:[EMAIL PROTECTED] Sent: Tuesday, 13 December 2005 3:13 PM To: mysql@lists.mysql.com Subject: to track the changes in database mySQL Hi all, I got this mail Id from mySQL lists.I would like to request you for one help. Actually I need to track the changes(UPDATE,INSERT,DELETE and others) done on the database in mySQL by different users. I need to know which user has done what changes . I am using mySQL 5.0.16-nt. I would like to know how I can create binary log or some other log for the same? Could you please help me on this? Thanks in advance ThanksRegards, Satya DISCLAIMER: This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] DISCLAIMER: This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: copying data!!!
Hello, We expect to offer native support for LDAP and PAM authentication, late next year. Thanks, Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com -Original Message- From: Sachin Bhugra [mailto:[EMAIL PROTECTED] Sent: Friday, December 09, 2005 1:38 PM To: mysql@lists.mysql.com Subject: copying data!!! Hello Friend, Can you please let me know how to copy data from a column in table A to a column in table B. e.g. I want to copy value of column age from table 2 to column age in table 1, provided the entries in column name, which is there in both the table, should match. In MySQL v 4 it could be done using Update tbl1,tbl2 syntax, but i have now MySQL 3.23 which does not supports this Update syntax... Also, can i use ldap to authenticate the MySQL users, if yes, please tell me how?? Tnax. Sachin -- 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: Now what's that called?
Hello, Are you think of Eventum? http://dev.mysql.com/downloads/other/eventum/ Thanks, Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA Phone: (713) 636-9239 Are you MySQL Certified? www.mysql.com/training//certification -Original Message- From: Alexander Shaw [mailto:[EMAIL PROTECTED] Sent: Monday, October 31, 2005 1:37 PM To: mysql@lists.mysql.com Subject: Now what's that called? Evening All, I knew I should have been paying attention. A while back I received an email about a software product that runs with mysql for development error tracking/reporting and it's used by the mysql ab team. Can't or the life of me remember what it's called. Can anyone help please? Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]