Re: integer
The maximum width is int(20). On Thu, May 22, 2008 at 5:15 PM, Saravanan [EMAIL PROTECTED] wrote: what kind of datatype it is int(50) parent_id| int(50) is that big int? Saravanan --- On Thu, 5/22/08, Norbert Tretkowski [EMAIL PROTECTED] wrote: From: Norbert Tretkowski [EMAIL PROTECTED] Subject: Re: integer To: mysql@lists.mysql.com Date: Thursday, May 22, 2008, 3:34 PM Am 22.05.2008, 14:04 +0530 schrieb Krishna Chandra Prajapati: I would to know the difference between the two int(10) and int (Used in create table ) MySQL has an excellent documentation, which of course also answers your question: http://dev.mysql.com/doc/refman/5.1/en/numeric-types.html Norbert -- 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] -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
Re: NOT [solved] Re: Error reading packet from server: Out of memory (Needed 6560 bytes) ( server_errno=5)
You can manually restart the slave process. On Wed, May 21, 2008 at 9:11 PM, Dominik Klein [EMAIL PROTECTED] wrote: Hello mysql list I posted this problem to the list earlier this month: Error reading packet from server: Out of memory (Needed 6560 bytes) ( server_errno=5) I was then told to upgrade to the newest version, which I did and which seemed to solve the problem. Today, I got this in my log: 080521 14:18:22 [ERROR] Error reading packet from server: Out of memory (Needed 2848 bytes) ( server_errno=5) 080521 14:18:22 [ERROR] Stopping slave I/O thread due to out-of-memory error from master Now, not only does it report an error, it also stops the slave process instead of auto re-starting it as it did in version 5.0.45 (which I used before). So all slave machines do not replicate until I manually start the slave again. What can I do about this problem? Regards Dominik -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
Re: Restarting slave after interruption
This is a classic error. You just reconfigurate the parameter master_log_file and master_log_pos .Good luck. On Fri, May 23, 2008 at 5:13 AM, Mike [EMAIL PROTECTED] wrote: On Thu, May 22, 2008 at 10:41 AM, François Beausoleil [EMAIL PROTECTED] wrote: Hi all! I must be stupid or something. I can't find what my problem is. I searched this list, and did find a couple of hits, but nothing that seemed fully relevant. This one in particular was interesting: http://lists.mysql.com/mysql/212863 I have a single master (server-id=1) and a single slave (server-id=2). Replication was correctly setup, and I was doing backups from the slave. To test recovery, I terminated the slave server (I'm on EC2), and I now wish to start a new one. If your taking a dump of the master open two windows. Don't close either In the first lock all tables with FLUSH ALL TABLES WITH READ LOCK; master status; Then in the second window procedure with mysqldump. First, I dump my master using this: mysqldump --master-data --flush-logs --extended-insert --single-transaction -u root -papassword mydb thedump.sql Then, I copy the dump to the slave and load the dump using: mysql -u root -papassword mydb thedump.sql Next, I login to the slave server using the mysql command line client and issue the following commands: CHANGE MASTER TO MASTER_HOST='10.252.155.80', MASTER_USER='root', MASTER_PASSWORD='apassword', MASTER_LOG_FILE='mysql-bin.54', MASTER_LOG_POS=98; I read the log file and position from the dump (--master-data), specifically, this line: CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.54', MASTER_LOG_POS=98; Then, I issue a START SLAVE on the slave, and SHOW SLAVE STATUS\G Here's the output: *** 1. row *** Slave_IO_State: Waiting for master to send event Master_Host: 10.252.155.80 Master_User: root Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.54 Read_Master_Log_Pos: 39727978 Relay_Log_File: mysqld-relay-bin.02 Relay_Log_Pos: 1381 Relay_Master_Log_File: mysql-bin.54 Slave_IO_Running: Yes Slave_SQL_Running: No Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 1062 Last_Error: Error 'Duplicate entry '479084' for key This is a Duplicate primary key. Usually means the position error. 1' on query. Default database: 'mydb'. Query: 'INSERT INTO assets (`content_type`, `email_id`, `size`, `thumbnail`, `updated_at`, `account_id`, `archive_id`, `title`, `type`, `folder_id`, `description`, `filename`, `height`, `owner_id`, `parent_id`, `created_at`, `width`) VALUES('image/jpeg', NULL, 6571, 'small', '2008-05-21 23:24:10', 125, NULL, NULL, NULL, NULL, NULL, '0101100102000104022008052003d78e21fe087d9623000b5c-21_small.jpg', 180, NULL, 479082, '2008-05-21 23:24:10', 240)' Skip_Counter: 0 Exec_Master_Log_Pos: 1244 Relay_Log_Space: 39728115 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: NULL Anybody can tell me what I'm doing wrong ? Am I dumping my master DB using the right combination of options ? Thanks ! François Beausoleil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
Re: mysqldump character set
If you create all your databases and tables with utf8,then every thing is fine. On Mon, Apr 28, 2008 at 1:43 AM, Velen [EMAIL PROTECTED] wrote: Hi, I'm storing some ascii codes in a table. When I do a dump using mysqldump from the server and then restoring it on another station, the ascii codes in the table has changed. But if i'm accessing the table from another station the code is good. Even if I insert it from a station, it goes fine in the server. Anyone knows why it changes when using mysqldump? How can I prevent this problem to happen in the future? Regards, Velen -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
RE: Spatial operators - DISTANCE
I would start by understanding MySQL spatial located at http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html FWIWMartin__Disclaimer and confidentiality noteEverything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission. From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Date: Thu, 22 May 2008 09:49:21 -0400 Subject: Spatial operators - DISTANCE Hi, I am developing a geo-spatial application that requires the DISTANCE function. We have been using 5.1.23-GIS beta, but have noted that it appears not to be in the 5.1.24 beta or the 6.0 alpha release. I also can find no documentation as to when this will be merged into the main release or go into production. Any hints or clues would be much appreciated. -- Best regards, jona. Just don't create a file called -rf. :-) --- Larry Wall -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ Keep your kids safer online with Windows Live Family Safety. http://www.windowslive.com/family_safety/overview.html?ocid=TXT_TAGLM_WL_Refresh_family_safety_052008
Re: Query Output Issue
- Original Message - From: Rob Wultsch [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: MYSQL General List mysql@lists.mysql.com Sent: Friday, May 23, 2008 1:42:07 PM GMT -08:00 US/Canada Pacific Subject: Re: Query Output Issue On Fri, May 23, 2008 at 1:35 PM, Rob Wultsch [EMAIL PROTECTED] wrote: SELECT p1.POPS AS `POPA`, p2.POPS AS `POPZ` FROM circuits INNER JOIN pops.POPS as p1 WHERE circuits.popID_A =p1.popID INNER JOIN pops.POPS as p2 WHERE circuits.pop_ID_Z =p2.popID Wow... I can't believe I wrote that originally. Definitely time for a 3 day break ;) -- Rob Wultsch [EMAIL PROTECTED] wultsch (aim) - Original Message --- Still fails with the same error on line 7 This time included the actual table information. SELECT p1.POPS AS `POPA`, p2.POPS AS `POPZ` FROM circuits INNER JOIN pops.POPS as p1 WHERE circuits.popID_A =p1.popID INNER JOIN pops.POPS as p2 WHERE circuits.pop_ID_Z =p2.popID -- Table xcircuits DDL CREATE TABLE `circuits` ( `customerID` int(11) default NULL, `end_customer` varchar(255) default NULL, `vlanID` int(11) default NULL, `port_A` varchar(255) default NULL, `OA_IP_A` varchar(255) default NULL, `popID_A` int(11) default NULL, `CID` varchar(255) default NULL, `pop_ID_Z` int(11) default NULL, `OA_IP_Z` varchar(255) default NULL, `port_Z` varchar(255) default NULL, `service_desc` varchar(255) default NULL, `customer_location` varchar(255) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; CREATE TABLE `pops` ( `popID` int(11) NOT NULL, `POPS` varchar(75) NOT NULL, `Network_Address` varchar(25) NOT NULL, PRIMARY KEY (`popID`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Timestamp and the On Update Current_Timestamp clause
Here is my test. Any way can retrieve the metadata. On Fri, May 9, 2008 at 10:45 PM, Martijn Tonies [EMAIL PROTECTED] wrote: SHOW CREATE TABLE ... Yes, I thought so :-( From a coding point of view, this requires parsing... Why isn't there anything in show full columns. Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle MS SQL Server Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
Re: error while creating a copy of a table
Didn't you google it ? On Thu, May 8, 2008 at 1:59 PM, Ananda Kumar [EMAIL PROTECTED] wrote: Hi All, I am getting below error. This is the only table of INNODB ENGINE, the default storage engine is MyISAM mysql create table tmp_dc as select gid,siteid,has_gy,starts from dc_tc; ERROR 1206 (HY000): The total number of locks exceeds the lock table size how do i fix this error. -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
Re: error while starting replication for the first time
I think you should check the error with perror at first. On Sat, May 24, 2008 at 12:46 AM, Mike [EMAIL PROTECTED] wrote: On Fri, May 23, 2008 at 12:08 PM, Ananda Kumar [EMAIL PROTECTED] wrote: Hi Mike, Since i have done a fresh backup from master (with master db down), and copied over the same to slave. Then why is the slaving looking for old relay-log. I also did the RESET SLAVE, bit still getting error. I am wondering, why is the slave looking for old relay-logs Your my.cnf might have relaylog info in it. You might have a master.info or relay log files in your mysql directory. The slave does need relay logs to replicate. So if you keep use RESET MASTER after you backup the mysql then you backup is worthless. Tell me the steps you are using? On 5/23/08, Mike [EMAIL PROTECTED] wrote: Ok, since you do not have the bin log you need to start over again with the replication and do either a mysqldump or get the rawdata. then once you have the data then you can start replication again. http://dev.mysql.com/doc/refman/5.0/en/replication-solutions-backups-mysqldump.html http://dev.mysql.com/doc/refman/5.0/en/replication-solutions-backups-rawdata.html On Fri, May 23, 2008 at 10:37 AM, Ananda Kumar [EMAIL PROTECTED] wrote: RESET MASTER...delete all the bin logs. Infact i tried this on the slave as it also a MASTER to itself, but the error kept on coming. regards anandkl On 5/23/08, Mike [EMAIL PROTECTED] wrote: On Fri, May 23, 2008 at 8:13 AM, Ananda Kumar [EMAIL PROTECTED] wrote: Files is owned by mysql, but the point is, these relay-log files are not present. Before setting up the slave, i cleaned up all files. If you want the logs back you could use RESET MASTER maybe. http://dev.mysql.com/doc/refman/5.0/en/reset-master.html Let me know. :-) regards anandkl On 5/23/08, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote: Please check the ownership of the files copied on the slave. Give permissions by chown -R mysql:mysql On Fri, May 23, 2008 at 2:47 PM, Ananda Kumar [EMAIL PROTECTED] wrote: Hi Krishna, As i said, this is a complete copy from master db to slave. I have deleted all old files from slave and setting up from scratch, by taking a complete backup from master, copying over to slave and using the change master command with BIN LOG and POSITION taken before taking a backup copy from master. On 5/23/08, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote: check permissions On Fri, May 23, 2008 at 12:33 PM, Ananda Kumar [EMAIL PROTECTED] wrote: Hi All, I shutdown my master, took a db files backup. Copied it over to slave machine. I executed change master command, then when i start slave slave start, i get the below error. I did reset slave, but still getting same error, what could be the reason, and how to fix it. 080522 23:04:05 [ERROR] Failed to open log (file '/data/mysql-log/relay-log/relay.000791', errno 2) 080522 23:04:05 [ERROR] Failed to open the relay log 'FIRST' (relay_log_pos 4) I am using mysql 5.0.41 community version, on debain. regards anandkl -- 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] -- 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] -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
Stored procedure permission error
Hi all, I'm receiving an error when trying to invoke a procedure from a [EMAIL PROTECTED] which is not the definer. I created the procedure with the statement 'SQL SECURITY INVOKER' but is still not working. Does anyone know why? The MySQL version is 5.0.36. Both users [EMAIL PROTECTED] and [EMAIL PROTECTED] have all privs on the database and also execute privs on the procedure. Thanks in advance. Regards, -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: NOT [solved] Re: Error reading packet from server: Out of memory (Needed 6560 bytes) ( server_errno=5)
Moon's Father schrieb: You can manually restart the slave process. Sure I can. But that's not sufficient. For now, I scripted some log watch thing that re-starts the slave in the particular situation. But this is not good. On Wed, May 21, 2008 at 9:11 PM, Dominik Klein [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hello mysql list I posted this problem to the list earlier this month: Error reading packet from server: Out of memory (Needed 6560 bytes) ( server_errno=5) I was then told to upgrade to the newest version, which I did and which seemed to solve the problem. Today, I got this in my log: 080521 14:18:22 [ERROR] Error reading packet from server: Out of memory (Needed 2848 bytes) ( server_errno=5) 080521 14:18:22 [ERROR] Stopping slave I/O thread due to out-of-memory error from master Now, not only does it report an error, it also stops the slave process instead of auto re-starting it as it did in version 5.0.45 (which I used before). So all slave machines do not replicate until I manually start the slave again. What can I do about this problem? Regards Dominik -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Query Output Issue
On Fri, May 23, 2008 at 3:06 PM, [EMAIL PROTECTED] wrote: - Original Message - From: Rob Wultsch [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: MYSQL General List mysql@lists.mysql.com Sent: Friday, May 23, 2008 11:10:56 AM GMT -08:00 US/Canada Pacific Subject: Re: Query Output Issue On Fri, May 23, 2008 at 1:47 PM, [EMAIL PROTECTED] wrote: Still getting and error on the last line SELECT p1.POPS AS `POPA`, p2.POPS AS `POPZ` FROM circuits INNER JOIN pops.POPS as p1 WHERE circuits.popID_A =p1.popID INNER JOIN pops.POPS as p2 WHERE circuits.pop_ID_Z =p2.popID I guess I am mindreader cause you did not post your error message. I really should hire myself at higher fees with this new found ability. Please stop: Top posting. Most lists either top post or bottom post, and some mix. This list mixes a small amount, but generally bottom post. When in doubt I follow the convention of the first response. Posting the relationship. Posting your table create syntax on the other hand would be useful. -- Rob Wultsch [EMAIL PROTECTED] - Original Message - SQL query: Documentation SELECT l1.POPS AS `POPA` , l2.POPS AS `POPZ` FROM circuits INNER JOIN pops.POPS AS p1 WHERE circuits.popID_A = l1.popID INNER JOIN pops.POPS AS p2 WHERE circuits.pop_ID_Z = l2.popID LIMIT 0 , 30 MySQL said: Documentation #1064 - 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 'INNER JOIN pops.POPS as p2 WHERE circuits.pop_ID_Z =l2.popID LIMIT 0, 30' at line 7 Your using WHERE instead of ON. Not sure why I did not see that earlier... SELECT l1.POPS AS `POPA` , l2.POPS AS `POPZ` FROM circuits INNER JOIN pops.POPS AS p1 ON circuits.popID_A = l1.popID INNER JOIN pops.POPS AS p2 ON circuits.pop_ID_Z = l2.popID LIMIT 0 , 30 http://dev.mysql.com/doc/refman/5.0/en/join.html -- Rob Wultsch [EMAIL PROTECTED] wultsch (aim) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Query Output Issue
On Fri, May 23, 2008 at 1:35 PM, Rob Wultsch [EMAIL PROTECTED] wrote: SELECT p1.POPS AS `POPA`, p2.POPS AS `POPZ` FROM circuits INNER JOIN pops.POPS as p1 WHERE circuits.popID_A =p1.popID INNER JOIN pops.POPS as p2 WHERE circuits.pop_ID_Z =p2.popID Wow... I can't believe I wrote that originally. Definitely time for a 3 day break ;) -- Rob Wultsch [EMAIL PROTECTED] wultsch (aim) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Restarting slave after interruption
Thanks Mike! Le 2008-05-22 à 17:13, Mike a écrit : If your taking a dump of the master open two windows. Don't close either In the first lock all tables with FLUSH ALL TABLES WITH READ LOCK; master status; Then in the second window procedure with mysqldump. The exact syntax was FLUSH TABLES WITH READ LOCK; SHOW MASTER STATUS; Bye ! François -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: integer
I think you'll find that's BIGINT, max INT is 11 Moon's Father wrote: The maximum width is int(20). On Thu, May 22, 2008 at 5:15 PM, Saravanan [EMAIL PROTECTED] wrote: what kind of datatype it is int(50) parent_id| int(50) is that big int? Saravanan --- On Thu, 5/22/08, Norbert Tretkowski [EMAIL PROTECTED] wrote: From: Norbert Tretkowski [EMAIL PROTECTED] Subject: Re: integer To: mysql@lists.mysql.com Date: Thursday, May 22, 2008, 3:34 PM Am 22.05.2008, 14:04 +0530 schrieb Krishna Chandra Prajapati: I would to know the difference between the two int(10) and int (Used in create table ) MySQL has an excellent documentation, which of course also answers your question: http://dev.mysql.com/doc/refman/5.1/en/numeric-types.html Norbert -- 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]