Re: how to measure the size of MYSQL database?
On Thu, Sep 06, 2001 at 12:31:34PM +0530, [EMAIL PROTECTED] wrote: > hello > > how can we get the size of Mysql database. > > niraj > > > > BN3 Hosted Customer Service Solution, basic service FREE. > CRM enable your web site in 5 minutes! http://www.bn3.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 If you are using Linux the following should help: du -hs /var/lib/mysql/ HTH, -- Mario Witte <[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: About installing MySQL on Linux 7.1
On Thu, Aug 09, 2001 at 02:45:23PM +0800, Alan wrote: > Excuse Me, > I'm a starter to Linux. > I've downloaded the MySQL-3.23.40-1 for my Linux OS. > They are in .rpm form. How can I install the software properly on Linux! = > > I try to follow the instructions mentioned in manual.txt but it didn't = > work. > Can you help me and tell my how to install it? Thanks! Hi, Normally a simple "rpm -ivh mysql-3.23.40-1.rpm" (or whatever the file is called) should do it. If it doesn't, can you post the output of rpm to this list? Did you download the right package? Which distribution do you use? BTW: Perhaps your distribution has a version numer of 7.1, but the newest Linux kernel is 2.4.7 ;) With regards, -- Mario Witte <[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: Kernel crash caused by mysql?
On Fri, Aug 03, 2001 at 03:42:28AM -0700, Van wrote: > Mario Witte wrote: > Memory or motherboard. How many sticks of RAM do you have in the machine? Are > they the same speed (p100/p133, etc.)? What kind of motherboard? Is updatedb > running at this time? (might be a hard-drive croaking while trying to update > the locate database). There are 2x256 MB and 2x128MB sticks in there, all at a spped of 133. Please don't ask me what kind of motherboard we're running in there, but that shouldn't be a problem. Updatedb is running around midnight, but I just found out that cron.hourly could be a problem in there as we experienced another crash tonight which was at 1:59, the crash yesterday occured at 4:59. Always around the full hour. I've tried and disabled cron.hourly for now, hoping it will help. Seems like it wasn't a problem of mysql, it was just mysql which was killed and thus appeared in the kerne ltrace or something. > Seems your machine might have a wrong hardware component somewhere. I'd check > it out if it's a production machine. We sure will, but the system is located about 500 kilometers from where our bureau is, so I hope it will stay alive at least over the weekend :-) > mysqld can't run as the only service. You can't run anything without initd. Ok, you won! ;) Thanks for your fast help, With regards, -- Mario Witte <[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: Newbie need help on MySQL on RH 7.1
On Wed, Aug 01, 2001 at 08:19:45PM -0400, Stonix wrote: > Hi, > > I installed a RH 7.1, and I installed all the packages for > apache, php and mysql. I don't know how to check if mysql > server is running. On my machine cannot connect to mysql > server. Hi, try executing the following command: ps ax|grep mysql If the server is running you should get an output like: 351 ?S 0:00 /bin/sh /usr/bin/safe_mysqld 403 ?S 0:00 /usr/libexec/mysqld 443 ?S 0:00 /usr/libexec/mysqld 444 ?S 0:00 /usr/libexec/mysqld 4152 pts/2S 0:00 grep mysql If there is no such output or just "grep mysql" try executing "/etc/init.d/mysql start" to start the server manually. HTH, -- Mario Witte <[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: Mysql performance monitoring?
Cricket looks great, I think I'll have to try it ASAP. For the moment I just found a utility called mrtg-mysql which puts mysql-stats into mrtg. Statistics aren't very extensive but enough for the moment. -- Mario Witte <[EMAIL PROTECTED]> On 2001.07.13 07:19:08 -0200 Van wrote: > Mario Witte wrote: > > > > Hello, > > I'm searching for a tool which will provide statistics about the usage > of a > > mysql-server like avg queries/minute, cpu load etc. > > > > I've tried mysqler and liked it, but couldn't get it to start as a > daemon. > > Are there any similar tools out there? > > > > Thanks in Advance, > > -- > Maria: > > Might be some folks working on it at mrtg, but, I think that one died. > > SNMP stuff is over kill for that, but, would add some value. > > http://myops.sourceforge.net/ is a start I've made, with the intentions > of > incorporating mysql monitoring, but, alas, so much to do, and, so little > time. > Some work has been done, but, I haven't had the time to port it to > anything > useful, yet. Mostly, some c apps, still sitting on my workstation. > > If you like the approach at the link above, I'd love to hear some > suggestions. > There are also a couple other projects that might be brewing on > sourceforge, > but, you'll have to search around a little. > > Also, check out Cricket, which is the next evolution of mrtg. They might > have > some contributors dealing with this subject. > > Hope that gives you some ideas. I like the question a lot. > > Best Regards, > Van > -- > = > Linux rocks!!! http://www.dedserius.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
Mysql performance monitoring?
Hello, I'm searching for a tool which will provide statistics about the usage of a mysql-server like avg queries/minute, cpu load etc. I've tried mysqler and liked it, but couldn't get it to start as a daemon. Are there any similar tools out there? Thanks in Advance, -- Mario Witte <[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: Many "Unauthenticatd Users"
On 2001.07.10 05:46:25 -0200 Gerlinde Fischer wrote: > Hi, > maybe you should use when connecting to mysql with the webserver instead > of > "pconnect" "connect". > Pconnect is persistent and is staying as long as you have set > the wait_timeout. It is set to 28800 sec by default. > > Regards Gerlinde > > At 15:17 09.07.01 -0200, you wrote: > >On 2001.07.09 11:04:35 -0200 Don Read wrote: > > > Stop Apache (or whatever the source of your logins), shut down & > restart > > > mysqld, then check/repair the tables in the mysql database; might > want > > > check > > > any other high activity tables also. > > > restart Apache. > > > >We already tried that. As long as we keep the webservers causing most of > >the traffic down everything works fine. When reactivating those servers > the > >problem reappears. > > > >Maybe mysql has problems inserting data into a table while doing a huge > >delete-query on the same table? > >(Around 2am the server has to delete something between 60 and 90 > >entries while still inserting new data into the table). > > > >-- > >Mario Witte <[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 > > BLITZ Internet Service GmbH >Kronacher Strasse 41 > D-96052 Bamberg, Germany > Tel. +49/951/9685160, Fax +49/951/9685164 >http://www.blitz.net > Hello, meanwhile we found a solution to the problem. After updating all server and clients to the mysql 3.23.39 the server stopped spawning those dead threads and about an hour later all dead threads had timed out. We still don't know why the problem occured so suddenly (the system had worked for weeks without any interruption before), but it doesn't occur anymore. With regards, -- Mario Witte <[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
Many "Unauthenticatd Users"
Hello, we are running a mysql-3.23-39 server under Suse 7.1 which has to do a very high number of insert-queries (somewhere around 600 queries/minute). But since yesterday the server kepps on spawing processes which are reported to belong to "Unauthenticated user" and in state "Login". This continues until max_connections is reached and then the server quits without further error messages. (Neither in the error log nor in the query-log). We have already tried reinserting all data from a dump, using a different server and different mysql-version. It shouldn't be a load problem, because before the problem occured the server (a Compaq Proliant with a 933 Mhz Xeon cpu) was running on a load average below 0.10. Any help will be appreciated, Thanks in Advance, -- Mario Witte <[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
