ANN: Database Workbench Pro 3.4 released
Upscene Productions is proud to announce the next version of the popular database development tool: Database Workbench 3.4 Pro Changes Highlights in 3.4 and previous versions --- - NexusDB v3 support - Many diagramming improvements - Better Stored Routine Debugger - Ability to cancel import/export processes - Monitoring GUI for Firebird 2.1 - Ability to cancel running queries in NexusDB, SQL Anywhere and Firebird 2.1 - Stored Routine debugger for SQL Anywhere - Many new features, enhancements and bug fixes... ... and much more ... More info at: http://www.upscene.com/products.dbw.index.php Download a trial at: http://www.upscene.com/downloads.php Thank you for reading, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RES: [SPAM] RE: Remote connection
It´s working. The problem was related to grant permission. Thank you. Cheers, Hugo -Mensagem original- De: Gavin Towey [mailto:gto...@ffn.com] Enviada em: terça-feira, 4 de agosto de 2009 19:46 Para: Hugo Leonardo Ferrer Rebello; mysql@lists.mysql.com Assunto: [SPAM] RE: Remote connection 1.) remove bind-address= and skip-networking from my.cnf 2.) grant permission to the external 'user'@'host' 3.) remove any firewall rules blocking port 3306 4.) make sure no overrides on the mysqld commandline. See http://hashmysql.org/index.php?title=Remote_Clients_Cannot_Connect If you continue to have problems, give us the exact steps you have tried and the exact error message you are receiving. Please try to connect using the mysql command line. Regards, Gavin Towey -Original Message- From: Hugo Leonardo Ferrer Rebello [mailto:hugo.rebe...@t-systems.com.br] Sent: Tuesday, August 04, 2009 1:09 PM To: mysql@lists.mysql.com Subject: Remote connection Hello Guys, I have a big doubt. I'm trying to access the mysql database remotely, but I can't. I have changed the skip-networking option on my.cnf file however it doesn't work. I have tried to include the bind_address = 0.0.0.0 but it still doesn't work. Sure I have commented the skip-networking option before enable the bind_address. I don't know what else I must do. Please, anybody can help me ? Look at the error message below. # mysql -u root -p -h 192.168.12.50 Enter password: ERROR 1045 (28000): Access denied for user 'root'@'192.168.12.50' (using password: YES) Cheers, Hugo The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
How to Detect MySql table update/difference
Hi, I'm a novel developer of MySql and now I am trying to create a mysql query to detect table updates. I query a database table every X seconds, and i want to get only the different rows in the table. The result that I want to have is simply TABLE (t = now) - TABLE (t = X second ago) Every time that i query the database I store the table situation in another table, called TABLE_TEMP, so the operation of difference detection is TABLE_DIFERENCE = TABLE - TABLE_TEMP. How can I do this query? The problem that I have is that I don't know the structure of the table and I want to create a program with can be used for all types of data and tables. Please help me. Best regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
SQL Image Viewer 2.4.0.132 released
SQL Image Viewer helps you retrieve, view, convert and export images and binary data stored in SQL Server, Firebird, MySQL, Oracle, SQLite, and various ODBC-supported databases (e.g. DB2 and PostgreSQL). It supports the following image formats: BMP, GIF, JPG, PNG, PSD, and TIFF, and recognises the following binary file types: PDF, HTML, XML, MP3, AVI, 7Z, BZ2, GZ, RAR, ZIP. More details are available from http://www.sqlimageviewer.com Thank you. Yeoh Ray Mond Associate, Yohz Software http://www.sqlimageviewer.com http://www.yohz.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: How to Detect MySql table update/difference
I have good news and bad news for you when it comes to MySQL 5.x. Good News if you are counting against MyISAM Bad News if you are counting against InnoDB Good News - For MyISAM Just use either SELECT table_rows FROM information_schema.tables WHERE table_schema='given db name' and table_name='given table name'; Or SELECT COUNT(1) FROM db-name.tbl-name; (This will work in MySQL 4.x as well) Bad News For InnoDB SELECT COUNT(1) FROM db-name.tbl-name, even though it can run faster than SELECT COUNT(*), will still count every row in the table anyway. If you are using InnoDB, you are on your own If you are using MyISAM, have fun Rolando A. Edwards MySQL DBA (CMDBA) 155 Avenue of the Americas, Fifth Floor New York, NY 10013 212-625-5307 (Work) 201-660-3221 (Cell) AIM Skype : RolandoLogicWorx redwa...@logicworks.net -Original Message- From: BS TLC [mailto:bs...@ymail.com] Sent: Wednesday, August 05, 2009 10:30 AM To: mysql@lists.mysql.com Subject: How to Detect MySql table update/difference Hi, I'm a novel developer of MySql and now I am trying to create a mysql query to detect table updates. I query a database table every X seconds, and i want to get only the different rows in the table. The result that I want to have is simply TABLE (t = now) - TABLE (t = X second ago) Every time that i query the database I store the table situation in another table, called TABLE_TEMP, so the operation of difference detection is TABLE_DIFERENCE = TABLE - TABLE_TEMP. How can I do this query? The problem that I have is that I don't know the structure of the table and I want to create a program with can be used for all types of data and tables. Please help me. Best regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=redwa...@logicworks.net
Re: Performance impact of large number of columns
The problem is that I need to search/sort by ANY of the 284 fields at times - 284 indexes is a bit silly, so there will be a lot of sequential scans (table has 60,000 rows). Given that criteria, will fewer columns in more tables provide a performance benefit? -j On Tue, 2009-08-04 at 16:03 -0700, Howard Hart wrote: If your key is good, your limitation is really in searching through the physical index file, not the data files which contain the actual records. Result is you're only limited by the disk seek time to read through the index files to get the physical (offset) location of the record in the data file. 10 rows or 1000 rows in that record shouldn't make much difference. Searching through multiple index files after splitting using complex joins may actually drop your performance an order of magnitude. As usual, YMMV depending on your database engine, schema, indexing efficiency, etc Howard Hart Ooma Jeremy Jongsma wrote: I have a table in a stock analysis database that has 284 columns. All columns are int, double, or datetime, except the primary key (varchar(12)). By my calculation this makes each row 1779 bytes. CREATE TABLE technicals ( symbol varchar(12) primary key, last double, open double, high double, ... etc ... ma_5day double, ma_20day double, ... etc ... ); I've been looking into splitting it into multiple tables, i.e.: -- Basic info CREATE TABLE technicals_basic ( symbol varchar(12) primary key, last double, open double, high double ); -- Moving averages CREATE TABLE technicals_ma ( symbol varchar(12), ma_5day double, ma_20day double, FOREIGN KEY symbol REFERENCES technicals_basic(symbol) ); Will splitting this into multiple tables provide any performance benefit? Queries will never ask for all 284 columns, so under the new system, even if split into 20 tables, there would be a maximum of 2-3 joins per query. The question is whether the row size reduction provides enough benefit to introduce table joins. I need to be able to search and sort by ANY of the 284 fields at times, so my concern is that the current large row size will affect the speed of sequential scans of the table (60,000 rows). Is that worry justified? -j -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: How to Detect MySql table update/difference
Ok, but in this way I can only detect if it's done ONE type of operation, for example if I add a row and I remove an another one with this query I detect no difference. The principal point of the query that I want is to say which rows are changed (added or deleted). I think it's not a easy query (or set of queries), but I want to create one for this goal. However thanks for the hint about the difference between COUNT(1) and COUNT(*)! Thanks. -Original Message- From: Rolando Edwards redwa...@logicworks.net Sent: Wednesday, August 05, 2009 23:12:09 Subject: RE: How to Detect MySql table update/difference I have good news and bad news for you when it comes to MySQL 5.x. Good News if you are counting against MyISAM Bad News if you are counting against InnoDB Good News - For MyISAM Just use either SELECT table_rows FROM information_schema.tables WHERE table_schema='given db name' and table_name='given table name'; Or SELECT COUNT(1) FROM db-name.tbl-name; (This will work in MySQL 4.x as well) Bad News For InnoDB SELECT COUNT(1) FROM db-name.tbl-name, even though it can run faster than SELECT COUNT(*), will still count every row in the table anyway. If you are using InnoDB, you are on your own If you are using MyISAM, have fun Rolando A. Edwards MySQL DBA (CMDBA) 155 Avenue of the Americas, Fifth Floor New York, NY 10013 212-625-5307 (Work) 201-660-3221 (Cell) AIM Skype : RolandoLogicWorx redwa...@logicworks.net -Original Message- From: BS TLC [mailto:bs...@ymail.com] Sent: Wednesday, August 05, 2009 10:30 AM To: mysql@lists.mysql.com Subject: How to Detect MySql table update/difference Hi, I'm a novel developer of MySql and now I am trying to create a mysql query to detect table updates. I query a database table every X seconds, and i want to get only the different rows in the table. The result that I want to have is simply TABLE (t = now) - TABLE (t = X second ago) Every time that i query the database I store the table situation in another table, called TABLE_TEMP, so the operation of difference detection is TABLE_DIFERENCE = TABLE - TABLE_TEMP. How can I do this query? The problem that I have is that I don't know the structure of the table and I want to create a program with can be used for all types of data and tables. Please help me. Best regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=redwa...@logicworks.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: How to Detect MySql table update/difference
You need a timestamp column that autoupdates upon insert. http://dev.mysql.com/doc/refman/5.0/en/datetime.html Then use the DATE_SUB function for x seconds. http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function _date-sub http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function _date-add Not sure what all this count stuff is about as that's not what the OP asked for. He wanted to know what NEW rows there was, not a count of them, at least that's how I read it. -Original Message- From: BS TLC [mailto:bs...@ymail.com] Sent: Wednesday, August 05, 2009 2:57 PM To: Rolando Edwards; mysql@lists.mysql.com Subject: Re: How to Detect MySql table update/difference Ok, but in this way I can only detect if it's done ONE type of operation, for example if I add a row and I remove an another one with this query I detect no difference. The principal point of the query that I want is to say which rows are changed (added or deleted). I think it's not a easy query (or set of queries), but I want to create one for this goal. However thanks for the hint about the difference between COUNT(1) and COUNT(*)! Thanks. -Original Message- From: Rolando Edwards redwa...@logicworks.net Sent: Wednesday, August 05, 2009 23:12:09 Subject: RE: How to Detect MySql table update/difference I have good news and bad news for you when it comes to MySQL 5.x. Good News if you are counting against MyISAM Bad News if you are counting against InnoDB Good News - For MyISAM Just use either SELECT table_rows FROM information_schema.tables WHERE table_schema='given db name' and table_name='given table name'; Or SELECT COUNT(1) FROM db-name.tbl-name; (This will work in MySQL 4.x as well) Bad News For InnoDB SELECT COUNT(1) FROM db-name.tbl-name, even though it can run faster than SELECT COUNT(*), will still count every row in the table anyway. If you are using InnoDB, you are on your own If you are using MyISAM, have fun Rolando A. Edwards MySQL DBA (CMDBA) 155 Avenue of the Americas, Fifth Floor New York, NY 10013 212-625-5307 (Work) 201-660-3221 (Cell) AIM Skype : RolandoLogicWorx redwa...@logicworks.net -Original Message- From: BS TLC [mailto:bs...@ymail.com] Sent: Wednesday, August 05, 2009 10:30 AM To: mysql@lists.mysql.com Subject: How to Detect MySql table update/difference Hi, I'm a novel developer of MySql and now I am trying to create a mysql query to detect table updates. I query a database table every X seconds, and i want to get only the different rows in the table. The result that I want to have is simply TABLE (t = now) - TABLE (t = X second ago) Every time that i query the database I store the table situation in another table, called TABLE_TEMP, so the operation of difference detection is TABLE_DIFERENCE = TABLE - TABLE_TEMP. How can I do this query? The problem that I have is that I don't know the structure of the table and I want to create a program with can be used for all types of data and tables. Please help me. Best regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org