Replication only DB
Hi, I've master with mysql 4.1.10 slave with mysql 4.0.18 On my two servers i have many database, can I do a replication of only 1 DB? thank Arcangelo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Replication only DB
You can simply specify the database: --replicate-do-db=db_name On Fri, 11 Mar 2005 09:24:38 +0100, Arcangelo Casavola [EMAIL PROTECTED] wrote: Hi, I've master with mysql 4.1.10 slave with mysql 4.0.18 On my two servers i have many database, can I do a replication of only 1 DB? thank Arcangelo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Deluxe Web [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql replication with one database
Hi All! I have two mysql server A,B. I'm using the replication between these servers. But i want to the replication work with just one database. Example: A server: database1, database2, database3 B server: database1, database4, database5 The A.database1 and B.database1 is same! I want replicate only this database1! Thanks is advance. Zoltan, Gyurasits DIGITAL SYSTEM - www.digsys.hu
Re: Better option then polling ?
Michael Gale wrote: Hello, I am fairly new to mysql and have a strange request I am not sure if stored procedures will solve this. I have a table in a database that is constantly being updated with new information. I would like to be notified if certain information gets committed. I think we'll try to do something regarding this asap 5.0 gets in production mode (and when we'll have time, whichever comes first ;) Our first idea is to add a stored procedure triggered on update of a particular table, then the stored procedure would call an UDF-function which would do the job. (just ping a particular port on a remote server, to force it update that table). As anyone been doing something like this ? At the moment we're just polling the whole table every 5 seconds (not a big table less than 500 records) -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Better option then polling ?
Hello, I am fairly new to mysql and have a strange request I am not sure if stored procedures will solve this. I have a table in a database that is constantly being updated with new information. I would like to be notified if certain information gets committed. Lets say for example the table gets updated every time a login attempt happens regardless if it is successful or not. So I want an app to watch the table for incorrect logins and if found to send an e-mail. Now there are several problems with this ... first... there could be hundreds of logins so we do not want the same app to spawn multiple processes each notifying the same incorrect login attempt. I was thinking about a cron that would run every X minute searching any newly added rows and keeping the last row id in a tmp file. Is there a better way ? Well, as far as I know, not with MySQL. But you might request it for 5.0 ... Database engines like InterBase, Firebird and Oracle have event mechanisms. Clients can register interest in a particular event and whenever the database fires such an even, the client will be notified in an asynchronous manner. A trigger on your table could solve this problem then. Obviously, this is a much better way compared to polling. :-) But, as I said, as far as I know, MySQL doesn't support this (yet). With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL Server Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Better option then polling ?
On 11.03.2005 08:18 (+0100), Michael Gale wrote: I have a table in a database that is constantly being updated with new information. I would like to be notified if certain information gets committed. Lets say for example the table gets updated every time a login attempt happens regardless if it is successful or not. So I want an app to watch the table for incorrect logins and if found to send an e-mail. Now there are several problems with this ... first... there could be hundreds of logins so we do not want the same app to spawn multiple processes each notifying the same incorrect login attempt. I was thinking about a cron that would run every X minute searching any newly added rows and keeping the last row id in a tmp file. When you're going to continously poll the database, I'd recommend you to enable the query cache that is in MySQL since version 4.0. It replies equal queries with their result from the cache as long as the table has not changed. So you could drastically reduce the database load for these queries. http://dev.mysql.com/doc/mysql/en/query-cache.html -- Yves Goergen LonelyPixel [EMAIL PROTECTED] Unclassified NewsBoard Forum -- newsboard.unclassified.de Free (GPL), easy to use and install, secure, innovative! (PHP+MySQL) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem with source distribution in installation
Most respectfully, I would like to get support regarding my problem. Description: I have installed Linux RedHat 9 (Shrike) now i am going to install Mysql-3.23.54a in Linux by compiling source code of respective package which has been downloaded from this site http://downloads.mysql.com/archives.php?p=mysql-3.23v=3.23.54a as well as download pdf format of MySQL manual for consulting about installation of source distribution but could not install in this platform even all requirement is duly met according to MySQL. Linux RedHat 9 (Shrike) GNU gcc 3.2.2 GNU make 2.79.1 MySQL-3.23.54a.src.tar.gz Basically, I donn't want to install this package in form of rpm format because i want to get libmysqlclient.a file by compiling source which is required for my project Porting MySQL on Embedded System. I am using uCsimm DragonballEZ with uClinux for this project. I have completed all thing which essential for a client to communicate with MySQL server. Infact, i would like to compile all source code with respect to the tool of uClinux GNU gcc because uCsimm is using M68EZ328 microprocessor. So, first of all i would like to compile all source code of the package MySQL-3.23.54a on linux RedHat 9 (Shrike) then on uClinux. Kindly tell me the solution of this problem. I am very greatful to you. Contact: vibrant wits software Inc. System Engineer [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem in a very simple SQL statement
Hi, Why do i get an error on this statement: select count(email) where email='[EMAIL PROTECTED]'; The error is: ERROR 1064: You have an error in your SQL syntax near 'where email='[EMAIL PROTECTED]'' at line 1 The statement seems pretty clear to me, but obviously something's wrong. What can it be ? Any help would be apreciated. Warm Regards, Mário Gamito -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem in a very simple SQL statement
Missed FROM clause... ;) Best regards, Mikhail. - Original Message - From: Mário Gamito [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, March 11, 2005 1:49 PM Subject: Problem in a very simple SQL statement Hi, Why do i get an error on this statement: select count(email) where email='[EMAIL PROTECTED]'; The error is: ERROR 1064: You have an error in your SQL syntax near 'where email='[EMAIL PROTECTED]'' at line 1 The statement seems pretty clear to me, but obviously something's wrong. What can it be ? Any help would be apreciated. Warm Regards, Mário Gamito -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Problem in a very simple SQL statement
[snip] select count(email) where email='[EMAIL PROTECTED]'; [/snip] select count(email) FROM TABLE where email='[EMAIL PROTECTED]'; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem in a very simple SQL statement
Arghh... shame on me forever. I'm speachless. Mikhail Entaltsev wrote: Missed FROM clause... ;) Best regards, Mikhail. - Original Message - From: Mário Gamito [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, March 11, 2005 1:49 PM Subject: Problem in a very simple SQL statement Hi, Why do i get an error on this statement: select count(email) where email='[EMAIL PROTECTED]'; The error is: ERROR 1064: You have an error in your SQL syntax near 'where email='[EMAIL PROTECTED]'' at line 1 The statement seems pretty clear to me, but obviously something's wrong. What can it be ? Any help would be apreciated. Warm Regards, Mário Gamito -- 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]
Reg creating log
Hi, What is the command to create log file while executing mysql command. I.e I want to run a file using mysql as follows Mysql -uroot db_name Inputfile I want to log the above results into a log file, to do the same what option I have to use here with mysql command. PS: Input file contains some sql statements. Please help me in this. This is very urgent. Thanks, Narasimha -Original Message- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 09, 2005 11:16 PM To: mysql@lists.mysql.com Subject: Re: Access Denied Hello. Right. No need to FLUSH PRIVILEGES after GRANT. My fault, sorry. Michael Stassen [EMAIL PROTECTED] wrote: Gleb Paharenko wrote: Hello. Execute FLUSH PRIVILEGES after granting. See: http://dev.mysql.com/doc/mysql/en/flush.html http://dev.mysql.com/doc/mysql/en/privilege-changes.html Yes, please read this one. FLUSH PRIVILEGES is NOT needed after GRANT, REVOKE, or SET PASSWORD. You only need to FLUSH if you directly edit the grant tables (INSERT, UPDATE, DELETE). Since he/she is using GRANT, FLUSH PRIVILEGES is unlikely to be relevant. http://dev.mysql.com/doc/mysql/en/access-denied.html http://dev.mysql.com/doc/mysql/en/user-resources.html Connect to the server using mysql command line client using specified in GRANT statement username and password to check that the problem not in MySQL server. What output does the following statement produce: SHOW GRANTS FOR 'metal-host'@'localhost'; Run this when it works, and then again when it doesn't. If the result is different, then something is changing the privileges assigned to [EMAIL PROTECTED], so the solution will involve finding what is doing that. If the privs are the same, then we need to look elsewhere. From the (not entirely clear) description, I expect the first case. What exact version of MySQL server do you use? [snip] Hello Gleb, no i m not doing flush..i dont even know what flush is. do u have anything in mind ? [snip] Michael Metal Host Contact wrote: I have installed in a single user called metal-host more than 10 databases all with different names and in different php scripts (phpbb phpnuke mambo etc). the problem is that they only work as I install them,after some hour later all the scripts show me that error : Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) then im trying to do : GRANT ALL PRIVILEGES ON somethign.* TO [EMAIL PROTECTED] IDENTIFIED BY password; and then each database that i re-give the GRANT all command works perfectly..but for 1 minute only,then it gives me the same : Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) So is there any limitation for the number of DBases that each user should run ? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Security Flaw
Hi, i've found a security flaw on mysql server for windows, but i'm not sure that the exploitation is possible in a real life condition. This bug allows an authenticaded user to cause the service to fail. In order to exploit this vulnerability, an user must own well-defined privileges on *.*. My question is this: is possible that an user own at least one of those privileges on *.* (for example GRANT CREATE TEMPORARY TABLES ON *.* TO 'test'@'%';): - REFERENCES - CREATE TEMPORARY TABLES - GRANT OPTION - CREATE - SELECT would be greatfull to get some help, Luca Ercoli -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql_install_db problem
I´ve problems with mysql_install_db I´m trying to install mysql (last version 4.1.10) in a x86 solaris 10 release. I prove with other version of solaris like 9 or 8 and always is the same result. The system return a core file but give me none log error. One strange thing is that was able to install with other machine. Thanks in advance ** Jose Antonio Rodrigo Sistemas Gamepro S.A 944792879 email [EMAIL PROTECTED] http:\\www.gamepro.es http:\\www.juegon.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How does one choose between MySQL and MaxDB?
Hello Darrell, all, this is a question which cannot be answered completely IMO. Also, as people's backgrounds differ, I may fail to find words which you understand the way I meant them - please take this into account. Am Do, den 10.03.2005 schrieb Darrell A. Sullivan, II um 17:17: Hello, I am planning to port some systems that are currently using proprietary database management to an SQL environment. In looking at the MySQL web site it appears that they have two different SQL database servers. I am trying to determine how to choose between the two. [[...]] Yes, these are distinct products: Both are DBMSs which speak SQL, but coming from separate code bases they have different properties / features and were (originally) targeted at different environments. Can anyone tell me what the practical day-to-day differences between the two products would be? MaxDB was targeted at the enterprise market from the start, with trained administrators, pre-planning of capacity, regular backups etc, whereas MySQL originally targeted fast application development, integration into Web servers, and embedding into applications. MySQL is now adding features which are essential for the enterprise market, whereas MaxDB is getting integrated into PHP etc. Still, both systems have their history and maybe never will be really similar. I looked at the documentation page that listed the differences between the two and it basically seemed as though MySQL was playing cath-up to MaxDB. In the sense that MaxDB already has some SQL features which MySQL is currently (or will be) adding, you are right. It is for you to check and decide how urgently you need these. Do not use older DBMS comparisons based on the status of MySQL 4.0 (or even 3.23), for any new setup you should take 4.1 (production) or even 5.0 (test, development - still alpha status). OTOH, MySQL has some properties that MaxDB does not have and IMO never will have - let me list just these: - different table handlers to choose from - the myisam table handler is extremely fast (no logging) and optimised for read-mostly situations - the multiple-version properties of InnoDB - various character sets and collation sequences, settable at DB, table, and even column level - replication (a former version of MaxDB offered distribution, and that was removed intentionally) However, considering how many people use MySQL there must be some driving reason behind that choice. I tried to give these above. The choice is for you to make. Regards, Jörg -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com Office: (+49 30) 417 01 487 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql_install_db problem
jose wrote: I´ve problems with mysql_install_db I´m trying to install mysql (last version 4.1.10) in a x86 solaris 10 release. I prove with other version of solaris like 9 or 8 and always is the same result. The system return a core file but give me none log error. One strange thing is that was able to install with other machine. I have seen this exact problem and I have seen two reasons for this. If you would like to try my packages, they are at www.blastwave.org. One problem is an initgroups call and the other is from the crypt function in libcrypt_?.so. I can give you patches for both. It may be best to try my package first to verify that you have no other problems and that this will fix things. Then if you do not want to use my packages, just post back to the list and I will send you the patches. Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Delays in replication and internet latency
Hi, We have replication running here and it has been excellent for a number of years. Recently we have been having lag in replication from London to Palo Alto (Plenty of bandwidth but a latency of 300ms round trip). The replications binlogs are being written at a rate of about 100MB to 200MB per hour and whilst we have no problems replicating to several servers that are reasonable close to the master, the Palo Alto server is getting over an hour behind at times. Does anyone know if there is something I can do to solve this? What experiences have others had in the past? Perhaps there is some way to increase the packet size or something to get over this latency problem... Or any other ideas? Cheers, Andrew SQL, Query -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
error 2002:
Hi All, I get the following error in Fedora3 when trying to run mysql from the cli, [EMAIL PROTECTED] mysql]# mysql ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I installed mysql via yum. I'm rather new to Linux and even more so to MysSQL. Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: error 2002:
Is the mysqld daemon running? (It should be.) What does the command ps aux | grep mysqld say? -Original Message- From: Mark Sargent [mailto:[EMAIL PROTECTED] Sent: Friday, March 11, 2005 8:52 AM To: mysql@lists.mysql.com Subject: error 2002: Hi All, I get the following error in Fedora3 when trying to run mysql from the cli, [EMAIL PROTECTED] mysql]# mysql ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I installed mysql via yum. I'm rather new to Linux and even more so to MysSQL. Cheers. Mark Sargent. -- 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: Multiple 1-1 tables better performance
Richard Lynch [EMAIL PROTECTED] wrote on 03/10/2005 05:13:09 PM: Apologies if this comes through twice... I *think* I fargled the To: the first time... My boss is claiming that having multiple 1-1 tables, with an index on the keys, is better performance. Example of his claim: table_1: person_id, name, phone table_2: person_id, address, city, state, zip, country is faster than: table: person_id, name, phone, address, city, state, zip, country Don't seem right to me that you'd get better performance by having the computer have to look up more crap, even if it is indexed. And surely SELECT name, phone FROM ... isn't going to be slowed down *THAT* much by the other data in the table sitting there unused... Is it? You can assume we're not dumb enough to do SELECT * FROM ... when we only need name and phone, okay? PS Since his largest table has way less than 1000 records, this question is largely academic anyway, and he should go for more maintainable and simpler schema. But I've given up on that argument. We might sell this to somebody someday with LOTS of records. Yeah, right. -- Like Music? http://l-i-e.com/artists.htm In my general experience, there are a few times when you need to split a single logical item across several physical tables (where there is a 1-1 between the tables for these records): a) You could put frequently accessed (or required) information on one table and rarely used (or optional) information on another. Smaller tables imply (but do not guarantee) faster response especially if one of the tables is a fixed-width table. b) You wanted/needed to use different ENGINES for different parts of the information. This occurs frequently in MySQL development when you want to use a fulltext index (MyISAM) on some fields while the rest of the data is stored in InnoDB. c) You want to assign separate permissions to groups of columns. You can put each group into their own table. This is related to but slightly different than column-level permissions. Fortunately, MySQL supports both design choices. Then there is the case of normalization. I can understand keeping phone numbers and addresses on separate tables than the person's name, birthdate, and other bits of unique information. People only get one set of names (not counting aliases, they would get a separate table) but they can have multiple phone numbers (home phone, work phone, fax machine, cell phone, etc.) and multiple addresses (work address, home address, vacation address, etc.). It makes great sense to split that kind of associated information into their own tables so that you can create 1-n relationships. However, if you have just 1-1 information and neither table is fixed width, and you do not have any of the other reasons (and I am sure there are more) that I outlined above, then you will be better served by keeping the information in a single table. Here is some more ammunition for your argument. The single slowest thing about using a database is using the hard disk. Each read request takes some average time (from 1ms to 100ms or more, depending on hardware) to find and retrieve any single block of information from the physical recording media. disclaimer THIS IS NOT AN OFFICIAL MYSQL EXAMPLE BUT IS MEANT TO BE REPRESENTATIVE OF HOW MANY DATABASES OPERATE Say you want to find a record whose PK value is 16. (If we assume that the OS has already cached the physical file information, then we can eliminate disk reads of the file allocation indexes in order to locate each file). seek 1 - find the first record of PK index file seek 2 - scan/search the index file for record with value 16. Get the offset of the data record in the data file from this index record. seek 3 - Use the offset found in the index to position the read heads at the beginning of the data record in the data file. seek 4 - Scan the disk to read record the entire record into memory (this is usually faster (by a factor of 10 or more) than any of the other previous steps). In essence this takes nearly no time compared to all of the other seeking we have to do just to get to this point. /disclaimer So by forcing the database to read one logical record from multiple physical tables (if it doesn't need to be arranged that way due to other reasons), your boss is forcing that cycle to repeat several times while if it were all on one table you would go through that cycle once and be done with it. HTH, Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Re: error 2002:
John Trammell wrote: Is the mysqld daemon running? (It should be.) What does the command ps aux | grep mysqld say? -Original Message- From: Mark Sargent [mailto:[EMAIL PROTECTED] Sent: Friday, March 11, 2005 8:52 AM To: mysql@lists.mysql.com Subject: error 2002: Hi All, I get the following error in Fedora3 when trying to run mysql from the cli, [EMAIL PROTECTED] mysql]# mysql ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I installed mysql via yum. I'm rather new to Linux and even more so to MysSQL. Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Hi All, output =, [EMAIL PROTECTED] mysql]# ps aux | grep mysqld root 4896 0.0 0.2 5300 660 pts/2S+ 00:02 0:00 grep mysqld Sorry, don't un it, eh. Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Replication only DB
At 02:35 AM 3/11/2005, you wrote: You can simply specify the database: --replicate-do-db=db_name Stupid/Not so Stupid question here. What mysql program has that option? I searched mysql.com and couldn't find it. I have looked at the man pages for mysql, mysqld, mysqladmin and mysqldump and didn't see it as an option to any of them. I also googled for --replicate-do-db and --replicate-to-db (incase you misspelled it). Still nothing. Can you give me/us a hint? Thanks Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Optimizing a big query...
mos wrote: At 07:01 PM 3/10/2005, Chris W. Parker wrote: Homam S.A. mailto:[EMAIL PROTECTED] on Wednesday, March 09, 2005 5:09 PM said: If your tables are mostly read-only, you could pre-generate page numbers on a periodic basis and select only specific ranges WHERE row_number BETWEEN page_start AND page_finish. How about just getting the entire list on the first page and then on all subsequent pages using LIMIT()? Chris. Chris, This is deja vu all over again.vbg I already suggested this. He needs the record count and Limit doesn't provide it. And separate Sql Count would be too slow. Mike This require the change of Mysql engine. I wish Mysql has such configuration option for that in future release. Sam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Replication only DB
Steve Buehler [EMAIL PROTECTED] wrote on 03/11/2005 10:10:57 AM: At 02:35 AM 3/11/2005, you wrote: You can simply specify the database: --replicate-do-db=db_name Stupid/Not so Stupid question here. What mysql program has that option? I searched mysql.com and couldn't find it. I have looked at the man pages for mysql, mysqld, mysqladmin and mysqldump and didn't see it as an option to any of them. I also googled for --replicate-do-db and --replicate-to-db (incase you misspelled it). Still nothing. Can you give me/us a hint? Thanks Steve It seems that you did everything EXCEPT rtfm. Here is the beginning of the chapter on replication: http://dev.mysql.com/doc/mysql/en/replication.html Here is the page in that chapter that describes not just --replicate-do-db but all of the other replication options, too: http://dev.mysql.com/doc/mysql/en/replication-options.html What performs the replication is the MySQL server. Insert the option(s) you want into the correct section (usually it's [mysqld] but can be different under some circumstances) of your my.cnf file (my.ini for windows) for your server. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Re: Replication only DB
replicate-do-db came in with 3.23.16, and it's in the manual (though the online search engine mishandles a search for 'replicate-do-db'--look under 'Replication startup options'). PB - Steve Buehler wrote: At 02:35 AM 3/11/2005, you wrote: You can simply specify the database: --replicate-do-db=db_name Stupid/Not so Stupid question here. What mysql program has that option? I searched mysql.com and couldn't find it. I have looked at the man pages for mysql, mysqld, mysqladmin and mysqldump and didn't see it as an option to any of them. I also googled for --replicate-do-db and --replicate-to-db (incase you misspelled it). Still nothing. Can you give me/us a hint? Thanks Steve -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.2 - Release Date: 3/11/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Replication only DB
Remember replicate-do-db doesn't look at queries to decide which ones to replicate. It only looks at the USE flag. This is very important: manual snip http://dev.mysql.com/doc/mysql/en/replication-options.html Tells the slave to restrict replication to statements where the default database (that is, the one selected by USE) is db_name. To specify more than one database, use this option multiple times, once for each database. Note that this does not replicate cross-database statements such as UPDATE some_db.some_table SET foo='bar' while having selected a different database or no database. If you need cross-database updates to work, make sure that you have MySQL 3.23.28 or later, and use --replicate-wild-do-table=db_name.%. /manual snip -Eric On Fri, 11 Mar 2005 09:36:53 -0600, Peter Brawley [EMAIL PROTECTED] wrote: replicate-do-db came in with 3.23.16, and it's in the manual (though the online search engine mishandles a search for 'replicate-do-db'--look under 'Replication startup options'). PB - Steve Buehler wrote: At 02:35 AM 3/11/2005, you wrote: You can simply specify the database: --replicate-do-db=db_name Stupid/Not so Stupid question here. What mysql program has that option? I searched mysql.com and couldn't find it. I have looked at the man pages for mysql, mysqld, mysqladmin and mysqldump and didn't see it as an option to any of them. I also googled for --replicate-do-db and --replicate-to-db (incase you misspelled it). Still nothing. Can you give me/us a hint? Thanks Steve -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.2 - Release Date: 3/11/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Eric Bergen [EMAIL PROTECTED] http://www.ebergen.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to determine how many ibdata files are needed?
Using MySQL 4.1.10, SuSE 8.2 Pro, reiser file system. Hi: I have been trying to locate a reference which would provide guidelines to determine if one ibdata should be used, or when to use several (two, three, etc.), but I can not seem to find anything in the manual. I have tried a single ibdata file for my 5 Gb database (which is going to grow as history gets added to it), two and even three ibdata files, the last with the autoextend argument. I have not seen a difference in performance so far. Is there any advantages to having one single ibdata file, or is it better to have several, and if so, how many? If you could point me to a url where I can read about this, I would greatly appreciate it. Thank you and regards. -- Alfredo J. Cole Grupo ACyC www.acyc.com - www.clshonduras.com - SolCom - www.acycdomains.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Optimizing a big query...
At 09:18 AM 3/11/2005, sam wun wrote: mos wrote: At 07:01 PM 3/10/2005, Chris W. Parker wrote: Homam S.A. mailto:[EMAIL PROTECTED] on Wednesday, March 09, 2005 5:09 PM said: If your tables are mostly read-only, you could pre-generate page numbers on a periodic basis and select only specific ranges WHERE row_number BETWEEN page_start AND page_finish. How about just getting the entire list on the first page and then on all subsequent pages using LIMIT()? Chris. Chris, This is deja vu all over again.vbg I already suggested this. He needs the record count and Limit doesn't provide it. And separate Sql Count would be too slow. Mike This require the change of Mysql engine. I wish Mysql has such configuration option for that in future release. Sam, That *may* be good to hear. I've used other databases that keep record counts in the index so any Select statement will return an accurate and fast record count. However it slows down the inserts/updates as it has to maintain these index counts as each record is added. So I hope this new mySQL feature can be turned off if necessary. You usually don't get a new feature like this without a speed penalty somewhere. Mike Sam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 4.1.10a has been released
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, MySQL 4.1.10a, a new version of the popular Open Source/Free Software Database Management System, has been released. It is now available in source and binary form for a number of platforms from our download pages at http://dev.mysql.com/downloads/ and mirror sites. Note that not all mirror sites may be up to date at this point in time - if you can't find this version on some mirror, please try again later or choose another download site. This MySQL 4.1.10a release just includes the additional patches for recently reported potential security vulnerabilites in the creation of temporary table file names and the handling of User Defined Functions (UDFs). We would like to thank Stefano Di Paola [EMAIL PROTECTED] for finding and reporting these to us. Please note that these changes affect the way in which User Defined Functions (UDF) are loaded. Please refer to the section User-defined Function Security Precautions in the manual: http://dev.mysql.com/doc/mysql/en/udf-security.html Functionality added or changed relative to 4.1.10: * Security improvement: The server creates `.frm', `.MYD', `.MYI', `.MRG', `.ISD', and `.ISM' table files only if a file with the same name does not already exist. * Security improvement: User-defined functions should have at least one symbol defined in addition to the `xxx' symbol that corresponds to the main `xxx()' function. These auxiliary symbols correspond to the `xxx_init()', `xxx_deinit()', `xxx_reset()', `xxx_clear()', and `xxx_add()' functions. `mysqld' by default no longer loads UDFs unless they have at least one auxiliary symbol defined in addition to the main symbol. The '--allow-suspicious-udfs' option controls whether UDFs that have only an `xxx' symbol can be loaded. By default, the option is off. `mysqld' also checks UDF filenames when it reads them from the `mysql.func' table and rejects those that contain directory pathname separator characters. (It already checked names as given in `CREATE FUNCTION' statements.) See the section in the manual on writing UDFs. Bye, LenZ - -- Lenz Grimmer [EMAIL PROTECTED] Senior Production Engineer MySQL GmbH, http://www.mysql.de/ Hamburg, Germany Are you MySQL certified? http://www.mysql.com/certification/ -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.5 (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQFCMcroSVDhKrJykfIRAkpeAJ9ZuMWzCn4+Uc4wEoliE+3Lgn5bKwCfbao6 nIhudxclakOx6Nl6PpIdlZw= =ODl8 -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 4.0.24 has been released
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, MySQL 4.0.24, a new version of the popular Open Source/Free Software Database Management System, has been released. It is now available in source and binary form for a number of platforms from our download pages at http://dev.mysql.com/downloads/ and mirror sites. Note that not all mirror sites may be up to date at this point in time - if you can't find this version on some mirror, please try again later or choose another download site. This is a bugfix release for the recent production version. It also includes fixes for recently reported potential security vulnerabilites in the creation of temporary table file names and the handling of User Defined Functions (UDFs). We would like to thank Stefano Di Paola [EMAIL PROTECTED] for finding and reporting these to us. Note that these changes affect the way in which User Defined Functions (UDF) are loaded. Please refer to the section User-defined Function Security Precautions in the manual: http://dev.mysql.com/doc/mysql/en/udf-security.html Please refer to our bug database at http://bugs.mysql.com/ for more details about the individual bugs fixed in this version. News from the ChangeLog: Functionality added or changed: * Security improvement: The server creates `.frm', `.MYD', `.MYI', `.MRG', `.ISD', and `.ISM' table files only if a file with the same name does not already exist. * Security improvement: User-defined functions should have at least one symbol defined in addition to the `xxx' symbol that corresponds to the main `xxx()' function. These auxiliary symbols correspond to the `xxx_init()', `xxx_deinit()', `xxx_reset()', `xxx_clear()', and `xxx_add()' functions. `mysqld' by default no longer loads UDFs unless they have at least one auxiliary symbol defined in addition to the main symbol. The '--allow-suspicious-udfs' option controls whether UDFs that have only an `xxx' symbol can be loaded. By default, the option is off. `mysqld' also checks UDF filenames when it reads them from the `mysql.func' table and rejects those that contain directory pathname separator characters. (It already checked names as given in `CREATE FUNCTION' statements.) See the section in the manual on writing UDFs. * `InnoDB': Added configuration option and settable global variable `innodb_autoextend_increment' for setting the size in megabytes by which `InnoDB' tablespaces are extended when they become full. The default value is 8, corresponding to the fixed increment of 8MB in previous versions of MySQL. * InnoDB: Do not acquire an internal `InnoDB' table lock in `LOCK TABLES' if `AUTOCOMMIT=1'. This helps in porting old `MyISAM' applications to `InnoDB'. `InnoDB' table locks in that case caused deadlocks very easily. Bugs fixed: * `FOUND_ROWS()' returned an incorrect value after a `SELECT SQL_CALC_FOUND_ROWS DISTINCT' statement that selected constants and included `GROUP BY' and `LIMIT' clauses. (Bug #7945) * Queries of the form `(SELECT ...) ORDER BY ...' were being treated as a `UNION'. This improperly resulted in only distinct values being returned (because `UNION' by default eliminates.) (Bug #7672) * Index cardinality was not being updated properly for `TEMPOARY' tables under some circumstances, such as `CREATE TABLE ... SELECT' followed by `ANALYZE TABLE'. (Bug #7519) * Fixed a server crash caused by `DELETE FROM TBL_NAME ... WHERE ... ORDER BY TBL_NAME.COL_NAME' when the `ORDER BY' column was qualified with the table name. (Bug #8392) * Fixed a bug in `MATCH ... AGAINST' in natural language mode that could cause a server crash if the `FULLTEXT' index was not used in a join (`EXPLAIN' did not show `fulltext' join mode) and the search query matched no rows in the table (Bug #8522). * Platform and architecture information in version information produced for `--version' option on Windows was always `Win95/Win98 (i32)'. More accurately determine platform as `Win32' or `Win64' for 32-bit or 64-bit Windows, and architecture as `ia32' for x86, `ia64' for Itanium, and `axp' for Alpha. (Bug #4445) * `InnoDB': Honor the `--tmpdir' startup option when creating temporary files. Previously, `InnoDB' temporary files were always created in the temporary directory of the operating system. On Netware, `InnoDB' will continue to ignore `--tmpdir'. (Bug #5822) * Fixed an optimization problem that allowed a negative number to be stored in a `DOUBLE UNSIGNED' column when it was assigned a value from a signed `DOUBLE' column. (Bug #7700) * Fixed a failure of multiple-table updates to replicate properly on slave servers when `--replicate-*-table' options had been specified. (Bug #7011) * Renamed `set_bit()' and `clear_bit()' functions in source
Re: Delays in replication and internet latency
Hello. You may use --slave_compressed_protocol=1. See: http://dev.mysql.com/doc/mysql/en/replication-options.html Andrew Braithwaite [EMAIL PROTECTED] wrote: Hi, We have replication running here and it has been excellent for a number of years. =20 Recently we have been having lag in replication from London to Palo Alto (Plenty of bandwidth but a latency of 300ms round trip). =20 The replications binlogs are being written at a rate of about 100MB to 200MB per hour and whilst we have no problems replicating to several servers that are reasonable close to the master, the Palo Alto server is getting over an hour behind at times. Does anyone know if there is something I can do to solve this? =20 What experiences have others had in the past? Perhaps there is some way to increase the packet size or something to get over this latency problem... Or any other ideas? Cheers, Andrew SQL, Query -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Reg creating log
Hello. You may use --tee option of mysql to store the results in the file. Or just redirect the output: mysql -uroot db_name 'input_file' 'output_file'. See: http://dev.mysql.com/doc/mysql/en/mysql-commands.html [EMAIL PROTECTED] wrote: Hi, What is the command to create log file while executing mysql command. I.e I want to run a file using mysql as follows Mysql -uroot db_name Inputfile I want to log the above results into a log file, to do the same what option I have to use here with mysql command. PS: Input file contains some sql statements. Please help me in this. This is very urgent. Thanks, Narasimha -Original Message- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 09, 2005 11:16 PM To: mysql@lists.mysql.com Subject: Re: Access Denied Hello. Right. No need to FLUSH PRIVILEGES after GRANT.=0D My fault, sorry.=0D Michael Stassen [EMAIL PROTECTED] wrote: =0D Gleb Paharenko wrote: Hello. =0D Execute FLUSH PRIVILEGES after granting. See: http://dev.mysql.com/doc/mysql/en/flush.html http://dev.mysql.com/doc/mysql/en/privilege-changes.html =0D Yes, please read this one. FLUSH PRIVILEGES is NOT needed after GRANT,=0D REVOKE, or SET PASSWORD. You only need to FLUSH if you directly edit the=0D grant tables (INSERT, UPDATE, DELETE). Since he/she is using GRANT, FLUSH=0D PRIVILEGES is unlikely to be relevant. =0D http://dev.mysql.com/doc/mysql/en/access-denied.html http://dev.mysql.com/doc/mysql/en/user-resources.html =0D Connect to the server using mysql command line client using specified in GRANT statement username and password to check that the problem not in MySQL server. What output does the=0D following statement produce: =0D SHOW GRANTS FOR 'metal-host'@'localhost'; =0D Run this when it works, and then again when it doesn't. If the result is=0D different, then something is changing the privileges assigned to=0D [EMAIL PROTECTED], so the solution will involve finding what is doing=0D that. If the privs are the same, then we need to look elsewhere. From the=0D (not entirely clear) description, I expect the first case. =0D What exact version of MySQL server do you use? =0D [snip] =0D Hello Gleb, no i m not doing flush..i dont even know what flush is. do u have anything in mind ? =0D [snip] =0D =0D Michael =0D =0D Metal Host Contact wrote: =0D I have installed in a single user called metal-host more than 10 databases all with different names and in different php scripts (phpbb phpnuke mambo etc). the problem is that they only work as I install them,after some hour later all the scripts show me that error : Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) then im trying to do : GRANT ALL PRIVILEGES ON somethign.* TO [EMAIL PROTECTED] IDENTIFIED BY password; and then each database that i re-give the GRANT all command works perfectly..but for 1 minute only,then it gives me the same : Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) So is there any limitation for the number of DBases that each user should run ? =0D --=0D For technical support contracts, goto https://order.mysql.com/?ref=3Densita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com --=0D MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Confidentiality Notice=0D The information contained in this electronic message and any attachments to= this message are intended for the exclusive use of the addressee(s) and may contain confidential or= privileged information. If you are not the intended recipient, please notify the sender at Wipro or= [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: where to get a mysql licence
Hello. [EMAIL PROTECTED] Bungarz, Kai [EMAIL PROTECTED] wrote: Hi! I wonder, where i can get answers about mysql licences. Does anybody know an adress to contact to? Best regards, Kai http://www.wido.de -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql Deamon Stop Automatically
Hello. What is in the error log? See: http://dev.mysql.com/doc/mysql/en/error-log.html Suresh [EMAIL PROTECTED] wrote: Hi Team, My Server's deamon goes down automatically, what are the basic steps to root cause. Thanks Suresh -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: configuring Mysql Query Browser with charset latin5
Hello. The general way to order a MySQL client to use some encoding is to execute SET NAMES 'encoding'. See: http://dev.mysql.com/doc/mysql/en/charset-connection.html But, as said at: http://bugs.mysql.com/bug.php?id=6982 Query Browser starts a new session for every new query, except when you start a transaction. And your previous SET NAMES doesn't have an effect. So, you may start a transaction, and then execute SET NAMES. During all transaction your character_set_xxx variables should have the same values. Nagehan Sahin [EMAIL PROTECTED] wrote: [-- text/plain, encoding 7bit, charset: us-ascii, 8 lines --] How can I configure Mysql Query Browser with charset latin5? Thanks.. - Do you Yahoo!? Yahoo! Small Business - Try our new resources site! -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql replication with one database
Hello. Use --replicate-do-db=db_name See: http://dev.mysql.com/doc/mysql/en/replication-options.html [snip] I have two mysql server A,B. I'm using the replication between these servers. But i want to the replication work with just one database. Example: A server: database1, database2, database3 B server: database1, database4, database5 The A.database1 and B.database1 is same! I want replicate only this database1! [snip]Zoltan Gyurasits [EMAIL PROTECTED] wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Selecting a 'Constant' result set?
Hello MySQL'ers, Is there a way to return a simple table of one-column, with *fixed* output? For example, I would like to return a one-column, 3-record table: - | value | - | 'a' | - | 'b' | - | 'c' | - Where I have specified 'a','b' and 'c' somewhere. Some *imaginary* SQL like: SELECT ['a','b','c'] as value It seems simple, no? -- Wellington -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Selecting a 'Constant' result set?
Fan, Wellington [EMAIL PROTECTED] wrote on 03/11/2005 01:09:13 PM: Hello MySQL'ers, Is there a way to return a simple table of one-column, with *fixed* output? For example, I would like to return a one-column, 3-record table: - | value | - | 'a' | - | 'b' | - | 'c' | - Where I have specified 'a','b' and 'c' somewhere. Some *imaginary* SQL like: SELECT ['a','b','c'] as value It seems simple, no? -- Wellington Try this: (SELECT a) UNION ALL (SELECT b) UNION ALL (SELECT c); I said UNION ALL instead of just UNION so that you would get all 3 rows even if one of the values equals one of the others. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Creating a Strong Brand
Title: KennoMedia Newsletter Dear Sir or Madam,Kenno Media provides all the necessary solutions for branding, corporate ID, web design and web development to create strong brands. Whenever you need to outsource your projects, we are ready to provide top quality at more than reasonable prices. All our artwork is based on true knowledge in branding and on the principles of web usability. Please, visit the links of some of the websites we have designed and programmed. Also, visit www.kennomedia.com to browse our portfolio. Corporate WebSites: www.KennoMedia.com, www.KennoHost.com, www.Funfair-Hire.co.uk, www.ca-acoustics.com, www.kennomedia.com/clients/kmet, www.kennomedia.com/clients/cscable, www.kennomedia.com/clients/cscable, www.kennomedia.com/clients/p2m E-commerce WebSites: www.WestGeneral.com Flash WebSites: www.festivitati.ro, www.bisericasfgheorghe.ro Here are some of the services we provide, with their prices: Logo: $150 A 5 to 10 page corporate website: $550 Corporate ID package (business card, letterhead, envelope, word template): $150 The complete, detailed list is available on request. If you are interested in our offer, please contact us. We are available anytime on email, phone, instant messengers and skype. We value open communication, as an important part of the process. Feel free to address any question to us.If you are interested to know anything else about us or to discuss any issue we are waiting for your message.We are looking forward for your answer and for starting collaboration as soon as possible. You may contact me anytime, via e-mail at [EMAIL PROTECTED] or Messenger at [EMAIL PROTECTED] - Yahoo Messenger/ [EMAIL PROTECTED] - MSN Messenger. Best regards,MonaCreative Director Kenno Media This is not spam. We have your contact information from public web site. If you wish to stop receiving further information on our offers and services simply reply to this email asking to unsubscribe. Thank you.
Lock timeout problem
Hi, we are using mysql 4.1.4-gamma and a few days ago we started to receive lock wait timeout messages from within our application also on other connections via tcp/ip ( from mysql clients ) the same thing happens While we are trying to discover what is causing these errors I've noted this in the output of SHOW ENGINE INNODB STATUS this is the text: ---TRANSACTION 0 735105891, ACTIVE 1812 sec, process no 24059, OS thread id 1741492237 225 lock struct(s), heap size 27968, undo log entries 12427 Question #1. Can I identify the query that was running in that transaction? I Think it may not be inside the binary log as we had to stop the server and start it again . Question #2. What does the 225 lock struct(s) mean Thanks Mauricio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Auto loading a table
I have a table fsearch_temp I use it as a memory table to keep things light and fast but after a restart I want to repopulate some data automatically. So I thought I just said load from TEST2 which would by a myisam table containing the hardbackup I need. But obviously not the right way of saying this. I must be reading the instructions wrong can someone clarify this for me? CREATE TABLE `fsearch_temp` ( `fsearchId` bigint( 19 ) unsigned NOT NULL AUTO_INCREMENT ,`fsearchHost` varchar( 100 ) NOT NULL default '',`fsearchSite` varchar( 255 ) NOT NULL default '',`fsearchDescription` varchar( 255 ) NOT NULL default '',`fsearchUrl1` varchar( 255 ) NOT NULL default '',`fsearchUrl2` varchar( 255 ) NOT NULL default '',`fsearchUrl3` varchar( 255 ) NOT NULL default '',`fsearchUrl4` varchar( 255 ) NOT NULL default '',`fsearchTime` int( 11 ) NOT NULL default '0',`fsearchIp` varchar( 22 ) NOT NULL default '',`fsearchKeyword` varchar( 100 ) NOT NULL default '',`fsearchBid` varchar( 11 ) NOT NULL default '0',`fsearchClicked` varchar( 6 ) NOT NULL default 'no',PRIMARY KEY ( `fsearchId` ) ,KEY `fsearchIp` ( `fsearchIp` ) ) ENGINE = MEMORY LOAD FROM TEST2 DEFAULT CHARSET = utf8 AUTO_INCREMENT =0 ThanksDonny LairsonPresident29 GunMuse LaneP.O. box 166Lakewood NM 88254http://www.gunmuse.com469 228 2183
FW: Configure issue
Dear Sirs: I attempted another mysql install on an exact same system that failed, although following the same process on server #1 succeeded. Here is the output of ./configure, which tries to start the mysql server, but shuts it down immediately: cabuov02:/opt/apps/mysql# ./configure NOTE: This is a MySQL binary distribution. It's ready to run, you don't need to configure it! To help you a bit, I am now going to create the needed MySQL databases and start the MySQL server for you. If you run into any trouble, please consult the MySQL manual, that you can find in the Docs directory. Installing all prepared tables Fill help tables To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: ./bin/mysqladmin -u root password 'new-password' ./bin/mysqladmin -u root -h cabuov02 password 'new-password' See the manual for more instructions. NOTE: If you are upgrading from a MySQL = 3.22.10 you should run the ./bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! You can start the MySQL daemon with: cd . ; ./bin/mysqld_safe You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; perl run-all-tests Please report any problems with the ./bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com Starting the mysqld server. You can test that it is up and running with the command: ./bin/mysqladmin version cabuov02:/opt/apps/mysql# Starting mysqld daemon with databases from /opt/apps/mysql/data STOPPING server from pid file /opt/apps/mysql/data/cabuov02.pid 050311 12:12:08 mysqld ended Any insight you could give me on this matter would be HIGHLY APPRECIATED, and thanks! Stay Strong, Michael OpenView Mike Stoller Walt Disney Studios IPNS West Enterprise Management Team Senior Computer Systems Engineer and Consultant
Configure issue
Dear Sirs: I attempted another mysql install on an exact same system that failed, although following the same process on server #1 succeeded. Here is the output of ./configure, which tries to start the mysql server, but shuts it down immediately: cabuov02:/opt/apps/mysql# ./configure NOTE: This is a MySQL binary distribution. It's ready to run, you don't need to configure it! To help you a bit, I am now going to create the needed MySQL databases and start the MySQL server for you. If you run into any trouble, please consult the MySQL manual, that you can find in the Docs directory. Installing all prepared tables Fill help tables To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: ./bin/mysqladmin -u root password 'new-password' ./bin/mysqladmin -u root -h cabuov02 password 'new-password' See the manual for more instructions. NOTE: If you are upgrading from a MySQL = 3.22.10 you should run the ./bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! You can start the MySQL daemon with: cd . ; ./bin/mysqld_safe You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; perl run-all-tests Please report any problems with the ./bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com Starting the mysqld server. You can test that it is up and running with the command: ./bin/mysqladmin version cabuov02:/opt/apps/mysql# Starting mysqld daemon with databases from /opt/apps/mysql/data STOPPING server from pid file /opt/apps/mysql/data/cabuov02.pid 050311 12:12:08 mysqld ended Any insight you could give me on this matter would be HIGHLY APPRECIATED, and thanks! Stay Strong, Michael OpenView Mike Stoller Walt Disney Studios IPNS West Enterprise Management Team Senior Computer Systems Engineer and Consultant
Re: Better option then polling ?
There's nothing wrong with polling as long as it's moderate and it doesn't lock resources. On a heavily updated table in a large volumen site, it scales much better than nasty triggers or events firing all over the place. Triggers are intended to maintain internal database consistency by enforcing business rules at the DB tier. They're not meant for event notification of external applications, especially if you're holding the transaction hostage until the remote call is completed. As someone mentioned here, asynchronous events (fire'n'forget) in some DBMS systems are much better suited to this because they don't don't prolong transactions, and subsequently locks on resources. I think the best choice in your scenario is to use adaptive polling: Track the average of DELTA (new records added between polls) over time, and adjust the polling internval accordingly. For example, if the current average DELTA is 100, and the new DELTA was 120, then you decrease the polling interval proportionally but not less than MIN value, and if it was 80, then you increase the polling interval proportionally but not greater than MAX value. This way you can adapt well to surges in events and prevent queue buildups. Homam --- Michael Gale [EMAIL PROTECTED] wrote: Hello, I am fairly new to mysql and have a strange request I am not sure if stored procedures will solve this. I have a table in a database that is constantly being updated with new information. I would like to be notified if certain information gets committed. Lets say for example the table gets updated every time a login attempt happens regardless if it is successful or not. So I want an app to watch the table for incorrect logins and if found to send an e-mail. Now there are several problems with this ... first... there could be hundreds of logins so we do not want the same app to spawn multiple processes each notifying the same incorrect login attempt. I was thinking about a cron that would run every X minute searching any newly added rows and keeping the last row id in a tmp file. Is there a better way ? Thanks. Michael. -- 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: Lock timeout problem
Mauricio, - Original Message - From: Mauricio Pellegrini [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Friday, March 11, 2005 9:13 PM Subject: Lock timeout problem Hi, we are using mysql 4.1.4-gamma and a few days ago we started to receive lock wait timeout messages from within our application also on other connections via tcp/ip ( from mysql clients ) the same thing happens While we are trying to discover what is causing these errors I've noted this in the output of SHOW ENGINE INNODB STATUS this is the text: ---TRANSACTION 0 735105891, ACTIVE 1812 sec, process no 24059, OS thread id 1741492237 225 lock struct(s), heap size 27968, undo log entries 12427 use SHOW PROCESSLIST to determine if you have a dangling session. You should commit your transaction. It looks like someone forgot to commit a big transaction. Question #1. Can I identify the query that was running in that transaction? I Think it may not be inside the binary log as we had to stop the server and start it again . Question #2. What does the 225 lock struct(s) mean It means appromately that the transaction has locks on 225 pages or 225 tables. Thanks Mauricio Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Better option then polling ?
There's nothing wrong with polling as long as it's moderate and it doesn't lock resources. On a heavily updated table in a large volumen site, it scales much better than nasty triggers or events firing all over the place. Triggers are intended to maintain internal database consistency by enforcing business rules at the DB tier. They're not meant for event notification of external applications, especially if you're holding the transaction hostage until the remote call is completed. Enforcing business rules? If you can put your rules into constraints, do it and drop the triggers. Triggers can be used for anything you like. Firing events can be one of them. As someone mentioned here, asynchronous events (fire'n'forget) in some DBMS systems are much better suited to this because they don't don't prolong transactions, and subsequently locks on resources. I think the best choice in your scenario is to use adaptive polling: Track the average of DELTA (new records added between polls) over time, and adjust the polling internval accordingly. For example, if the current average DELTA is 100, and the new DELTA was 120, then you decrease the polling interval proportionally but not less than MIN value, and if it was 80, then you increase the polling interval proportionally but not greater than MAX value. This sounds like usuable advice. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL Server Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql error nr.0
Using MySQL version 4.0, I am trying to backup my database using MySQL Administrator. When executing the backup I get error mysql error nr.0 which doesn't tell me much. I did a Google search on the error and it didn't tell me much. Can anyone shed light on this error message? Thanks. Darin Vanatta [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fwd: ./configure issue
Dear Sirs: I attempted another mysql install on an exact same system that failed, although following the same process on server #1 succeeded. Here is the output of ./configure, which tries to start the mysql server, but shuts it down immediately: cabuov02:/opt/apps/mysql# ./configure NOTE: This is a MySQL binary distribution. It's ready to run, you don't need to configure it! To help you a bit, I am now going to create the needed MySQL databases and start the MySQL server for you. If you run into any trouble, please consult the MySQL manual, that you can find in the Docs directory. Installing all prepared tables Fill help tables To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: ./bin/mysqladmin -u root password 'new-password' ./bin/mysqladmin -u root -h cabuov02 password 'new-password' See the manual for more instructions. NOTE: If you are upgrading from a MySQL = 3.22.10 you should run the ./bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! You can start the MySQL daemon with: cd . ; ./bin/mysqld_safe You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; perl run-all-tests Please report any problems with the ./bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com Starting the mysqld server. You can test that it is up and running with the command: ./bin/mysqladmin version cabuov02:/opt/apps/mysql# Starting mysqld daemon with databases from /opt/apps/mysql/data STOPPING server from pid file /opt/apps/mysql/data/cabuov02.pid 050311 12:12:08 mysqld ended Any insight you could give me on this matter would be HIGHLY APPRECIATED, and thanks! Stay Strong, Michael OpenView Mike Stoller Walt Disney Studios IPNS West Enterprise Management Team Senior Computer Systems Engineer and Consultant Stay Strong, Michael OpenView Mike Stoller CEO/Senior Consultant and Engineer EHI-INSM Inc. [EMAIL PROTECTED] http://www.ehiinsm.com Disclaimer: My opinion, remarks, advice, etc. are not indicative of any of my company's policies or procedures. The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from your computer.
./configure issue
Dear Sirs: I attempted another mysql install on an exact same system that failed, although following the same process on server #1 succeeded. Here is the output of ./configure, which tries to start the mysql server, but shuts it down immediately: cabuov02:/opt/apps/mysql# ./configure NOTE: This is a MySQL binary distribution. It's ready to run, you don't need to configure it! To help you a bit, I am now going to create the needed MySQL databases and start the MySQL server for you. If you run into any trouble, please consult the MySQL manual, that you can find in the Docs directory. Installing all prepared tables Fill help tables To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: ./bin/mysqladmin -u root password 'new-password' ./bin/mysqladmin -u root -h cabuov02 password 'new-password' See the manual for more instructions. NOTE: If you are upgrading from a MySQL = 3.22.10 you should run the ./bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! You can start the MySQL daemon with: cd . ; ./bin/mysqld_safe You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; perl run-all-tests Please report any problems with the ./bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com Starting the mysqld server. You can test that it is up and running with the command: ./bin/mysqladmin version cabuov02:/opt/apps/mysql# Starting mysqld daemon with databases from /opt/apps/mysql/data STOPPING server from pid file /opt/apps/mysql/data/cabuov02.pid 050311 12:12:08 mysqld ended Any insight you could give me on this matter would be HIGHLY APPRECIATED, and thanks! Stay Strong, Michael OpenView Mike Stoller Walt Disney Studios IPNS West Enterprise Management Team Senior Computer Systems Engineer and Consultant Stay Strong, Michael OpenView Mike Stoller CEO/Senior Consultant and Engineer EHI-INSM Inc. [EMAIL PROTECTED] http://www.ehiinsm.com Disclaimer: My opinion, remarks, advice, etc. are not indicative of any of my company's policies or procedures. The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from your computer.
./mysql_install_db: line 86: my_print_defaults: command not found
Hi All, after experiencing trouble with the rpm install on Fedora3, I went with the tar install. All went well, until I got to this part of the install manual, After you complete the procedure and have the server running, you should assign passwords to the accounts created by *mysql_install_db*. Instructions for doing so are given in Section 2.9.3, Securing the Initial MySQL Accounts http://dev.mysql.com/doc/mysql/en/default-privileges.html. In the examples shown here, the server runs under the user ID of the |mysql| login account. This assumes that such an account exists. Either create the account if it does not exist, or substitute the name of a different existing login account that you plan to use for running the server. 1. Change location into the top-level directory of your MySQL installation, represented here by /|BASEDIR|/: shell cd /|BASEDIR|/ /|BASEDIR|/ is likely to be something like |/usr/local/mysql| or |/usr/local|. The following steps assume that you are located in this directory. 2. If necessary, run the *mysql_install_db* program to set up the initial MySQL grant tables containing the privileges that determine how users are allowed to connect to the server. You'll need to do this if you used a distribution type that doesn't run the program for you. Typically, *mysql_install_db* needs to be run only the first time you install MySQL, so you can skip this step if you are upgrading an existing installation, However, *mysql_install_db* does not overwrite any existing privilege tables, so it should be safe to run in any circumstances. To initialize the grant tables, use one of the following commands, depending on whether *mysql_install_db* is located in the |bin| or |scripts| directory: shell bin/mysql_install_db --user=mysql shell scripts/mysql_install_db --user=mysql Below is what I did, [EMAIL PROTECTED] scripts]# mysql_install_db --user=mysql -bash: mysql_install_db: command not found [EMAIL PROTECTED] scripts]# ./mysql_install_db --user=mysql ./mysql_install_db: line 86: my_print_defaults: command not found Could not find help file 'fill_help_tables.sql' in ./support-files or inside .. I guess I'm missing something quite fundamental, yes..? Just can't think what. Anyone see the obvious.? Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
insert - select from two different applications race condition?
I have a simple problem... I'm using mysql 4.1.9/innodb table and two small python applications A and B first application A is executed, and do a simple INSERT into a table then application B is executed: - B does a SELECT in the same table, that should return the entry created by application A (and based on the result, an UPDATE (to the entry application A has created) or an INSERT if it can't find it... but in this scenario it should find it since B is always executed just after A is) I can be sure that application A is executed before application B is started, even though B can be started just after A is done. The problem is that every once in a while, the SELECT doesn't return anything... even though I can check that application A created the entry... Everything looks as if the INSERT from application A hasn't completed when the SELECT in the application B is performed... Even though application A terminated before application B started! Any clue about what's going on? How can I prevent that? thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem: Too many connections
Hi, I have a live site using mysql. It is heavily used with over thousand users per minute, with 3 select / update queries per user per minute accounting to over 3000 queries per minute. The problem is that many times connection to this mysql server fails with the error Too many connection also sometimes the server becomes down bcoz of overload. The server has around 4GB of RAM with mysql version of 4.0.23 So my question is , is the problem related with just tuning of configuration parameters or can the problem be solved by any means too. Any kind of help is deeply appreciated. Thanks in advance, Sapna