Charlene wrote:
Anybody have any idea why MySQL would start to have this error message
every 4 or so days at midnight:
Do look at the logs, but if the error always occurs at midnight, you
might look for a disk backup or compression program that's scheduled
to run than and accesses the databas
mal non-
locking reads it performs during the transaction.
Regards,
Harrison
--
Harrison C. Fisk, Senior Principal Technical Support Engineer
MySQL @ Oracle, Inc., http://www.mysql.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Martijn Tonies wrote:
For example, the Firebird DBMS stores (longer) Blob data not right
there in the record, so whenever you don't request the blob (that is,
not selecting it), it ignores it completely and it can go through the
file quickly.
As do most of the MySQL storage engines.
InnoD
Martijn Tonies wrote:
For example, the Firebird DBMS stores (longer) Blob data not right
there in the record, so whenever you don't request the blob (that is,
not selecting it), it ignores it completely and it can go through the file
quickly.
As do most of the MySQL storage engines.
Cheers,
and access the mysql there?
The only way I know to access tables from different servers
from a single connection is federated tables:
http://dev.mysql.com/doc/refman/5.0/en/federated-use.html
Once you do that, you are accessing it like a local table.
I hope this helps.
Neil
Regards,
Hi all,
I've got a quite large database (23G) that is running on a 5.0.32
version of MySQL. I really want to upgrade out of 5.0.32 to the
latest version of 5.1 (or even 5.4) but a straight mysql_upgrade of
the database takes long enough that I'd have serious down-time issues
(last time I benchmar
Hi all,
I'm trying to drag a database through the upgrade process from 5.0.32
but I keep running into small cross-version compatibility issues.
At present my live database is running 5.0.32 and is large enough that
it would take too long (read days) to perform an upgrade on, and
drives an importa
_test values (NULL)/*!*/;
The SET INSERT_ID functionality will cause the next INSERT to use
that value for the auto_increment regardless of what it would have
generated.
Regards,
Harrison
--
Harrison C. Fisk, Principal Support Engineer
MySQL AB, www.mysql.com
--
MySQL General Maili
Mariella Petrini wrote:
...MySQL 6.0.2 with Falcon on Linux with Debian 4.
I have compiled the source code for 64 bit executable.
The system is an Intel 2 cpus 4 cores each, with 8 GB
of RAM.
After having created
approximately 8,500 empty tables mysqld server was
still alive, you could connect
Mathieu Bruneau wrote:
I never tried the falcon engine, but could it be that mysql is running
out of file descriptor ?
That's less likely with Falcon than with engines that put each
table and index in its own file. By default, Falcon tables share
a single tablespace.
Regards,
Ann
--
My
Rick James wrote:
Instead I broke blobs into pieces, inserting them with a sequence number.
Understanding the underlying problem, that still seems like an
unnatural way to store pictures and documents.
Added benefit: Does not clog up replication while huge single-insert is
being copied over
| Key | Default |
Extra |
+--+--+--+-+-
++
| item_id | int(10) unsigned | NO | PRI | |
auto_increment |
| product_id | varchar(45) | NO | MUL | 0
||
Regards,
Harrison
index). I generally always use that option on a
production machine.
It does a few other things as well (LIMIT 1000, max_join_size), so
make sure you check it out before using it. It used to be called --i-
am-a-dummy mode (that option works too), so you might see it referred
to as that
ed by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
_
_
_
_
This email has been scanned by the Mess
mysql client uses internally)
Try out:
SELECT char(7);
And see if it makes a beep for you. It should if the mysql client
can make the beep on a syntax error.
Regards,
Harrison
--
Harrison C. Fisk, Trainer and Consultant
MySQL AB, www.mysql.com
Get a jumpstart on MySQL Cluster
output the errors to screen afaik. You can redirect it to a
file or similar if you want.
Regards,
Harrison
--
Harrison C. Fisk, Trainer and Consultant
MySQL AB, www.mysql.com
Get a jumpstart on MySQL Cluster -- http://www.mysql.com/consulting/
packaged/cluster.html
--
MySQL General Ma
y sometimes worked based on the execution plan wouldn't be very
useful) .
Regards,
Harrison
--
Harrison C. Fisk, Trainer and Consultant
MySQL AB, www.mysql.com
Get a jumpstart on MySQL Cluster --
http://www.mysql.com/consulting/packaged/cluster.html
Regards,
Harrison
-
mailing list (or even the web forum at
http://forums.mysql.com/list.php?104 which is very active).
Regards,
Harrison
--
Harrison C. Fisk, Trainer and Consultant
MySQL AB, www.mysql.com
Get a jumpstart on MySQL Cluster --
http://www.mysql.com/consulting/packaged/cluster.html
--
MySQL Gene
can use STR_TO_DATE to "fix" a
datetime field before it is loaded into the table directly.
will be quite hard to figure out on my own i guess?
Thanks again!
From: Harrison Fisk <[EMAIL PROTECTED]>
To: "Jessica Svensson" <[EMAIL PROTECTED]>
CC: mysql@lists.mysql.com
Sub
it could be 5 more years before its impelemented and that i
> should maybe look for other solutions.
Maybe they didn't implement it yet because there's an easy workaround:
create a temporary table including the columns to be skipped, LOAD it,
and then use INSERT..SELECT to copy over on
Hi,
On May 8, 2005, at 1:47 PM, Kevin Burton wrote:
Harrison Fisk wrote:
aren't loaded into the query cache, they are loaded into the key
cache (key_buffer_size).
Yes... you busted me ! :). I meant to say key cache though.
Alright, I assumed a typo or such.
Not only THAT but it doesn'
ent insert sounds like it would work well with your above
mythical application (since you didn't mention any DELETEs). The only
locking conflict you might have would be that your INSERT's would lock
other INSERT's while it is occuring.
Regards,
Harrison
--
Harrison C. Fisk, Traine
NULL default '',
`searchIp` varchar(15) NOT NULL default '',
KEY `searchAffid` (`searchAffid`),
KEY `searchKeyword` (`searchKeyword`)
) ENGINE=MEMORY DEFAULT Select * from fsearch_search;
Regards,
Harrison
--
Harrison C. Fisk, Trainer and Consultant
MySQL AB, www.mysql.
ists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
Regards,
Harrison
--
Harrison C. Fisk, Trainer and Consultant
MySQL AB, w
Hi,
On Mar 3, 2005, at 3:13 PM, mos wrote:
At 12:39 PM 3/3/2005, Harrison Fisk wrote:
Hi,
On Mar 3, 2005, at 11:32 AM, mos wrote:
At 10:07 PM 3/2/2005, you wrote:
Hello.
You may use ALTER TABLE .. DISABLE KEYS to speed up the loading
process
on the MyISAM table.
That may work provided I can get
pace or memory, then it should use a Repair
by sort instead.
Also keep in mind that Repair by sort doesn't work for UNIQUE or
PRIMARY KEYs.
Regards,
Harrison
--
Harrison C. Fisk, Trainer and Consultant
MySQL AB, www.mysql.com
Get a jumpstart on MySQL Cluster --
http://www.mysql.com/co
p in mind this would increase your index size by about a
third, so it would take more diskspace and you would fit less into
cache, so it would decrease response times slightly for the count(*)
query.
Regards,
Harrison
--
Harrison C. Fisk, Trainer and Consultant
MySQL AB, www.mysql.com
Get
7.0.296 / Virus Database: 265.6.2 - Release Date: 20/12/2004
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
Regards,
Harrison
--
Harrison C. Fisk, Trainer and Consultant
MySQL AB, www.mysql.co
lem.
So the UPDATE effectively does the same thing as the REPLACE that hits
a problem. I would most likely stick with REPLACE since it is a bit
easier to understand how it is working and has less client code.
Regards,
Harrison
--
Harrison C. Fisk, Trainer and Consultant
MySQL AB, www.mysql.com
Mobile:
Hi,
On Tuesday, December 7, 2004, at 03:07 PM, Klaus Berkling wrote:
On Dec 6, 2004, at 3:51 PM, Harrison Fisk wrote:
Hi,
On Monday, December 6, 2004, at 04:15 PM, Klaus Berkling wrote:
I beginning to use MySQL clustering abilities for a large records
keeping solution.
I have installed 4.1.7
all of the machines in the cluster so even if you need 15
gigs of ram, you could do it with 4 * 4GB machines.
Regards,
Harrison
--
Harrison C. Fisk, Trainer and Consultant
MySQL AB, www.mysql.com
Are you MySQL certified? www.mysql.com/certification
--
MySQL General Mailing List
For list arch
d the entire row (10k in this
case, with 2500 float fields) than doing 2 disk seeks and reading 8
bytes (2 columns). Moving data thru CPU and memory is trivial in cost
compared to doing an extra disk seek.
Regards,
Harrison
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/
ods of
table access. Even if you aren't use these access methods, it will
never be any slower to access than a regular index.
Keep in mind that it will take longer to build the index in the first
place, and make your decision appropriately.
Regards,
Harrison
On Thursday, September 9, 2
n the data into
the separate days. The only thing I would be worried about in that
scenario is if inserts are coming from multiple threads. In that case
you could still possibly run into locking issues with the inserts
locking each other.
Regards,
Harrison
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ry key for InnoDB is a
clustered index. If you are inserting randomly ordered data it will
take a bit more effort to maintain than normal.
5. Make your innodb log files as large as the innodb_buffer_pool_size
that you set above.
Hope that helps some, good luck.
Regards,
Harrison
On Tuesday
, Manchester.
Should I even attempt this using mysql?
Has anyone played with this much data in mysql?
Thanks
Robert
--
Robert Harrison Bsc MBSC CITP
IT Manager
Harrison Goddard Foote
+44 113 2330110
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
t now.
Regards,
Harrison
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
should both be
able to do it. You can see the release dates at:
http://dev.mysql.com/doc/mysql/en/News.html
Regards,
Harrison
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
. You can even set it on the fly with something like: SET
GLOBAL read_only = 1;
Regards,
Harrison
On Tue, 16 Mar 2004, cvarda wrote:
> I'm currently replicating all databases, so this would happen.
>
> This means that I should change my setup to do not replicate the 'mysql&#
hat 4.1.0 used
for later releases as it was the only release that used it. If you
upgrade the client to 4.1.1 (which is available for download? where
didn't you see it?) then you will no longer get that error message.
Regards,
Harrison
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
r hdds it is a tough decision. For reliability you
should keep the binary update logs and the data on seperate hdds.
However then you don't really gain much performance, so it is tempting to
move the InnoDB logs or spread the tables across both drives. For
performance the InnoDB logs ideally
I'm trying to get results back from an sql query in the easiest way to
handle in my script.
table 'categories' and table 'restcat' (restaurant categories).
I'd like to construct a query where I can look up a specific restaurant
id, yet somehow related it to the categories table so that instea
OIN's:
SELECT *
FROM outings as o INNER JOIN pics AS p1 ON o.pic1_id=p1.pic_id
INNER JOIN pics AS p2 ON o.pic2_id=p2.pic_id
INNER JOIN pics AS p3 ON o.pic3_id=p3.pic_id
INNER JOIN pics AS p4 ON o.pic4_id=p4.pic_id;
Either of those should work fairly well. Hope that helps some.
Harrison
Mike wrot
Err, I don't know what I was thinking.
You can simply do a select into dumpfile like:
select data from test where id=1 into dumpfile "/tmp/test2.gif";
That is designed for writing blobs to a file.
Harrison
Harrison C. Fisk wrote:
> The data isn't actually being corru
ually will just select the data and then do whatever needs
to be done in the language you are writing your application in. It
would be like a 5 line script in either perl or php. Hope this helps
you out some.
Harrison
Miles Martin wrote:
>Hello there,
>
>I have a problem that I
.
Hope that helps some.
Harrison
Jesper Öman wrote:
>Hi, I have a little problem making a query with only one SELECT phrase;
>
>I wan't to solve this with a JOIN since sub-selects are not supported in
>MySQL:
>
>select table1.id from table1 where table1.id not in(select table2.
which MySQL will then be able to use indexes to
join on.
Harrison
Elsad YUSIFLI wrote:
>i have a table and 51000 records in it.
>it has got an index on HOST_NAME field.
>next query lasts 45 seconds to execute...
>is it normal ? server is PIII 500 double cpu
>
>SELECT b.ip as ip,
ime you specify. Shouldn't be too hard at all.
Good luck.
Harrison
- Original Message -
From: "Tab Alleman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 28, 2002 12:21 PM
Subject: Batching sql statements
I want to write a batch file of sql sta
to always
leave the log that is currently in use. You can check out for more
information:
http://www.mysql.com/doc/L/o/Log_file_maintenance.html
Harrison
On Sun, 26 May 2002, Batara Kesuma wrote:
> I have some very big files in my /var/lib/mysql.
> [root@nias mysql]# ls -l nias-bin*
&
always assumed it was the first, but depending
on how the query processor works I could see the second one being faster.
If anyone knows for sure, feel free to help me out, Thanks.
Harrison
- Original Message -
From: "Patelli Paolo" <[EMAIL PROTECTED]>
To: <[EMAIL PRO
ght
be 0 goals or goalopp for the game, in which case we still want the number
(which would be 0).
Hope that helps you understand some of the logic behind why the query has to
be this way.
Harrison
- Original Message -
From: "Adriano Manocchia" <[EMAIL PROTECTED]>
To: <[EMAI
the option
files using your preferred text editor and next time you restart mysqld it
will use those new values you specified.
Harrison
- Original Message -
From: "Amy Zediak" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 21, 2002 1:12 PM
Subject: m
the database to store data. The preferred way to do this with
images is to just keep track of the name and location of the file in the
database.
Good luck with your application.
Harrison
- Original Message -
From: "Info_Best-IT" <[EMAIL PROTECTED]>
To: <[EMAIL PROTEC
is in SQL statement format, like mysqldump gives, and not
in a tab-delimited file or anything similar to that. Hope that helps you
out.
Harrison
- Original Message -
From: "Bensin Joseph" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, May 19, 2002 6:04
Hello,
Try using "NOT NULL". As weird as MySQL can be, don't think it is that
NUTty. =)
Harrison
- Original Message -
From: "Jule" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 17, 2002 7:00 PM
Subject: "ALTER TABLE $table AD
Hello,
Try using "NOT NULL". As weird as MySQL can be, don't think it is that
NUTty. =)
Harrison
- Original Message -
From: "Jule" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 17, 2002 7:00 PM
Subject: "ALTER TABLE $table AD
n check if those NULLS are there
and if they are, then we know there isn't a corresponding entry in MapTable.
Thus it will give us the results we want. Hope that helps.
Harrison
- Original Message -
From: "Augey Mikus" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
table locking to accomplish this in MySQL.
This is detailed at:
www.mysql.com/doc/e/x/example-Maximum-column-group-row.html
Hope that helps some.
Harrison
- Original Message -
From: "support" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 06, 2002 12:25
dir you have specified
has enough space in order to run the tests. I'm not sure how much exactly
is needed, but more than you currently have it seems. Hope that helps.
Harrison
- Original Message -
From: "Minas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sen
ble/writable by whomever the mysqld is
running as.
Harrison
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, May 04, 2002 1:41 PM
Subject: Newbee: importing data from .MYD .MYI .frm
> Hi all,
>
> A colleague has created a data
Actually I think the SHOW TABLE STATUS like 'TABLENAME' command can show
you the next auto_increment value.
Although I can say I wouldn't really ever use it except for personal use,
not in an actual application.
Harrison
- Original Message -
From: "Paul DuBois&quo
I need to pull a variable number of fields from a table from the last
inputted fields. For example, instead of doing something like
"SELECT * FROM table"
I am looking for a way to do something like this(hypothetical, I don't
really know what I should do).
"SELECT LAST_TEN_FIELDS FROM
Ann Myhre wrote:
>Hi group
>
>Access has a datatype (I don't remember the name) which is a kind of boleaen; it
>represents Yes/No, true or false. When I try to translate that creating a table in
>MySQL I try ENUM("N","Y") but I do not get the expected result when using If Y
>then...(ASP). Do I
Lorang Jacques wrote:
>Hello,
>This is the last time I will post this thread. Apparently nobody knows any
>solution to this :
>
>The Fulltext search only matches those rows who match
>teh exact word, so if I search for "bank", the query wont find banking.
>(this would work with "like '%bank%'", b
mysql> quit
Fix 2:
$ mysqladmin shutdown
$ safe_mysqld &
All of these are only temporary. After inserting/updating to the
table, the warning from myisamchk reappears.
>Submitter-Id:
Huh?
>Originator:
rom network); 20 Jun 2001 16:15:59 -
Received: from doamail06.doa.state.wi.us (165.189.251.86)
by www.mysql.com with SMTP; 20 Jun 2001 16:15:59 -
Received: by doamail06.doa.state.wi.us with Internet Mail Service
(5.5.2653.19)
id ; Wed, 20 Jun 2001 11:18:35 -0500
Message-ID:
&l
sts.mysql.com/php/unsubscribe.php
--
Regards,
Verle Harrison
Battery Wholesale Distributors
40120 Industrial Park Circle
Georgetown, TX 78626
512.869.6280 ph 512.863.0620 fax
Batteries for your UPS
http://batterywholesale.com/
[EMAIL PROTECTED]
---
ard payment process
>
>Thanks in advance.
--
Regards,
Verle Harrison
Battery Wholesale Distributors
40120 Industrial Park Circle
Georgetown, TX 78626
512.869.6280 ph 512.863.0620 fax
Batteries for your UPS
http://batterywholesale.com/
[EMAIL PROTECTED]
--
68 matches
Mail list logo
