I reset the master, flush logs, reset master, show master status..
shows FINANCE-bin.186 at position 79
so I started the slave
CHANGE MASTER TO
MASTER_HOST='192.168.1.168',
MASTER_USER='repl',
MASTER_PASSWORD='Daredevil22',
MASTER_LOG_FILE='FINANCE-bin.186',
MASTER_LOG_POS=79;
start slave;
and I
More info..
I dont see anythign wrong with the binlog the slave has
E:\mysql\datamysqlbinlog databasebackup-relay-bin.001
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
# at 4
#691231 19:00:00 server id 1 log_pos 0 Rotate to
FINANCE-bin.186 pos:79
# at 46
#691231 19:00:00 server
Replace does a delete followed by an insert.
Ahh, I'm testing innodb on our tables with this problem
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
all the way up to the current event
as soon as it hits the current event it dies, all I have to do is wait 5
min for more events to build up, and start slave and it takes off again
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
matt ryan wrote:
Replace does a delete followed by an insert.
Ahh, I'm testing innodb on our tables with this problem
I've switched to innodb but performance isnt very good
while the insert runs, here's what I get for performance
select count(*) from rondon;
1 row in .13 sec
select count(*) from
matt ryan wrote:
Replace does a delete followed by an insert.
Ahh, I'm testing innodb on our tables with this problem
Doh another problem
innodb has no merge option, I have too much data, and the only way to
deal with it, is partition the data and then tie it together with merge
views
and doing the
group by on that, which is exactly what I was doing the second time
around. and I find it hard to believe that I'm that much smarter than
the MySQL preprocessor. So, if anyone has any thoughts on this strange
disparity in time, I'd be interested to hear them! Thanks a lot!
-Matt
I cant keep the slave up for more than 10 minutes
constantly getting these errors
040812 10:32:25 Error reading packet from server: binlog truncated in
the middle of event (server_errno=1236)
040812 10:32:25 Got fatal error 1236: 'binlog truncated in the middle
of event' from master when
Victor Pendleton wrote:
Can you reset the slave to read the next event its relay log? If this is not
possible, is refreshing the data from the master a viable option?
I can start slave, and it runs a little while, then stops again.
I can refresh the data from the master, iv'e done it 25 times
I deleted every table off the slave, and reloaded them, I do this twice
a week because it wont replicate
The master server has a check optimize every sunday
I had a similar situation one week ago. Found one of the tables (MyISAM) had a
corrupt index. After fixing it, everything was fine again.
locking the whole table? I
thought with myisam it would only lock a table if you delete records,
and insert records, it locks it to fill the gaps.
If I need to switch to another table type it's an option, having locked
tables is NOT an option.
Thanks in advance Matt
--
MySQL General Mailing List
Check it out
mysql start slave;
Query OK, 0 rows affected (0.00 sec)
mysql start slave;
ERROR 1198: This operation cannot be performed with a running slave, run
SLAVE S
TOP first
mysql start slave;
ERROR 1198: This operation cannot be performed with a running slave, run
SLAVE S
TOP first
mysql
the answer to that problem. Let me know if I can provide anything to
make the problem more clear. Thanks for your help!
Matt Winckler
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Michael Stassen wrote:
What hardware and OS?
Pentium II 300, 192 MB RAM, almost-brand-new 80GB hard drive, running Gentoo
Linux (kernel 2.4.25-gentoo).
How did you get and install mysql? MySQL supplied binary? 3rd party
binary? Built from source? If the answer is not MySQL supplied
binary,
the problem...MySQL's binaries seem to work fine.
Thanks again for your rapid insight!
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
).
Although, I suppose if this is only a maintenance query (I suspect it
is), then it probably doesn't matter. But, the bottom line is: if you
can avoid join, do it. There's only so much the query optimizer can
do.
--
Matt Warden
Berry Neuroscience Lab
Department of Psychology
Miami University
often forget about which features are/were unimplemented
in mysql. My apologies.
--
Matt Warden
Berry Neuroscience Lab
Miami University
http://mattwarden.com
This email proudly and graciously contributes to entropy.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Should I even attempt this using mysql?
Has anyone played with this much data in mysql?
I've got two 100 gig databases in mysql, and slave replication on both
of them, the only time I have a problem is table scans, that much data
will be slow.
--
MySQL General Mailing List
For list archives:
One of my slaves has decided to stop replicating
every time I reset it, I get this
040728 8:46:46 Error reading packet from server: binlog truncated in
the middle of event (server_errno=1236)
040728 8:46:46 Got fatal error 1236: 'binlog truncated in the middle
of event' from master when
Update on this, I found that when the slave stops, all I have to do is
start the slave and it's good again
Here's what the log shows.. the only thing I did was start slave and
it picked right back up
040728 9:25:13 Error reading packet from server: binlog truncated in
the middle of event
Mark,
How is it possible to have a hit rate of 1000/1000? Doesn't the buffer
get initialized by cache misses?
-- Matt [EMAIL PROTECTED]
Re: INNODB SHOW STATUS
From: Marc Slemko (marcsznep.com)
Date: Wed Apr 21 2004 - 10:29:44 CDT
On Tue, 20 Apr 2004, Emmett Bishop wrote:
Howdy all
Split the myisam table into seperate tables. We will
call each table a bucket.
Create a MERGE table of all of them. For selecting the
data.
When inserting, use a hash function on your primary
key values to determine which bucket to insert into.
If you almost always select by primary key, then
I went over your data. This is what I noticed first:
| Select_full_join | 0|
| Select_full_range_join | 0|
| Select_range | 1|
| Select_range_check | 0|
| Select_scan | 301 |
What command will provide this data?
--
Hmm
I'm guessing my stats arent too good, lots of full table scans, but this
is to be expected, my users can query any table by any column, and I
cant index all column combinations
Variable_name
Value
Resend, firefox did not send the way it looked when I typed it!
I'm guessing my stats arent too good, lots of full table scans, but this
is to be expected, my users can query any table by any column, and I
cant index all column combinations
Variable_name Value
Select_full_join
I've found the slow query log is useless to me, it's 50 meg right now.
Is there a tool that will identify common querys? I could probably
come up with some sql's if I load it into a table, but it would take
quite a while to sort out.
I posted a request on the mysql bugtraq to move it to a
it to ascii first.
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
OK, so if I can convert it into ascii, then it will be
a text file, which I can import using the instructions
at http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html,
right?
Thanks.
Yep, just have the table structure match the ascii file and load it in
Matt
--
MySQL General Mailing List
For list
it offline, I
only have ms boxes, no linux here, none of our techs know linux well
enough to move to it.
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I load all the data into a table with no keys
then I insert this data into a table with 225 million records, this
large table has the primary key, this is what takes a LONG time
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Lachlan Mulcahy wrote:
MySQL Version: 4.0.18
Server OS: windows 2000, or 2003
Memory 2 gig
CPU(s) dual 2.6-3ghz xeon 500-2mb cache (cpu load is low)
Disks (RAIDs and Independent disk speed/types) 8x72 gig 15,000 rpm scsi
II u320 raid 5 dell perc setup
--
MySQL General Mailing List
For list
Lopez David E-r9374c wrote:
Since you have a temp table created (no keys I assume), use the command
mysqldump -v -e -n -t dbname tablename filename.sql
This creates a file that inserts the records back into the same table
it also does not do an insert ignore
I need the records to go into the
Do you ever delete from this table?
Temp table is trunicated before the EBCDIC file is loaded
Have you removed the unecessary duplicate key on the first column of your primary key?
Have not touched the DIC index yet, I need a backup server to change
indexes, it would take the main server down for
Donny Simonton wrote:
Matt,
I've been reading this thread for a while and at this point, I would say
that you would need to provide the table structures and queries that you are
running.
For example, we have one table that has 8 billion rows in it and it close to
100 gigs and we can hammer it all
Since you have a temp table created (no keys I assume), use the command
mysqldump -v -e -n -t dbname tablename filename.sql
This should create insert statements with many values in a single
insert. Then use the client program to insert them to you db.
mysql -u matt -p dbname filename.sql
file, wipe out the server, and then restore the files, there's not
enough free space to do a proper defrag
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Tim Brody wrote:
You may find that the 'dic' KEY isn't necessary, as it's the first part of
your PRIMARY KEY.
I've found better performance for multi-column keys by putting the columns
in order of least variance first, e.g. for a list of dates:
1979-04-23
1979-07-15
1980-02-04
1980-06-04
You want
Consider replicating to some slave servers and dividing reads among them.
I already replicate to slaves, and sites will do read only queries off
these slaves
99.9 % of the tables are read only anyway, the only tables we update or
insert into, are very very small and fast.
These big tables are
You might be out of luck with MySQL ... sorry.
You may need to switch to a database that has a parallel query
facility. Then - every query becomes a massive table scan but gets
divided into multiple concurrent subqueries - and overall the job
finishes in a reasonable amount of time. The
Lopez David E-r9374c wrote:
matt
1) inserts using this format is much faster:
INSERT INTO table (col1, col2) VALUES (val1,val2), (val3,val4)
is much faster then single row insert. My experience is
2.5 hrs vs.. 36 hrs.
2) The PACK_KEYS=1 may be hurting you. I've never used it.
3
Egor Egorov wrote:
Are you running this under Microsoft Windows?
Yes, windows 2k and 2003, mysql-nt 4.0.16
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
You may want more indexes but you might be getting killed because you already have too
many.
To test - try loading into a table without indexes and see if it makes a difference.
At the very least - check to see if the primary index which starts with 'dic' can make
your
(obviously put in the appropriate column names etc for your data structure!)
Cheers,
Matt
-Original Message-
From: Joshua J. Kugler [mailto:[EMAIL PROTECTED]
Sent: 07 July 2004 22:22
To: [EMAIL PROTECTED]
Subject: Re: INSERT DISTINCT?
Certainly, it's called making a unique index
You're missing a closing at the end of your sql on the last line
which may be throwing up an error.
Cheers,
Matt
On 2 Jul 2004, at 15:05, Michael Mason wrote:
Write.txt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
you can try - like moving the 'type' out into a
lookup table and storing the ID in the hierarchy (allowing you to retrieve
all places of a certain type, for instance).
This is a situation in which views are (for me, anyway) sorely missed!
Cheers,
Matt
-Original Message-
From: David
Hey Rob,
You're looking for a group by to allow mysql to aggregate over the IP's:
SELECT ip, count(*) FROM iptable GROUP BY ip ORDER BY ip DESC limit 10;
-Matt
-Original Message-
From: rmck [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 01, 2004 1:03 PM
To: [EMAIL PROTECTED]
Subject
Woops! Forget I said that, you wanted to order by the most occurrences.
Sorry.
SELECT ip, count(*) FROM iptable GROUP BY ip ORDER BY 2 DESC limit 10;
Heh... I should learn to read one of these days...
-Matt
-Original Message-
From: rmck [mailto:[EMAIL PROTECTED]
Sent: Thursday, July
Marc Liyanage has taken much of the effort out of php and mysql
installation for the mac.
http://www.entropy.ch/software/welcome.html
On 30 Jun 2004, at 04:41, Kieran Kelleher wrote:
Mac OS X is well supported by MySQL. MySQL is even preinstalled in Mac
OS X Server, although we choose to
Rebuilding index takes 3 1/2 days!!! Growing pains with mysql..
I've got 2 dedicated servers, each with a slave, all run 32gig 15k rpm
raid 5 on u320 perc raid cards, dell 2600/4600's with single channel
backplanes (new ones will have dual channel)
All have 2 gig of ram, but I've never seen mysql
, if someone sees something that I could change to speed things up, or
I should direct this question elsewhere... thanks for your help and
thanks for reading this far!
Thanks again,
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
quicker to insert into an un-indexed table and
then create an index, compared with inserting into the table and updating
the index for each row.
Hope this helps!
Matt
-Original Message-
From: Martin Gainty [mailto:[EMAIL PROTECTED]
Sent: 25 June 2004 17:43
To: [EMAIL PROTECTED
BY
indexed_column DESC relative to ORDER BY indexed_column ASC.
The performance is only poor when using an index for DESC, *if the index is
PACKED*. (There's different criteria that determines if a certain index is
packed.) Otherwise, it should be pretty much exactly the same as ASC.
Matt
--
MySQL
this:
SELECT * FROM table ORDER BY key DESC LIMIT 10
but it won't for this:
SELECT * FROM table WHERE key_part1=123
ORDER BY key_part2 DESC LIMIT 10
e.g. when the index is already used for the WHERE. Of course this was
fixed in 4.0.
Matt
--
MySQL General Mailing List
For list archives
distribution.
Hope that helps.
(Oh, also what Terry said in his reply!)
Matt
- Original Message -
From: Pieter Botha
Sent: Monday, June 21, 2004 3:54 AM
Subject: Full text search problem
Hi
I have a fulltext search on a dbase for lost pets.
My problem is the following:
I have dog
to give me more detail so I can figure out why the
service keeps dying? Any help would be greatly appreciated.
Thanks,
Matt
MySQL 4.0.20
Red Hat Enterprise Linux 2.9.5
Kernel 2.4.21-1.1931.2.399.ent
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
(locking should prevent the processes from
getting the same data, since the objects/rows held in the transaction would
be locked out).
Difficult to say without a better idea of what you are trying to achieve,
though!
Cheers,
Matt
-Original Message-
From: Thomas Schwanhaeuser [mailto
to
change 1 line in myisam/ftdefs.h:
#define misc_word_char(X) ((X)=='\'')
change that to:
#define misc_word_char(X) (0)
I HOPE that is correct! ;-)
Matt
- Original Message -
From: Andrea Gangini
Sent: Thursday, June 10, 2004 9:44 AM
Subject: Help with apostrophe and FTS
.
Hope that helps.
Matt
- Original Message -
From: Scott Fletcher
Sent: Thursday, June 10, 2004 2:47 PM
Subject: Column's DataType -- TEXT vs BLOB...
I'm wrestling over deciding on which data type to go with, TEXT or BLOB. I
have one table with one column of 400 characters, I
Hi Ronan,
Yes, it's fine to mix table types in databases and queries.
Matt
- Original Message -
From: Ronan Lucio
Sent: Thursday, June 03, 2004 2:44 PM
Subject: Table types
Hi,
Is it wise to have a database with hybrid table types?
In other words: if I have a table that wouldn
columns are always created on
disk because HEAP tables don't support variable-length rows. I think this
limitation will be lifted in 5.0 or 5.1.
For the original poster, maybe this is one of the times that a RAM disk
could be useful for MySQL's tmpdir.
Matt
--
MySQL General Mailing List
For list
a SQL query. :-)
Thanks for any input.
David.
Hope that helps somewhat.
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I'm using version 4.1.1-alpha, running on RedHat Linux 9.
Victoria Reznichenko wrote:
Matt Mastrangelo [EMAIL PROTECTED] wrote:
How can an InnoDB table be created with case sensitive collation? The
example below creates two identical tables, one MyISAM and the other
InnoDB. The InnoDB fails
I'm running version 4.1.1-alpha. The 3 select statements below on the
following test table produce inconsitent results:
create table test (test varchar(20)) charset latin1 collate
latin1_general_cs;
insert into test values ('abcField1');
insert into test values ('abcField2');
insert into test
How can an InnoDB table be created with case sensitive collation? The
example below creates two identical tables, one MyISAM and the other
InnoDB. The InnoDB fails when inserting primary keys that differ in case
only. What am I doing wrong?
Thanks.
drop database test;
create database test
(date) BETWEEN month(now() - interval 1 month) AND month(now)
Cheers,
Matt
-Original Message-
From: mayuran [mailto:[EMAIL PROTECTED]
Sent: 03 May 2004 16:15
To: [EMAIL PROTECTED]
Subject: WHERE clause problem
This is my table:
mysql desc testing
end up being told by the select that there
is
nothing left in the queue, when in reality there could be a dozen
records
waiting in the delayed insert handler waiting to be put into the
table.
Is my assumption correct?
Yes it is.
Cheers
Peter
Matt
--
MySQL General Mailing List
For list
use INDEX, and then use SHOW
CREATE TABLE, MySQL will have it specified as KEY. :-)
Thanks,
John
Hope that helps.
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
, what you're seeing IS a bug and should be reported if
it hasn't already been.
Matt
- Original Message -
From: John Mistler
Sent: Friday, April 30, 2004 1:39 PM
Subject: Another Trailing Spaces Issue
The TINYTEXT format solves the problem of storing the string with
spaces at
the end
depends on how you're doing this, and exactly what you want. :)
Cheers,
Matt
-Original Message-
From: Matthias Eireiner [mailto:[EMAIL PROTECTED]
Sent: 26 April 2004 23:00
To: [EMAIL PROTECTED]
Subject: simplifying OR clauses
hi there,
I have a basic question:
how can I simplify
would create People_Jobs to describe the
relationship between the two.
There are a number of different methods that have been published, including
'Norwegian', I believe - and a bit of googling should turn up some info on
these. :)
Cheers,
Matt
-Original Message-
From: Ronan Lucio [mailto
I do something similar in my PHP applications - using an object wrapper to
the SQL connection. That way, when an error occurs, the object automatically
outputs the query, along with any error which was returned.
Cheers,
Matt
-Original Message-
From: Richard Bryson [mailto:[EMAIL
value; and 3) you can't index the whole column -- but you can
INDEX (col(255)), which has the same effect. :-)
Hope that helps.
Matt
- Original Message -
From: John Mistler
Sent: Friday, April 30, 2004 3:54 AM
Subject: Storing a space
Is there a way to force an invisible space
to accept a date in this format or do i really have to go
through every sql statement and parse the date and rebuild it to be -mm-dd? thanks
so much. deadline is fast approaching.
Matt Tucker
thoughtbot
.
Matt
- Original Message -
From: [EMAIL PROTECTED]
Sent: Wednesday, April 28, 2004 12:01 AM
Subject: fulltext index -- word needs not found
Description:
We have three different unrelated tables, each with one field that
has a fulltext index. In each table, in the field with the fulltext
a given row).
One rule of thumb is: If there are two or more columns within a given table
which together are the logical way to identify that row (and the way you
would always join to the table), then use those as a compound key, otherwise
assign a separate autoincrement column as a PK.
Cheers,
Matt
[snip]
$sun_5a_n1 = 1;
$sun_5a_t1 = 2;
if($sun_5a_n1) {
$result = mysql_query(UPDATE sunday SET
a5_n_1='$sun_5a_n1',a5_t_1='$sun_5a_t1')
while($row = mysql_fetch_array($result)) {
(line 17)echo Sunday @ 5am slot modified to Name:
$sun_5a_n1, Time:
$sun_5a_t1br;
the last insert_id for the current connection.
Most puzzling - I saw a closed bug from March on mysql.com which would have
explained this, however, then, the above short procedure would have failed
as well!
Has anyone out there run into similar troubles?
Cheers,
Matt
--
MySQL General Mailing List
,
Matt
-Original Message-
From: Matt Chatterley [mailto:[EMAIL PROTECTED]
Sent: 23 April 2004 02:08
To: 'MySQL List'
Subject: LAST_INSERT_ID() and Stored Procs
Hi all.
Another hiccup along the happy road with MySQL 5.0!
The last bit of a stored procedure I have just put together
I suspect you want 'IS NULL' rather than '= NULL'. :)
I always find it best to think of NULL as undefined value rather than no
value - which is why you need to check for it especially (using IS rather
than = or other operators).
Cheers,
Matt
-Original Message-
From: Yonah Russ
be used. EXPLAIN will show the same plan for
COUNT(*) and COUNT(1). :-)
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
it installed on Windows at the moment - because it's more
convenient to debug (and restart)!
Cheers,
Matt
-Original Message-
From: [EMAIL PROTECTED] [mailto:mysql-list-
[EMAIL PROTECTED]
Sent: 15 April 2004 20:29
To: Matt Chatterley
Subject: Re: Slow Connection from PHP to MySQL 5.0
do
| NO|
| have_symlink | YES |
| have_openssl | NO|
| have_query_cache | YES |
++---+
8 rows in set (0.03 sec)
You might find the following helpful
http://www.codeant.com/tutorials/mysql/MySQLTutorial.html
Matt
-Original Message-
From: Chen, Jenny
connections' flag (but
have tried both with it off and on, since I am not actually using a password
for the connection at present).
Any suggestions will be most gratefully received!
Cheers,
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
:-)) as
long as their product is greater than 4GB. BTW, you can't have the
limit be 8GB -- when you go greater than 4GB, the Max_data_length will
be 1TB.
Hope that helps.
Matt
- Original Message -
From: Dan
Sent: Tuesday, April 13, 2004 3:58 PM
Subject: Altering MAX_DATA_LENGTH
a KEY on col2 to be
able to do so.
Cheers,
Matt.
-Original Message-
From: Eldon Ziegler [mailto:[EMAIL PROTECTED]
Sent: 11 April 2004 08:53
To: [EMAIL PROTECTED]
Subject: Re: Do I specify a primary key to be primary, unique and index ?
From the MySQL documentation:
* A PRIMARY KEY
embedded code though, it should work perfectly...
Cheers,
Matt
-Original Message-
From: David Carlos Brunstein [mailto:[EMAIL PROTECTED]
Sent: 11 April 2004 05:23
To: 'Rodrigo Galindez'
Cc: [EMAIL PROTECTED]
Subject: RE: MSSQL to MYSQL
Hi Rodrigo.
I'm facing a similar task but from
that have no associated order?
The above should do what you state below, though - I think!
Cheers,
Matt
-Original Message-
From: Michael Collins [mailto:[EMAIL PROTECTED]
Sent: 11 April 2004 05:14
To: [EMAIL PROTECTED]
Subject: sql join help
I suppose this would be easier
INTO bContinue;
END WHILE;
END
//
Then from MySQLCC:
call name_test(@sTest, @iRand);
select @sTest AS frag, @iRand AS rng;
Cheers,
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Boyd,
Can I ask why it really matters? :-) I would assume the DEFAULT value
is stored at creation time; but the end result would be the same either
way.
BTW, I hate how MySQL's SHOW CREATE TABLE quotes DEFAULT INT-family
values. :-( It shouldn't do that.
Matt
- Original Message
Hi sascha,
How's the space on your datadir partition (or wherever this table is)?
I believe MySQL creates the temp tables during ALTER in the DB
directory, not the tmpdir.
If the space there is OK, have you checked the error log for anything
related?
Matt
- Original Message -
From
TABLES when you're finished.
Matt
- Original Message -
From: Steve Sills
Sent: Tuesday, April 06, 2004 8:17 PM
Subject: backup
I want to use rsync to backup my db server, how do i lock all the tables
for all the db's to read only so i cando my backup, then unlock them
again. It needs
!
Cheers,
Matt
-Original Message-
From: Tarik ANSARI [mailto:[EMAIL PROTECTED]
Sent: 10 April 2004 14:51
To: [EMAIL PROTECTED]
Subject: LIKE search with different orders
Hello again,
To follow my previous message, the CONCAT method does works, but now my
problem is to make a search where
functional.
The only fix I know is to blow away the data on the slaves and start again
with a fresh snapshot (including master.info). As far as I know there's
no disk problems (all servers less than a year old, and lots of space
available).
Any thoughts?
-Matt-
--
MySQL General Mailing List
how to do this in mysql, off the top of
my head).
What precisely are you trying to achieve, though - this might be completely
wrong for you!
Thanks,
Matt
-Original Message-
From: JOHN MEYER [mailto:[EMAIL PROTECTED]
Sent: 07 April 2004 15:39
To: [EMAIL PROTECTED]
Subject: Database
Hi,
This is what HAVING is for. :-)
Matt
- Original Message -
From: Joe Rhett
Sent: Monday, April 05, 2004 8:59 PM
Subject: Re: Why can't I use an AS value in the WHERE clause.
On Mon, Apr 05, 2004 at 08:03:33PM -0500, Paul DuBois wrote:
At 17:29 -0700 4/5/04, Daevid Vincent
? :) I know, I know.. I keep harping on about views...
Regards,
Matt.
-Original Message-
From: Michael Pheasant [mailto:[EMAIL PROTECTED]
Sent: 03 April 2004 11:57
To: [EMAIL PROTECTED]
Subject: can't call a stored proc from another stored proc?
Hi,
1) Can a stored procedure call another
do one INSERT into the new table, using a select similar to the one above.
Thanks,
Matt
-Original Message-
From: Brad Tilley [mailto:[EMAIL PROTECTED]
Sent: 03 April 2004 21:00
To: [EMAIL PROTECTED]
Subject: two tables with same field names into one table
Hello,
I am a mysql newbie
missed something obvious?
Before I forget, I am using (please forgive me), 5.0a-alpha on Windows 2K.
Thanks,
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
GROUP_CONCAT() is in 4.1. :-)
Matt
- Original Message -
From: m.pheasant
Sent: Wednesday, March 31, 2004 5:26 PM
Subject: RE: Is this possible?
You would need an aggregate concat() function I think its in 5.0
m
-Original Message-
From: Chris Boget [mailto:[EMAIL
are found in one table
or both. You wouldn't know which table though (but from your message, I
guess that is unimportant).
I suppose there are a number of things you could do, really...
Regards,
Matt
-Original Message-
From: Scott Haneda [mailto:[EMAIL PROTECTED]
Sent: 30 March 2004 07:39
101 - 200 of 661 matches
Mail list logo
