Re: Is there a professional quality mySQL GUI for Linux?
I use SQLYog emulated with wine and/or cross over office it works 100% fine :D wine sqlyog.exe Next Next Next Finish :D On 3/15/07, Daevid Vincent [EMAIL PROTECTED] wrote: Can anyone recommend a real, quality, professional level mySQL GUI for Linux? KDE, Gnome, whatever. Doesn't matter. Beggars can't be choosers right. Something along the lines of SQLYog (Enterprise ideally). I'm kind of disappointed that I can't seem to find anything. They're all either some Admin tool designed to setup users and all that stuff. Yawn. Or they're so limited, I might as well just use an XP VMWare and a windows GUI client instead. Sadly SQLYog has no intentions of porting to Linux :-\ mySQL Query Browser is for the most part useless. It's v1.1.18 and gives almost no benefit to using the CLI mode. You can't sort by clicking headings. They UI is awkward to use. You can't even set the font sizes, so it's HUGE (at least in my KDE it is). mySQL Workbench is Alpha, and I couldn't even get it to connect to the localhost server (despite the other tools in that package work)!!? phpMyAdmin is wonderful -- for a Web UI tool. But not very practical for serious development. Anything else in my search is either equally amateur or simply just an inactive or dead project. How is it that mySQL is effectively a Linux native tool for all intents and purposes, yet there isn't nearly the level of GUIs for it that there are for Windows?! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- -- Thiago LPS C.E.S.A.R - Administrador de Sistemas msn: [EMAIL PROTECTED] 0xx 81 8735 2591 --
Re: monitor multiple mysql servers with no 3306 access
yes man try use Nagios or Cacti (put it on google) there is many ways that you can monitor it .. :) i think that Nagios is the best one , you can install a daemon to collect information between the [mysql service] - Nagios NRPE (Nagios Remote Plugin Executor) on local box - Nagios box with web reports :) \m/ On 3/13/07, Bing Du [EMAIL PROTECTED] wrote: On 3/13/07, Bing Du [EMAIL PROTECTED] wrote: Hi, Seems like there are quite many MySQL monitoring tools on the Internet. The one I tried today was MONyog http://www.webyog.com/en/. I've also tried a couple of others before, including phpmysqladmin as I was suggested. They require you provide mysql server name and port number. In our situation, we have three or four separate MySQL servers running. Each has 'skip-networking' configured. So mysql don't accept requests coming from outside via network. Each mysql server also runs as web server. 'Localhost' is used for communication between web applications and database server. In this case, how should I monitor our multiple mysql servers remotely? Would anybody advise? Thanks in advance, Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Probably you cant access it from network (remote access), but if you do some script do interconnect them.. maybe you can get this working :D Or if you prefer you can enable the tcp/ip socket on a diferent port for each instances of mysql running in your box.. :) -- -- Thiago LPS C.E.S.A.R - Administrador de Sistemas msn: [EMAIL PROTECTED] 0xx 81 8735 2591 -- Thanks for the reply. I don't think we want to open any port for MySQL connections. Is it possible to install some local stats collector on each MySQL server and my central monitor polls each stats collector? So I don't need to directly connect to mysql. The goal is make minimum impact on database services. That's just my rough idea. Before I delve into writing home grown scripts, anybody aware of any such server-client based monitoring tools or have a better idea? Thanks, Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- -- Thiago LPS C.E.S.A.R - Administrador de Sistemas msn: [EMAIL PROTECTED] 0xx 81 8735 2591 --
Re: how would mysqld restart affect dynamically set global variables?
dude try put it on var/my.cf set-variable = max_connections = 1024 set-variable = max_user_connections = 128 set-variable = table_cache=1200 :wq! i have this working with a mysql3x should be similar to mysql4/5x On 3/14/07, Bing Du [EMAIL PROTECTED] wrote: Hi, We're running mysql 4.1.20. If I understand the manual correctly, I can change max_connections while mysqld is running without restart mysqld to make the change take effect. But what if mysqld restarts later in some other situations, like machine reboot, would my (global) change on max_connections remain? I'm just very clear when to make dynamic changes and when is better to put changes in my.cnf. Please advise. Thanks in advance, Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- -- Thiago LPS C.E.S.A.R - Administrador de Sistemas msn: [EMAIL PROTECTED] 0xx 81 8735 2591 --
Re: Don't have libmysqlclient.so
try find on your system find / -name '*lib*mysql*client*' -type f them link one to /usr/lib/libmysqlclient.so.10 and try it again until you find one that can solve the problem.. :) On 3/14/07, POON Ben [EMAIL PROTECTED] wrote: Hi everyone, I've just installed MySQL 5.0.37 from source. One of my other programs require libmysqlclient.so.10 I was under the impression that if I installed MySQL from source, it will be made. I looked at /usr/local/lib and there is no libmysqlclient.so.10 or even a MySQL folder... Can anyone tell me how i can get it or where I can find it? I am using sparc solaris 10. Thank you very much, Ben -- -- Thiago LPS C.E.S.A.R - Administrador de Sistemas msn: [EMAIL PROTECTED] 0xx 81 8735 2591 --
Re: monitor multiple mysql servers with no 3306 access
Probably you cant access it from network (remote access), but if you do some script do interconnect them.. maybe you can get this working :D Or if you prefer you can enable the tcp/ip socket on a diferent port for each instances of mysql running in your box.. :) On 3/13/07, Bing Du [EMAIL PROTECTED] wrote: Hi, Seems like there are quite many MySQL monitoring tools on the Internet. The one I tried today was MONyog http://www.webyog.com/en/. I've also tried a couple of others before, including phpmysqladmin as I was suggested. They require you provide mysql server name and port number. In our situation, we have three or four separate MySQL servers running. Each has 'skip-networking' configured. So mysql don't accept requests coming from outside via network. Each mysql server also runs as web server. 'Localhost' is used for communication between web applications and database server. In this case, how should I monitor our multiple mysql servers remotely? Would anybody advise? Thanks in advance, Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- -- Thiago LPS C.E.S.A.R - Administrador de Sistemas msn: [EMAIL PROTECTED] 0xx 81 8735 2591 --