time mysql is restarted (for example on a reboot).
---
William R. Mussatto, Senior Systems Engineer
http://www.csz.com
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
On Mon, March 12, 2007 8:04, Neil Tompkins said:
I've been researching the best method to store credit card numbers in a
database which are saved encrypted. My version of mysql is 3.23 therefore
I
think the only function I could use is
ENCODE() and DECODE().
I've tried these functions and
On Tue, March 6, 2007 9:40, Marcus Bointon said:
On 6 Mar 2007, at 17:12, David T. Ashley wrote:
Best practice is that all times maintained in a database (or
anywhere on the
server) are UTC, and are only converted to local timezone and/or
adjusted to
daylight savings time as required to
On Wed, February 28, 2007 14:10, Ryan Stille said:
I am on 4.1.20-1.
Maybe your OS isn't patched?
Try this: SELECT @@global.time_zone;
Won't help if you are on debian which is still on 4.0.
If you get back SYSTEM, then MySQL is looking to the OS for timezone
data. And its only loaded when
Please post to the list not to me personnally.
Original Message
Subject: RE: [PART 2/2] InnoDB - Different EXPLAINs for same query From:
John Anderson [EMAIL PROTECTED]
Date:Thu, January 18, 2007 10:24
To: William R. Mussatto
innodb_flush_method=O_DIRECT
innodb_open_files=8192
innodb_sync_spin_loops=32
innodb_thread_sleep_delay=1000
innodb_autoextend_increment=1024M
innodb_file_per_table=TRUE
[client]
socket=/tmp/mysql.sock
John Anderson
---
William R. Mussatto, Senior Systems Engineer
http
Have you looked at ubuntu distribution of linux. I think they have a
'school' variant which might be close to what you need. Also, the people
there might be able to give you more help. Good luck.
On Thu, December 7, 2006 9:39, Saqib Ali said:
Hello All,
I know this is little bit off-topic
Sorry, but I haven't gotten any emails from the list and I'm trying to
determine if there is a blockages. Sorry to disturb the list.
---
William R. Mussatto, Senior Systems Engineer
http://www.csz.com
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list
the time might be realistic. It depends on the hardware
you are using and what else is going on on the system.
Hope this helps.
---
William R. Mussatto, Senior Systems Engineer
http://www.csz.com
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http
related to each other?
Do you want all the information from each of the tables (which are NOT
related to each other) between the specified dates? If that is the case
you are looking at a UNION rather than a strait JOIN.
---
William R. Mussatto, Senior Systems Engineer
http://www.csz.com
Ph
for the UNION of the
separate information from table a, where it meets its WHERE conditions,
and the information from table b where it meets its WHERE conditions. The
fact that both where conditions are the same doesn't matter. Hope this
helps.
---
William R. Mussatto, Senior Systems Engineer
http
otherwise you are looking at a table scan which is always slow.
---
William R. Mussatto, Senior Systems Engineer
http://www.csz.com
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Would it not be best to have the field with the fewest repeats (i.e., the
closest to unique) first, or is that what you meant.
Bill
On Tue, October 17, 2006 10:12, Jerry Schwartz said:
I didn't think of that (combinations). You are probably right. Due to my
background, I tend not to think a lot
Just noticed that you said partitions. I am assuming that you meat
multiple drives in a raid array.
Bill
David Lazo said:
Thanx again.
For the time being, we will keep 4 drives with Dan's suggestion. OS and
MySQL running from there.
On 8/25/06 11:03 AM, Dan Buettner [EMAIL PROTECTED]
A couple of comments:
- Simultaneous connections can be increased, but at some point the user
than runs the mysqld process will run out of file handles it can allocate
(each table takes 2 or 3).
- If we are talking about a database server and test server being the same
box then what are you trying
customers can have the same issue (row) then you will need an
intermediate table which has two columns: customerID and issueID.
---
William R. Mussatto, Senior Systems Engineer
http://www.csz.com
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives
. These
last 50 might be the most recent entries, for example. Can
this be done
in single query?
Dirk Bremer - Senior Systems Engineer - ESS/AMS - NISC Lake
St. Louis MO
- USA Central Time Zone
636-755-2652 fax 636-755-2503
[EMAIL PROTECTED]
www.nisc.coop
--
---
William R
romyd misc said:
Hi Everyone,
I'm developing an application using C# .NET and mysql as database. It's a
multithreaded application, we open a mysql database connection at the very
beginning when the application is started and all the database requests
use
the same connection. But under
error
number 2003 stating I can't connect to MYSQL server. Is there something
that someone can suggest?
Thanks,
Chuck
---
William R. Mussatto, Senior Systems Engineer
http://www.csz.com
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives
need to specify that the index is UNIQUE (see changes above)
---
William R. Mussatto, Senior Systems Engineer
http://www.csz.com
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
this.
---
William R. Mussatto, Senior Systems Engineer
http://www.csz.com
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I was storing some 8 bit information in a varchar binary field (encrypted
stuff) and I think its getting corrupted. I thought they were (except for
size) interchangable? I'm running debian GNU Linux and haven't moved to
sarge so I'm still on 3.23.x but will be moving shortly.
---
William R
Gleb Paharenko said:
Hello.
In my opinion, one of the causes of the problem can be the processing of
trailing spaces in varbinary fields. See:
http://dev.mysql.com/doc/mysql/en/binary-varbinary.html
Thanks, you may be right since the results are too short.
William R. Mussatto [EMAIL
David Blomstrom said:
I discovered by accident that I can link any website
on my reseller account to one database. That would be
far more convenient than working with six separate
databases, and it would also cut down on file size
overall, since there are certain tables that I share
between
Eric Bergen said:
Apache 1.3 with php (not sure about tomcat) is a pre forked daemon. Any
connection pooling numbers will be per child. Try setting your
connection numbers per child (for most php apps this is 1) and let us
know what happens. I'm guessing it will create as many connections as
joe
--
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
. Edit the dump file and see.
- ian
Or it could be that a table name is now a reserved word.
DIV in my case
--
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
(if any) will have to be adjusted so that traffic on the
correct port is allowed from only that IP.
Just a thought.
--
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
William R. Mussatto said:
Mark Matthews said:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
William R. Mussatto wrote:
Keith Ivey said:
William R. Mussatto wrote:
I've been googling for 1/2 hr w/o any answers. sorry if I've missed
the obvious.
Problem. Fresh install of mysql 4.7.1
Warning!! Make sure the php module will handle the new password scheme in
4.1. DBD::mysql from AS will not. There are work arounds. I'm having to
fall back to 4.0 because I can't get .jsp to work with 4.1 database (no
connection).
GH said:
What I have been asking for... is that the upgrade
Hassan Schroeder said:
William R. Mussatto wrote:
Tried it and now I get connection timed out after three tries. I'm
running the testbed using the tomcat buried in netbeans.
Frankly, the whole concept of running a server from within an IDE
sounds so sketchy to me -- but I'm definitely
Mark Matthews said:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
William R. Mussatto wrote:
Tried it and now I get connection timed out after three tries. I'm
running the testbed using the tomcat buried in netbeans. Cut and
pasted the example from the on line docs. Put the jar
Mark Matthews said:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
William R. Mussatto wrote:
Keith Ivey said:
William R. Mussatto wrote:
I've been googling for 1/2 hr w/o any answers. sorry if I've missed
the obvious.
Problem. Fresh install of mysql 4.7.1, AS perl 5.8
DBI and DBD-Mysql
Michael Stassen said:
Rudy Lippan wrote:
On Mon, 15 Nov 2004, Patrick Galbraith wrote:
William,
I'm not sure about this, because it involves windows/active state, and
those ppm packages used for active state perl are pre-compiled to
run. I'll talk to the current maintainer about this
') function
Look at http://dev.mysql.com/doc/mysql/en/Password_hashing.html for the
details as well as work arounds. When they update DBD::mysql this should
go away.
--
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list
at stdconfig.ph line 2
Any thoughts on how far I need to fall back to get around this?
--
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Keith Ivey said:
William R. Mussatto wrote:
I've been googling for 1/2 hr w/o any answers. sorry if I've missed
the obvious.
Problem. Fresh install of mysql 4.7.1, AS perl 5.8
DBI and DBD-Mysql via ppm.
Client does not support authnticaiton protocol
What version of MySQL were you using
Mark Matthews said:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
William R. Mussatto wrote:
Keith Ivey said:
William R. Mussatto wrote:
I've been googling for 1/2 hr w/o any answers. sorry if I've missed
the obvious.
Problem. Fresh install of mysql 4.7.1, AS perl 5.8
DBI and DBD-Mysql
can think to do (assuming you can't ask
which version is supported) is to try the long and then the short version
of the passwords, or to allow the default behavior of the DBI- connect
function to be altered by a parameter.
On Nov 15, 2004, at 5:14 PM, William R. Mussatto wrote:
Mark Matthews said
www.acyc.com - www.clshonduras.com - SolCom
--
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
the answer the query
each time, on a busy server you may end up with quite a few connecitons.
Just a thougth.
--
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
Alfredo Kengi Kojima said:
MySQL Administrator 1.0.11 has been released.
MySQL Administrator is a GUI management console for MySQL, with support
for tasks such as managing users, configuring MySQL, performing backups,
editing table definitions etc.
More information at:
a php
mail system and I've had to increase the number of connections because of
its connection pooling.
--
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
, it
won't be of any use in shrinking it).
A number of products allow the extants to be added onto automatically when
the initial assignment is exceeded. I thought one of the newer versions of
MySQL did that as well but I don't know if its in a stable release yet.
--
William R. Mussatto, Senior Systems
know that the site is getting virtually no traffic, so the problem is
not that it is being overloaded. I have tried this scenario at least a
dozen times, and the same thing always happens.
Ryan
Are you running mod_perl?
--
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext
by any chance? You might check to make sure that
you are calling 'disconnect' at the end of each call. With mod_perl
connections may stay open. I see a similar problem with php. Also,
mod_perl will cause the children to be larger.
--
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext
the database after large numbers of deletes/updates/inserts because the
space in the file will not become fragmented.
--
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
an auto_increment column. What's
going on?
Dan
($pk) = $dbh-selectrow_array('SELECT LAST_INSERT_ID()');
BTW this also works in java.
--
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
url_id.
insert the user record using the url_id you now have.
repeat until you run out of records.
Not elegent but it will get the job done. Note look into documentation on
how to get the new url_id after you do an insert. Its in the DBD::mysql
for perl.
--
William R. Mussatto, Senior Systems
J S said:
Hi,
I need some help please! I have 60GB of proxy logs to parse and load
into a mysql database. I've written a parsing script but I'm stuck
now on how to load the data in.
I have a database called PROXY_LOG with 2 tables:
USER_TABLE
user_id date_time url_id
here
this.conn =
DriverManager.getConnection(this.DBUrl,this.dbuser,this.dbpasswd);
where DBUrl is a string like jdbc:mysql://localhost:3306/+this.dbname;
and dbuser and dbpasswd are the strings containing the username and password.
--
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154
vs 2.6.x from kernel for base?
--
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
' and use the following script:
echo -n 'Dumping at '
date
cd ../mysql
for d in `find -type d -maxdepth 1 -mindepth 1 | sed 's/^\.\///'`
do
mysqldump -u root --password={your mysql root password here}
--add-drop-table -l $d ../mysqlback/$d.dmp
done
Obviously for a linux setup.
--
William R
Robert A. Rosenberg said:
This is a re-submission of a 4/21 reply that was bounded by the list.
At 09:14 -0400 on 04/21/2004, Lou Olsten wrote about Re: MySQL Website:
I have not been able to access the mysql.com server for about a day and
a half now from my office. From home, it's fine.
system in the database. Last time I checked fixed length
database records process much faster.
What computer language are you using to do the work. That would help in
answering the rest of the question.
--
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
/Date_and_time_functions.html
Michael
For finergrain accuracy:
(UNIX_TIMESTAMP(TIStop)-UNIX_TIMESTAMP(TIStart))/60
This gets difference in minutes.
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http
How about if you dumped to a compressor and stored the result?
Steve Williams said:
Hi,
The problem with doing a myqldump to a file (via cron) is that at some
point it will hit the filesize limitiations. By streaming it over the
network, that problem is avoided on both ends of the pipe.
_
Choose now from 4 levels of MSN Hotmail Extra Storage - no more account
overload! http://click.atdmt.com/AVE/go/onm00200362ave/direct/01/
yes.
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives
chip
on motherboard. Moral: if you can't trust the hardware, all bets are off.
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
, but
giving direct create and destroy rights to our customers is a bit of a
security hole IMHO. And yes the web page is on a secured server.
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http
Chris L. White said:
C:\MySQL\binmysql show
ERROR 1045 (28000): Access denied for user: 'ODBC'@'localhost' (Using
password:
YES)
C:\MySQL\binmysql show -u root
ERROR 1045 (28000): Access denied for user: 'root'@'localhost' (Using
password:
YES)
Your musql setup requires a password
with ; or \g.
Your MySQL connection id is 4 to server version:
5.0.0-alpha-max-debug-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql
Chris L. White
Network Administrator
Coe-Truman Technologies, Inc.
Email: [EMAIL PROTECTED]
William R. Mussatto, Senior Systems
.
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
. Win 98 source code? Eight monkeys, five minutes.
-- NullGrey
I have one php application with php and mysql where php is imbedded in the
apache children and when connection pooling is on, there is a connection
for each apache child process.
William R. Mussatto, Senior Systems Engineer
Ph. 909-920
of the NAT firewall.
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
are they not being closed?
Is the user running show processlist allowed to see all processes (e.g.
'root')?
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
? http://www.mysql.com/certification/
So a char(16) binary would work fine as well?
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
thought this list wanted bottom posting? Sorry if I've got it backwards.
How does connection pooling figure into this? I would assume a drop table
command would be needed since from MySQL's point of view, the connection
never gets dropped.
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154
, processed 590,020,855 queries
(404/sec. avg)
Have you tried mytop with debian and 3.23.49 -- version in Debian stable?
we keep getting core dumps. Does it have to be run as root? Sorry if OT
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General
Marvin Wright said:
Hi,
I'm in the process of setting up a new database server that will run on
redhat linux.
The machine will be dual processor with 4GB ram and about 16GB disk.
The machine is going to be used purely with InnoDB tables and will have
a few very large tables acting as cache
. If the second table also has a auto-increment column you will
have to get its value after that insert.
Hope this helps.
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
if you told us what hardware you are planning to use or what kinds of
questions or environment it will support. Then the list can get more
specific.
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http
.
-- NullGrey
Welcome to 'Group By'
Table: Date (y-m-d),amount (decimal),dealercode
select sum(amount),dealercode from table where date 'date1' and date
'date2' group by dealercode
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
transactions; however, InnoDB
does. Please see docs for details.
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
deleting the contents of the table
and any related tables. (Its for a conversion program and I delete
everything if the conversion fails).
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http
Hello
I want to know if there is java API to mySQL like its available for C
and C++.
Bye
Kalika
SMS using the Yahoo! Messenger;Download latest version.
Look for Connector/J on the MySql site.
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
.
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
it with mysqladmin
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ON h.serverid = s.serverid
WHERE h.employeeid = 9
ORDER BY h.historyid DESC
Works fine once I remove the TOP 20 from the query. If this isn't
supported, is there an equivalent?
Thanks,
Jim
remove TOP 20 from front, add 'limit 20' to back.
William R. Mussatto, Senior Systems Engineer
Ph. 909
/ noXtension
You mean they have solved the problem of having to used matched CPU's.
Used to be that you had to throw out the old CPU's and get all new.
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http
use the datetime field type since you will
simplify sorting and conditionals.
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
and Time
values.
c. something else entirely.
Also, are you running this in a procedureal language (e.g., perl, java)?
This will give us other options.
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http
solution to this I noticed that
you have a separate date and time field. Is there a reason for this. It
would be easier to get single row for each sessionID if they were one
field. Otherwise I think you will have to go with the method Peter
proposed above.
William R. Mussatto, Senior Systems
tea.. ok how about this:
select sessionID,max(concat(idate,' ',itime)) from test group by sessionID
Note I thought date and time were reserved so I substituted..
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list
?
Anyone done this?
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I'm wrong). So, unless you
have a spare in the back you will end up replacing 3 drives (assuming Raid
5). That may be why the WD model has such low capacity compared with the
normal IDE drives.
Just my 2 cents worth.
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909
=
DriverManager.getConnection(this.DBUrl,this.dbuser,this.dbpasswd);
}
catch (Exception e) {
e.printStackTrace();
}
Hope this helps..
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives
.
--
This is a x86 (32 bit) chip. It may or may not have 'hyperthreading'
where it can act as two processors.
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Somehow you are still using the older org.gjt.mm.mysql drivers not
connector/J. When I asked many moons ago I was told that they could not
both be used at the same time by Tomcat even in separate contexts, but
YMMV.
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608
there not that a new one had been substituted.
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
users.username='sator')
Susan Ator
Online Services Engineer
National Public Radio
Distribution Division
[EMAIL PROTECTED]
Short answer is mysql does not do sub-selects (i.e., a select inside of a
select). The join part is not this issue.
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154
- Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
I sit corrected, 4.1x but its alpha from the manual:
Subqueries are supported in MySQL version 4.1.
I run a production IPP so we run debian with is very far BACK from the
bleeding edge.
William R. Mussatto, Senior Systems
this in the past. For speed recommend user_id's in
all tables be indexed. Obviously replace 'WHATEVER' with the userID
value.
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
We run Tomcat4. Currently we are using the older mm- drivers. Is there
anyway to move to connector /J one context at a time rather than all at
once?
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http
and the image on the disk? Only case where
this would be a problem would be if the numbers of images were so large
that the file look up mechanism of the file system began to be a factor.
In cases like that I use a tree of subdirectories tied to something like
ISBM number.
William R. Mussatto, Senior
, or blob type field then MySQL silently
converts all character fields longer than one character to varchar. This
may be why you see it sometimes converting the fields.
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list
see why they have to be FIRST! Ugh.
Major performance hit would be a guess. Otherwise the database would have
to do a table scan. Think about how it would find the related record. I
think is a requirement of db2 as well
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX
each can create a
TEMPORARY table with the same name. Only the table created by a given
client is visible to that client.
I use MySQL 4.0.7 on Red Hat.
Thanks,
Mamatha
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
Since you're posting on a MySQL list, you could probably expect some
biased responses. Could you post more about what you need to use a
database for, i.e., what are your needs, wants, what kind of data are
you handling, connection rates, serving platform, code base, etc.
Here are a few URLs
mysql_num_rows()
In perl:$numRows = $sth-rows;
Note the following warning from the DBI man page:
Generally, you can only rely on a row count after a non-SELECT execute
(for some specific operations like UPDATE and DELETE), or after fetching
all the rows of a SELECT statement.
Bye!
William R
1 - 100 of 197 matches
Mail list logo