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 in
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 int(10) not null,
row_id int(10) not null auto_increment,
primary key
Range table fields (range):
lo int(10)
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 crea
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
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,
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
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 up
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.
>
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 a
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
On Wednesday 31 October 2001 20:06, you wrote:
> On Wed, Oct 31, 2001 at 07:30:12AM -0800, Kyle Hayes wrote:
> > Has anyone used LVM to create snapshots on a master in order to set
> > up replication? We have specialized scripts that are getting harder
> > and harder to main
Has anyone used LVM to create snapshots on a master in order
to set up replication? We have specialized scripts that are getting
harder and harder to maintain as we find weird edge cases
and other annoying bits. Jeremy Zawodny's 'myrepl' script locks
our larger tables for too long.
So, we're l
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 o
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= sort_
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 t
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
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 myisamch
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:
>
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
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 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");
> $a
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 30 August 2001 14:09, Mustafa Hashmi wrote:
> Thanks for the response Joshua,
>
> That is an option - however not one I would be very comfortable with. I
> have a similar setup for virtual hosts generally - wanted something more
> flexible and powerful for a virtual server implementati
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
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 h
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 d
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 c
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 --use
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 to
drivers helps. We have a couple of
systems that run much better when we 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
bits on 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:
ssues that come up if you
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
train stops.
> So now you know why they call this a workstation...
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
e longer method, but
this seems like it is 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
***
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
this:
RESTORE 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: ht
Linux RedHat 6.2 (kernel 2.2.14 SMP)
>
> MySQL version:
> 3.23.32 from binary RPM (MySQL-3.23.30-1.i386.rpm)
>
I don't know that MySQL has that much to do with it in this case.
Best,
Kyle
--
Kyle Hayes
Quicknet Technologies t: +1 415 864 5225
520 Townsen
42 matches
Mail list logo
