I've stored millions of images/files in mysql with minimal performance
hit, performance loss is mostly based on your storage implementation.
Checkout this article:
http://www.dreamwerx.net/phpforum/?id=1
On 10/11/06, Greg Donald [EMAIL PROTECTED] wrote:
On 10/10/06, Rodney Courtis [EMAIL
I'd start by looking at your schema.. Quite a lot of use of
varchars... I'd suggest using chars (takes more space but processes
faster).. Or even better, normalize the data so that you have a table
for symbols that is linked to this table via an integer based foreign
key.
Also it seems wierd
I'm having some issues creating a stored procedure to optimize tables
in the database. I'm pulling the table names from the information
schema. The tablename doesn't seem to be correctly being replaced in
the optimize command..
I've tried used prepared statements which seem to correctly
For an PHP example of how to import data getting around
max_packet_size, performance, etc. issues.. Be sure to read this
article.
Also linked from: http://dev.mysql.com/doc/refman/4.1/en/blob.html
Article @ http://php.dreamwerx.net/forums/viewtopic.php?t=6
--
MySQL General Mailing List
For list
Cron hack?
have a console running:
tail -f hostname.log | grep tablename filter.log
-or-
tail -f hostname.log | grep -v insert into blobtablename filter.log
then have a cronjob every X minutes running: echohostname.log
To truncate the full querylog from getting too big?
Not
No ideas internally to mysql, you can always fire up a sniffer
(sniffit, tcpdump, etc).. something like that would tell you.
On Mon, 31 Jan 2005 20:32:49 -0500, John May
[EMAIL PROTECTED] wrote:
Anyone have any ideas on this one? :
I've scoured the MySQL manuals... does anyone know if
ORDER BY host DESC LIMIT 1
On Wed, 29 Dec 2004 14:18:02 -0800 (PST), Richard Reina
[EMAIL PROTECTED] wrote:
I know to most of you this will seem like a mundane
question, but I was hoping someone can tell me how to
select the last record in a table that meets certain
criteria. Like to see who
Read thru the changelog online and see if there's any fixes that
affect you or new features you want.. otherwise just leave it..I
have some terribly old mysql versions running, but they are rock solid
doing their job.. If it aint broke don't fix it? might apply...
On Mon, 22 Nov 2004
It's an argument that can go on forever... We have 10's of thousands
of images in mysql databases.. very fast/reliable.. easy to
replicate, stream, etc..
On Tue, 28 Sep 2004 08:42:13 +0200, Jigal van Hemert [EMAIL PROTECTED] wrote:
From: GH [EMAIL PROTECTED]
I was wondering how to get
setup that you did to have such good
performance?
On Tue, 28 Sep 2004 11:47:26 -0400, DreamWerx [EMAIL PROTECTED] wrote:
It's an argument that can go on forever... We have 10's of thousands
of images in mysql databases.. very fast/reliable.. easy to
replicate, stream, etc
appreciate any ideas or recommendations you have.
Thanks,
Ed
-Original Message-
From: DreamWerx [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 28, 2004 8:54 AM
To: GH
Cc: Jigal van Hemert; [EMAIL PROTECTED]
Subject: Re: Images
Separate/dedicated servers for web
It would be quite easy to drop a squid or similar proxy infront to
cache the db images in memory and deliver them for a set cache-time or
something.. That would be 1 way to boost performance..
On Tue, 28 Sep 2004 09:55:54 -0700, Ed Lazor [EMAIL PROTECTED] wrote:
-Original Message-
I
Great .. I don't have any numbers.. but basically there is quite
little latency using the FTP interface, data is streamed in and out of
mysql on the fly, inserting and selecting blocks of rows.. The FTP
server is written in java using JDBC to talk the database, so it's
quite fast.
On Tue, 28
Blob but are there others?
On Tue, 28 Sep 2004 13:39:20 -0400, DreamWerx [EMAIL PROTECTED] wrote:
It would be quite easy to drop a squid or similar proxy infront to
cache the db images in memory and deliver them for a set cache-time or
something.. That would be 1 way to boost
Might try using windows program called SQLYOG.. makes this dead easy..
On Fri, 24 Sep 2004 09:52:10 -0700 (PDT), Seena Blace
[EMAIL PROTECTED] wrote:
Hi,
How to migrate mysql database from one box to another box ?
thanks
-Seena
-
Do you Yahoo!?
Good binary storage article w/ sample code:
http://php.dreamwerx.net/forums/viewtopic.php?t=6
On Mon, 27 Sep 2004 16:47:37 -0500, Jack Taffar [EMAIL PROTECTED] wrote:
Is it possible to store an excel file into a blob field in mysql? If so how
do I go about importing the file into the blob
Shutdown mysql, move data files, create symlink to datafile(s) on
other partition/disk/whatever..
- Original Message -
From: VijayKumar Dogra [EMAIL PROTECTED]
Date: Wed, 22 Sep 2004 11:22:55 +0530
Subject: MySQL data files
To: [EMAIL PROTECTED]
Hello All,
Is there any way
17 matches
Mail list logo