lly. If they work change the my.cnf to make
them survive the next 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: htt
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 functi
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 requ
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 l
aracter field, using LIKE, etc. I'm slowly but sure tracking those down
and fixing them, I'm just curious if that could have anything to do with
this strange behavior.
Thanks,
John A.
-Original Message-
From: William R. Mussatto [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January
gt; open_files_limit=8192 # Anything higher needs corresponding ulimit entry
>
>
>
> #Buffers
>
> join_buffer_size=128M
>
> key_buffer_size=512M
>
> key_buffer=512M
>
> large_pages
>
> max_heap_table_size=1024M
>
> myisam_sort_buffer_size=256M
>
> read_buffer_size=64M
>
> read_buffer=64M
>
> query_cache_size=32M
>
> query_cache_type=1
>
> record_buffer=512
>
> sort_buffer=512M
>
> table_cache=512
>
> thread_cache=4M
>
> thread_stack=512K
>
> thread_cache_size=300
>
> thread_concurrency=16
>
> tmp_table_size=1G
>
>
> #innodb
>
> innodb-table-locks=off
>
> transaction_isolation=REPEATABLE-READ
>
> innodb_buffer_pool_size=1024M
>
> innodb_log_buffer_size=8M
>
> innodb_flush_log_at_trx_commit=0
>
> innodb_log_file_size=128M
>
> innodb_additional_mem_pool_size=32M
>
> innodb_thread_concurrency=16
>
> innodb_commit_concurrency=4
>
> 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://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]
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 Lis
to match the
new structure), drop the old table and rename the new table to the old
tables name. So 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.
t;
Then it is really a UNION. I hope you have the date field as an index
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
it a RELATIONAL database. If the tables
don't have such a relationship you are asking 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
; --
> http://www.spacemarc.it
Well that's what you asked it to do, if you look closely at your query.
How are table a, b, and c 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
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 lo
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
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 PR
ore issues, but no issue can 'belong' to
more than one customer then its 1 to many and you can put the customer ID
in the issues table.
If several customers can have the same issue (row) then you will need an
intermediate table which has two columns: customerID and issueID.
---
Wi
somewhere
>> > between 1000 and 2000 rows, but you just want to see the
>> last 50. These
>> > last 50 might be the most recent entries, for example. Can
>> this be done
>> > in single query?
>> >
>> > Dirk Bremer - Senior Systems
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
ing the installation. I wasn't sure what to use
> to Default Schema so I just put in test. I keep getting a connection error
> number 2003 stating I can't connect to MYSQL server. Is there something
> that someone can suggest?
>
>
>
> Thanks,
>
>
>
> Chu
as you can see I do not select a engine type, is there some
> engine type better suited and or faster for the way I am
> trying to use the keys?
>
> Thanks for your advice and help.
Close but you need to specify that the index is UNIQUE (see changes above)
---
William R. Mussatto, Seni
is implies, at least to me, that one doesn't need a 2nd
> database server or to do a mysqldump (your steps 5-7). Instead, we just
> tar cv /mnt/ops/dbbackup (to use the article's example name for the
> mounted snapshot), save the tape, and dispense with the snapshot.
> Wouldn&
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.
>
>
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.
---
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
> bet
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 a
ald
>>>
>>>
>>>>I am trying to insert data for the first time using MySQL. In Oracle
>>>> I used the following:
>>>>
>>>># my $sql = "insert into bar( group_name, me, daily, item, unit,
>>>> qty, amount, tax, total )
>>>>
>>>># values( ?, ?, ?, ?,?,?,
>>>> ?, ?, ? ) ";
>>>> my $sth = $dbh->prepare( $sql );
>>>> die $dbh->errstr if $dbh->err;
>>>> $sth->execute( $group_name, $me, $daily, $item, $unit, $qty,
>>>> $amount,
>>>>$tax, $total ) || die "Cannot execute FIRST
>>>> Statement!!\n$DBI::errstr";
>>>>
>>>>
>>>>I keep getting "Can't call method "prepare" on an un undefined value.
>>>> All the name listed are correct by looking at MySQLAdmin1.3\4.
>>>
>>>Apart from David Logan's answer:
>>>
>>>You have to create the $dbh object first (man DBI); the "undefined
>>> value" in
>>>
>>>the error message refers to that.
>>>
>>>
>>>HTH
>>>
>>>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]
index named with a keyword, which 3.23.x appears to
> allow but 4.0.x doedsn't. 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
myodbc on the windows box and then use
access.
The firewall's (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 Genera
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
>>> pas
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"
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 do
William R. Mussatto said:
> Mark Matthews said:
>> -BEGIN PGP SIGNED MESSAGE-
>> Hash: SHA1
>>
>> William R. Mussatto wrote:
>>> Keith Ivey said:
>>>
>>>>William R. Mussatto wrote:
>>>>
>>>>
>>&g
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'
lution I used was to create
the passwords using OLD_PASSWORD('plaintextPassword') 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
P
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 m
un older mysql which have to support the old
interfaces. The only think I 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
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'
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 authn
#x27;dbi:mysql:cjuhsdinfo', '{username}',
'{password}') called
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 li
manual, and also read High Performance MySQL
>> from Zawodny
>> and Balling, and MySQL from Paul Dubois, but none of them seem to
> address
>> this issue.
>>
>> Can somebody point me to a URL or book that I should be reading to
> improve,
>> this, or
> I'll look into this, though.
>
> Thanks,
> Michael
Actually php may be using connection pooling which will NOT close off the
connections. It can be configured either way in the apache php
configuration file. I use squirrelmail, which is a php based webmail
system with MySQL holdin
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:
> h
k. From
>>>>
>>
>> what
>>
>>>>I've been reading, a restart will cause this to happen, but I'm in a
>>>> production environment, and I'm afraid that InnoDB will take its
>>>> sweet
>>>
>>>time
&g
onsive. Do
each of your perl scripts include an explicit ' $dbh->disconnect;'? That
may be needed to return things to the pool. You might also make sure that
the $dbh is 'my'ed and that its scope is less than the entire program.
For example putting it inside of set of { }
ble.
>
> I've read on this list that people running MySQL w/ FreeBSD can have
> similar sounding problems. I am wondering if there is a connection.
>
> I know that the site is getting virtually no traffic, so the problem is
> not that it is being overloaded. I have tried this scen
thing always happens. Is this a known issue
> with Apache + mysql 4.0.18?
>
> Ryan
>
Are you using mod_perl 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 proble
s not involving the BLOB field,
> and
> after the indexes have been exausted, only the relatively small non-BLOB
>
> needs to be read and checked. The downside is that if the search
> involves
> the BLOB field, or if the BLOB field needsw to be fetched, then a second
>
> disk access is required, reducing performance.
>
> That is how I understand it: if anybody knows better, feel free to
> correct
> me - one learns by ones mistakes.
>
> Alec
>
There are certain performance advantages if the rows in a table are fixed
length. If blobs/text fields are moved to a separate table then the
varchar fields can be stored as char. Also, you will no have to clean up
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
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>> > $dialog->destroy;
>> >
>> > warn "Error updating recordset:[EMAIL PROTECTED]" . $@
>> .
>> > "\n\n";
>> >
>> > return 0;
>> >
>> > }
>> >
>> >
>>
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
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 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]
ent
connection setup.
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
// we register the driver, use the new driver string here
this.conn =
DriverManager.getConnection(this.DBUrl,this.dbuser,this.dbpasswd);
where DBUrl is a string like "jdbc:mysql://localhost:3306/"+
rnel from 7.0 and newer + MySQL + high load = highly probable
> instability
>
>
>
> --
> Sasha Pachev
> Create online surveys at http://www.surveyz.com/
Any particular reason to use 2.4.x vs 2.6.x from kernel for base?
--
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-
/'`
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. 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]
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 fi
o the file system and then storing the address on
the file 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 Syste
are used in the
>calculation.
>
> For more date functions, see the manual:
>
><http://www.mysql.com/doc/en/Date_and_time_functions.html>
>
> Michael
>
For finergrain accuracy:
(UNIX_TIMESTAMP(TIStop)-UNIX_TIMESTAMP(TIStart))/60
This gets difference in minutes.
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.
* from t2 Order by id
>
> _
> 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
choice. If you can, I'd try running the queries on a different
> machine.
>
> Good luck,
> Ware
If moving to new hardware solved the problem, it was the hardware. Had
similar problem with Linux kernel compilation a few years ago. Drove us
crazy for a while since on that
y run it that way. We have one customer who
can use a web page to create databases so they meet certain criteria, 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 Eng
to clear the buffer.
>
>
>
> mysql>
>
>
>
> Chris L. White
> Network Administrator
> Coe-Truman Technologies, Inc.
> Email: [EMAIL PROTECTED]
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]
Chris L. White said:
> C:\MySQL\bin>mysql show
>
> ERROR 1045 (28000): Access denied for user: 'ODBC'@'localhost' (Using
> password:
>
> YES)
>
>
>
> C:\MySQL\bin>mysql show -u root
>
> ERROR 1045 (28000): Access denied for user: 'root'@'localhost' (Using
> password:
>
> YES)
Your musql setup requi
p://webtuitive.com
>
>dream. code.
On a related note.
You should always "close" the connection before ending the jsp, not depend
on the garbage collector to do it for you.
In the case of a connection pool setup this will return the connection to
the po
not be an exaggeration to describe the
>>> history of the
>>> computer industry for the past decade as a massive effort to
>>> keep up with
>>> Apple."
>>> - Byte Magazine
>>>
>>> Given infinite time, 100 monkeys could type out th
mysql server, i.e., the 'host' address
will be the public IP 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]
ctions being used, and the limit is 300, we still get the
>>>>>>
>>>>>>"already
>>>>>>more than max_user_connections" error...
>>>>>>
>>>>>>>>-- Henrik
>>>>>>>>
>>>>>>>>gerald_clark skrev:
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>>Henrik Skotth wrote:
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>>Hello all,
>>>>>>>>>>
>>>>>>>>>>We recently upgraded to 4.0, it went
>>>>>>>>>>very well and the performance gains have been great.
>>>>>>>>>>But now the server has started to act strangely. Every few
>>>>>>>>>> days,
>>>>
>>>>the
>>>>
>>>>>>>>>>
>>>>>>>>server starts to refuse connections, saying
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>>>that there is already more than max_user_connections, but there
>>>>
>>>>is
>>>>
>>>>>>>>>>
>>>>>>>>really only one or two active connections and our
>>>>
>>>>max_user_connections
>>>>
>>>>>>is 300. I have to take down and restart the server to solve the
>>>>
>>>>problem,
>>>>
>>>>>>and it keeps happening over and over again every few days...
>>>>>>
>>>>>>>>
>>>>>>>>>>Am I the only one having this problem? Any suggestions?
>>>>>>>>>>
>>>>>>>>>>Regards,
>>>>>>>>>>-- Henrik Skotth, Hogwarts.nu
>>>>>>>>>
>>>>>>>>>Are there 298 or 299 inactive connections?
>>>>>>>>>If so, why 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://lists.mysql.com/[EMAIL PROTECTED]
>>>>>>
>>>>>>INSERT INTO test SET
>>>>>>`id` = AES_ENCRYPT('551850040',
>>>>>> '0bf251c9aaf007deaf1143ca1492b561');
>>>>>>
>>>>>>my field 'id' is VARCHAR(16) NOT
I do that in Mysql? Or, maybe there is such system in Mysql.
> Is there any Mysql reference talk about this matter?
I 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
ges since.
>
> Please do, it sounds useful. I'd like to roll it into version 1.5
> before I release it.
>
> Jeremy
> --
> Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
> <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/
>
> MySQL 4.0.15
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 a
inserts you must get the last_inserted_id BETWEEN the
inserts. 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 Mailin
same time. You set the number
on connections. Each connection takes up a bit of memory, even if idle
(php and mod_perl hold open connections. .jsp may or may not.
Your response time (how long is acceptable) will depend on you actual
database and questions you ask it as well as the hardware. It might
t to keep up
> with Apple."
> - Byte Magazine
>
> Given infinite time, 100 monkeys could type out the complete works of
> Shakespeare. Win 98 source code? Eight monkeys, five minutes.
> -- NullGrey
Welcome to 'Group By'
Table: Date (y-m-d),amount (decimal),dealercode
se
y.
You almost have it. Look up 'Lock Tables' in the manual.
Unlike most database engines, mysql allows various types of tables. The
defaults is myisam which does not support transactions; however, InnoDB
does. Please see docs for details.
William R. Mussatto, Senior Systems Engin
I use is right after 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
> 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-92
omeone tell me where i do mistake?
>> > >
>> > >Thanks a lot..
>> > >
>> > >Sbandy
>> > >
>> > >
>> > >
>> > >[EMAIL PROTECTED]
>> > >http://www.motormaniaci.com
>> > >il portale pe
gt;> Thanks in advance,
>>
>> Dan
blob datatype. But again why do this. use a file system and put the
file's address in the database.
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]
; history h
> INNER JOIN servers s 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
>
>
remo
ometimes the grep line) if the server is running.
Normally you will start a safe_mysqld rather than mysqld
Alternatively you would start 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]
way...
> Get yourself a quad Xeon-board, and start with two CPUs, adding more as
> you go along...
>
> --
> Andreas D. Landmark / 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
e ref. manual.
If you need both date and time 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
e
>>> session numbers (one is enough).
>>>
>>>Make any more sense?
>>>
>>>
>>>
>>>Tim Winters
>>>Creative Development Manager
>>>Sampling Technologies Incorporated
> --snip--
> While I was trying to figure an eleg
>>
>>Make any more sense?
>>
>>
>>
>>Tim Winters
>>Creative Development Manager
>>Sampling Technologies Incorporated
--snip--
While I was trying to figure an elegant solution to this I noticed that
you have a separate date and time field. Is there a
999' give me the information where there is only one record
with a given SessionID?
b. For user '999' for each sessionID give me the unique Date and Time
values.
c. something else entirely.
Also, are you running this in a procedureal language (e.g., perl, java)?
This will give us o
same time?
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]
calhost:3306/"+dbname;
try {
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
this.conn =
DriverManager.getConnection(this.DBUrl,this.dbuser,this.dbpasswd);
}
catch (Exception e) {
e.printStackTrace();
}
Hope this helps..
stion remains for SATA: basic drive reliability. Related
to that is length of time drive will remain available. A dirty secret of
RAID is that when a drive goes it must be replaced you must replace it
with the same drive (please..please tell me 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-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
family with linux would
> be nice too.
>
>
> --
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
Fo
5)
> ..
>
>
> Thanks for your help.
> eff. Usman
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
tly used to link tables in a
relationship. If you "reused" '3' the associated records would think the
originial record was still 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]
ser_id is NULL and users.user_id = WHATEVER
The key is "dacs_access.user_id is NULL" While I haven't tried it with
your data, I've used this in the past. For speed recommend user_id's in
all tables be indexed. Obviously replace 'WHATEVER' with the userID
va
___
> Do you Yahoo!?
> Yahoo! Calendar - 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
users
> ON dacs_access.user_id=users.user_id
> WHERE 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).
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
r.
In cases like that I use a tree of subdirectories tied to something like
ISBM number.
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]
wrong and how to fix it, I'm happy, but I'd rather not have to dump and
> reimport.
>
> I'm running MySQL 4.0.11 on RHL 7.2. I'm using the "huge" my.cnf file
> with some minor tweaks. The tables I'm speaking of have no indexes in
> it. They had
, and more
> importantly, I don't 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,
Y table. The
>>> non-TEMPORARY table is hidden to the client that creates the TEMPORARY
>>> table as long as the TEMPORARY table exists.
>>>A second TEMPORARY table with the same name cannot be created.
>>>
>>>This is on a connection-specific basis. Two cli
ations like UPDATE and DELETE), or after fetching
all the rows of a SELECT statement.
> Bye!
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
-
Before posting, please check:
http:/
1 - 100 of 213 matches
Mail list logo
