add index to slave but not master
Hello, I have a question that, if I add the index to the table in slave, but don't do it in master, will it make problems? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
DBA MySQL Job Spain
Hello people, We are looking for a MySQL DBA, based in Malaga (Spain). If you have 5+ years experience administering MySQL and you are interested in join an international company, please send your CV in english to: monica.gar...@hays.es mailto:monica.gar...@hays.es . Salary from 40k and different employee benefits. English fluent is required and Spanish is a plus. This job is in-situ, not remote, you will working at the company in Málaga. * Disclaimer This message (including any attachments) is confidential and may be legally privileged. If you are not the intended recipient, you should not disclose, copy or use any part of it. If you have received this email in error, please delete the email and any attachments immediately and notify the Hays plc group of companies (“Hays”) helpdesk at hsrsupp...@hays.com. Any information, statements or opinions contained in this message (including any attachments) are given by the author. They are not given on behalf of Hays unless subsequently confirmed by an individual other than the author who is duly authorised to represent Hays. Whilst all reasonable care has been taken to avoid the transmission of viruses, it is your responsibility as recipient to ensure that the opening or other use of this message and any attachments will not adversely affect your systems. Hays accepts no responsibility for damage caused by viruses and you should, therefore, carry out such virus and other checks as you consider appropriate. Hays plc is registered in England and Wales with company number 2150950. Hays plc’s registered office is at 250 Euston Road, London NW1 2AF. Opt Out (where applicable) Should you wish to opt out of receiving further information about our services, please email customerserv...@hays.com to unsubscribe or alternatively write to our Customer Helpline Team at the following address: Hays Specialist Recruitment Limited, 1st Floor Atlas House 173 Victoria Street London SW1E 5NA. To update your contact details or relevant information, please contact the sender. * -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: add index to slave but not master
Functionally not a problem. Many people use a slave for different work loads then their master. Different indexes for different queries make sense. Be aware that should you intend to make backups off the slave or even leave yourself open to promoting slave to master as a HA strategy then things will differ from the original master and you might notice a performance difference as a result. Hth Andrew On Oct 31, 2011 7:47 AM, Jeff Pang jeffrp...@gmail.com wrote: Hello, I have a question that, if I add the index to the table in slave, but don't do it in master, will it make problems? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=eroomy...@gmail.com
Re: DBA MySQL Job Spain
在 2011-10-31一的 09:40 +,Garcia, Monica写道: Hello people, We are looking for a MySQL DBA, based in Malaga (Spain). If you have 5+ years experience administering MySQL and you are interested in join an international company, please send your CV in english to: monica.gar...@hays.es. Salary from 40k and different employee benefits. English fluent is required and Spanish is a plus. This job is in-situ, not remote, you will working at the company in Málaga. * Disclaimer This message (including any attachments) is confidential and may be legally privileged. If you are not the intended recipient, you should not disclose, copy or use any part of it. If you have received this email in error, please delete the email and any attachments immediately and notify the Hays plc group of companies (“Hays”) helpdesk at hsrsupp...@hays.com. Any information, statements or opinions contained in this message (including any attachments) are given by the author. They are not given on behalf of Hays unless subsequently confirmed by an individual other than the author who is duly authorised to represent Hays. Whilst all reasonable care has been taken to avoid the transmission of viruses, it is your responsibility as recipient to ensure that the opening or other use of this message and any attachments will not adversely affect your systems. Hays accepts no responsibility for damage caused by viruses and you should, therefore, carry out such virus and other checks as you consider appropriate. Hays plc is registered in England and Wales with company number 2150950. Hays plc’s registered office is at 250 Euston Road, London NW1 2AF. Opt Out (where applicable) Should you wish to opt out of receiving further information about our services, please email customerserv...@hays.com to unsubscribe or alternatively write to our Customer Helpline Team at the following address: Hays Specialist Recruitment Limited, 1st Floor Atlas House 173 Victoria Street London SW1E 5NA. To update your contact details or relevant information, please contact the sender. * you send it again? -- Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) Using Gmail? Please read this important notice: http://www.fsf.org/campaigns/jstrap/gmail?10073. signature.asc Description: This is a digitally signed message part
problem with table
Hello, I am using MYSQL database with Linux server. I have a problem with one table, when I tried to get the data from that table, I am getting error : “mysql error 4600: mysql server gone away. No connection, trying to re-connect” …. This error message getting and cursor getting stuck in next line…..mysql prompt does not appear. When “*check table tablename; “ * same problem getting….. And also When I tried to describe the table : “*desc tablename*;” its working properly on the same table…. Plz ……….. any one can help….
Re: problem with table
在 2011-10-31一的 16:18 +0530,nataraj 0102写道: Hello, I am using MYSQL database with Linux server. I have a problem with one table, when I tried to get the data from that table, I am getting error : “mysql error 4600: mysql server gone away. No connection, trying to re-connect” …. This error message getting and cursor getting stuck in next line…..mysql prompt does not appear. When “*check table tablename; “ * same problem getting….. And also When I tried to describe the table : “*desc tablename*;” its working properly on the same table…. Plz ……….. any one can help…. see here,http://dev.mysql.com/doc/refman/5.1/en/gone-away.html may it -- Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) Using Gmail? Please read this important notice: http://www.fsf.org/campaigns/jstrap/gmail?10073. signature.asc Description: This is a digitally signed message part
Re: importing mysql structures only or restore ignoring non-existing tables and columns?
On 29 Oct 2011, at 22:59, luci spam wrote: I have 2 servers (1 for development, 1 for service) I keep ADD/DELETE columns and CREATE/DELETE Indexes on my development server, so these 2 server have similar but different mysql data structures. I know there's an option to expert structures only. (like –no-data) Is there a way (except 3rd party software like mysqldiff.org) to import structure only to an existing data? Alternativley, is there a way to import only data ignoring non-existing tables and colums? (I thought this may do the trick if I back-up data - import structure - restore the data.) You can use SELECT...INTO DUMPFILE and LOAD DATA INFILE... to achieve what I believe you're asking here, save the eventual misunderstanding. ;-) Cheers -- Luis Motta Campos is a DBA, Foodie, and Photographer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: add index to slave but not master
On 31 Oct 2011, at 08:46, Jeff Pang wrote: Hello, I have a question that, if I add the index to the table in slave, but don't do it in master, will it make problems? Jeff, I manage some big data here and this is my preferred strategy - shard the workload in different mysql pools (behind a load balancer) and give each different pool a different, custom-tailored index set optimized for the workload expected. Be warned that if you promote a new master without ensuring index-compatibility with the master workload you will (obviously) observe performance variations. Good luck. Cheers! -- Luis Motta Campos is a DBA, Foodie, and Photographer -- Luis Motta Campos is a DBA, Foodie, and Photographer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org