Read / Write statistics
Hi, I am trying to obtain read/write statistics from our database (4.0.21). I started by using the Bytes_received and Bytes_sent from "show status"; however, today one of them (Bytes_sent) reset itself to 0... Which really messes up my calculations... I need this data... Is there any other way to obtain it? I was doing: $Total_bytes = ( $Bytes_received + $Bytes_sent ); $Percentage_received = ( ( $Bytes_received * 100 ) / \ $Total_bytes )); However, it won't work when the counter clears itself. Is there a way to se that value to unsigned bigint? Is there any other way? Beforehand, thank you for your help! __ Celebrate Yahoo!'s 10th Birthday! Yahoo! Netrospective: 100 Moments of the Web http://birthday.yahoo.com/netrospective/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Multiple table join help
All, I have done some reading and research; however, I seem to be at a loss... And this time, I am not sure how to ask Google... Here is the problem: Table A: id INT valuevarchar (10) Table B: id INT valuevarchar (10) Table C: id INT AINT BINT DINT Table D: id INT ... other_values Table C is in order to "normalize" values for A and B So, I want to be able to do a query to C that returns the id values of D in order to cross reference that table later. Since table C only knows the numeric values of the string, I need to be able to do so as part of the query by comparing C.a with A.id; however, I also need to compare with the value string... Now, I can do that with one table (A, for example): mysql> select C.D from C, A -> where C.a = A.id AND A.value='berry'; However, I am not sure how to add the next condition: -> where C.b = B.id AND B.value='fruit'; That would allow me to obtain the values on C where A.value = berry and B.value = fruit; however using the numeric values of A.id and B.id There most be a simple solution... To add to the problem, I am using MySQL 4.0.15, so the multiple select would not work... Any help would be appreciated as I have little hair left!!! Beforehand, thank you for the help! __ Do you Yahoo!? Yahoo! Mail - You care about security. So do we. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Database hung; please help!
All, I found my database "hung" this morninig on a Linux system. I could not connect locally to /tmp/mysql.sock or remotelly. I tried to do a "mysqladmin status"; but that hung too. Linux was reporting high CPU utilization. The proces infromation is as follows: Name: mysqld State: T (stopped) SleepAVG: 83% Tgid: 10326 Pid:10326 PPid: 10309 TracerPid: 0 Uid:60 60 60 60 Gid:60 60 60 60 FDSize: 256 Groups: 60 VmSize:73964 kB VmLck: 0 kB VmRSS: 33664 kB VmData:67312 kB VmStk:32 kB VmExe: 3964 kB VmLib: 2316 kB Threads:25 SigPnd: 0004 ShdPnd: SigBlk: 00085007 SigIgn: 1006 SigCgt: 800064e9 CapInh: CapPrm: CapEff: The CPU and memory information were OK (only high CPU utliziation to about 70%) Any ideas? Beforehand, thank you for your help! __ Do you Yahoo!? Jazz up your holiday email with celebrity designs. Learn more. http://celebrity.mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: RESEND: Compilation of MySQL with OpenSSL in alternate location.
Mr. Fisher, Yes, that seems to be the problem... It is adding a space before the path. Also, the path should be static; however, it is using ../data which is wrong since I am compiling under /data/Software/mysql and the OpenSSL directory is directly under /data. I did a grep for /data/OpenSSL and can not see where the translation is done. Do you have an idea? Is this a bug I should report? Thank you VERY much for everybody's help! Best regards, E SA --- "Douglas K. Fischer" <[EMAIL PROTECTED]> wrote: > V. M. Brasseur wrote: > > > E SA wrote: > > > >> gcc -DDEFAULT_CHARSET_HOME=\"/data/MySQL\" > >> -DDATADIR=\"/data/MySQL/var\" > >> -DSHAREDIR=\"/data/MySQL/share/mysql\" > -DDONT_USE_RAID > >> -I. -I. -I.. -I./../include -I../include -I./.. > -I.. > >> -I.. /data/OpenSSL/include/openssl -O3 -DDBUG_OFF > -MT > >> libmysql.lo -MD -MP -MF .deps/libmysql.Tpo -c > >> libmysql.c -o libmysql.o > >> gcc: cannot specify -o with -c or -S and multiple > >> compilations > >> make[2]: *** [libmysql.lo] Error 1 > >> make[2]: Leaving directory > >> `/data/software/tars/mysql-4.0.20/libmysql_r' > >> make[1]: *** [all-recursive] Error 1 > >> make[1]: Leaving directory > >> `/data/software/tars/mysql-4.0.20' > >> make: *** [all] Error 2 > > > > > > This problem is not related either to OpenSSL or > to OpenSSH. The main > > error above is "gcc: cannot specify -o with -c or > -S and multiple > > compilations". That means the problem lies with > GCC or, more > > specifically, with the parameters which are being > passed to it. > > Exactly. From just a cursory look at your gcc > output, it appears there > is extraneous space character in the 5th line: > > -I.. /data/OpenSSL/include/openssl > > should instead be > > -I../data/OpenSSL/include/openssl > > This line is telling gcc to include the > ../data/OpenSSL/include/openssl > directory in its search for header files. The extra > space causes gcc to > parse the command line incorrectly, resulting in > your error message. > > Cheers, > > Doug > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > ___ Do you Yahoo!? Win 1 of 4,000 free domain names from Yahoo! Enter now. http://promotions.yahoo.com/goldrush -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: RESEND: Compilation of MySQL with OpenSSL in alternate location.
Miss Brasseur, Sorry for the Mr... You are right. Id did not know. The reason why I think it was SSL related is because that error only comes up when I try to compile with SSL support. Also, on the includes where the compiler fails, you can see: -I.. /data/OpenSSL/include/openssl Which points to the fact that it is trying to look at the OpenSSL include files in order to create that specific binary... I will try the suggested solutions today and post back to the group to give an update. Best regards, E SA --- "V. M. Brasseur" <[EMAIL PROTECTED]> wrote: > E SA wrote: > > Mr. Brasseur, > > "Miss" Brasseur, but you could not have known so no > offense is taken. > > > OpenSSH is installed in the server in its default > > location. Still, no luck. > > > > Configure goes on without problems, and then make > > gives me the following error message: > > > > > > gcc -DDEFAULT_CHARSET_HOME=\"/data/MySQL\" > > -DDATADIR=\"/data/MySQL/var\" > > -DSHAREDIR=\"/data/MySQL/share/mysql\" > -DDONT_USE_RAID > > -I. -I. -I.. -I./../include -I../include -I./.. > -I.. > > -I.. /data/OpenSSL/include/openssl -O3 -DDBUG_OFF > -MT > > libmysql.lo -MD -MP -MF .deps/libmysql.Tpo -c > > libmysql.c -o libmysql.o > > gcc: cannot specify -o with -c or -S and multiple > > compilations > > make[2]: *** [libmysql.lo] Error 1 > > make[2]: Leaving directory > > `/data/software/tars/mysql-4.0.20/libmysql_r' > > make[1]: *** [all-recursive] Error 1 > > make[1]: Leaving directory > > `/data/software/tars/mysql-4.0.20' > > make: *** [all] Error 2 > > > > > > Any other ideas? > > This problem is not related either to OpenSSL or to > OpenSSH. The main > error above is "gcc: cannot specify -o with -c or -S > and multiple > compilations". That means the problem lies with GCC > or, more > specifically, with the parameters which are being > passed to it. > > A quick Google search on the GCC error turned up > some hints. For > starters, according to this article, you should have > a look at your > imake: > http://gcc.gnu.org/ml/gcc/1998-11/msg00367.html > > It is, however, an old posting and therefore might > not apply in this > case. Which version of GCC are you using? You may > need to consider > upgrading it. Many of the references turned up in > the Google search > speak of this as a good idea. > > Here is the Google search which was performed. > Please read through the > references available here and give some things a > try: > http://www.google.com/search?hl=en&lr=&ie=UTF-8&q=%22gcc%3A+cannot+specify+-o+with+-c+or+-S+and+multiple%22&btnG=Search > > Cheers, > > --V > > > Thank you for your help! > > > > > > > > --- "V. M. Brasseur" <[EMAIL PROTECTED]> wrote: > > > > > >>OpenSSH != OpenSSL. Just because you have one > >>installed doesn't mean > >>that the other is. Apparently the MySQL > compilation > >>using OpenSSL > >>requires OpenSSH for some reason. You might want > to > >>try installing it > >>and giving the compile another whirl: > >> > >>http://www.openssh.com/ > >> > >>Also, the exact output of the ./configure message > >>you're receiving might > >>help people get a better handle on exactly what > the > >>problem might be. > >> > >>Cheers, > >> > >>--V > >> > >>E SA wrote: > >> > >>>All, > >>> > >>>I already sent this message once, but I got no > >> > >>answer. > >> > >>>Has naybody successfully compiled MySQL with > >> > >>OpenSSL > >> > >>>NOT in /usr/local/ssl? > >>> > >>>I can not use stunnel, and I have not found > >> > >>anything > >> > >>>in > >>>google. > >>> > >>>Please let me know. > >>> > >>>- - - - - - - - - - - - - - - - - - - - - - - - - > >> > >>- - > >> > >>>- > >>> > >>>Original post: > >>> > >>> > >>>All, > >>> > >>>I am trying to compile MySQL with OpenSSL in an > >>>alternate location ( /data/OpenSSL ). > >>> > >>>When I do that either configure will say that no > >&
Re: RESEND: Compilation of MySQL with OpenSSL in alternate location.
Mr. Brasseur, OpenSSH is installed in the server in its default location. Still, no luck. Configure goes on without problems, and then make gives me the following error message: gcc -DDEFAULT_CHARSET_HOME=\"/data/MySQL\" -DDATADIR=\"/data/MySQL/var\" -DSHAREDIR=\"/data/MySQL/share/mysql\" -DDONT_USE_RAID -I. -I. -I.. -I./../include -I../include -I./.. -I.. -I.. /data/OpenSSL/include/openssl -O3 -DDBUG_OFF -MT libmysql.lo -MD -MP -MF .deps/libmysql.Tpo -c libmysql.c -o libmysql.o gcc: cannot specify -o with -c or -S and multiple compilations make[2]: *** [libmysql.lo] Error 1 make[2]: Leaving directory `/data/software/tars/mysql-4.0.20/libmysql_r' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/data/software/tars/mysql-4.0.20' make: *** [all] Error 2 Any other ideas? Thank you for your help! --- "V. M. Brasseur" <[EMAIL PROTECTED]> wrote: > OpenSSH != OpenSSL. Just because you have one > installed doesn't mean > that the other is. Apparently the MySQL compilation > using OpenSSL > requires OpenSSH for some reason. You might want to > try installing it > and giving the compile another whirl: > > http://www.openssh.com/ > > Also, the exact output of the ./configure message > you're receiving might > help people get a better handle on exactly what the > problem might be. > > Cheers, > > --V > > E SA wrote: > > All, > > > > I already sent this message once, but I got no > answer. > > > > Has naybody successfully compiled MySQL with > OpenSSL > > NOT in /usr/local/ssl? > > > > I can not use stunnel, and I have not found > anything > > in > > google. > > > > Please let me know. > > > > - - - - - - - - - - - - - - - - - - - - - - - - - > - - > > - > > > > Original post: > > > > > > All, > > > > I am trying to compile MySQL with OpenSSL in an > > alternate location ( /data/OpenSSL ). > > > > When I do that either configure will say that no > > installation of OpenSSH is there (even with the > > --with-openssl-includes= and --with-openssl-libs= > ), > > or it will compile without OpenSSL support ( show > > variables like ... ). > > > > My configure is as follows: > > > > ./configure --prefix=/data/MySQL > > --exec-prefix=/data/MySQL \ > > --enable-thread-safe-client --enable-assembler \ > > --enable-local-infile > --with-extra-charsets=complex \ > > --disable-shared --with-openssl=/data/OpenSSL \ > > --without-docs --with-vio > > > --with-openssl-includes=/data/OpenSSL/include/openssl > > \ > > --with-openssl-libs=/data/OpenSSL/lib > > > > Has anybody successfully compiled MySQL with > OpenSSL > > support in an alternate location? > > > > The MySQL version is 4.0.20. > > > > Any help would be appreciated. > > > > > > > > __ > > Do you Yahoo!? > > New and Improved Yahoo! Mail - Send 10MB messages! > > http://promotions.yahoo.com/new_mail > > > __ Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RESEND: Compilation of MySQL with OpenSSL in alternate location.
All, I already sent this message once, but I got no answer. Has naybody successfully compiled MySQL with OpenSSL NOT in /usr/local/ssl? I can not use stunnel, and I have not found anything in google. Please let me know. - - - - - - - - - - - - - - - - - - - - - - - - - - - - Original post: All, I am trying to compile MySQL with OpenSSL in an alternate location ( /data/OpenSSL ). When I do that either configure will say that no installation of OpenSSH is there (even with the --with-openssl-includes= and --with-openssl-libs= ), or it will compile without OpenSSL support ( show variables like ... ). My configure is as follows: ./configure --prefix=/data/MySQL --exec-prefix=/data/MySQL \ --enable-thread-safe-client --enable-assembler \ --enable-local-infile --with-extra-charsets=complex \ --disable-shared --with-openssl=/data/OpenSSL \ --without-docs --with-vio --with-openssl-includes=/data/OpenSSL/include/openssl \ --with-openssl-libs=/data/OpenSSL/lib Has anybody successfully compiled MySQL with OpenSSL support in an alternate location? The MySQL version is 4.0.20. Any help would be appreciated. __ Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages! http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Compiling MySQL with OpenSSL on alternate location
All, I am trying to compile MySQL with OpenSSL in an alternate location ( /data/OpenSSL ). When I do that either configure will say that no installation of OpenSSH is there (even with the --with-openssl-includes= and --with-openssl-libs= ), or it will compile without OpenSSL support ( show variables like ... ). My configure is as follows: ./configure --prefix=/data/MySQL --exec-prefix=/data/MySQL \ --enable-thread-safe-client --enable-assembler \ --enable-local-infile --with-extra-charsets=complex \ --disable-shared --with-openssl=/data/OpenSSL \ --without-docs --with-vio --with-openssl-includes=/data/OpenSSL/include/openssl \ --with-openssl-libs=/data/OpenSSL/lib Has anybody successfully compiled MySQL with OpenSSL support in an alternate location? The MySQL version is 4.0.20. Any help would be appreciated. Best regards, ES __ Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages! http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Compiling MySQL with OpenSSL
All, I am trying to compile MySQL with OpenSSL in an alternate location ( /data/OpenSSL ). When I do that either configure will say that no installation of OpenSSH is there (even with the --with-openssl-includes= and --with-openssl-libs= ), or it will compile without OpenSSL support ( show valiables like ... ). My configure is as follows: ./configure --prefix=/data/MySQL --exec-prefix=/data/MySQL \ --enable-thread-safe-client --enable-asembler \ --enable-local-infile --with-extra-charsets=complex \ --disable-shared --with-openssl=/data/OpenSSL \ --without-docs --with-vio --with-openssl-includes=/data/OpenSSL/include/openssl \ --with-openssl-libs=/data/OpenSSL/lib Has anybody suceessfuly compiled MySQL with OpenSSL support in an alternate location? The MySQL version is 4.0.20. Any help would be appreciated. Best regards, ES __ Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages! http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
