I have just installed redhat linux 9 which ships with mysql
3.23.56. Mysql has to be setup so that it can use innodb tables,
and data inserts (blobs) should be able to handle at least 8M
at a time. The machine has two P III 933MHz CPU's,
1.128G RAM (512M*2 + 128M), and a 36 Gig hd with 1 Gig swap
you can create/alter the particular column with 'zerofill' attribute set. i.e.:
create table books (isbn bigint(16) unsigned zerofill, somemore varchar(100));
-yves
-Ursprüngliche Nachricht-
Von: Eben Goodman [EMAIL PROTECTED]
An: [EMAIL PROTECTED]
Gesendet: Dienstag, 5. August 2003
The fact that you have several millions of rows may indicate that you
have an I/O problem, not CPU.. do some benchmarking. and perhaps the
solution is going to (if not already) SCSI drives, or some kind of raid
configuration (recommend raid 0+1)
Or if you want to keep costs low.. perhaps using
Hi all,
I think you misunderstood me. :-) I try to be more detailed, and I will
also give an example.
So, I have these two tables:
CREATE TABLE main (
ID int not null,
Value int,
primary key (ID)) Type = InnoDB;
CREATE TABLE sub (
MainID int not
I'm baffled by reaching a limit of between 1456 and 1458 connections, at
which
point I can no longer make new connections. I've tried compiling my own
MySQL and using the stock MySql RPM's. I've experimented with ulimits,
values in my.cnf, and kernel parameters, and all the permutations of the
Jennifer Goodie wrote:
I have a stand alone database server. It is a RAID5 running mySQL 3.23.55
on FreeBSD 4.1 and has 768MB of RAM, I'm not sure on the processor speed,
but I think it's a P3 1GHz. It has several tables with 20-40 million rows
and a ton of smaller tables with less than 1
On Wed, Jul 30, 2003 at 12:34:54PM +0800, unplug wrote:
I use rpm to update the previous version. I can use innodb in redhat 9
with version 2.23.56. But it failed in redhat 7.2. I wonder it is the
kernel problem.
Why would you suspect the kernel? How did it fail?
BTW, I want to ask
I'm writing a function for Perl module I'm writing that will allow you to do
$query = SELECT.DBIallexcept($dbh,'fred','wilma').FROM monkey;
If that will help. Let em know and I'll notify you when it's done.
Thanks
Dan
As Victoria says, you can't. However I agree that this syntax
is
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Sat, 26 Jul 2003, Zenon Panoussis wrote:
Can I safely comment out everything after %install on
that line, or will something else break?
The %install section finished successfully that way, but then
the next problem popped up:
RPM
At 07:00 PM 8/6/2003, you wrote:
Currently, I have a Celeron 1.2 Ghz server with 512 RAM, and I'm considering
moving to a P4 2 Ghz with the same amount of RAM. I have a few specific
tables with several million rows of data, and it takes quite a long time to
process that data on my current server.
On Wed, Aug 06, 2003 at 11:39:26AM -0400, walt wrote:
On Wednesday 06 August 2003 11:26 am, Andy Smith wrote:
Andy,
I just noticed that you have
a mix of port numbers. Can you try
`netstat -an | grep 3306`
from the command line and see if the master is indeed listening on that
Todd and Guys,
Your advice helped me too. I think either Apple screwed up when set up
/tmp directory to be writeable by root only or since MySQL package has bug
or shall be installed ONLY as root user.
- Nicos
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
On Thu, Aug 07, 2003 at 01:41:57PM -0700, Jennifer Goodie wrote:
I have a stand alone database server. It is a RAID5 running mySQL 3.23.55
on FreeBSD 4.1 and has 768MB of RAM, I'm not sure on the processor speed,
but I think it's a P3 1GHz. It has several tables with 20-40 million rows
and a
Unfortunatly, I'm stuck using mysqld version 3.23.54 :(
Original Message Follows
From: Victoria Reznichenko [EMAIL PROTECTED]
Date: Fri, 08 Aug 2003 18:29:45 +0300
Paul Mahon [EMAIL PROTECTED] wrote:
Hello, I recently managed to corrupt a table pretty badly. I read the
sections in the
Hi!
On Aug 05, Justin Hopper wrote:
On Tue, 2003-08-05 at 10:57, Paul DuBois wrote:
At 10:30 -0700 8/5/03, Justin Hopper wrote:
I have a table with a FULLTEXT index on a column of type 'text'.
Searches on this table using MATCH() AGAINST() work fine for most
words. However, I needed
Hi,
I've been writing software on the mac since 1987, but am brand new at
unix/php/mysql, and that's where I'm headed so I'm reading everything I can
get my hands on, but like anything else there's going to be a learning
curve, that having been said...
I followed the install instructions at
Andreas wrote:
Bill Hernandez wrote:
I followed the install instructions at http://entropy.ch , and was
able to
get mySql php installed on my G4 - (OSX 10.2.6) last night. I
downloaded
Navicat and setup a password for the mysql user. I created a connection
called myDatabase_connection to a
I have a table with a column date that contains dates in SQL format,
i.e. 2003-08-10
I need to query the table and return all the rows from the current date
thru the next 6 days. (i.e. today 2003-08-10 thru Saturday 2003-08-16).
I have tried the following query which returns all of the desired
Does it restart or just shut down? Do you have to start it up in the
morning? And is there a specific time at which this happens? If you don't
have logging on, you should consider turning it on for debugging purposes.
After it happens again, check your error log (should be in your data
directory -
David,
Firstly, to answer your question I don't know of a MySQL function that
may allow you to sort indirectly by the contents of a field - there are
many many functions and some of them are very specialised, and if you
ever move to another db all those great little functions may not be
there.
Ok, I know it WAS there because we have two similar tables
that should
contain sister records. One table has a record the other
doesn't so
it had to have been deleted. I need to find out WHEN it
was deleted.
How do I create a log of record deletes?
If you keep the
Hi,
I have a MySQL database for books. The ISBN field is set as varchar(15) and
I've put a test ISBN number in of 1--111-11. Can someone tell me why
this SQL query isn't working?
$ISBN = $_GET['isbn'];
$query = SELECT * FROM book_details WHERE ISBN = '$ISBN';
Since the field is a varchar,
I have a table I'm using for logging purposes with a schema like:
create table results (
user varchar(255)
);
Where user is not a unique field and I want to find out how many unique
users there are in the table.
I want to do something like:
select count(count(*)) from results group
Perhaps just something trivial but both numbers are differing:
SELECT * FROM book_details WHERE ISBN = '1---1'
and
and I've put a test ISBN number in of 1--111-11
In any case I have ran a test on my servers with mysql V 4.0.13 and things
work accordingly.
Thanks,
Aaron Holmes
adrian GREEMAN wrote:
I have also read the manual section on this {as I should have
done] to try and understand it
and how to enable reading a local file - the discussion section
seems confusing and confused.
I tried following what others have done and
modified the ini file with
I'd cross post to the mysql-java/jdbc mailing list... Most likely you
need to modify mysql config to allow larger packet sizes.. search the
list archive/website for max_allowed_packet info..
On Fri, 8 Aug 2003, Ma Mei wrote:
Dear administrator,
Now I have a quesion and want to get your help.
this is a Perl script, not shell ...
#!/usr/bin/perl
use strict;
use DBI;
# change the next four to match your network
my $SLAVE_IP= '0.0.0.0';
my $MASTER_IP = '0.0.0.0';
my $USER= 'user';
my $PASSWORD= 'password';
my ( $dbh, $sth, @masterResult, @slaveResult, $i );
At 08:15 PM 8/10/2003, you wrote:
I have a table I'm using for logging purposes with a schema like:
create table results (
user varchar(255)
);
Where user is not a unique field and I want to find out how many unique
users there are in the table.
I want to do something like:
select
28 matches
Mail list logo
