I am reposting this because it got sent right at the start of all the fun
with the mailing list.
Best,
Kyle
-
I have a series of data in one table that I need to put into a set of ranges.
Here is a simplified version of the tables:
data table fields (data):
val
On Friday 08 February 2002 16:32, Gurupartap Davis wrote:
Yes, I saw that before...My filesize was limited to 2GB before, but now
with a 2.4 kernel and reiserfs I _should_ be allowed to create a 20GB
data file now, right?
So something's wrong... as I said before, I have successfully created
On Tuesday 05 February 2002 13:03, Matthias Hoffmann wrote:
dear all.
I have a problem using mysql(occured at using phpMyAdmin):
i send the query:
DELETE FROM test WHERE user = test AND timestamp = 2002-02-05
21:42:53 AND var1=1000.1 LIMIT 1
and 0 effect.
but when var1 has a (INT) value
On Friday 01 February 2002 14:19, Jim Dickenson wrote:
Am I to assume that based on your response that one should never use a
float field type if you ever want to select the data?
Er, no,
12.3399 float_var 12.3400
works fine.
It is the = operation that doesn't. Remember that
If you only have 2GB of RAM and you are allocating 5120M (=5GB) for the
key_buffer, you have a problem. That should make your system swap like
mad and everything slow to a crawl. Also, note that some of these config
options may effect per-thread allocation. I don't know which ones off the
On Wednesday 16 January 2002 07:28, Hamlin Nicholas-qa568 wrote:
Easier yet, when using DBI::mysql, is:
my $IncrementedID = $dbh-{'mysql_insertid'};
When executed after the INSERT command.
Does this now work with 64-bit auto-increment fields now in DBI? As of
less than a year ago, DBI
On Saturday 12 January 2002 20:53, Jeremy Zawodny wrote:
On Fri, Jan 11, 2002 at 08:08:51AM -0800, Kyle Hayes wrote:
We write our own replication system using our own checkpointing and
code. We start with the update logs (we're not happy about the
future removal of the update logs because
On Thursday 10 January 2002 17:22, Matthew Walker wrote:
Where I work, we're at the point of needing to maintain two database
servers, one inhouse, and the other at another physical location. We
need to replicate between the servers, to keep them both up to date, as
both will be getting
Comments inline below.
On Wednesday 09 January 2002 18:13, Paul DuBois wrote:
At 17:23 -0800 1/9/02, Kyle Hayes wrote:
[snipped replication explanation]
The program works by getting the contents of the update log and using
the Perl DBI do() function on each statement.
The problem
I am putting the finishing touches on a completely reworked replication
server/client scheme (we cannot use MySQL's native replication for what we
are doing). The whole thing is written in Perl/DBI and runs
on Linux (x86). We are using various versions of MySQL, but all 3.23.x
series. We
On Wednesday 31 October 2001 21:42, Gary Huntress wrote:
I'm up to over 1 databases in one data directory and that is
becoming a performance problem as users make their connections. I would
like to begin running multiple servers on the same box.I made my
first attempt tonight and was
On Wednesday 24 October 2001 23:09, Jeremy Zawodny wrote:
On Wed, Oct 24, 2001 at 06:25:58AM -0400, Tony wrote:
I am looking for a creative way to optimize my web application
(largely reads) with a transaction firehose on the data input side.
Batch vs. OLTP, if you will.
Is there any
On Friday 26 October 2001 07:18, Wai Lee wrote:
I dig through the manual and changed any possible settings
set-variable= max_heap_table_size=2000M
set-variable= key_buffer=2500M
set-variable= max_allowed_packet=1M
set-variable= table_cache=512
set-variable=
On Friday 26 October 2001 10:00, Dana Holt wrote:
Can I automatically generate a random, unique, integer value in a certain
range when inserting data into a column using SQL?
If so, how?
Random is easy. Just find a good RNG (random number generator) somewhere
(there are many available on
On Tuesday 23 October 2001 13:50, David Potter wrote:
Dear list members,
We are running Mysql 3.23 on Redhat Linux 7.1.
We have an emergency. This is the first time we have ever had a problem.
Our production database suddenly crashed. I have tried to repair the
tables with myisamchk
On Tuesday 23 October 2001 14:15, Garrett Marone wrote:
Chances are, you need to type
myisamchk -o *.MYI
as you only want to run myisamchk on the Index file, which is typically the
.MYI file.
you probably typed myisamchk -o *
which is wrong.
Heh. I think you're right. It does look like
On Monday 22 October 2001 08:41, jim barchuk wrote:
Hi Martin!
I have been trying to connect to mySQL for a couple of days now with
no result! I try to log in via telnet..to my remote server..I get in
the system but when I try to log in to the database, nothing!! I use
this:
mysql
On Thursday 18 October 2001 09:45, Bill Adams wrote:
Matthew Bloch wrote:
I'm running several MySQL installation (all version 3.23.37 under Linux)
under what I presume are some fairly harsh conditions, and wondered what
circumstances cause tables to be corrupted and need fixing with
On Thursday 18 October 2001 12:31, Bill Adams wrote:
Kyle Hayes wrote:
I found yesterday (at the advice of this list) that adding an
occasional call to FLUSH TABLES fixed my corruption problems. I
would do that right before the disconnect or program exit.
What kernel are you using
On Thursday 04 October 2001 13:37, Paul DuBois wrote:
At 4:08 PM -0400 10/4/01, Jason Frisvold wrote:
Is there a way to have DBI return the value of the auto-incremented field
upon insert? Or do I have to insert and then do a select afterwards?
$dbh-do (your insert statement);
$auto_inc =
I did not see subselects in this list. Will MySQL support subselects in 4.x?
What exactly does the LOAD TABLE FROM MASTER 'automagically' comment mean?
Does that command sync the slave with the master at that point? If I have
three tables, A, B, and C, and I want to load them at runtime
The queries were...
select * from cookies left join users on cookies.uid=users.uid left join
sessions on users.uid=sessions.uid where
cookies.cookie=e3bd03382561eb3619b66fbea2af217d;
select * from cookies left join users on cookies.uid=users.uid left join
extended on
On Thursday 02 August 2001 17:27, mike cullerton wrote:
on 8/2/01 3:31 PM, Ricardo Kleemann at [EMAIL PROTECTED] wrote:
Hi,
Anyone know if there's a module or plug-in or something that allows BIND
to work with a mysql database?
from http://www.isc.org/products/BIND/bind9.html
A new,
On Wednesday 25 July 2001 17:53, Elvis wrote:
You can always degrade the credit card.
1) verify AUTH ONLY (not capture) with your CC provider. (if you want to
verify they have funds available and the CC is valid)
2) store the CC # in the database
3) ..do your order processing thing or
On Tuesday 26 June 2001 04:49, Gunnar von Boehn wrote:
Hello everybody,
I thing, that I have a problem that needs a sequence and that
auto-increment can't do the job this time.
So, I think the only way to solve this is a sequence table.
Lets take a single row, integer value for holding
As of a couple of months ago, there is a bug with DBI's implementation of
$dbh-{'mysql_insert'}. It didn't handle 64-bit IDs correctly. We converted
everything to use SELECT LAST_INSERT_ID(). It works. MySQL is fine, the
problem was in DBI.
Don't use SELECT MAX(ID) ... as that will not
On Friday 08 June 2001 22:16, Rohit Peyyeti wrote:
Hello All:
I have two mysqld runnning in ports: 3307 3308 respectively. I started
the second one by using 'mysqld_multi start 2'. whereas mysqld running on
port 3307 is the default mysqld started at the boot time.
when i issue command
On Wednesday 06 June 2001 08:53, dariofg wrote:
Hello,
I'm trying to run mysql in a chroot jail, but the server
errors out. I've modified safe_mysqld so it would call
MySQL with the following command:
nice --5 nohup /usr/local/mysql/libexec/mysqld --
basedir=/ --datadir=/var --user=mysql
Check the manual to make sure, but I believe that you need to also make sure
that the operating system privileges are set correctly too. Not sure what
you'll need in Windows, but in Linux, your hosting company probably runs
MySQL under the user mysql. Thus, for the database to write out the
I've found that past versions of MySQL ship with a version of safe_mysqld
that reads the config file itself and only passes on a few of the parameters.
We had to rewrite our own version to allow mysqld to actually parse the stuff
on its own. Note that the my.cnf file that ships often seems
do not use one of the CPUs.
If e2fsck says the partition is fine, then it might not be this problem.
Best,
Kyle
--
Kyle Hayes
Quicknet Technologies t: +1 415 864 5225
520 Townsend St. Suite D f: +1 415 864 8388
San Francisco, CA 94103 w: http://www.quicknet.net
USA
the floor :-(
If you are running BSD, you might have the same problems. Again, I am not
very knowlegable about BSD.
Best,
Kyle
--
Kyle Hayes
Quicknet Technologies t: +1 415 864 5225
520 Townsend St. Suite D f: +1 415 864 8388
San Francisco, CA 94103 w: http://www.qu
are responsible for leaking them.
Best,
Kyle
--
Kyle Hayes
Quicknet Technologies t: +1 415 864 5225
520 Townsend St. Suite D f: +1 415 864 8388
San Francisco, CA 94103 w: http://www.quicknet.net
USA
://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED] Trouble
unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Kyle Hayes
Quicknet Technologies t: +1 415 864 5225
520 Townsend St. Suite D
s a bug.
Best,
Kyle
--
Kyle Hayes
Quicknet Technologies t: +1 415 864 5225
520 Townsend St. Suite D f: +1 415 864 8388
San Francisco, CA 94103 w: http://www.quicknet.net
USA
***
"HEAR TH
foo_backup.bar, foo_backup.baz, foo_backup.blah FROM
'/tmp/mysqlbackups/'
???
Best,
Kyle
--
Kyle Hayes
Quicknet Technologies t: +1 415 864 5225
520 Townsend St. Suite D f: +1 415 864 8388
San Francisco, CA 94103 w: http://www.quicknet.net
USA
Nevermind. I see that the manual online has this information. Sigh. It
doesn't do what I want unfortunately.
Best,
Kyle
On Monday 29 January 2001 09:32, Kyle Hayes wrote:
The manual section on BACKUP does not state what locking behavior the
command has. Does it lock all the tables
37 matches
Mail list logo