Richard Dice is a friend of mine, and has done a wonderful
tutorial on "Choosing the right database system" that I found
marvelous, at webmonkey:
http://hotwired.lycos.com/webmonkey/backend/databases/tutorials/tutorial1.ht
ml
Regards,
Kelly Black
Sprint PCS
Performance Engineering
Irvine, Ca. 9
Just run mysql in it's own little "jail"
with --user=mysql # or some username you add to the tables...
Regards,
Kelly Black
-Original Message-
From: Dimitar Haralanov [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 26, 2003 4:18 PM
To: [EMAIL PROTECTED]
Subject: Re: granting privileg
again?
-Original Message-
From: Don Read [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 26, 2003 8:44 PM
To: Black, Kelly W [PCS]
Cc: [EMAIL PROTECTED]
Subject: RE: sum() using group, and duplicates problems...
On 26-Mar-2003 Black, Kelly W [PCS] wrote:
> Thanks again Serge and Don,
>
&
Also you can do
mysql -u userid -p -h hostname dbname < /path/to/your/script.sql
Regards,
Kelly Black
Linux was very clearly the answer, but what was the question again?
-Original Message-
From: Anderson Pereira Ataides [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 27, 2003 5:37 AM
Usually there's a little more administrative work to limiting
usage...but it's up to you.
Regards,
~KB
-Original Message-
From: Jennifer Goodie [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 26, 2003 2:38 PM
To: Black, Kelly W [PCS]; 'Dimitar Haralanov'; [EMAIL PR
I think this might do what you want, but then you will be required to log
in with the -p syntax...
GRANT SELECT on *.* TO yourlogin@'%' IDENTIFIED BY "somepassword";
FLUSH PRIVILEGES;
mysql -u youruserid -p -h hostname dbasename
Regards,
Kelly Black
Linux was very clearly the answer, but what
r, release.
And not just DISTINCT measurement results.
Serge.
On Wed, 26 Mar 2003 12:00:24 -0600 (CST)
Don Read <[EMAIL PROTECTED]> wrote:
>
> On 26-Mar-2003 Black, Kelly W [PCS] wrote:
> > Don
> >
> > Thanks. I will have to change them and try that.
> >
.
Thanks for your help.
Regards,
Kelly W. Black
Linux was very clearly the answer, but what was the question again?
-Original Message-
From: Don Read [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 25, 2003 8:30 PM
To: Black, Kelly W [PCS]
Cc: Mysql (E-mail)
Subject: RE: sum() usi
You guys probably need to start mysql with the --skip-grant option
and fix the allow tables...
See the mysql.com website or google.com for "lost password" "mysql"
-Original Message-
From: Chee-Wai Yeung [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 25, 2003 5:09 PM
To: [EMAIL PROTECTED]
]
Sent: Tuesday, March 25, 2003 4:13 PM
To: Black, Kelly W [PCS]
Subject: Re: mysql install---help please
I typed in
/usr/local/mysql/bin/mysql -u userid -p -h localhost password:
prompted for password, gave only one I ever use
response was
ERROR 1045: Access denied for user: '[EMAIL PROT
Try
/usr/local/mysql/bin/mysql -u userid -p -h hostname
password:
mysql>
Regards,
Kelly Black
Linux was very clearly the answer, but what was the question again?
-Original Message-
From: Jennifer Goodie [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 25, 2003 3:16 PM
To: katherine bjo
Try using
GRANT ALL ON Security.* TO newbuddy@'%' INDENTIFIED BY 'password';
Regards,
Kelly Black
Linux was very clearly the answer, but what was the question again?
-Original Message-
From: Terrance Win [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 25, 2003 12:57 PM
To: [EMAIL PROTEC
Hello.
Sorry for the long post. This has been a big problem for me, and I
hope someone will help...
I have a long standing problem with an MySQL query.
Or perhaps a couple of sql query problems...
Firstly I have been told I cannot use sum() on a value while using
group by "parm" because it's n
Cute.
sql, query
~K Black
-Original Message-
From: [EMAIL PROTECTED] [mailto:mysql-help@;lists.mysql.com]
Sent: Thursday, November 14, 2002 6:38 AM
To: Black, Kelly W [PCS]
Subject: confirm unsubscribe from [EMAIL PROTECTED]
Hi! This is the ezmlm program. I'm managing the
[
If you ran into any problems it would probably
be RAM. RAM is cheap so if you have trouble...just
pop a couple of 512MB chips in it.
~KB
-Original Message-
From: Jeremy Zawodny [mailto:Jeremy@;Zawodny.com]
Sent: Wednesday, November 13, 2002 11:12 AM
To: Devore, Jacob
Cc: '[EMAIL PROTECTE
You might need to use rpm -e to uninstall previous version first.
Check the documentation.
~Kelly W. Black
-Original Message-
From: Rick Root [mailto:rroot@;wakeinternet.com]
Sent: Wednesday, November 13, 2002 10:47 AM
To: mysql
Subject: Upgrading MySQL from 3.23.41 to 3.23.53a
I woul
Did you remember to allow backwards compatibility in @INC
for perl 5.6.1?
~K Black
-Original Message-
From: Octavian Rasnita [mailto:orasnita@;home.ro]
Sent: Wednesday, November 13, 2002 2:58 AM
To: MySQL List
Subject: Using MySQL with Perl 5.8?
Hi all,
I was able to install the modul
27.0.0.1 localdomain.localhost localhost
~Kelly W. Black
-Original Message-
From: Phil Iovino [mailto:phil@;nxtek.net]
Sent: Wednesday, November 13, 2002 10:36 AM
To: 'Paul DuBois'; Black, Kelly W [PCS]; 'Scott Pippin'
Cc: [EMAIL PROTECTED]
Subject: RE: Installation Help
It doesn't appear this part is valid sql, query
DATA_DIRECTORY="/tmp";
~K Black
-Original Message-
From: Yuyi Guo [mailto:yuyi@;fnal.gov]
Sent: Wednesday, November 13, 2002 9:21 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: create table w/ data/index directory
Hi,
I am usin
Right.
My mistake.
I think you get the general idea.
~K Black
-Original Message-
From: Paul DuBois [mailto:paul@;snake.net]
Sent: Tuesday, November 12, 2002 4:21 PM
To: Black, Kelly W [PCS]; 'Phil Iovino'; 'Scott Pippin'
Cc: [EMAIL PROTECTED]
Subject: RE: Installa
Get on out there with your bad self Michael !!
:)
~KB
-Original Message-
From: Michael T. Babcock [mailto:mbabcock@;fibrespeed.net]
Sent: Tuesday, November 12, 2002 3:23 PM
To: David Kramer
Cc: '[EMAIL PROTECTED]'
Subject: Re: Why does safe_mysqld runs as root?
David Kramer wrote:
>By
Check if mysqld or some other process uses all
available memory. If not you may have to use
'ulimit' to allow mysqld to use more memory
or you can add more swap space",
If it persists, use vmstat 1
~Kelly W Black
-Original Message-
From: Jeremy Zawodny [mailto:Jeremy@;Zawodny.com]
Sent
See the file INSTALL_BINARY
~KB
-Original Message-
From: Pierre [mailto:pierre@;epinetworx.com]
Sent: Tuesday, November 12, 2002 1:45 AM
To: [EMAIL PROTECTED]
Subject: Problem compiling mysqlgui 1.7.5
Hi,
I try to compile mysqlgui-src-1.7.5 on my GNU/Linux system with gcc-3.2
but with
Make sure you issued the correct GRANT statements
at the sql, query.
mysql>use mysql;
Database Changed
mysql> GRANT * ON *.* TO '[EMAIL PROTECTED]' IDENTIFIED BY 'somepassword';
#note that will give FULL access...see the docs to restrict this.
mysql> FLUSH PRIVILEGES;
0 Rows Affected.
~Kelly W.
Don't re-install.. Fix the problem
Try issuing
shell>cd /usr/local/mysqlversion
shell>./configure
~K Black
-Original Message-
From: mod_perl [mailto:shine_perl@;spectrum.net.in]
Sent: Monday, November 11, 2002 10:23 PM
To: [EMAIL PROTECTED]
Subject: unable to start mysql
hi all,
when
Make sure when you are creating the database that
U_Number | int(9) unsigned | | PRI | NULL
is
U_Number | numeric() | | PRI | NULL
-Original Message-
From: Petre Agenbag [mailto:internet@;boesmanland.com]
Sent: Tuesday, November 12, 2002 4:27 AM
To: [E
You don't have a compiler installed? Hmmm. This seems tough to
believe.
Try issuing 'which cc'
~K Black
-Original Message-
From: leaddog1 [mailto:jsobeck@;lead-dog.net]
Sent: Tuesday, November 12, 2002 6:44 AM
To: [EMAIL PROTECTED]
Subject: Solaris 2.6
Is there any version of MySQL wi
Make sure some previous version of MySql isn't running.
I have seen this on systems which had the OS installed version
of MySql, and I had to issue
shell> /sbin/service mysql stop
shell> cd /usr/local/mysqlversion
shell> ./bin/mysqld_safe -user=theuserid
Hope this helps...
~Kelly W. Black
---
I have been using the MySql 4.x MAX with absolutely
NO problems. It's being used on heavily operated servers,
and I upgraded to 4.x for it's incredible index speeds and
it's VERY reliable to me.
In fact, in our local benchmarks it's kicking the living crap out
of Oracle on sql, query. :)
~Kelly
Michael I have a nice perl program I wrote that I use to dump
from MySql to a tab delimited ASCII file. I would
pass it along if you think it would help...
~Kelly W. Black
-Original Message-
From: Michael T. Babcock [mailto:mbabcock@;fibrespeed.net]
Sent: Monday, November 11, 2002 2:38
.
~Kelly W. Black
-Original Message-
From: [EMAIL PROTECTED] [mailto:CZachary@;wiley.com]
Sent: Monday, November 11, 2002 1:48 PM
To: Adolfo Bello
Cc: Black, Kelly W [PCS]; Mysql Lists
Subject: RE: /tmp/mysql.sock question (newbie)
There is a cleanup script run via cron that removes files from
XFS is X server Font Server, and is unrelated.
~Kelly W. Black
-Original Message-
From: David Kramer [mailto:DKramer@;reflect.com]
Sent: Monday, November 11, 2002 1:51 PM
To: [EMAIL PROTECTED]
Subject: Mysql starts under XFS on boot up???
I noticed that Mysql starts up under XFS, Im not
mysql.sock /tmp/mysql.sock
and things seem to work fine.
~K Black
-Original Message-
From: Adolfo Bello [mailto:adolfobello@;bisapi.com]
Sent: Monday, November 11, 2002 1:32 PM
To: Black, Kelly W [PCS]
Cc: Mysql Lists
Subject: RE: /tmp/mysql.sock question (newbie)
I am also a newbi
Can you post about 30 seconds worth of
the vmstat 1 command when the system
is busy?
Thanks
~Kelly W. Black
-Original Message-
From: [EMAIL PROTECTED] [mailto:kahnmatt@;engin.umich.edu]
Sent: Monday, November 11, 2002 11:09 AM
To: [EMAIL PROTECTED]
Subject: Commands out of sync
Hi-
I'
You can do this in /etc/my.cnf
~K Black
-Original Message-
From: [EMAIL PROTECTED] [mailto:CZachary@;wiley.com]
Sent: Monday, November 11, 2002 10:05 AM
To: [EMAIL PROTECTED]
Subject: /tmp/mysql.sock question (newbie)
Hello all, I would like to change where the /tmp/mysql.sock file get
This may be a (hmmmpf) dumb question or maybe the docs say,
but I cannot find it.
When posting this list regarding sql, query, and other info :) does the
list server modify the posts to a maximum width? (For all using terminals
to browse?)
If so what is the line width? (80 characters?)
I wanted
kvars=yes'
If this didn't confuse you let me know I will try to confuse you again.
~Kelly W. Black
sql, query
-Original Message-
From: SpyProductions Support Team [mailto:support@;spyproductions.com]
Sent: Friday, November 08, 2002 2:26 PM
To: Black, Kelly W [PCS]
Cc: [EMAIL P
check out http://www.rpmfind.net/
-Original Message-
From: SpyProductions Support Team [mailto:support@;spyproductions.com]
Sent: Friday, November 08, 2002 12:51 PM
To: Black, Kelly W [PCS]
Cc: [EMAIL PROTECTED]
Subject: RE: MysQL Installation
Well hells bells!
Would that be the '
Mysqladmin is seperate rpm
~K Black
-Original Message-
From: SpyProductions Support Team [mailto:support@;spyproductions.com]
Sent: Friday, November 08, 2002 11:13 AM
To: [EMAIL PROTECTED]
Subject: MysQL Installation
I just installed the most recent version of MySQL with an RPM (throug
Several things.
Don't use root to connect remotely.
Run mysqld as a userid on the server not root.
You may need to grant on mysql database for more than localhost.
Such as
(Note this grants all privileges to all databases. See mysql docs
for restricted access)
GRANT * ON *.* TO 'userid' IDENT
Make sure /etc/hosts has this line
127.0.0.1 localhost
~Kelly W. Black
-Original Message-
From: Kevin Passey [mailto:kpassey@;kdpsoftware.co.uk]
Sent: Thursday, November 07, 2002 4:38 AM
To: 'Timothy Venn'; Mysql (E-mail)
Subject: RE: Host not allowed to connect problem
Hello Tim,
Are
This is incorrect.
!google "new line character" linux windows
-Original Message-
From: Gelu Gogancea [mailto:ggelu@;arctic.ro]
Sent: Wednesday, November 06, 2002 11:33 AM
To: Black, Kelly W [PCS]; Schroeder, Bradley (Contractor);
[EMAIL PROTECTED]
Subject: Re: Problem importing
I have seen this when Windows was involved.
Windows word and note pads have a different new
line character than Un*x type systems.
Perhaps that's what's foiling the sql query.
~K Black
-Original Message-
From: Gelu Gogancea [mailto:ggelu@;arctic.ro]
Sent: Wednesday, November 06, 2002 10
Try using dashes.
-mm-dd
-Original Message-
From: Andrew Sitnikov [mailto:sitnikov@;infonet.ee]
Sent: Wednesday, November 06, 2002 9:39 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: DateTime comparation problems
Hello bugs,
SELECT ... FROM table o WHERE o.date >= 20020901
Also see
http://hotwired.lycos.com/webmonkey/backend/databases/tutorials/tutorial1.ht
ml
It helped me a lot here...
sql query by the man
~Kelly W. Black
-Original Message-
From: Daniel Kasak [mailto:dkasak@;nusconsulting.com.au]
Sent: Tuesday, November 05, 2002 2:49 PM
To: Alain Motas
Take a look at "meta syntactics".
For example (using perl)
my $dbh = DBI->connect('DBI:mysql:SD2:localhost', 'root','') or die
"Couldn't connect to database $!\n";
my $SQL =<<"EOT";
insert into
table(col1,col2,col3,col4,col5,col6,col7,col8,col9,col10,col11,col12,col13,c
ol14,col15,col16,c
So use the C syntx instead.
:)
-Original Message-
From: Steven Webb [mailto:scumola@;yahoo.com]
Sent: Tuesday, November 05, 2002 12:21 PM
To: Black, Kelly W [PCS]; Mysql list
Subject: RE: using libmysqld - can't connect to remote DB as client.
Ok, but I'm writing this in C
I have had problems with this kind of statement:
date = DATE
Try
date = 'DATE'
or even
date =curdate();
Note you can subtract
date = curdate()-1;
I have encountered no problems with upper/lower case in Linux
and Mysql.
~Kelly W. Black
-Original Message-
From: John Ragan [mailto:j
I think your problem might be here ->
you have db_connect("my_blah_database");
Try using something like
my $dbh = DBI->connect("DBI:mysql:$dbname:hostname", $dbuser, $dbpasswd) ||
die "can't connect: $DBI::errstr\n";
Also make sure you include the || die "can't connect: $DBI::errstr\n";
as in th
Note also there are methods to control loads under MySql.
You can use limits from the environment shell to
keep the load averages down.
People may say this is not in good form, or style,
but it works for me.
There are several methods you can use within the my.cnf
to streamline the MySql server
Make sure you use the complete line of syntax
mysqladmin -u username -p -h hostname create databasename
password: (enter the password to that userid here)
Oh yeah sql query .
~Kelly W. Black
-Original Message-
From: john [mailto:john@;cllug.org]
Sent: Monday, November 04, 2002 3:53 P
Try using
shell>mysqladmin -u root -p -h hostname databasetobecreated
password:
~Kelly W. Black
-Original Message-
From: Admin-Stress [mailto:meerkapot@;yahoo.com]
Sent: Monday, November 04, 2002 2:41 PM
To: [EMAIL PROTECTED]
Subject: newbie: creating database error
After playing aroun
Message-
From: James Northcott [mailto:jnorthcott@;dpmg.com]
Sent: Monday, November 04, 2002 2:29 PM
To: Black, Kelly W [PCS]
Subject: RE: Interesting Challenge
> I have tried with and without having. Neither works.
>
> If you try running the query without cell, or sector, the
>
Try using
mysql>show variables;
Some variables can be exported to the sql server via the environment table.
For example:
shell>ulimit=2046
shell>export ulimit
shell>mysqld restart
Hope this helps,
~Kelly W. Black
-Original Message-
From: Nissim Lugasy [mailto:lugasy@;lerc.nasa.gov]
S
This simply returns me to the documentation.
Thanks
-Original Message-
From: James Northcott [mailto:jnorthcott@;dpmg.com]
Sent: Monday, November 04, 2002 12:13 PM
To: Mysql (E-mail)
Subject: RE: Interesting Challenge
> mysql> SELECT cell, sector,
If you only want one row, then sel
More appropriately, use curdate()feature from within sql.
select * where date= < curdate()-1;
for example
~Kelly W. Black
-Original Message-
From: Benjamin Pflugmann [mailto:benjamin-mysql@;pflugmann.de]
Sent: Monday, November 04, 2002 1:06 PM
To: Jim Hogan
Cc: [EMAIL PROTECTED]
Subject
You might also need to add hostname.
It depends on what GRANT sql statement was
used to add the user id.
Something like
mysql -u userid -p -h hostname dbasename
should work.
If not, check that mysqld is in fact running. You can
use
ps -aux | grep mysql
Regards,
~Kelly W. Black
-Orig
Hi sql query wizards!
I need some help.
Is there a way I can take this query here =>
mysql> SELECT cell, sector,
-> sum(att) as att,
-> sum(lc) as lc,
-> sum(csh) as csh,
-> ROUND((SUM( lc + csh ) * 100 ) / (SUM(att) - SUM(tccf + bpp + bpc +
suf)),2) AS drops,
-> sum(tccf) as
Use the ROUND statement
ROUND(sum(CLICKS),sum(IMPS)/sum(CLICKS)*100.0,0),2);
-Original Message-
From: David Garamond [mailto:davegaramond@;icqmail.com]
Sent: Sunday, November 03, 2002 2:31 AM
To: [EMAIL PROTECTED]
Subject: rounding behaviour
hi,
mysql> select 1/29;
+--+
| 1/29 |
+-
Typically if your OS runs, the mysql will too.
You should only be worried with hardware
if you are running large database apps
on a slow system.
-Original Message-
From: Stephen Hitchner [mailto:steve@;number41media.com]
Sent: Friday, November 01, 2002 9:40 PM
To: Mysql
Subject: mysql die
If you have installed MySql in some
non-standard location, or if the original
installation was from the OS install, it
may be that you need to link the socks.
I have done this, others will probably
complain. I had this problem on many
systems newly installed. I fixed it with
ln -s /var/lib/path/t
I have done this on about 72,000 domains.
Set up one master group.
Allow databases to be created under the name the user wants.
Then configure the grant statement so that it uses their virtual host name.
GRANT ALL on dbasename TO [EMAIL PROTECTED] IDENTIFIED BY
'somepassword';
FLUSH PRIVILEGES;
Okay killall -HUP then
-Original Message-
From: Mark [mailto:admin@;asarian-host.net]
Sent: Thursday, October 31, 2002 6:45 PM
To: Black, Kelly W [PCS]; 'CM Miller'; [EMAIL PROTECTED]
Subject: Re: Still not getting a mysql prompt
- Original Message -----
From: "Blac
Make sure you are logging in as indicated in the docs.
Something along these lines (from local host)
shell> mysql -u username -p hostname databasename
if hostname (being your hosts domain name) doesn't work
try "localhost"
It may be possible that mysql needs to be owned over to
a user id on th
It's all right here => http://www.mysql.com/manual.php
-Original Message-
From: John Meyer [mailto:johnmeyer_1978@;yahoo.com]
Sent: Thursday, October 31, 2002 1:49 PM
To: [EMAIL PROTECTED]
Subject: Creating users through SQL
How do I create users for a specific database using SQL?
-
Michael
Heheheh lmao!
I can see what you mean
oh yea sql query!
~K Black
-Original Message-
From: Michael T. Babcock [mailto:mbabcock@;fibrespeed.net]
Sent: Thursday, October 31, 2002 12:11 PM
To: '[EMAIL PROTECTED]'
Subject: Re: sql query
Black, Kelly W [PCS] wrote
-
From: [EMAIL PROTECTED] [mailto:mysql-help@;lists.mysql.com]
Sent: Thursday, October 31, 2002 2:14 PM
To: Black, Kelly W [PCS]
Subject: confirm unsubscribe from [EMAIL PROTECTED]
Hi! This is the ezmlm program. I'm managing the
[EMAIL PROTECTED] mailing list.
To confirm that you would like
You must issue
flush privileges;
to the sql query line.
~K Black
-Original Message-
From: alex [mailto:alex@;dynaweb.ru]
Sent: Thursday, October 31, 2002 11:06 AM
To: [EMAIL PROTECTED]
Subject: access denied for user with granted privileges
Hi ppl!
I've got a strange problem.
I've c
Try compiling form source instead of running binary.
~K Black
-Original Message-
From: Mark [mailto:admin@;asarian-host.net]
Sent: Thursday, October 31, 2002 12:33 PM
To: heath boutwell; [EMAIL PROTECTED]
Subject: Re: Thread Thrashing and 3.23.53a
- Original Message -
From: "hea
compile mysql with
./configure --with-memory-limit=
I forget the exact syntax.
It's also possible to pass the limit on via the env.
try using "show variables;"
as your sql query, and read how my.cnf is affecting the
settings.
Then you can export memory limits with ulimit to env from the
shel
Joe
You might want to try owning all the mysql files over to
a userid like "mysql" and then use
cd /usr/local/mysql-ver.
./bin/mysqld_safe --user=mysql &
sql query
Regards
~K Black
-Original Message-
From: Joe M [mailto:joe_m@;circlepressroom.com]
Sent: Thursday, October 31, 2002 11:1
Almost all modern unix type systems come with the powerd daemon.
-Original Message-
From: Jan Steinman [mailto:Jan@;Bytesmiths.com]
Sent: Thursday, October 31, 2002 10:46 AM
To: [EMAIL PROTECTED]
Subject: UPS (Was: Mysql in Innodb)
>From: gerald_clark <[EMAIL PROTECTED]>
>
>A UPS is of
pico /etc/services
ulimit 2 # size in k
BTW
It cannot remove files in use.
It would simply generate cron errors
-Original Message-
From: Lars Andersson [mailto:lars@;rockar.nu]
Sent: Thursday, October 31, 2002 11:05 AM
To: Black, Kelly W [PCS]
Cc: [EMAIL PROTECTED]
Subject: RE
#!/usr/local/bin/perl
use strict;
my @files=(`/bin/ls /tmp/sql*.M*`);
for (@files) {
unlink;
}
exit 0;
shell> crontab -e
0 2 * * * /usr/local/bin/perl /path/to/delete/program
:wq
:)
-Original Message-
From: Lars Andersson [mailto:lars@;rockar.nu]
Sent: Thursday, October 31, 2002 9:56 A
Hi,
I could use some advice on this query.
SELECT cell, sum(att) as att , sum(lc) as lc , sum(csh) as csh,
ROUND((SUM( lc + csh ) * 100 ) / (SUM(att) - SUM(tccf + bpp + bpc + suf)),2)
AS drops, sum(tccf) as tccf, sum(bpp) as bpp, sum(bpc) as bpc, sum(suf) as
suf,
ROUND((SUM( tccf + bpp + bpc
use this
Shell>TMPDIR=/tmp
Shell>export TMPDIR
restart mysql.
-Original Message-
From: CM Miller [mailto:cmmiller1973@;yahoo.com]
Sent: Thursday, October 31, 2002 9:42 AM
To: [EMAIL PROTECTED]
Subject: How do I log into MySQL?
I can start/stop the daemon for MySQL with no problem.
Pretty lame.
-Original Message-
From: [EMAIL PROTECTED] [mailto:mysql@;lists.mysql.com]
Sent: Thursday, October 31, 2002 11:58 AM
To: Black, Kelly W [PCS]
Subject: Re: SELECT
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass
The government has a white paper on this.
Just !google "benchmark MySQL"
-Original Message-
From: Benji Spencer [mailto:ben.spencer@;moody.edu]
Sent: Thursday, October 31, 2002 9:36 AM
To: Benjamin Pflugmann
Cc: [EMAIL PROTECTED]
Subject: Re: How much data can MySQL push out?
>Sorry,
78 matches
Mail list logo