mysql instance disk quota
Hello, We have some instances running in a hardware server, each instance has different port. For quota limits, we can adjust my.cnf to control each instance's memory usage, also can use cgroups to set CPU quota. But what's the general solution to setup the disk quota? For example, I want each instance should use the storage no more than 50GB. Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: mysql instance disk quota
How to set OS disk quota? On 2015/9/6 17:52, Reindl Harald wrote: set OS disk quota for them -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: mysql instance disk quota
Am 06.09.2015 um 11:08 schrieb Ken Peng: We have some instances running in a hardware server, each instance has different port. For quota limits, we can adjust my.cnf to control each instance's memory usage, also can use cgroups to set CPU quota. But what's the general solution to setup the disk quota? For example, I want each instance should use the storage no more than 50GB. you can't what do you expect how a database server should do if the disk quota is reached? what about the global table space? signature.asc Description: OpenPGP digital signature
Re: mysql instance disk quota
Hi, If disk quota is reached, an error can be threw out. we can accept this policy. Thanks. On 2015/9/6 17:28, Reindl Harald wrote: Am 06.09.2015 um 11:08 schrieb Ken Peng: We have some instances running in a hardware server, each instance has different port. For quota limits, we can adjust my.cnf to control each instance's memory usage, also can use cgroups to set CPU quota. But what's the general solution to setup the disk quota? For example, I want each instance should use the storage no more than 50GB. you can't what do you expect how a database server should do if the disk quota is reached? what about the global table space? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: mysql instance disk quota
Am 06.09.2015 um 11:37 schrieb Ken Peng: If disk quota is reached, an error can be threw out. we can accept this policy. Thanks. and damage will happen - jesus christ the worst thing for a database is "disk full", if you don't care just start the mysql instances as different users and set OS disk quota for them, but be prepared for data loss sooner or later On 2015/9/6 17:28, Reindl Harald wrote: Am 06.09.2015 um 11:08 schrieb Ken Peng: We have some instances running in a hardware server, each instance has different port. For quota limits, we can adjust my.cnf to control each instance's memory usage, also can use cgroups to set CPU quota. But what's the general solution to setup the disk quota? For example, I want each instance should use the storage no more than 50GB. you can't what do you expect how a database server should do if the disk quota is reached? what about the global table space? signature.asc Description: OpenPGP digital signature
Re: mysql instance disk quota
Am 06.09.2015 um 12:01 schrieb Ken Peng: How to set OS disk quota? that's hardly a mysql question http://lmgtfy.com/?q=linux+disk+quota On 2015/9/6 17:52, Reindl Harald wrote: set OS disk quota for them signature.asc Description: OpenPGP digital signature
Instance tuning
I've long used mysqltuner.pl and have recently heard that it may not be the best tool for the job. what are others using? What experiences have you had with mysqltuner.pl Inquiring minds want to know -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Instance tuning
Hey Bruce, Much of the output is inaccurate and the tool is rather dated. A On Wed, Apr 11, 2012 at 10:23 PM, Bruce Ferrell bferr...@baywinds.orgwrote: I've long used mysqltuner.pl and have recently heard that it may not be the best tool for the job. what are others using? What experiences have you had with mysqltuner.pl Inquiring minds want to know -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
RE: Reg...My Hung MYSQL instance
Thank you everyone who have responded back... The issue is fixed now after increasing the max connections param Shafi M -Original Message- From: Johan De Meersman [mailto:vegiv...@tuxera.be] Sent: Tuesday, August 23, 2011 4:06 PM To: Suresh Kuna Cc: Shafi AHMED; mysql@lists.mysql.com; Andrew Moore Subject: Re: Reg...My Hung MYSQL instance - Original Message - From: Suresh Kuna sureshkumar...@gmail.com Can you paste your error log and configuration file with the total memory you have on the server. Hey, someone posting something actually useful. You must be new here :-D Ahmed, do you have more connections than you used to? Some of the memory parameters in the mysql config are allocated per connection instead of globally, so it's quite possible to use more memory than you have if you get a lot of clients. All of this is well-documented on mysql.com, but if you post your config and some info about your usage and dataset here we can have a brief look, too. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel Get your world in your inbox! Mail, widgets, documents, spreadsheets, organizer and much more with your Sifymail WIYI id! Log on to http://www.sify.com ** DISCLAIMER ** Information contained and transmitted by this E-MAIL is proprietary to Sify Technologies Limited and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this mail notify us immediately at ad...@sifycorp.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Reg...My Hung MYSQL instance
- Original Message - From: Shafi AHMED shafi.ah...@sifycorp.com Thank you everyone who have responded back... The issue is fixed now after increasing the max connections param Glad to hear that, but it seems unlikely, to me. Certain things, like the query cache, index cache, etc. are allocated once, at startup. Those are fixed memory requirements. Other things, like read buffers, sort buffers and the like get allocated every time a client connects. Those are dynamic memory requirements, and the amount they use increases linearly with the number of concurrent connections you get. Thus, increasing the max connections can never *reduce* your memory requirements - only potentially allow *more* memory to be allocated. I still suspect that you ran out of memory because you had a sudden influx of connections; and now that you've increased the max connections you'll run out of memory even faster next time that occurs. If it works now, it works; but keep that in the back of your mind somewhere for next time you see it occur :-) -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Reg...My Hung MYSQL instance
Great, thank you sir! Appreciate your comprehensive reply Best Rgs, Shafi AHMED -Original Message- From: Johan De Meersman [mailto:vegiv...@tuxera.be] Sent: Thursday, August 25, 2011 1:30 PM To: Shafi AHMED Cc: mysql@lists.mysql.com Subject: Re: Reg...My Hung MYSQL instance - Original Message - From: Shafi AHMED shafi.ah...@sifycorp.com Thank you everyone who have responded back... The issue is fixed now after increasing the max connections param Glad to hear that, but it seems unlikely, to me. Certain things, like the query cache, index cache, etc. are allocated once, at startup. Those are fixed memory requirements. Other things, like read buffers, sort buffers and the like get allocated every time a client connects. Those are dynamic memory requirements, and the amount they use increases linearly with the number of concurrent connections you get. Thus, increasing the max connections can never *reduce* your memory requirements - only potentially allow *more* memory to be allocated. I still suspect that you ran out of memory because you had a sudden influx of connections; and now that you've increased the max connections you'll run out of memory even faster next time that occurs. If it works now, it works; but keep that in the back of your mind somewhere for next time you see it occur :-) -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel Get your world in your inbox! Mail, widgets, documents, spreadsheets, organizer and much more with your Sifymail WIYI id! Log on to http://www.sify.com ** DISCLAIMER ** Information contained and transmitted by this E-MAIL is proprietary to Sify Technologies Limited and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this mail notify us immediately at ad...@sifycorp.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Reg...My Hung MYSQL instance
Hello Shafi, On 8/25/2011 02:02, Shafi AHMED wrote: Thank you everyone who have responded back... The issue is fixed now after increasing the max connections param I disagree. I believe you only reduced the symptom of the problem. The real problem was you had too many open connections. The solution is to figure out why each of your connections had been open for so long and why you needed so many. * Were those idle connections sitting around doing nothing? - close them * Were they taking forever to finish their business? - write better queries or improve your data structures. Then close them. Allowing more connections to be made at one time can only push your system harder. Each connection requires some resources to check its status. There must be buffers for sending and receiving data. Also, if there are any connection-specific MySQL objects created on a connection that never closes, then those objects will continue to take up resources as well (user variables, prepared statements, temporary tables) . Basically, you need to get your connections under control in order to solve your problem. Raising the limit was probably a temporary fix, at best. -- Shawn Green MySQL Principal Technical Support Engineer Oracle USA, Inc. - Hardware and Software, Engineered to Work Together. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Reg...My Hung MYSQL instance
Dear, Today suddenly my database went into hung state due to Out of Memory [ Killed process 1330 (mysqld) ]. Please advise me folks.This happens now often Shafi Get your world in your inbox! Mail, widgets, documents, spreadsheets, organizer and much more with your Sifymail WIYI id! Log on to http://www.sify.com ** DISCLAIMER ** Information contained and transmitted by this E-MAIL is proprietary to Sify Technologies Limited and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this mail notify us immediately at ad...@sifycorp.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Reg...My Hung MYSQL instance
It will only do what you let it. If your server ui consuming too much memory it because you've let it. On Aug 23, 2011 9:22 AM, Shafi AHMED shafi.ah...@sifycorp.com wrote: Dear, Today suddenly my database went into hung state due to Out of Memory [ Killed process 1330 (mysqld) ]. Please advise me folks.This happens now often Shafi Get your world in your inbox! Mail, widgets, documents, spreadsheets, organizer and much more with your Sifymail WIYI id! Log on to http://www.sify.com ** DISCLAIMER ** Information contained and transmitted by this E-MAIL is proprietary to Sify Technologies Limited and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this mail notify us immediately at ad...@sifycorp.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=eroomy...@gmail.com
Re: Reg...My Hung MYSQL instance
Kill the Mysql process as of now set the proper buffer parameters as per the usage. start the mysql instance. On Tue, Aug 23, 2011 at 2:04 PM, Andrew Moore eroomy...@gmail.com wrote: It will only do what you let it. If your server ui consuming too much memory it because you've let it. On Aug 23, 2011 9:22 AM, Shafi AHMED shafi.ah...@sifycorp.com wrote: Dear, Today suddenly my database went into hung state due to Out of Memory [ Killed process 1330 (mysqld) ]. Please advise me folks.This happens now often Shafi Get your world in your inbox! Mail, widgets, documents, spreadsheets, organizer and much more with your Sifymail WIYI id! Log on to http://www.sify.com ** DISCLAIMER ** Information contained and transmitted by this E-MAIL is proprietary to Sify Technologies Limited and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this mail notify us immediately at ad...@sifycorp.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=eroomy...@gmail.com -- Regards, Dhaval Jaiswal
Re: Reg...My Hung MYSQL instance
Hello Shafi, Can you paste your error log and configuration file with the total memory you have on the server. On Tue, Aug 23, 2011 at 2:04 PM, Andrew Moore eroomy...@gmail.com wrote: It will only do what you let it. If your server ui consuming too much memory it because you've let it. On Aug 23, 2011 9:22 AM, Shafi AHMED shafi.ah...@sifycorp.com wrote: Dear, Today suddenly my database went into hung state due to Out of Memory [ Killed process 1330 (mysqld) ]. Please advise me folks.This happens now often Shafi Get your world in your inbox! Mail, widgets, documents, spreadsheets, organizer and much more with your Sifymail WIYI id! Log on to http://www.sify.com ** DISCLAIMER ** Information contained and transmitted by this E-MAIL is proprietary to Sify Technologies Limited and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this mail notify us immediately at ad...@sifycorp.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=eroomy...@gmail.com -- Thanks Suresh Kuna MySQL DBA
Re: Reg...My Hung MYSQL instance
- Original Message - From: Suresh Kuna sureshkumar...@gmail.com Can you paste your error log and configuration file with the total memory you have on the server. Hey, someone posting something actually useful. You must be new here :-D Ahmed, do you have more connections than you used to? Some of the memory parameters in the mysql config are allocated per connection instead of globally, so it's quite possible to use more memory than you have if you get a lot of clients. All of this is well-documented on mysql.com, but if you post your config and some info about your usage and dataset here we can have a brief look, too. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: best practice: mysql_multi, VMs w/single instance per or doesn't matter?
Other people have answered with pros and cons of virtualisation, but I would rather ask another question: why do you feel it necessary to split up the database? If it's only used for QC, it's probably not in intensive use. Why would you go through the bother of splitting it up? You're staying on the same server, apparently, so you'll have to decide which instance gets what part of cpu, memory and other resources, you'll have to provide separate backup for all instances, et cetera; while leaving things as they are is zero effort. What is the problem with the current setup that will be resolved by splitting? -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: best practice: mysql_multi, VMs w/single instance per or doesn't matter?
The biggest issue for me is that you want your development environment to be as identical as possible to the production environment (to avoid mistakes when you move your application over). You don't want your production environment to accidentally access your development data; but at the same time you want to make sure that your development isn't accidentally playing with the live data. Since I'm running a *AMP application, I can just use localhost and not worry about forgetting to change the database name references. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com -Original Message- From: Johan De Meersman [mailto:vegiv...@tuxera.be] Sent: Friday, March 04, 2011 6:21 AM To: Sid Lane Cc: MySql Subject: Re: best practice: mysql_multi, VMs w/single instance per or doesn't matter? Other people have answered with pros and cons of virtualisation, but I would rather ask another question: why do you feel it necessary to split up the database? If it's only used for QC, it's probably not in intensive use. Why would you go through the bother of splitting it up? You're staying on the same server, apparently, so you'll have to decide which instance gets what part of cpu, memory and other resources, you'll have to provide separate backup for all instances, et cetera; while leaving things as they are is zero effort. What is the problem with the current setup that will be resolved by splitting? -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=je...@gii.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
best practice: mysql_multi, VMs w/single instance per or doesn't matter?
I've always had a single physical server that is the qc mysql database for all our applications but it's now up to 85 schemas so I want to break it up along the same lines as production (where there's redundant pools of mysql servers by application class). my basic question is whether it's better to run multiple instances on the same host or run single instances on multiple VMs on the same physical server. I can see slight advantages/disadvantages to each but no obvious upside nor downside to either. remember, this is dev/qc, not prod, so I'm leaning toward VMs so I don't have to manage port #s in configs or expect developers to remember that (also, I don't have to modify scripts for multiple instances, paths, etc). not big reasons for sure but all else equal I'll go the less work route and the only upside to multi I see is not having to reload the box as VM host. any compelling argument for either approach?
Re: best practice: mysql_multi, VMs w/single instance per or doesn't matter?
i would use virtual machines because port/socket/configuration after running our whole infrastructure on vmware i can not understand how i could live without machine-snapshots and auto-failover :-) on hardware with virtualization support performance is also not a problem and ESXi is free without support on hardware matching the HCL Am 03.03.2011 22:52, schrieb Sid Lane: I've always had a single physical server that is the qc mysql database for all our applications but it's now up to 85 schemas so I want to break it up along the same lines as production (where there's redundant pools of mysql servers by application class). my basic question is whether it's better to run multiple instances on the same host or run single instances on multiple VMs on the same physical server. I can see slight advantages/disadvantages to each but no obvious upside nor downside to either. remember, this is dev/qc, not prod, so I'm leaning toward VMs so I don't have to manage port #s in configs or expect developers to remember that (also, I don't have to modify scripts for multiple instances, paths, etc). not big reasons for sure but all else equal I'll go the less work route and the only upside to multi I see is not having to reload the box as VM host. any compelling argument for either approach? signature.asc Description: OpenPGP digital signature
Re: best practice: mysql_multi, VMs w/single instance per or doesn't matter?
Just know that there is not-a-problem in running multiple instances on the same host, then all you have to do is to evaluate the performance factor. In your case I would not introduce the overhead of the VMs, but take advantage of this to learn how to manage multiple instances on the same host that is always useful. You can have a look at Giuseppe Maxia's MySQL Sandboxhttp://mysqlsandbox.net/ Or if you wish I can share my technique I use since 3.23. Cheers Claudio 2011/3/3 Reindl Harald h.rei...@thelounge.net i would use virtual machines because port/socket/configuration after running our whole infrastructure on vmware i can not understand how i could live without machine-snapshots and auto-failover :-) on hardware with virtualization support performance is also not a problem and ESXi is free without support on hardware matching the HCL Am 03.03.2011 22:52, schrieb Sid Lane: I've always had a single physical server that is the qc mysql database for all our applications but it's now up to 85 schemas so I want to break it up along the same lines as production (where there's redundant pools of mysql servers by application class). my basic question is whether it's better to run multiple instances on the same host or run single instances on multiple VMs on the same physical server. I can see slight advantages/disadvantages to each but no obvious upside nor downside to either. remember, this is dev/qc, not prod, so I'm leaning toward VMs so I don't have to manage port #s in configs or expect developers to remember that (also, I don't have to modify scripts for multiple instances, paths, etc). not big reasons for sure but all else equal I'll go the less work route and the only upside to multi I see is not having to reload the box as VM host. any compelling argument for either approach? -- Claudio
RE: best practice: mysql_multi, VMs w/single instance per or doesn't matter?
There is almost no VM overhead these days. mySQL is disk I/O bound, not CPU bound. With VMWare you can setup your partitions to be raw disks (not virtual disk files) so you get native I/O. If you were to get some SSD's, I bet you would even see some significant performance increase too even over a true native system. Also consider sharding your tables to put some on raw/ssd/vmdk depending on how they're used. VMWare has options that are nearly bare-metal. There are other free options like KVM that are built right into the kernel. I personally use VirtualBox here at work for development, but I use VMWare Workstation at home. At previous jobs, we used VMWare Server (free) for all the UAT from the test servers themselves to the test guest OS (XP, Win7, OSX, Linux, browser variants, etc.) Virtual Machines are the ONLY way to go these days IMHO. It's silly to try and setup mySQL on different ports and go through all that hassle and configuration. With VM's you can just clone one to setup a new instance, you have fail-over, backups, they're easy to move to new hardware, they have console GUIs, intelligent shuffling of resources, maximizing hardware, minimizing costs (electric, carbon, space, etc). There are so many benefits and almost no detriments to a VM these days with computers as powerful as they are. Even updating the VMs (patching) is fairly straight forward with the major Linux distros (many even have web GUI front ends to push patches to all VMs, not to mention automated unattended updates if you desire) Just do it. DO IT! You won't ever look back, and like Reindl said, you'll wonder how you got this far without VMs. :-) -Daevid. There are only 11 types of people in this world. Those that think binary jokes are funny, those that don't, and those that don't know binary. -Original Message- From: Claudio Nanni [mailto:claudio.na...@gmail.com] Sent: Thursday, March 03, 2011 2:14 PM To: Reindl Harald Cc: mysql@lists.mysql.com Subject: Re: best practice: mysql_multi, VMs w/single instance per or doesn't matter? Just know that there is not-a-problem in running multiple instances on the same host, then all you have to do is to evaluate the performance factor. In your case I would not introduce the overhead of the VMs, but take advantage of this to learn how to manage multiple instances on the same host that is always useful. You can have a look at Giuseppe Maxia's MySQL Sandboxhttp://mysqlsandbox.net/ Or if you wish I can share my technique I use since 3.23. Cheers Claudio 2011/3/3 Reindl Harald h.rei...@thelounge.net i would use virtual machines because port/socket/configuration after running our whole infrastructure on vmware i can not understand how i could live without machine-snapshots and auto-failover :-) on hardware with virtualization support performance is also not a problem and ESXi is free without support on hardware matching the HCL Am 03.03.2011 22:52, schrieb Sid Lane: I've always had a single physical server that is the qc mysql database for all our applications but it's now up to 85 schemas so I want to break it up along the same lines as production (where there's redundant pools of mysql servers by application class). my basic question is whether it's better to run multiple instances on the same host or run single instances on multiple VMs on the same physical server. I can see slight advantages/disadvantages to each but no obvious upside nor downside to either. remember, this is dev/qc, not prod, so I'm leaning toward VMs so I don't have to manage port #s in configs or expect developers to remember that (also, I don't have to modify scripts for multiple instances, paths, etc). not big reasons for sure but all else equal I'll go the less work route and the only upside to multi I see is not having to reload the box as VM host. any compelling argument for either approach? -- Claudio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
How to create new mysql instance
Hi, Can any body help me how to create new instance at the same mysql databas server in 5.0.85 community version ? Thanks Jeetendra Ranjan
Re: How to create new mysql instance
Can any body help me how to create new instance at the same mysql databas server in 5.0.85 community version ? You might find useful: http://code.openark.org/blog/mysql/manually-installing-multiple-mysql-instances-on-linux-howto At least i used that last time i had to set 2 instances on my machine. iñigo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Query_cache instance creation
Hi, MySQL query cache implementation is based on the Query_cache object (ref: sql_cache.cc). But I cannot find where the instance for the object is created ... (like new Query_cache qcache ...). Can anybody point me to the file please? Regards, Raja
RE: Query_cache instance creation
You might have better luck on the mysql-internals list -Original Message- From: Rajarshi Chowdhury [mailto:mailtorajar...@gmail.com] Sent: Tuesday, July 21, 2009 4:58 AM To: mysql@lists.mysql.com Subject: Query_cache instance creation Hi, MySQL query cache implementation is based on the Query_cache object (ref: sql_cache.cc). But I cannot find where the instance for the object is created ... (like new Query_cache qcache ...). Can anybody point me to the file please? Regards, Raja The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: generic remote command/script for monitoring MySQL instance health
On Mon, 9 Mar 2009, Sven wrote: Hi folks I am searching for a generic command to monitor that MySQL instance is up and running. I don't have any know-how about the schema of the DB. kind regards Sven Aluoor Hi What about 'mysqladmin ping' ? Regards, Thomas Spahni -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: generic remote command/script for monitoring MySQL instance health
On 3/11/09, Thomas Spahni t...@lawbiz.ch wrote: I am searching for a generic command to monitor that MySQL instance is up and running. I don't have any know-how about the schema of the DB. What about 'mysqladmin ping' ? Hi Thomas thank you. That was the command I searched. kind regards Sven -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
generic remote command/script for monitoring MySQL instance health
Hi folks I am searching for a generic command to monitor that MySQL instance is up and running. I don't have any know-how about the schema of the DB. kind regards Sven Aluoor -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: generic remote command/script for monitoring MySQL instance health
you may like to try mytop or watch -n10 mysql -BNA databasename -e show full processlist add user,host,databasename as needed Sven schrieb: Hi folks I am searching for a generic command to monitor that MySQL instance is up and running. I don't have any know-how about the schema of the DB. kind regards Sven Aluoor -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Instance scale-out
I succesfully install multiple instances on the same host since many years (good old 3.23), my rule of the game is: different os user, different os user homedir, different my.cnf (with different port/socket) and start the server ecluding the possibility to read other than its own my.cnf with --defaults-file=/home/mysql-instance-x/my.cnf It works greatly and never had one problem (as long as you also start mysql client with --defaults-file=/correct/my.cnf) Question: Why on Certification Study Guide, Chapter 42, Page 576, First Bullet it states: Each server must have its own network interface(..) it will not even start properly if it discovers that its network interfaces are already in use(...) Even if at the end it changes the version a little bit stating: .can share the same hostname. They can also share the same IP address as long as they listen on different TCP/IP port numbers. I find at least confusing,and I think that should be corrected, am I wrong? What do the masters think? Claudio
Re: Instance scale-out
I think you are confusing a network interface (such as a tcp port) with a physical network device (such as a LAN card). For me the study guide is correct. I succesfully install multiple instances on the same host since many years (good old 3.23), my rule of the game is: different os user, different os user homedir, different my.cnf (with different port/socket) and start the server ecluding the possibility to read other than its own my.cnf with --defaults-file=/home/mysql-instance-x/my.cnf It works greatly and never had one problem (as long as you also start mysql client with --defaults-file=/correct/my.cnf) Question: Why on Certification Study Guide, Chapter 42, Page 576, First Bullet it states: Each server must have its own network interface(..) it will not even start properly if it discovers that its network interfaces are already in use(...) Even if at the end it changes the version a little bit stating: .can share the same hostname. They can also share the same IP address as long as they listen on different TCP/IP port numbers. I find at least confusing,and I think that should be corrected, am I wrong? What do the masters think? Claudio __ This email has been scanned by Netintelligence http://www.netintelligence.com/email -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Instance scale-out
Hi John, So according to this interpretation a port IS a network interface, it means that I have thousands of network interfaces on my servers? I never thought of a port as a network interface, I always thought of it as an attribute(address of an application on the host) of the tcp/ip protocol, transported by the network interface (all the software stack, not only physical device). This is in my concept of interface, but probably my english is lacking! Thanks Claudio 2009/2/5 John Daisley john.dais...@mypostoffice.co.uk I think you are confusing a network interface (such as a tcp port) with a physical network device (such as a LAN card). For me the study guide is correct. I succesfully install multiple instances on the same host since many years (good old 3.23), my rule of the game is: different os user, different os user homedir, different my.cnf (with different port/socket) and start the server ecluding the possibility to read other than its own my.cnf with --defaults-file=/home/mysql-instance-x/my.cnf It works greatly and never had one problem (as long as you also start mysql client with --defaults-file=/correct/my.cnf) Question: Why on Certification Study Guide, Chapter 42, Page 576, First Bullet it states: Each server must have its own network interface(..) it will not even start properly if it discovers that its network interfaces are already in use(...) Even if at the end it changes the version a little bit stating: .can share the same hostname. They can also share the same IP address as long as they listen on different TCP/IP port numbers. I find at least confusing,and I think that should be corrected, am I wrong? What do the masters think? Claudio __ This email has been scanned by Netintelligence http://www.netintelligence.com/email
Re: Instance scale-out
Hi Claudio, I don't think its your English, I agree with you that its not just confusing it is wrong. Each server must have its own network interface At least for my 10 years experience in IT and UNIX I would understand network interface as physical network interface unless specified as otherwise. Maybe the MySQL community has a differenet opinion :P ;) cheers Andy. This message was sent using IMP, the Internet Messaging Program. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Instance scale-out
An interface by definition is a point of interconnection. Maybe its a bit of a grey area where the interpretation can be different depending on whether you think in terms of hardware or software. Its the port which is used to communicate with the MySQL (or indeed any other) server software so therefore for the server software (but maybe not the physical hardware) its the port which is the point of interconnection (the network interface). For me the book is correct but I can see where confusion could occur. John Hi Claudio, I don't think its your English, I agree with you that its not just confusing it is wrong. Each server must have its own network interface At least for my 10 years experience in IT and UNIX I would understand network interface as physical network interface unless specified as otherwise. Maybe the MySQL community has a differenet opinion :P ;) cheers Andy. This message was sent using IMP, the Internet Messaging Program. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=john.dais...@butterflysystems.co.uk __ This email has been scanned by Netintelligence http://www.netintelligence.com/email -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Instance scale-out
John, I don't want to argue too much on this but I'd also like the opinion of the big heads in MySQL I think there's no grey area here. An interface is an interface and can be of any type and supporting any protocol(TCP/IP on ethernet card, UDP idem. DSL on WAN card, PPP on POTS modem) A port is related ONLY to the TCP/IP protocol(in this case) Moreover, are all the *nix systems wrong? --- [c...@terramia ~]$ man ifconfig IFCONFIG(8)Linux Programmer's Manual IFCONFIG(8) NAME ifconfig - configure a network interface SYNOPSIS ifconfig [interface] ifconfig interface [aftype] options | address ... So, let's see what a 'network interface' is: [c...@terramia ~]$ /sbin/ifconfig eth0 eth0 Link encap:Ethernet HWaddr 00:1C:23:3F:CB:C0 inet addr:10.xxx.xxx.xxx Bcast:10.xxx.xxx.xxx Mask:255.255.255.0 inet6 addr: fe80::21c:23ff:fe3f:cbc0/64 Scope:Link UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:4057947 errors:0 dropped:0 overruns:0 frame:0 TX packets:3932495 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:851379513 (811.9 MiB) TX bytes:1896970616 (1.7 GiB) Interrupt:177 Aren't we supposed to see just a port number here? Cheers Claudio 2009/2/5 John Daisley john.dais...@mypostoffice.co.uk An interface by definition is a point of interconnection. Maybe its a bit of a grey area where the interpretation can be different depending on whether you think in terms of hardware or software. Its the port which is used to communicate with the MySQL (or indeed any other) server software so therefore for the server software (but maybe not the physical hardware) its the port which is the point of interconnection (the network interface). For me the book is correct but I can see where confusion could occur. John Hi Claudio, I don't think its your English, I agree with you that its not just confusing it is wrong. Each server must have its own network interface At least for my 10 years experience in IT and UNIX I would understand network interface as physical network interface unless specified as otherwise. Maybe the MySQL community has a differenet opinion :P ;) cheers Andy. This message was sent using IMP, the Internet Messaging Program. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=john.dais...@butterflysystems.co.uk __ This email has been scanned by Netintelligence http://www.netintelligence.com/email
Re: Instance scale-out
Claudio, Nobody is arguing, its a discussion list not an arguing list and this is a good discussion to have on here. Im very interested in seeing what others have to say about this but here is how I interpret it (based on my 18 years of IT experience which includes many years working with MySQL including becoming mysql dba and dev certified amongst many other certifications) I would say in terms of the MySQL server the interface is either a TCP/IP Port, a Named Pipe, shared memory or a UNIX Socket. Depending on the host operating system it can use any of those interfaces but each instance must have its own interface. I believe you are confusing server hardware and server software. Do you consider a server to be a physical machine or an application that runs on a physical machine? Its the same difference. The network card is physical hardware, the port is not! John John, I don't want to argue too much on this but I'd also like the opinion of the big heads in MySQL I think there's no grey area here. An interface is an interface and can be of any type and supporting any protocol(TCP/IP on ethernet card, UDP idem. DSL on WAN card, PPP on POTS modem) A port is related ONLY to the TCP/IP protocol(in this case) Moreover, are all the *nix systems wrong? --- [c...@terramia ~]$ man ifconfig IFCONFIG(8)Linux Programmer's Manual IFCONFIG(8) NAME ifconfig - configure a network interface SYNOPSIS ifconfig [interface] ifconfig interface [aftype] options | address ... So, let's see what a 'network interface' is: [c...@terramia ~]$ /sbin/ifconfig eth0 eth0 Link encap:Ethernet HWaddr 00:1C:23:3F:CB:C0 inet addr:10.xxx.xxx.xxx Bcast:10.xxx.xxx.xxx Mask:255.255.255.0 inet6 addr: fe80::21c:23ff:fe3f:cbc0/64 Scope:Link UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:4057947 errors:0 dropped:0 overruns:0 frame:0 TX packets:3932495 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:851379513 (811.9 MiB) TX bytes:1896970616 (1.7 GiB) Interrupt:177 Aren't we supposed to see just a port number here? Cheers Claudio 2009/2/5 John Daisley john.dais...@mypostoffice.co.uk An interface by definition is a point of interconnection. Maybe its a bit of a grey area where the interpretation can be different depending on whether you think in terms of hardware or software. Its the port which is used to communicate with the MySQL (or indeed any other) server software so therefore for the server software (but maybe not the physical hardware) its the port which is the point of interconnection (the network interface). For me the book is correct but I can see where confusion could occur. John Hi Claudio, I don't think its your English, I agree with you that its not just confusing it is wrong. Each server must have its own network interface At least for my 10 years experience in IT and UNIX I would understand network interface as physical network interface unless specified as otherwise. Maybe the MySQL community has a differenet opinion :P ;) cheers Andy. This message was sent using IMP, the Internet Messaging Program. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=john.dais...@butterflysystems.co.uk __ This email has been scanned by Netintelligence http://www.netintelligence.com/email __ This email has been scanned by Netintelligence http://www.netintelligence.com/email -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Instance scale-out
Quoting John Daisley john.dais...@mypostoffice.co.uk: I would say in terms of the MySQL server the interface is either a TCP/IP Port, a Named Pipe, shared memory or a UNIX Socket. Depending on the host operating system it can use any of those interfaces but each instance must have its own interface. Just to chip in on this, an interface can obviosly mean a lot of things depending on the context and I accept the above discription in relation to MySQL. However in the text originally referenced the term used was network interface which I think most Sys/DB admins etc would understand to be a network interface in the sense the operating system considers it, ie a physical or virtual IP network intreface at the OS level. With regards the MySQL requirement the original text was discussing, I believe it is in reference to a TCP port which will normally be sitting on an OS level network interface hence I think this is badly worded in the text. thanks Andy. This message was sent using IMP, the Internet Messaging Program. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Instance scale-out
Andy, Like I said, I would like to hear what others think and I'd be particularly interested in some comment from within MySQL. For the purposes of the exam, which I think the original question related to, I would say you have to accept mysql's interpretation of 'network interface' as being a port, socket, pipe etc. Thats what it says in the study guide and the reference manual and thats what they are going to test you on. John Quoting John Daisley john.dais...@mypostoffice.co.uk: I would say in terms of the MySQL server the interface is either a TCP/IP Port, a Named Pipe, shared memory or a UNIX Socket. Depending on the host operating system it can use any of those interfaces but each instance must have its own interface. Just to chip in on this, an interface can obviosly mean a lot of things depending on the context and I accept the above discription in relation to MySQL. However in the text originally referenced the term used was network interface which I think most Sys/DB admins etc would understand to be a network interface in the sense the operating system considers it, ie a physical or virtual IP network intreface at the OS level. With regards the MySQL requirement the original text was discussing, I believe it is in reference to a TCP port which will normally be sitting on an OS level network interface hence I think this is badly worded in the text. thanks Andy. This message was sent using IMP, the Internet Messaging Program. __ This email has been scanned by Netintelligence http://www.netintelligence.com/email -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Instance scale-out
First to help people join the discussion, the guilty paragraph of certification study guide 42.1 -- Each server must have its own network interfaces, including the TCP/IP port, the named pipe or shared memory (on Windows), and the Unix socket file (on Unix). One server cannot use network interfaces that are used by another server; it will not even start up properly if it discovers that its network interfaces are already in use. Note that it isn't necessary to set up multiple hostnames for the server host. All the MySQL servers running on a given host can share the same hostname. They can also share the same IP address as long as they listen on different TCP/IP port numbers. -- Hey John, I am really interested in this discussions, as you see! I understand perfectly what is the meaning with the MySQL certificator/certified glasses, but I am not really use to see a unit socket file as a network interface, not even the shared memory. I understand that this is all about semantic but I guess there is 99% that rather would call the 'mysql network interface' simply as a communication channel, pipeline, or stack. Named pipes, Shared Memory, Unix socket file have nothing to do with network, they live on the same server, and do not even need any network protocol. [X] Named pipes and Shared Memory are means for windows channel for interprocess communication [X] Unix socket file is same thing on unix systems, using a file as pipe. I am not confusing hardware and software, I do not care if and how many physical cards are in the host, for me the network interface is a layer of software that enable two or more systems to communicate over a network of interconnected systems, be the interconnection medium any, ethernet, wireless, bluetooth, CDN, The network card must be bridging the physical medium that transport information with the host, so it can be any piece of hardware, but the greatness of standards and protocols is abstraction, and thank the Lord! We have the internet accessible from almost everywhere! DSL, WI-FI, UMTS, 3G, also I tried TCP/IP over Bluetooth! I just need from a O.S. level have available a network interface (see virtual hosts, they can all be bound to the same physical card) Would you please issue and comment the following commands? $man ifconfig $ifconfig eth0 I am positive that the book is using the words 'network interface' using a meaning that is only in the mind of the authors, and a few more. Claudio 2009/2/5 John Daisley john.dais...@mypostoffice.co.uk Claudio, Nobody is arguing, its a discussion list not an arguing list and this is a good discussion to have on here. Im very interested in seeing what others have to say about this but here is how I interpret it (based on my 18 years of IT experience which includes many years working with MySQL including becoming mysql dba and dev certified amongst many other certifications) I would say in terms of the MySQL server the interface is either a TCP/IP Port, a Named Pipe, shared memory or a UNIX Socket. Depending on the host operating system it can use any of those interfaces but each instance must have its own interface. I believe you are confusing server hardware and server software. Do you consider a server to be a physical machine or an application that runs on a physical machine? Its the same difference. The network card is physical hardware, the port is not! John John, I don't want to argue too much on this but I'd also like the opinion of the big heads in MySQL I think there's no grey area here. An interface is an interface and can be of any type and supporting any protocol(TCP/IP on ethernet card, UDP idem. DSL on WAN card, PPP on POTS modem) A port is related ONLY to the TCP/IP protocol(in this case) Moreover, are all the *nix systems wrong? --- [c...@terramia ~]$ man ifconfig IFCONFIG(8)Linux Programmer's Manual IFCONFIG(8) NAME ifconfig - configure a network interface SYNOPSIS ifconfig [interface] ifconfig interface [aftype] options | address ... So, let's see what a 'network interface' is: [c...@terramia ~]$ /sbin/ifconfig eth0 eth0 Link encap:Ethernet HWaddr 00:1C:23:3F:CB:C0 inet addr:10.xxx.xxx.xxx Bcast:10.xxx.xxx.xxx Mask:255.255.255.0 inet6 addr: fe80::21c:23ff:fe3f:cbc0/64 Scope:Link UP BROADCAST RUNNING MULTICAST MTU:1500 Metric
Re: Instance scale-out
For the purposes of the exam, which I think the original question related to, I would say you have to accept mysql's interpretation of 'network interface' as being a port, socket, pipe etc. Thats what it says in the study guide and the reference manual and thats what they are going to test you on. I'm sure if you bring this to Dave Stokes's attention, he will see that the ambiguity is cleared up. The way this is used in the cert guide is NOT common usage (I will not comment on whether it's correct or not) and will be a trap if it's really tested the way it's worded. I know they aren't trying to trap anyone. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Starting a 2nd MySQL instance on UNIX
Would you kindly supply the changes you made, for our collective education? Thanks. Arthur On Mon, Apr 28, 2008 at 11:54 AM, Mark-E [EMAIL PROTECTED] wrote: Hi Ian, Thanks for the reply. I was specifying the new port of 3307. I actually got it working over the weekend. Turns out I had to add a few entries in the mysqld section of the my.cnf file and I was able to connect. Regards, Mark
RE: Starting a 2nd MySQL instance on UNIX
Hi Arthur, Sure, no problem! This actually proved to be rather tricky because the first instance was installed in /usr/local/mysql. It seems that by default, MySQL looks for things in this locations so if you deviate from it, you have to be explicit with mysql and tell it where to look for things. My new MySQL 50 instance had to run alongside the 4.0.20 instance so I installed it into /usr/local/mysql-50 ** Here is a summary of things I had to do to bring this up properly ** I created a my.cnf and put it in /usr/local/mysql-50 In the my.cnf, I defined the following (The first entry is for the mysql program and the 2nd entry is for the mysqld program). [mysql] socket=/tmp/mysql50/mysql.sock port=3307 [mysqld] user=mysql5 pid-file=/usr/local/mysql-50/mysql50.pid log=/usr/local/mysql-50/mysql50d.log port=3307 max_allowed_packet=32M == I had to set this so I could import the MySQL 4.0.20 database properly. Some users may not need this set as high. socket=/tmp/mysql50/mysql.sock #Path to installation directory. All paths are usually resolved relative to this. basedir=/usr/local/mysql-50 #Path to the database root datadir=/usr/local/mysql-50/data You have to be careful to not only pick a separate port, but also a separate pid file for the process ID and a separate socket file, especially if you are running both instance at the same time. I modified the mysql.server in the /support-files folder. I had to set the basedir and the datadir. I then copied this to the /bin folder. I edited the mysql_install_db file in the /scripts folder and set the basedir and datadir. I then ran that to create the mysql database. As root, I started the server ./bin/mysql.server start (The server starts up :) ). Since the user mysql50 is defined in this script, it then starts mysqld as the mysql50 user. Now, the tricky part, to run mysql and access the mysql database, you cannot just say mysql -u root -p mysql, it will try to connect to the default instance in /usr/local/mysql. What you have to do is: Mysql --defaults-file=/usr/local/mysql-50/my.cnf -u root -p mysql This now properly connects to the new mysql50 instance. Also, if you want to run mysqladmin, you need to specify the --defaults-file option. Make sure wherever you use the --defaults-file option that it is the FIRST command line option used. It took me quite some time to get this all working but now, I understand MySQL much better. I hope this proves to be some help to you and others out there who may be going through the same thing. Regards, Mark From: Arthur Fuller [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 29, 2008 9:29 AM To: Eramo, Mark Cc: mysql@lists.mysql.com Subject: Re: Starting a 2nd MySQL instance on UNIX Would you kindly supply the changes you made, for our collective education? Thanks. Arthur On Mon, Apr 28, 2008 at 11:54 AM, Mark-E [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] wrote: Hi Ian, Thanks for the reply. I was specifying the new port of 3307. I actually got it working over the weekend. Turns out I had to add a few entries in the mysqld section of the my.cnf file and I was able to connect. Regards, Mark
R: Starting a 2nd MySQL instance on UNIX
Hello, I faced this issues a few years ago and I'd like to give my contributions. The easy and clean way I've found: -- -- One installation for each mysql instance -- On each instance you can have as many databases as you want. -- One different mysql user and homedir (mysql41,mysql50) for each mysql installation. -- Put .my.cnf file in the home directory of each mysql user with the right parameters (different ports and socket files at least, this is the way I have found not to conflict between instances) Ex: :-.my.cnf: # The MySQL server [mysqld] port= 3515 socket = /tmp/mysql5015.sock skip-locking key_buffer = 256M max_allowed_packet = 1M :-: -- Start each mysql instance with his own user -- In this way I have several MySQL server instances (from 3.23 to 5.x) wonderfully working on the same 2.7 Solaris machine. Aloha! Claudio Nanni -Messaggio originale- Da: Eramo, Mark [mailto:[EMAIL PROTECTED] Inviato: martedì 29 aprile 2008 15.54 A: Arthur Fuller Cc: mysql@lists.mysql.com Oggetto: RE: Starting a 2nd MySQL instance on UNIX Hi Arthur, Sure, no problem! This actually proved to be rather tricky because the first instance was installed in /usr/local/mysql. It seems that by default, MySQL looks for things in this locations so if you deviate from it, you have to be explicit with mysql and tell it where to look for things. My new MySQL 50 instance had to run alongside the 4.0.20 instance so I installed it into /usr/local/mysql-50 ** Here is a summary of things I had to do to bring this up properly ** I created a my.cnf and put it in /usr/local/mysql-50 In the my.cnf, I defined the following (The first entry is for the mysql program and the 2nd entry is for the mysqld program). [mysql] socket=/tmp/mysql50/mysql.sock port=3307 [mysqld] user=mysql5 pid-file=/usr/local/mysql-50/mysql50.pid log=/usr/local/mysql-50/mysql50d.log port=3307 max_allowed_packet=32M == I had to set this so I could import the MySQL 4.0.20 database properly. Some users may not need this set as high. socket=/tmp/mysql50/mysql.sock #Path to installation directory. All paths are usually resolved relative to this. basedir=/usr/local/mysql-50 #Path to the database root datadir=/usr/local/mysql-50/data You have to be careful to not only pick a separate port, but also a separate pid file for the process ID and a separate socket file, especially if you are running both instance at the same time. I modified the mysql.server in the /support-files folder. I had to set the basedir and the datadir. I then copied this to the /bin folder. I edited the mysql_install_db file in the /scripts folder and set the basedir and datadir. I then ran that to create the mysql database. As root, I started the server ./bin/mysql.server start (The server starts up :) ). Since the user mysql50 is defined in this script, it then starts mysqld as the mysql50 user. Now, the tricky part, to run mysql and access the mysql database, you cannot just say mysql -u root -p mysql, it will try to connect to the default instance in /usr/local/mysql. What you have to do is: Mysql --defaults-file=/usr/local/mysql-50/my.cnf -u root -p mysql This now properly connects to the new mysql50 instance. Also, if you want to run mysqladmin, you need to specify the --defaults-file option. Make sure wherever you use the --defaults-file option that it is the FIRST command line option used. It took me quite some time to get this all working but now, I understand MySQL much better. I hope this proves to be some help to you and others out there who may be going through the same thing. Regards, Mark From: Arthur Fuller [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 29, 2008 9:29 AM To: Eramo, Mark Cc: mysql@lists.mysql.com Subject: Re: Starting a 2nd MySQL instance on UNIX Would you kindly supply the changes you made, for our collective education? Thanks. Arthur On Mon, Apr 28, 2008 at 11:54 AM, Mark-E [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] wrote: Hi Ian, Thanks for the reply. I was specifying the new port of 3307. I actually got it working over the weekend. Turns out I had to add a few entries in the mysqld section of the my.cnf file and I was able to connect. Regards, Mark Questo messaggio ed ogni suo allegato sono confidenziali e possono essere riservati o, comunque, protetti dall'essere diffusi. Se il ricevente non é il destinatario diretto del presente messaggio, é pregato di contattare l'originario mittente e di cancellare questo messaggio ed ogni suo allegato dal sistema di posta. Se il ricevente non é il destinatario diretto del presente messaggio, sono vietati l'uso, la riproduzione e la stampa di questo messaggio e di ogni suo allegato, nonché la diffusione del loro contenuto a qualsiasi altro soggetto
Re: Starting a 2nd MySQL instance on UNIX
Hi Ian, Thanks for the reply. I was specifying the new port of 3307. I actually got it working over the weekend. Turns out I had to add a few entries in the mysqld section of the my.cnf file and I was able to connect. Regards, Mark Ian Simpson wrote: Mark, When you try to log-in to the new instance, are you specifying the new port number to the client? If you don't give it the new port number, then it will connect to the default port, which is presumably your 4.0.20 instance. Mark-E wrote: I have a Solaris box where MySQL 4.0.20 instance is running (to support Bugzilla 2.22). I have loaded mysql5.0 on the same box (for Bugzilla 3.0.3) and created a new mysql50 user that I want to use to run this instance with. I tried to start the instance on another port by running the following command... ./bin/mysqld_safe --defaults-file=/usr/local/mysql-5.0/my.cnf --socket=/tmp/mysql50/mysql.sock --port=3307 --basedir=/usr/local/mysql-5.0 --datadir=/usr/local/mysql-5.0/data --pid-file=/usr/local/mysql-5.0/mysql50.pid --user=mysql50 The instance appears to start but the message Starting the instance comes up and I never get back to the system prompt. it just sits there. If I open another terminal window and do a ps -ef | grep mysql, I can see the new processes running. There is nothing in the error log. I ran the mysql_install_db.sh script to create the mysql database however, I cannot log in. I thought that it creates a root user with no password. I tired logging in as root with no password bu no luck. If i use the mysql 4.0.20 root user password, I get into the 4.0.20 instance even though the mysql50 user does not have mysql 4.0.20 in it's path. when I run mysql at the prompt, how would I differentiate between the 2 instances? So at this point I am stuck. If anyone out can help guide me on what I need to do to ge tthe instance up and running properly, I would appreciate it. I am rather new to MySQL and I have read through the docs but things are still not very clear. Thanks! Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- View this message in context: http://www.nabble.com/Starting-a-2nd-MySQL-instance-on-UNIX-tp16834758p16941984.html Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Starting a 2nd MySQL instance on UNIX
Mark, When you try to log-in to the new instance, are you specifying the new port number to the client? If you don't give it the new port number, then it will connect to the default port, which is presumably your 4.0.20 instance. Mark-E wrote: I have a Solaris box where MySQL 4.0.20 instance is running (to support Bugzilla 2.22). I have loaded mysql5.0 on the same box (for Bugzilla 3.0.3) and created a new mysql50 user that I want to use to run this instance with. I tried to start the instance on another port by running the following command... ./bin/mysqld_safe --defaults-file=/usr/local/mysql-5.0/my.cnf --socket=/tmp/mysql50/mysql.sock --port=3307 --basedir=/usr/local/mysql-5.0 --datadir=/usr/local/mysql-5.0/data --pid-file=/usr/local/mysql-5.0/mysql50.pid --user=mysql50 The instance appears to start but the message Starting the instance comes up and I never get back to the system prompt. it just sits there. If I open another terminal window and do a ps -ef | grep mysql, I can see the new processes running. There is nothing in the error log. I ran the mysql_install_db.sh script to create the mysql database however, I cannot log in. I thought that it creates a root user with no password. I tired logging in as root with no password bu no luck. If i use the mysql 4.0.20 root user password, I get into the 4.0.20 instance even though the mysql50 user does not have mysql 4.0.20 in it's path. when I run mysql at the prompt, how would I differentiate between the 2 instances? So at this point I am stuck. If anyone out can help guide me on what I need to do to ge tthe instance up and running properly, I would appreciate it. I am rather new to MySQL and I have read through the docs but things are still not very clear. Thanks! Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Starting a 2nd MySQL instance on UNIX
I have a Solaris box where MySQL 4.0.20 instance is running (to support Bugzilla 2.22). I have loaded mysql5.0 on the same box (for Bugzilla 3.0.3) and created a new mysql50 user that I want to use to run this instance with. I tried to start the instance on another port by running the following command... ./bin/mysqld_safe --defaults-file=/usr/local/mysql-5.0/my.cnf --socket=/tmp/mysql50/mysql.sock --port=3307 --basedir=/usr/local/mysql-5.0 --datadir=/usr/local/mysql-5.0/data --pid-file=/usr/local/mysql-5.0/mysql50.pid --user=mysql50 The instance appears to start but the message Starting the instance comes up and I never get back to the system prompt. it just sits there. If I open another terminal window and do a ps -ef | grep mysql, I can see the new processes running. There is nothing in the error log. I ran the mysql_install_db.sh script to create the mysql database however, I cannot log in. I thought that it creates a root user with no password. I tired logging in as root with no password bu no luck. If i use the mysql 4.0.20 root user password, I get into the 4.0.20 instance even though the mysql50 user does not have mysql 4.0.20 in it's path. when I run mysql at the prompt, how would I differentiate between the 2 instances? So at this point I am stuck. If anyone out can help guide me on what I need to do to ge tthe instance up and running properly, I would appreciate it. I am rather new to MySQL and I have read through the docs but things are still not very clear. Thanks! Mark -- View this message in context: http://www.nabble.com/Starting-a-2nd-MySQL-instance-on-UNIX-tp16834758p16834758.html Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Server Instance Config Wizard
Hi, I just installed MySQL in my Windows 2003 server and I ran the configuration wizard. All seems to work correctly up to the point where it tries to start the service (almost at the end of the configuration) for which it fails and spits out an error message: Error No. 2003 Can't connect to MySQL server on 'LocalHost' (10061) The same error message suggests that I should make sure that my firewall has an exception for the service to run on port 3306 (which it does). I have really no idea why the service cannot be started and I would appreciate some help on figuring this out. Things I have already tried are listed below: *Turning off the Anti-virus *Turning off Windows firewall Thanks in advance! -BeasC -- View this message in context: http://www.nabble.com/MySQL-Server-Instance-Config-Wizard-tp16497722p16497722.html Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Server Instance Setup Error
I will rerun later today At 08:04 2008-03-10, you wrote: That error message is usually when you try to login to MySQL by whatever means (the Windows install Wizard may be attempting this in the final steps upon starting up? But it should not be starting up as root...). Can you complete the installation using the wizard (I am assuming this is where the error is occurring), then start-up MySQL? This error generally occurs when a user attempts to login. We may need some more details to troubleshoot this. Can you please re-run the install. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Server Instance Setup Error
Craig Huffstetler escribió: Greetings again Andrew, That error message is usually when you try to login to MySQL by whatever means (the Windows install Wizard may be attempting this in the final steps upon starting up? But it should not be starting up as root...). Can you complete the installation using the wizard (I am assuming this is where the error is occurring), then start-up MySQL? This error generally occurs when a user attempts to login. We may need some more details to troubleshoot this. Can you please re-run the install. Sincerely, Craig Huffstetler On Sun, Mar 9, 2008 at 6:12 PM, AndrewMcHorney [EMAIL PROTECTED] wrote: Hello I am running on Windows XP and MYSQL 5.05.1A. I have not yet started up mysql. Andrew At 13:52 2008-03-09, you wrote: mysql GRANT ALL ON databaseName.* TO 'your_mysql_name'@'your_client_host'; #mysql -S /tmp/mysql.sock -- Ing. Vidal Garza Tirado Depto. Sistemas Aduanet S.A. de C.V. Tel. (867)711-5850 ext. 4346, Fax (867)711-5855. Ave. César López de Lara No. 3603 Int. B Col Jardín. Nuevo Laredo, Tamaulipas, México. -- Este mensaje ha sido analizado por MailScanner en busca de virus y otros contenidos peligrosos, y se considera que está limpio. For all your IT requirements visit: http://www.aduanet.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Server Instance Setup Error
Hello I just tried to install the mysql server and I am getting the following error messgae for the Apply Security Setting: The security settings could not be applied. Error number 1045 Access denied for use '[EMAIL PROTECTED]' (using password:YES) What does this mean and how do I fix it? Thanks, Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Server Instance Setup Error
Greetings Andrew, Make sure you have granted access to your user: (run command line) mysql GRANT ALL ON databaseName.* TO 'your_mysql_name'@'your_client_host'; Sincerely, Craig Huffstetler P.S. - What version of MySQL, what operating system and are you using the command line (I was assuming you are familiar with the command line)...the command above is to be run via the command line. On Sun, Mar 9, 2008 at 2:23 PM, AndrewMcHorney [EMAIL PROTECTED] wrote: Hello I just tried to install the mysql server and I am getting the following error messgae for the Apply Security Setting: The security settings could not be applied. Error number 1045 Access denied for use '[EMAIL PROTECTED]' (using password:YES) What does this mean and how do I fix it? Thanks, Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
Re: Server Instance Setup Error
Greetings again Andrew, That error message is usually when you try to login to MySQL by whatever means (the Windows install Wizard may be attempting this in the final steps upon starting up? But it should not be starting up as root...). Can you complete the installation using the wizard (I am assuming this is where the error is occurring), then start-up MySQL? This error generally occurs when a user attempts to login. We may need some more details to troubleshoot this. Can you please re-run the install. Sincerely, Craig Huffstetler On Sun, Mar 9, 2008 at 6:12 PM, AndrewMcHorney [EMAIL PROTECTED] wrote: Hello I am running on Windows XP and MYSQL 5.05.1A. I have not yet started up mysql. Andrew At 13:52 2008-03-09, you wrote: mysql GRANT ALL ON databaseName.* TO 'your_mysql_name'@'your_client_host';
Re: How do you allow external computers to access server instance?
Mysql restricts access outside the server after the installation (on not all, but several cases) so i suggest to connect to the mysql database as root and review the host values on the user table, that can give you an idea of who is allowed and from where is allowed ...remeber that % means anywhere. If you need more information i suggest to read the manual searching by users permissions. Carlos Ferindo Middleton wrote: I found how to bind to addrees to but didn't find anything in my.ini about skip-networking but now I have this problem where the I can't connect locally sitting at the computer using hostname localhost if I type in the IP address of the computer I get a messsage saying {Hostname} is not allowed to connect to this MySQL server Ferindo On 6/21/07, Baron Schwartz [EMAIL PROTECTED] wrote: Hi, Ferindo Middleton wrote: I've installed MySQL5 on a machine running Windows XP. I'm not an advanced user so I chose all the default configuration settings when I went through the setup wizard for the server instance. The database works fine and I can access it when I'm sitting at the computer through the command line client and MySQL Query Browser. However, if I try to access the server instance from another computer on my LAN via MySQL Query Browser, I get a message saying the connection is refused How do I configure the server to allow incoming connections from other computers on my network? Try to configure bind-address to the server's IP address, and ensure skip-networking is not defined. Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How do you allow external computers to access server instance?
Don't forget to allow port 3306 (or whatever port you're server listens on) through any Windows firewall... Tim -Original Message- From: Carlos Proal [mailto:[EMAIL PROTECTED] Sent: Friday, June 22, 2007 1:40 PM Cc: mysql@lists.mysql.com Subject: Re: How do you allow external computers to access server instance? Mysql restricts access outside the server after the installation (on not all, but several cases) so i suggest to connect to the mysql database as root and review the host values on the user table, that can give you an idea of who is allowed and from where is allowed ...remeber that % means anywhere. If you need more information i suggest to read the manual searching by users permissions. Carlos Ferindo Middleton wrote: I found how to bind to addrees to but didn't find anything in my.ini about skip-networking but now I have this problem where the I can't connect locally sitting at the computer using hostname localhost if I type in the IP address of the computer I get a messsage saying {Hostname} is not allowed to connect to this MySQL server Ferindo On 6/21/07, Baron Schwartz [EMAIL PROTECTED] wrote: Hi, Ferindo Middleton wrote: I've installed MySQL5 on a machine running Windows XP. I'm not an advanced user so I chose all the default configuration settings when I went through the setup wizard for the server instance. The database works fine and I can access it when I'm sitting at the computer through the command line client and MySQL Query Browser. However, if I try to access the server instance from another computer on my LAN via MySQL Query Browser, I get a message saying the connection is refused How do I configure the server to allow incoming connections from other computers on my network? Try to configure bind-address to the server's IP address, and ensure skip-networking is not defined. Baron -- 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]
How do you allow external computers to access server instance?
I've installed MySQL5 on a machine running Windows XP. I'm not an advanced user so I chose all the default configuration settings when I went through the setup wizard for the server instance. The database works fine and I can access it when I'm sitting at the computer through the command line client and MySQL Query Browser. However, if I try to access the server instance from another computer on my LAN via MySQL Query Browser, I get a message saying the connection is refused How do I configure the server to allow incoming connections from other computers on my network? -- Ferindo Middleton -Sleekcollar-
Re: How do you allow external computers to access server instance?
Hi, Ferindo Middleton wrote: I've installed MySQL5 on a machine running Windows XP. I'm not an advanced user so I chose all the default configuration settings when I went through the setup wizard for the server instance. The database works fine and I can access it when I'm sitting at the computer through the command line client and MySQL Query Browser. However, if I try to access the server instance from another computer on my LAN via MySQL Query Browser, I get a message saying the connection is refused How do I configure the server to allow incoming connections from other computers on my network? Try to configure bind-address to the server's IP address, and ensure skip-networking is not defined. Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How do you allow external computers to access server instance?
I found how to bind to addrees to but didn't find anything in my.ini about skip-networking but now I have this problem where the I can't connect locally sitting at the computer using hostname localhost if I type in the IP address of the computer I get a messsage saying {Hostname} is not allowed to connect to this MySQL server Ferindo On 6/21/07, Baron Schwartz [EMAIL PROTECTED] wrote: Hi, Ferindo Middleton wrote: I've installed MySQL5 on a machine running Windows XP. I'm not an advanced user so I chose all the default configuration settings when I went through the setup wizard for the server instance. The database works fine and I can access it when I'm sitting at the computer through the command line client and MySQL Query Browser. However, if I try to access the server instance from another computer on my LAN via MySQL Query Browser, I get a message saying the connection is refused How do I configure the server to allow incoming connections from other computers on my network? Try to configure bind-address to the server's IP address, and ensure skip-networking is not defined. Baron -- Ferindo Middleton Web Application Developer/Database Administrator/IT Infrastructure and Integration Management Specialist/Perception Augmentation and Control Supplementation Research Specialist for AI Wetware-to-Software Interface and Design -Sleekcollar-
Obtaining the first or second instance of an event
I am looking at data from a telephone call centre. I have a table giving data on calls made including time and date with the name CallDateTime. Each call has a number, CallId and each customer has a number CustomerNo. Each row represents a different call. I would like to create a column which identifies the first call made by a customer in a particular month. That is if a particular call is the first call made by that customer in that month, there is a 1 in the column, otherwise there is a zero. I would also like to identify the second call (if any) made by the customer in a particular month. I am quite inexperienced with MySQL and SQL in general and would appreciate any help which you can offer. Thanks David Scott _ David Scott Department of Statistics, Tamaki Campus The University of Auckland, PB 92019 Auckland 1142,NEW ZEALAND Phone: +64 9 373 7599 ext 86830 Fax: +64 9 373 7000 Email: [EMAIL PROTECTED] Graduate Officer, Department of Statistics Director of Consulting, Department of Statistics -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Obtaining the first or second instance of an event
Hi David, David Scott wrote: I am looking at data from a telephone call centre. I have a table giving data on calls made including time and date with the name CallDateTime. Each call has a number, CallId and each customer has a number CustomerNo. Each row represents a different call. I would like to create a column which identifies the first call made by a customer in a particular month. That is if a particular call is the first call made by that customer in that month, there is a 1 in the column, otherwise there is a zero. I would also like to identify the second call (if any) made by the customer in a particular month. I am quite inexperienced with MySQL and SQL in general and would appreciate any help which you can offer. There are many solutions to this type of query. I have written about some of them at http://www.xaprb.com/blog/2006/12/07/how-to-select-the-firstleastmax-row-per-group-in-sql/. For your particular query, I would start by just writing a query to find the rows, then progress to maintaining the column later. Probably something like this would do it: select calls.* from calls inner join ( select CustomerNo, min(CallDateTime) as CallDateTime from calls group by CustomerNo, left(CallDateTime, 7) ) as min_rows using(CustomerNo, CallDateTime) This may not be the most efficient way to do the query, but I think once you learn how it works you can worry about that. (Only you can do that, because you know the table structure and the kinds of queries you're doing). Finding the second call is just an extension of this technique. More is in the article I linked. cheers Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Redirecting all queries to mysql dababase to another instance
Hi, I need to write a small middleware program that can capture, inspect and redirect all queries to an old instance of mysql to a new instance. Any help or pointers to get started would be greatly appreciated. thanks, Chike. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Redirecting all queries to mysql dababase to another instance
Hi, Chibuike Muoh wrote: Hi, I need to write a small middleware program that can capture, inspect and redirect all queries to an old instance of mysql to a new instance. Any help or pointers to get started would be greatly appreciated. Perhaps this will help: http://jan.kneschke.de/projects/mysql/mysql-proxy Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqlmanager: The instance ... is being stopped forcibly. Normallyit should not happen. ...
Hi, I installed the noinstall package of mysql 5.0.41 on Windows Server 2003 R2 SP2. I manage an instance with mysqlmanager of this package. The my.ini is the following: [manager] pid-file=mysqld37.pid [mysqld37] mysqld-path=D:/Programme/MySQL/mysql-5.0.41-win32/bin/mysqld-nt.exe datadir=D:/Daten/domestic default-storage-engine=MYISAM port = 3310 socket = /tmp/mysql.sock37 log log-error relay-log=proliant-relay-bin All mysqlmanager commands seem to work, with one exception: mysql stop instance mysqld37; Query OK, 0 rows affected (35.14 sec) You see that it takes more than half a minute until the instance ist stopped. The mysqlmanager displays when runnig with --standalone: The instance 'mysqld37' is being stopped forcibly. Normallyit should not happen. Probably the instance has beenhanging. You should also check your IM setup. You see my setup above, I cannot spot any problem. The error log is the following: 070511 18:11:34 InnoDB: Started; log sequence number 0 43655 070511 18:11:34 [Warning] 'db' entry 'searchresult_eth [EMAIL PROTECTED]' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE. 070511 18:11:34 [Warning] 'db' entry 'eth [EMAIL PROTECTED]' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE. 070511 18:11:34 [Warning] 'db' entry 'eth [EMAIL PROTECTED]' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE. 070511 18:11:34 [Warning] 'db' entry 'eth [EMAIL PROTECTED]' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE. 070511 18:11:34 [Note] D:\Programme\MySQL\mysql-5.0.41-win32\bin\mysqld-nt.exe: ready for connections. Version: '5.0.41-community-nt-log' socket: '' port: 3310 MySQL Community Edition (GPL) The name of our ETH database has capital letters but that did not matter for years. In the bug database there is no problem of this kind (http://bugs.mysql.com/search.php?cmd=displaystatus[]=Allseverity=allsearch_for=mysqlmanagerdirection=ASClimit=50reorder_by=id) Do you see a problem with my setup here or do you think that this is a bug? Thanks, Uwe Galle
Re: Installing 2nd instance on windows.
Thanks to all for so good responce. Now I will experiment with it and reply earliest. Thanks CPK -- Keep your Environment clean and green.
Re: Installing 2nd instance on windows.
Dear friends, thank you for your response. but the problem is that when I try to install MySQL 5.0 from windows .msi installer on windows XP with MySQL 5.0 already installed, the installer does not shows any option regarding new installation. I can just rapair/remove the installation. Why? As I know we can install multiple instances of MySQL running for different ports, how to make it available on Windows? I need to run two different mysql servers on same machine at different ports(3306, 3307 etc) is it possible and how? Thanks again, CPK Keep your Environment clean and green.
Re: Installing 2nd instance on windows.
It should be possible to do a manual install from the non-installer download. Moreover, it should also be possible to run 2 instances on 2 different ip-adresses on one computer. It's been a while sincei ran MySQL on Windows, so my memory is not clear on this, but scan the docs, and your questions will be answered. On Tue, May 8, 2007 20:35, C K wrote: Dear friends, thank you for your response. but the problem is that when I try to install MySQL 5.0 from windows .msi installer on windows XP with MySQL 5.0 already installed, the installer does not shows any option regarding new installation. I can just rapair/remove the installation. Why? As I know we can install multiple instances of MySQL running for different ports, how to make it available on Windows? I need to run two different mysql servers on same machine at different ports(3306, 3307 etc) is it possible and how? Thanks again, CPK Keep your Environment clean and green. -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean. -- Later Mogens Melander +45 40 85 71 38 +66 870 133 224 -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Installing 2nd instance on windows.
I am fairly newbie at MySQL in general, not to mention MySQL on Windows which I've never used, but I'll trow my 2 cents here. Instead of installing a whole new set of files, wouldn't that be easier just to start a 2nd instance of the MySQL server using a different configuration file? indicating a different port, socket file, and new datadir? regards, Enrique. --- Mogens Melander [EMAIL PROTECTED] wrote: It should be possible to do a manual install from the non-installer download. Moreover, it should also be possible to run 2 instances on 2 different ip-adresses on one computer. It's been a while sincei ran MySQL on Windows, so my memory is not clear on this, but scan the docs, and your questions will be answered. On Tue, May 8, 2007 20:35, C K wrote: Dear friends, thank you for your response. but the problem is that when I try to install MySQL 5.0 from windows .msi installer on windows XP with MySQL 5.0 already installed, the installer does not shows any option regarding new installation. I can just rapair/remove the installation. Why? As I know we can install multiple instances of MySQL running for different ports, how to make it available on Windows? I need to run two different mysql servers on same machine at different ports(3306, 3307 etc) is it possible and how? Thanks again, CPK Keep your Environment clean and green. -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean. -- Later Mogens Melander +45 40 85 71 38 +66 870 133 224 -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- What you have been obliged to discover by yourself leaves a path in your mind which you can use again when the need arises.--G. C. Lichtenberg http://themathcircle.org/ Food fight? Enjoy some healthy debate in the Yahoo! Answers Food Drink QA. http://answers.yahoo.com/dir/?link=listsid=396545367 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Installing 2nd instance on windows.
Is it possible to install more than instances on Linux of MySQL 5.0? I am using WinXP SP 2 and MySQL 5.0.17. Thanks CPK -- Keep your Environment clean and green. -- Keep your Environment clean and green.
Installing 2nd instance on windows.
Is it possible to install more than instances on Linux of MySQL 5.0? I am using WinXP SP 2 and MySQL 5.0.17. Thanks CPK -- Keep your Environment clean and green.
Can't configure instance w/ 5.0.22 instance wizard
No matter what I do, it fails at the step where it's supposed to install and start the 'Windows service with an error 0. Is this a known issue? It sure would be nice to get more information about the failure from the wizard. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Instance manager and starting instances on demand
When setting up several instances in the instance manager, if you don't want them all to start at once, but you want to start instances on demand (like when you have instances of different MySQL versions) the only way I found to achieve this goal is is to set the option nonguarded. Then, when you start the instance with START INSTANCE name, it starts, but the IM does not monitor it. Justly so, because of the nonguarded option. So before submitting a bug (or feature request) report, my questions are: 1) Is this the correct way of setting several instances and firing them on demand? 2) Can I revert the effects of nonguarded? I tried with UNSET instance_name.nonguarded, but it does not have any effect. Thanks for any help. Giuseppe -- _ _ _ _ (_|| | |(_| The Data Charmer _| http://datacharmer.blogspot.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
conflict between SapDB 7.4 service instance and Trend ServerProtect
On a Windows Server (Win2000 or WinXP) that is running a database instance (or many database). If I run the antivirus from Trend Micro (Trend ServerProtect) all my database instance service are stopped. Do you have any idea ? already talk with TrendMicro? Thx, Stéphane -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re: User Specific Instance Running
Anthony, Friday, October 11, 2002, 5:26:39 AM, you wrote: AWM There is non-root user implementation of MySQL-Pro 4.0.4 linux binary in AWM this users environment (RH 7.3). AWM my.cnf has been modified to include individual user, port , AWM bind-address and host specifics (and etc) unique to that user and is AWM passed as --defaults-file through mysqld_safe script. Data AWM directories are already available with this user/group's ownership. AWM All attempts to run mysql -u root file and other privledged commands This is not a privilege command :-) It means that you connect as user 'root' without a password to the database 'file'. AWM (also tried --skip-grant-tables) end up with Error 1045 Access Denied AWM ? --skip-grant-tables is an option of mysqld, not a mysql client program. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: User Specific Instance Running
Victoria Reznichenko wrote: Anthony, Friday, October 11, 2002, 5:26:39 AM, you wrote: AWM There is non-root user implementation of MySQL-Pro 4.0.4 linux binary in AWM this users environment (RH 7.3). AWM my.cnf has been modified to include individual user, port , AWM bind-address and host specifics (and etc) unique to that user and is AWM passed as --defaults-file through mysqld_safe script. Data AWM directories are already available with this user/group's ownership. AWM All attempts to run mysql -u root file and other privledged commands This is not a privilege command :-) It means that you connect as user 'root' without a password to the database 'file'. This occurs immediately after running mysql_install_db then running mysql.server scripts so there isn't any passwords at this time. AWM (also tried --skip-grant-tables) end up with Error 1045 Access Denied AWM ? --skip-grant-tables is an option of mysqld, not a mysql client program. Understood, however, doesn't using that switch (with mysqld) impact how you gain access to the server from a security aspect whether using mysql, mysqladmin etc? Thank You, Anthon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
User Specific Instance Running
There is non-root user implementation of MySQL-Pro 4.0.4 linux binary in this users environment (RH 7.3). my.cnf has been modified to include individual user, port , bind-address and host specifics (and etc) unique to that user and is passed as --defaults-file through mysqld_safe script. Data directories are already available with this user/group's ownership. All attempts to run mysql -u root file and other privledged commands (also tried --skip-grant-tables) end up with Error 1045 Access Denied ? -- Anthony Anthony W. Marino Pres./CTO, AWM Objects Phone: (732) 610-2441 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: instance
Alexander, Wednesday, July 17, 2002, 11:32:19 PM, you wrote: AB When I want to run two servers with different AB configuration. Can I run in the same machine and two AB running? Yes, you can (it's not true for Windows): http://www.mysql.com/doc/M/u/Multiple_servers.html http://www.mysql.com/doc/m/y/mysqld_multi.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
instance
When I want to run two servers with different configuration. Can I run in the same machine and two running? Alexander sql, query ___ Yahoo! Encontros O lugar certo para encontrar a sua alma gêmea. http://br.encontros.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: instance
Hello Alexander, You can easily have two or more instances (mysqld processes) of MySQL running on the physically same server as long as they have different data directories. You possibly could, in theory, have a system where several mysqld processess share the same data directory (still having different databases) but this approach is _extremely_ tricky to get working reliably. About the need of several server instances, you could use another MySQL for production use (possibly with the normal port, stable table handlers etc.), meanwhile having another instance for development use, running on a different port. The good point of this approach is that if the development instance crashes due to some strange experiment (as mine sometimes does :-), it won't affect the production instance in any way. Of course, you should try to separate your production and development environments, but it's not always affordable. Regards, Iikka ** * Iikka Meriläinen * * IT Support * * Vaalan kunta * * -- * * E-mail: [EMAIL PROTECTED] * ** On Wed, 17 Jul 2002, Alexander Burbello wrote: When I want to run two servers with different configuration. Can I run in the same machine and two running? Alexander sql, query ___ Yahoo! Encontros O lugar certo para encontrar a sua alma gêmea. http://br.encontros.yahoo.com/ - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
set connection as instance variable ( servlet and mysql)
Hi, My application is about online exam with java servlet as tool, tomcat 3.2.3 as server solution , mysql 3.49 as the backend. considering 180 students take the exam at same time within 50 minutes, there are a lot of transactions with database. what i did right now is to define connection in local variable(within doGet or doPost method), every time this servlet is called, new connection is created. after transaction is done, this connection is closed. I am worrying the speed.(it will comsume a lot connection and time for open new connection). so I am thinking to define connection as instance variable in every servlet, so it can save sometime to open new connection. However, I am not sure if it will cause multi-thread problem? How and when i can close the connection. __ Find, Connect, Date! http://personals.yahoo.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: set connection as instance variable ( servlet and mysql)
- Original Message - From: bin cai [EMAIL PROTECTED] To: mysql list [EMAIL PROTECTED] Sent: Friday, May 17, 2002 10:59 AM Subject: set connection as instance variable ( servlet and mysql) Hi, My application is about online exam with java servlet as tool, tomcat 3.2.3 as server solution , mysql 3.49 as the backend. considering 180 students take the exam at same time within 50 minutes, there are a lot of transactions with database. what i did right now is to define connection in local variable(within doGet or doPost method), every time this servlet is called, new connection is created. after transaction is done, this connection is closed. I am worrying the speed.(it will comsume a lot connection and time for open new connection). so I am thinking to define connection as instance variable in every servlet, so it can save sometime to open new connection. However, I am not sure if it will cause multi-thread problem? How and when i can close the connection. You should definitely use a connection pool. Sharing an instance of a connection will work, but you will have performance problems, and it is impossible to demarcate transactions when you do this. If you upgrade to Tomcat-4, it has connection pooling built in. Otherwise you might want to take a look at the commons project at http://cvs.apache.org/viewcvs/jakarta-commons/dbcp/ -Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to know MySQL instance(all daemons) really startup?
Hi, all mysql team As we know, use safe_mysqld or mysql.server we can startup Mysql instance. But how can i know when all the mysqld daemons really startup except use command ps? Thanks in advance. Robert Li Computer Associates - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to know MySQL instance(all daemons) really startup?
Robert, `mysqladmin ping` will print mysqld is alive if the server is running, or error message in any other case. Peter On Wed, 20 Feb 2002, Li, Robert wrote: Hi, all mysql team As we know, use safe_mysqld or mysql.server we can startup Mysql instance. But how can i know when all the mysqld daemons really startup except use command ps? Thanks in advance. Robert Li Computer Associates -- GPG ID D40940EC FPR 89CC E331 FFD0 3138 9CB2 FE0D 122E 9EC9 D409 40EC - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: get instance variable
Hi Robert - The only way I have found to get this sort of stuff (as well as security info) out is to use mysql_query (or mysql_real_query) and issue the query just like you would at the mysql client. Then you can interpret the results that are returned. I am having to do that with column level grants by user ID to implement views of the data in a C++ environment and it's the only way that I could find to do it. There are not a lot of C API things that are specific to getting data column metadata and other configuration data. IT is mostly for obtaining connections, results sets, and manipulating result sets. It appears that the way they want you to get stuff out using the C API is not with lots of specific calls, but by just issuing the command yourself and interpreting the result set. I found the best way is to write a simple program to issue a call and the cout the result set information. Be sure and do that because sometimes the returned data will surprise you a little bit I have some working C++ connection and result set classes if you would like them, plus a test program you can use. Ken Hylton -Original Message- From: Li, Robert [mailto:[EMAIL PROTECTED]] Sent: Monday, February 18, 2002 9:07 PM To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Subject:get instance variable Hi, all MySQL team Here is another question. I want to get individual MySQL instance's variable(like datadir, tmpdir etc) using C API. Is there any function can do this? I know that use mysqladmin and use query show variables can do this. Thanks and regards Robert Li Computer Associates RD Centre Beijing , China Tel:+86 10 6561 1136 ext 852 (O) Fax:+86 10 8529 8979 E-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to restore all databases in one instance?
Hi, all As we know, we can backup all dbs in one instance using mysqldump --alldatabases all_db.sql, so can we restore all of these dbs from all_db.sql in one time? Mysql client program mysql can only restore one database per time---mysql sample_db sample_db.sql. Thanks in advance. Best regards Robert Li Computer Associates RD Centre Beijing , China Tel:+86 10 6561 1136 ext 852 (O) +86 10 6731 1652 (H) Fax:+86 10 8529 8979 E-mail: [EMAIL PROTECTED] -Original Message- From: Sammy Lau [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 29, 2001 6:06 PM To: Li, Robert; [EMAIL PROTECTED] Subject: Re: how to setup Mysql multiple instances http://www.mysql.com/documentation/mysql/bychapter/manual_MySQ L_Database_Adm inistration.html#Multiple_servers - Original Message - From: Li, Robert [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, December 29, 2001 5:58 PM Subject: how to setup Mysql multiple instances Hi,all MySQL teams: First let me wish you all happy new year! Wish Mysql win more victories in DB area. I am a programmer in CA. I know Mysql supports multiple instances. One way is to install different servers, on each server, runs an instance. The other way is to use one server, one installation to run multi instances. Now i can setup the environment in the first way. I want to know how to setup in the second way. Would you pls kindly help me to solve this problem? Thank you very much! Regards Robert Li Computer Associates Programmer, RD Beijing (China) Tel: +86 10 65611136 ext 852 Fax: +86 10 85298979 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to restore all databases in one instance?
At 13:13 +1100 2/19/02, Li, Robert wrote: Hi, all As we know, we can backup all dbs in one instance using mysqldump --alldatabases all_db.sql, so can we restore all of these dbs from all_db.sql in one time? Mysql client program mysql can only restore one database per time---mysql sample_db sample_db.sql. Thanks in advance. Why do you say that? The output from mysqldump --all-databases includes the appropriate USE statements to switch databases. Best regards Robert Li Computer Associates RD Centre Beijing , China Tel:+86 10 6561 1136 ext 852 (O) +86 10 6731 1652 (H) Fax:+86 10 8529 8979 E-mail: [EMAIL PROTECTED] -Original Message- From: Sammy Lau [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 29, 2001 6:06 PM To: Li, Robert; [EMAIL PROTECTED] Subject: Re: how to setup Mysql multiple instances http://www.mysql.com/documentation/mysql/bychapter/manual_MySQ L_Database_Adm inistration.html#Multiple_servers - Original Message - From: Li, Robert [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, December 29, 2001 5:58 PM Subject: how to setup Mysql multiple instances Hi,all MySQL teams: First let me wish you all happy new year! Wish Mysql win more victories in DB area. I am a programmer in CA. I know Mysql supports multiple instances. One way is to install different servers, on each server, runs an instance. The other way is to use one server, one installation to run multi instances. Now i can setup the environment in the first way. I want to know how to setup in the second way. Would you pls kindly help me to solve this problem? Thank you very much! Regards Robert Li Computer Associates Programmer, RD Beijing (China) Tel: +86 10 65611136 ext 852 Fax: +86 10 85298979 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
get instance variable
Hi, all MySQL team Here is another question. I want to get individual MySQL instance's variable(like datadir, tmpdir etc) using C API. Is there any function can do this? I know that use mysqladmin and use query show variables can do this. Thanks and regards Robert Li Computer Associates RD Centre Beijing , China Tel:+86 10 6561 1136 ext 852 (O) Fax:+86 10 8529 8979 E-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
get instance variable
Hi, all MySQL team Here is another question. I want to get individual MySQL instance's variable(like datadir, tmpdir etc) using C API. Is there any function can do this? I know that use mysqladmin and use query show variables can do this. Thanks and regards Robert Li Computer Associates RD Centre Beijing , China Tel:+86 10 6561 1136 ext 852 (O) Fax:+86 10 8529 8979 E-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
get instance variable
Hi, all MySQL team Here is another question. I want to get individual MySQL instance's variable(like datadir, tmpdir etc) using C API. Is there any function can do this? I know that use mysqladmin and use query show variables can do this. Thanks and regards Robert Li Computer Associates RD Centre Beijing , China Tel:+86 10 6561 1136 ext 852 (O) Fax:+86 10 8529 8979 E-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How Huge of your mySQL database or table in your former Instance
On Sun, Dec 16, 2001 at 09:49:29AM -0600, Philip Molter wrote: On Sun, Dec 16, 2001 at 02:00:58AM -0800, Jeremy Zawodny wrote: : On Mon, Dec 10, 2001 at 01:25:07PM +0800, Ares Liu wrote: : : So, could you give me some advice that if it is feasible ? Or show : me your successful cases of using mySQL which is supporting very : large DB or tables with details ? : : How about a table with 260 million rows? We've got one that is very, : very quick for indexed selects. How quick is it for inserts? And what table type? Sorry for the insanely late reply. I had to vanish for a while. It is a MyISAM table and we can run a few hundred inserts/second on it--(probably a lot more, but I can't easily test that right now. Hope that helps. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 5 days, processed 123,265,106 queries (246/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How Huge of your mySQL database or table in your former Instance
On Mon, Dec 10, 2001 at 01:25:07PM +0800, Ares Liu wrote: So, could you give me some advice that if it is feasible ? Or show me your successful cases of using mySQL which is supporting very large DB or tables with details ? How about a table with 260 million rows? We've got one that is very, very quick for indexed selects. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 16 days, processed 373,938,737 queries (254/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How Huge of your mySQL database or table in your former Instance
On Sun, Dec 16, 2001 at 02:00:58AM -0800, Jeremy Zawodny wrote: : On Mon, Dec 10, 2001 at 01:25:07PM +0800, Ares Liu wrote: : : So, could you give me some advice that if it is feasible ? Or show : me your successful cases of using mySQL which is supporting very : large DB or tables with details ? : : How about a table with 260 million rows? We've got one that is very, : very quick for indexed selects. How quick is it for inserts? And what table type? * Philip Molter * Texas.net Internet * http://www.texas.net/ * [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
binding a domain name to a MySQL instance
Is there any way to bind something other than the hostname to a MySQL instance? I'm going to be moving a database from one server to another, and would like the scripts that reference that data to simply talk to db.mydomain.com, rather than have to reconfigure things during launch. Is this possible? ari -- Ari Davidow Applications Administrator, Web Central Tufts University 617-627-4291 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: binding a domain name to a MySQL instance
The solution we took was to write a global configuration file and share connection data as need. This way it only needs to be changed in one place. Furthermore, if you connect as follows: dbi:mysql:host=db_01;database=database_name and then on your client machine, either via bind or the /etc/hosts file, point the db_01 host name to the IP of your database server. I've been doing this for some time, works very well. Hope this helps, -Bart -Original Message- From: ari davidow [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 3:23 PM To: [EMAIL PROTECTED] Subject: binding a domain name to a MySQL instance Is there any way to bind something other than the hostname to a MySQL instance? I'm going to be moving a database from one server to another, and would like the scripts that reference that data to simply talk to db.mydomain.com, rather than have to reconfigure things during launch. Is this possible? ari -- Ari Davidow Applications Administrator, Web Central Tufts University 617-627-4291 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How Huge of your mySQL database or table in your former Instance
All, Now I want to design a database which contains more than 10G data to use. I think the largest table in my db will contains more than 30 million records and the amount of this kind of table will be up to 7 or 10. In my instance there won't be so many clients connecting. normally, there are less than 20 clients concurrent querying. My hardware is dual PIII 933, 512M I plan to upgrade to 1G RAM, three SCSI 18G HD, one of them is dedicated to mySQL DB. platform RH 7.2 with XFS. So, could you give me some advice that if it is feasible ? Or show me your successful cases of using mySQL which is supporting very large DB or tables with details ? Thanks a lot! Ares - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How Huge of your mySQL database or table in your former Instance
Thanks very much Paul, Could you like to tell me what time spent in your querying ten thousands of records from tables one time? In my test, when I query 10,000 records from a table which contains 17 millions records total, it will cost less than 1 second of querying INDEX, or cost more than 30 seconds of querying normal COLUMNs. I want to know query speed in larger table. Regards Ares - Original Message - From: [EMAIL PROTECTED] To: Ares Liu [EMAIL PROTECTED] Sent: Monday, December 10, 2001 1:28 PM Subject: Re: How Huge of your mySQL database or table in your former Instance Now I want to design a database which contains more than 10G data to use. I think the largest table in my db will contains more than 30 million records and the amount of this kind of table will be up to 7 or 10. In my instance there won't be so many clients connecting. normally, there are less than 20 clients concurrent querying. My hardware is dual PIII 933, 512M I plan to upgrade to 1G RAM, three SCSI 18G HD, one of them is dedicated to mySQL DB. platform RH 7.2 with XFS. So, could you give me some advice that if it is feasible ? Or show me your successful cases of using mySQL which is supporting very large DB or tables with details ? I've just restructured a database which has 8 identical tables whose size varies by the hour. They often have 30-35 million rows each. In addition, there are two new tables per day, and the system has been running for over a year now. The database server is a dual PIII-1000 with 1 Gb of RAM, 18 Gb Ultra-wide SCSI disk for the system, and a RAID array with 14 * 73 Gb IBM 10,000 rpm Ultra-wide SCSI discs. The system sings. It's easy to hit disk limits with a large database, hence the RAID array above. It has 8-10 other machines on a 100 MHz ethernet lan which fire selects at the database server, and two which issue inserts into the 8 tables mentioned above. Hope this helps a little. Regards, Paul Wilson iiNet Ltd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can one use more than one character set with one server instance?
Hello helpful list! For one of our customers we have to store russian and german text in a database. Is is somehow possible to do this with one server instance or do I have to split the data to be stored in two databases on two server instances? Thanks you very much, Goeran Zaengerlein - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Database instance
I am planning for a migration from MS-SQL MY-SQL. Does Mysql support database instance? How can I configure Mysql to support transaction rollback ? Regards Peter Li This message was sent through MyMail http://www.mymail.com.au - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php