Bummer, Martin.
What more can you tell us about your specific application? What are
you storing and searching on, exactly? Any chance you can filter on
another column to reduce the number of records that need a string
search?
Dan
On 6/28/06, Martin Jespersen <[EMAIL PROTECTED]> wrote:
I was
Those warnings always give me pause, too - but I used mysqlhotcopy in
production for about 5 years at my previous place of employment.
Probably like the warnings about threading in perl 5.8 - been using
threads in production for nearly 2 years without a problem.
Only 2 problems with mysqlhotcopy
If it were so cut-and-dry, I would know which one to choose ;-) Obviously
it's not.
I'm leaning towards the mysqlhotcopy because it is way faster, and now I
know how to selectively restore. I have a slight concern with the
self-professed beta nature of it -- is that unfounded?
Tim
> -Or
I will try REPAIR TABLE data. data.MYD is 4.1G so I am over the 4GB
limit and growing.
I also tried:
CHECK TABLE data QUICK;
CHECK TABLE data MEDIUM;
CHECK TABLE data EXTENDED;
They all showed OK.
Thank you again,
raymond
-Original Message-
From: Dan Buettner [mailto:[EMAIL PROTECTED]
That's a good thought, Tim - file grep could provide a quick means to
access the data from a mysqldump file. Probably a dumb suggestion
because I'm sure you'll do this, but you should try it out ahead of
time, before you need to actually restore something.
The reason I say this is - if you use s
I'm not sure that avg_row_length has a bearing on your problem right
now ... the output of show table status you posted earlier shows that
you have:
current data length: 4335220336
maximum data length: 1099511627775
data_free: 0 (oddly)
data_free should be something like 1099511627775 - 43352203
> -Original Message-
> From: Dan Buettner [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 29, 2006 9:26 AM
> To: Tim Lucia
> Cc: mysql@lists.mysql.com
> Subject: Re: Recommended backup scripts for mysql databases
>
> Hi Tim - those are all important considerations, yes.
>
> In my mind n
Mark Steudel wrote:
Is there a way get distinct results between pf and sf?
Select
pf.name,
sf.name
From
tblpropertyfeatures,
tblsuitefeatures
Inner Join tblfeatures AS pf ON tblpropertyfeatures.featureid = pf.id
Inner Join tblfeatures AS sf ON tblsuitefeatures.featureid = sf.id
Do you m
If I understand the results from SHOW TABLE STATUS LIKE 'data';
My avg_row_length = 497 Why would descreasing it to 50 have a positive
Effect. I would assume I should increase it?
Thank you/Raymond
-Original Message-
From: Brent Baisley [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 29,
I have been just reading the book and doing the examples and
learning how good MySQL is. I was early asking about Query and now I'm
doing it like the SQL says to do it. A recient one is like this:
mysql> SELECT au_lname, phone
-> FROM authors
-> WHERE phone LIKE '415%';
++
Is there a way get distinct results between pf and sf?
Select
pf.name,
sf.name
From
tblpropertyfeatures,
tblsuitefeatures
Inner Join tblfeatures AS pf ON tblpropertyfeatures.featureid = pf.id
Inner Join tblfeatures AS sf ON tblsuitefeatures.featureid = sf.id
--
Excellent Dan!
Thanks!
-Original Message-
From: Dan Buettner [mailto:[EMAIL PROTECTED]
Sent: Thu 6/29/2006 4:35 PM
To: Jeff
Cc: mysql@lists.mysql.com
Subject: Re: Mysqlhotcopy and replication
Jeff, that is i
Hi all,
I have a couple of stored procedures where SP1 is calling SP2.
SP2 has a return value which I need for SP1 to continue processing the data.
The relevant bit of SP1 looks like this:
mlCounter = 12;
call SP2(mlCounter, return_val);
Relevant bits of SP2 look like:
CREATE PROCEDURE
Jeff, that is indeed the case - the replication thread will "freeze"
just like any other thread, and pick up where it left off.
In fact, the statements are still replicated to the slave by the
replication thread, stored in the slave's relay-bin file I think.
Therefore even though the slave data i
Xiabo, can you post the output of SHOW CREATE TABLE please?
See http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html
which indicates it could be due to how the column was created:
DOUBLE[(M,D)] [UNSIGNED] [ZEROFILL]
A normal-size (double-precision) floating-point number. Allowable
Oops, left out an important part. You should change the Avg_row_length also.
ALTER TABLE AVG_ROW_LENGTH = 50
You need to specify an average row length if you have dynamic length fields in
the table (blob, text, etc.).
Also, perhaps a silly question which you may have answered earlier, but does
I've got a replication slave db (all MyISAM tables) that I currently
back up every night by stopping MySQL, tarballing the table files, then
starting MySQL up again.
I'd like to use Mysqlhotcopy to do this so that the db can stay up for
reads while the backup is being done. Here's my question. W
Xiaobo Chen wrote:
Hi, all
I have a table like this:
+--+-+--+-+-+---+
| Field| Type| Null | Key | Default | Extra |
+--+-+--+-+-+---+
| id_freq | int(11) | | PRI | 0 | |
| id_theta | int(11) |
Hi Pooly, all,
Pooly wrote:
Hi,
I stumbled on one issue yesterday which took me some time to figure out.
the table is :
create table tt ( PCname varchar(5) not null default '');
insert into tt values ('Centaure');
So, by mistake I inserted names which were too long for the field, but
then I t
Hi, all
I have a table like this:
+--+-+--+-+-+---+
| Field| Type| Null | Key | Default | Extra |
+--+-+--+-+-+---+
| id_freq | int(11) | | PRI | 0 | |
| id_theta | int(11) | | PRI | 0 |
Hmmm ... several references online make it sound like that's all you
should need to do (the alter table statement, that is).
My next step would be to try a 'CHECK TABLE data QUICK' to see if it
reports anything unusual. If it does, issue a 'REPAIR TABLE data'
command. If check table quick repor
I guess I had the LIMIT in the wrong location.
Thanks for the help!
Mike
"Mike Wexler" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Mike wrote:
>> I have a SELECT statement for MS SQL that is
>>
>> SELECT TOP 1 id FROM menu_links ORDER BY id desc
>>
>> and need to convert it t
Yesterday:
I ran the following command:
ALTER TABLE data max_rows=1100
Today:
The client still reported table is full.
I rebooted the client and stopped and started the mysql server.
I still get the table is full error on the data table.
I ran the command:
\ echo "SHOW TABLE STATUS LIKE 'da
SELECT max(id) FROM menu_links
:)
> -Original Message-
> From: Mike Wexler [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 29, 2006 1:22 PM
> To: Mike
> Cc: mysql@lists.mysql.com
> Subject: Re: MS SQL TOP Replacement
>
> Mike wrote:
> > I have a SELECT statement for MS SQL that is
> >
How do I call a MySQL stored procedure from an ASP application and get the
value of an Out Parameter?
I've got the following Stored Procedure defined in my database:
DELIMITER $$
DROP PROCEDURE IF EXISTS `bpa`.`sp_GetNextInv` $$
CREATE PROCEDURE `sp_GetNextInv`(
IN nChapterID Int,
OUT cInvNo V
Mike wrote:
I have a SELECT statement for MS SQL that is
SELECT TOP 1 id FROM menu_links ORDER BY id desc
and need to convert it to MySQL. I cannot find what will do that.
Help is greatly appreciated.
TIA
Mike
SELECT id FROM menu_links ORDER BY id desc LIMIT 1
--
MySQL General
I have a SELECT statement for MS SQL that is
SELECT TOP 1 id FROM menu_links ORDER BY id desc
and need to convert it to MySQL. I cannot find what will do that.
Help is greatly appreciated.
TIA
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
Hello Andreas,
You could try with this:
> insert into table1 (authorid, lastname, firstname)
> values (nextval('s_authors'), 'Meyers', 'Scott');
INSERT INTO table1(authorid, lastname, firstname)
VALUES (null, 'Meyers', 'Scott');
> insert into table2 (authorid, title, subtitle)
> values (currval
Have your where clause select the customer, sort result by autoincrement
column DESC limit 50
Only problem is the order would be the inverse (i.e., last in first
displayed) from your goal. Only way I can thing to go around this would
be to select into a temp table and then sort that into the desi
Hi Andreas!
Andreas Bauer wrote:
In my postgres database, the value of the
insert into command of the table 2 is
currval(sequence).There are severally such insert into
commands back-to-back:
insert into table1 (authorid, lastname, firstname)
values (nextval('s_authors'), 'Meyers', 'Scott');
At 16:13 +0100 29/6/06, Pooly wrote:
If you know the picid previously retrieved, then the clause (caption
LIKE '%searchterm%' OR title LIKE '%searchterm%' OR blurb LIKE
'%searchterm%') is redundant, isn't it ?
No, because those details may well be different for different
instances of the same
On Thursday 29 June 2006 08:18 am, Pooly wrote:
> Hi,
>
> I stumbled on one issue yesterday which took me some time to figure out.
> the table is :
> create table tt ( PCname varchar(5) not null default '');
> insert into tt values ('Centaure');
(5) indicates a display width.
> So, by mistake I i
Hi,
I stumbled on one issue yesterday which took me some time to figure out.
the table is :
create table tt ( PCname varchar(5) not null default '');
insert into tt values ('Centaure');
So, by mistake I inserted names which were too long for the field, but
then I tried to do queries on this part
Hi,
2006/6/28, Chris Sansom <[EMAIL PROTECTED]>:
I'm sure this is an elementary problem, but I can't get my head round it.
I have two tables: pix and sections, the relevant bits of which are:
pix (2,421 rows):
picid varchar(7) not null
sectionid smallint(5) unsigned not n
On 6/29/06, Tim Lucia <[EMAIL PROTECTED]> wrote:
I am in the process of designing the backup procedures for a soon-to-be
production DB. I have gone back and forth on mysqldump and mysqlhotcopy.
As I see it (for MyISAM tables), the hot copy backs up faster, restores
faster, but does not allow for
Looks like your full command would end up being:
mysqldump /usr/local/bin/mysql --opt -uroot -pmypassword db
which makes little sense. (You don't need that ${MYSQL} in there).
Instead, maybe what you want is to use an environment variable for
mysqldump, a la
MYSQLDUMP="`which mysqldump 2>/dev/nu
Thanks for the examples. I haven't been able to get them to work yet.
Here's what I tried:
MYSQL="`which mysql 2>/dev/null`" || MYSQL="/usr/local/bin/mysql"
MYSQL_ARGS="--opt -uroot -pmypassword db"
ARCHDIR=/backup/mysql
NAME=db_dump
# Remove archives older than 64 days
find ${ARCHDIR} -type f
Hello NG,
I have to migrate a postgres database to a mysql data-
base. There are some problems applying this.
How can I implement a reference in phpmyadmin between
two fields from two different tables, so that the
two fields of the two different tables
have the same values?
And when I have to f
Hi Tim - those are all important considerations, yes.
In my mind neither mysqldump nor mysqlhotcopy really make selective
restore of one or a few records truly easy. Unless you edit the SQL
dump file (impratical in most text editors when it gets beyond several
MB) you won't be able to restore a
Tim Lucia wrote:
I am in the process of designing the backup procedures for a soon-to-be
production DB. I have gone back and forth on mysqldump and mysqlhotcopy.
As I see it (for MyISAM tables), the hot copy backs up faster, restores
faster, but does not allow for selective restores ("Hello, Sup
At 22:04 +0100 28/6/06, I wrote:
I have two tables: pix and sections, the relevant bits of which are:
pix (2,421 rows):
picid varchar(7) not null
sectionid smallint(5) unsigned not null
caption text null
picid and sectionid are a joint primary key
I am in the process of designing the backup procedures for a soon-to-be
production DB. I have gone back and forth on mysqldump and mysqlhotcopy.
As I see it (for MyISAM tables), the hot copy backs up faster, restores
faster, but does not allow for selective restores ("Hello, Support? I
accidental
Jad madi schrieb:
Same here
On Mon, 2006-06-26 at 06:46 -0300, João Cândido de Souza Neto wrote:
I read that message and had no feelings.
<[EMAIL PROTECTED]> escreveu na mensagem
news:[EMAIL PROTECTED]
Please, read and let me know what do you feel
I feel sad. There was no message ;_;
Brent Baisley schrieb:
I'll give it a shot.
First, select the people that got the first advertisement:
SELECT c_id,aa_id
FROM adverticelink
WHERE aa_id=4
From that result, you want to additionally filter out who didn't get
the second advertisement. Since that information is contained in the
44 matches
Mail list logo
