Interesting, never tried compressing the data, sounds like that might be
a nice addon.. Do you have any performance numbers you can share? I posted
some performance numbers on one of my implementations some time ago.
I found the thread here:
http://lists.mysql.com/mysql/206337
On Tue, 3 Ju
Rick is dead on correct, I call I chunking blob data.. There is an
article here on a simple implementation:
http://www.dreamwerx.net/phpforum/?id=1
I've had hundreds of thousands of files in this type of storage before
with no issues.
On Tue, 3 Jul 2007, Rick James wrote:
> I gave up on putt
I would love to see an implementation with 1 row for large data that works
well. The main issues I had were that mysql has a default max packet size
limit (I think it used to be like 16MB (mysql 3.23) - 1GB Mysql 4 - Not
sure v5. Alot of people don't have control over those settings in their
env
I don't feel the implementation direction this article takes is good. It
uses single row binary storage, which anyone who has had to deal with
large files knows is a definate issue.
On Sat, 21 Apr 2007, Kevin Waterson wrote:
> This one time, at band camp, "Michael Higgins" <[EMAIL PROTECTED]>
Here's a good php implementation, you can implement the concept in any
language you like:
http://www.dreamwerx.net/phpforum/?id=1
On Fri, 20 Apr 2007, Michael Higgins wrote:
> Hello, all --
>
> I want to set up a database for document storage. I've never worked with
> binary files stored in ta
I've built systems than stream tons of data via this method, at times
into some impressive requests per second. Also I've exposed files stored
in this manner via a ftp interface with servers able to deliver near wire
speed data in and out of the db storage.
When your into a load balanced environ
I have to disagree with most, I would store the entire file in the
database, metadata and all. Better security, if you have a backend
database, it's much harder to get the data than pdf's sitting in a
directory on the webserver. Plus if you ever want to scale to a
multi-webserver environment, th
Here's a great article on how to store pdf/whatever binary as blob chunks:
http://www.dreamwerx.net/phpforum/?id=1
On Wed, 7 Mar 2007, Jay Pipes wrote:
> Ed wrote:
> > Hi All,
> > I'm trying to figure out how to put a pdf file into a blob field.
> >
> > I guess a pdf file is a binnary file an
Don't store binary data in large blobs - You should instead chunk your
data for better performance and no packet limitation issues.
Good implementation article at: http://www.dreamwerx.net/phpforum/?id=1
On Mon, 5 Feb 2007, abhishek jain wrote:
> On 2/3/07, abhishek jain <[EMAIL PROTECTED]> wro
Check for .err text log files .. they are probably in
/opt/mysql/mysql/data/
called servername.err
servername is the hostname of your box.
On Thu, 28 Dec 2006, Jeff Jones wrote:
> Hi!
>
> I'm a rookie, so bear with me...
>
> Keep getting:
>
> Starting mysqld daemon with database
Sounds more like it's setup on a SAN.. a NAS is a different type of unit
like a NetApp filer.
I'd have to agree with the other poster, I'm not sure your current config
is valid.
A more typical setup would be that both boxes should have their own
unique SAN partitions, and a high speed network c
If your storing files in mysql, it's best to chunk/shard your data if your
not doing so already. Example article/code at:
http://www.dreamwerx.net/phpforum/?id=1
On Thu, 16 Nov 2006, Shain Lee wrote:
> Hi ,
>
> I wanted to store images , musics, videos ..etc in mysql database.storing
> cont
Sure.. checkout this article:
http://php.dreamwerx.net/forums/viewtopic.php?t=6
Very fast mysql storage implementation in PHP, port the design to
whatever lanaugage suits you.
On Wed, 21 Apr 2004, adrian Greeman wrote:
> Please excuse a very simple inquiry from a near beginner
>
> If I wish t
On Fri, 12 Mar 2004, Jigal van Hemert wrote:
> I've been reading this thread, but I can't see the advantages of storing
> files in a database.
> I've always had the impression that a *file* system was the appropriate
> place to store files.
Scalability, searching, security.. just a few..
> Rep
http://php.dreamwerx.net/forums/viewtopic.php?t=6
storage implementation that is not affected by max_packet_size.
On Thu, 11 Mar 2004, Tomas Zvala wrote:
> Hello,
> I run into a problem where I need to get contents of BLOB to my php
> script. I found out that I'm limited by max_packet_size (wh
It does make the database larger.. as far as overhead... As you
can't just store the file as a blob.. You'll need some referencing data in order to
find it, and restore it back out of the database..
I just checked out my database (100's of files) which has:
Total file size: 1765.34MB
Mysql fil
I store any kind of files, PDF/word/etc.. I just like not having
lots of directories with 1000's of files each in them... Seems
more organized to me..
On Thu, 11 Mar 2004, Erich Beyrent wrote:
> >Use the BLOB, Luke!
> >
> >See your local MySQL manual for details.
> >
> >We're using BLOBs to st
Check this article:
http://php.dreamwerx.net/forums/viewtopic.php?t=6
Port code/design to perl or whatever client language you want.. mysql
could care less once it's got the data (correctly)
On Tue, 9 Mar 2004, Isa Wolt wrote:
> Hi,
>
> I would like to save a binary file into a mysql databas
Donny, what do you do? Throw all the values into an array or something
on the client side, and use a random number generator to pull out the
array elements?
I suppose (depending on resultset size) pulling that many rows from server
to client and handing on client side could be faster...
On
If your infact (sounds like) storing the pictures meta-data (name, size,
owner, etc) and the data (blob of some kind) .. I would definately break
up the design into 2 tables. That way when dealing with the meta-data
table (your RAND() query) there is much less data that needs to be
traversed to g
Never think enough is enough.. Current operation levels can easily be pushed many
times their current level/ratio in a short matter of time, and databases
can grow rapidly (Even tho it's not identified here)
I have spec'd boxes before based on someone reccomendations for load, and
then found 2
I'd go with raid 1+0 ... Be a shame to have that much cpu power and become
I/O bound.. This way you've got 4 disks feeding the cpu's instead of 2..
Better performance than raid 5, and only 2 more disks than your current
config.
On Tue, 2 Mar 2004 [EMAIL PROTECTED] wrote:
>
>
>
>
> I have a requ
By default mysqldump just dumps to stdout.. so you need to > (pipe) it to
a textfile.. the correct syntax, you need to put the database name after
the username/password (after the mysql options)
.. give that a shot.. most likely all the garbage/output wacked out your
session..
On Tue, 10 Feb 20
Are you just copying the files? I'd suggest using mysqldump if you are
not already..
On Tue, 10 Feb 2004, Scott Purcell wrote:
> Hello,
>
> I am running a DB on a machine in which I am developing on. Then I have been copying
> the contents of ~mysql/data/databasename to another box where I am
Read this article for it's design on database storage.. I have several
big implementations on this design which are fast, reliable and scalable
(one of them in the medical field aswell)
http://php.dreamwerx.net/forums/viewtopic.php?t=6
On Sun, 1 Feb 2004, Yuri Oleynikov wrote:
> Hi everyone,
This may have been mentioned.. I have not been recieving message for 12+
hours now.. And it appears:
Jan 13 01:23:49 cyclone tcplog: smtp connection attempt from 213.136.52.31
Jan 13 01:23:50 cyclone sendmail[10674]: ruleset=check_relay,
arg1=lists2.mysql.com, arg2=213.136.52.31, relay=lists2.mys
Exactly.. it's like disk inodes.. So instead of a larger query and the
database having to transmit the big resultset over the network to the
webserver (assuming a multi-tier architecture), using up memory, you break
it down into smaller queries so the webserver keeps asking for chunks as
they are
This article discusses it briefly:
http://php.dreamwerx.net/forums/viewtopic.php?t=6
I am using this type of design/technology for quite a few clients. Some
storing gigs and gigs of data (images, documents, pdf, anything) over
multiple servers.
The scalability and performance of a well designed
Yes and no.. mySQL itself cannot do this.. If you need to keep growing in
size (on 1 server) you may want to look at some kind of LVM disk array/SAN
you can keep plugging in disks and extending the volume..
I do kinda of what you are looking for with 1 application, but it is all
software controll
True initially... What I've done is use a java appserver frontend (orion)
that's a caching server.. It gets the request, checks if it has the image
in it's memory cache, if so serves it, otherwise goes to the backend and
gets it, stores in memory cache, serves it..
Very fast and aleviates alot o
16MB? you mean the max packet per query limit? If your storing data in
huge/large blob then you are making a big mistake in my opinion and taking
a huge performance hit... I've got files over 1GB in size in mysql now..
they went in and out at almost filesystem speed...
On Sun, 14 Dec 2003,
I'd agree with chris. I've got a ton of data/files in mysql for years
now and no problems... The thruput in/out is increadible if you implement
the storage handler correctly.
Plus it gives you certain advantages such as security/scalability/etc...
With storing the files on disk, the files nee
This page has sample article/code how to store any type/size of file in
mysql.. Depending on the appliation it could be a good idea (such as
revision control or something)
http://php.dreamwerx.net/forums/viewtopic.php?t=6
On Fri, 12 Dec 2003 [EMAIL PROTECTED] wrote:
> I am working with a pro
Might just create a common table that stores messages back and forth.. it
stores sender id, recipent, message, etc..
each server polls the table ever so often (cronjob) for messages for it
and processes them, removing them from the queue.. it's like a simple
message broker..
On Tue, 2 Dec 2003
This is the article for you:
http://php.dreamwerx.net/forums/viewtopic.php?t=6
Shows how to store large files in database... I've currently got gigs and
gigs of files in mysql using this method..
On Tue, 2 Dec 2003, Jim Kutter wrote:
> Hi folks.
>
> I'm storing files in a BLOB table for a numbe
Be warned about hitting the default max_packet_size limitation of mysql
which will cause large files to not insert.
This link shows another way to overcome that limitation:
http://php.dreamwerx.net/forums/viewtopic.php?t=6
On Mon, 1 Dec 2003, Mickael Bailly wrote:
>
>
> Here is a sample code i
Maybe look at using a HEAP table? Load it on startup from a datasource..
On Wed, 5 Nov 2003, Arnoldus Th.J. Koeleman wrote:
>
>
> I have a large table which I like to store into memory .
>
>
>
>
>
>
>
> Table looks like
>
>
>
> Spid_1__0
>
>
>
> (recordname varchar(20) primary key,
>
>
>
> dat
http://php.dreamwerx.net/forums/viewtopic.php?t=6
This code has served millions of binary objects (pics, files, etc)
for me with no problems.. good luck.
On Tue, 1 Jan 2002, Braulio wrote:
> What is the best method to use to include pictures in tables? I am using
> PHP. I have several custom
I usually use ps.setBytes() and pass it a byte[] array ..
On Wed, 22 Oct 2003, Scott Purcell wrote:
> Hello,
> I have opted to insert some small jpg files into the mysql database using java.
> Code below.
>
> When I do a select from the table using the mysql> command line, it generates
> pages
Checkout http://php.dreamwerx.net/forums/viewtopic.php?t=6
For a PHP example you could easily convert to PERL or just install PHP
standalone binary on the box.
On Fri, 3 Oct 2003, Zafar wrote:
> Hello
>
> Having trouble inserting images into a BLOB column. No problems doing
> this 'one at a ti
Any mysql encryption functions would be done server side ofcourse before
putting it into the database.. I'd just incorporate an de/encryption
scheme into your client app, and insert as standard BLOB string to remote
server.
On Sat, 4 Oct 2003, sian_choon wrote:
> Hi,
> I have the question rel
Might instead want to look at
where fooid in (xx, xx, xx, xx)
On Sat, 4 Oct 2003, Marc Slemko wrote:
> If I do a query such as:
>
> SELECT * from foo where fooid = 10 or fooid = 20 or fooid = 03 ...
>
> with a total of around 1900 "or fooid =" parts on a given table with 500k
> rows, it takes
Might try mytop (search google for it) .. jeremy z wrote it.. it works
well for realtime monitoring..
On Tue, 23 Sep 2003, John May wrote:
> Is there any way to monitor which databases are being used the most
> heavily on a MySQL server? Thanks for any info!
>
> - John
>
> --
>
> ---
I'm pretty sure you need to sync the entire database (all tables) to all
slaves before starting replication..Your servers are technically
already out of sync..
And no wonder it crashes, tables are missing in it's view..You need to
hit the initial replication setup manual pages..
On Thu,
Most likely you'd need to do some datatype mapping changes to the
script...
Everyone I know who's had to do this has typically used something like
sqlyog (search google) and used the ODBC import cabability to transfer
data from MSSQL -> MySQL..
On Thu, 18 Sep 2003, Tormod Halvorsen wrote:
> Hi
>From mysql manual:
If you want to create the resulting file on some other host than the
server host, you can't use SELECT ... INTO OUTFILE. In this case you
should instead use some client program like mysqldump --tab or mysql -e
"SELECT ..." > outfile to generate the file
On Fri, 12 Sep 2003
Are you running linux and is it SMP? Kernel version plz..
On Wed, 10 Sep 2003, Dathan Vance Pattishall wrote:
>
> /usr/local/mysql/bin/perror 127
> Error code 127: Unknown error 127
> 127 = Record-file is crashed
>
> I've been getting this allot lately from mysql-3.23.54-57.
>
>
> Things that
I'm not too familiar with this.. someone else today used the value 50,
when in fact based on their avg_row_length being reported as:
Avg_row_length: 2257832
Your average row length is reported as:
Avg_row_length = 20564
From: http://www.mysql.com/doc/en/CREATE_TABLE.html
AVG_ROW_LENGTH A
On Thu, 4 Sep 2003, Keith Bussey wrote:
> Running that shows me the following:
>
> mysql> SHOW TABLE STATUS FROM email_tracking LIKE 'email_body_old';
> ++++++-+-+--+---++---
>
> Wisol, Inc.
> Chief Technology Manager
> (514) 398-9994 ext.225
>
>
> Quoting Colbey <[EMAIL PROTECTED]>:
>
> >
> > Most likely it's the 4GB OS limitation... My suggestion is to create a
> > new table using mysql's built in raid option..
Most likely it's the 4GB OS limitation... My suggestion is to create a
new table using mysql's built in raid option... span the table over
multiple files to allow of much larger table growth...
migrate all the rows over to the new spanned table..
On Thu, 4 Sep 2003, Keith C. Ivey wrote:
> O
We use a point to point VPN between server sites for this... so the
security/encryption is totally transparent to mysql, it's just connecting
to an IP address on tcp/3306 and the vpn appliances down the line deal
with all the data security...
There are cheaper solutions such as using freeswan, s
I'd be willing to bet if you implement serializable, serialize it and dump
it to a binary column (blob) .. you should be able to restore...
On Fri, 29 Aug 2003, Dennis Knol wrote:
> Hello,
>
> Is it possible to store Java objects in the mysql database?
>
> Kind regards,
> Dennis
>
>
> _
There are several people with this auto-responder crap going on.. all of
their emails should be de-listed in my opinion..
Here's my sendmail block list thusfar:
[EMAIL PROTECTED]:/]> cat /etc/mail/access | grep notify
[EMAIL PROTECTED] REJECT #notify
[EMAIL PROTECTED] REJECT #notify
I like using either raid 0+1.. it really cooks, or if you can'y spare the
disks, raid 1 ...Something pushing that many queries, should probably
be protected from disk failure.
On Wed, 20 Aug 2003, Jackson Miller wrote:
> I am setting up a dedicated MySQL server with some pretty heavy usage.
It depends if you had any kind of query logging enabled (binary or text)
.. If you started safe_mysqld with -l (that's text logging of queries) ..
or configured my.cnf with bin-log (that's binary logging)..
You should be able to pipe/patch the logs against the database and let it
run all the upda
I'm sure there's gonna be some file locking issues.. If you just trying to
get some scalability, might want to look at replication instead, with the
SAN hosting 1 copy of the database for each server..
On Tue, 19 Aug 2003, Scott Pippin wrote:
> I would like to set up a round robin cluster with
If you can post your current my.cnf + box configuration I'm sure we can
come up with some suggestions..
On Mon, 18 Aug 2003, Creigh Shank wrote:
> How would I tune my.cnf for a larger memory box? (Running on UPS;
> production machine(s) will go into Co-Lo with UPS and generator.) I
> realize
Depends on db size... kinda risky putting it in memory if it's being
updated and power goes bye-bye..
You should be able to get alot more performance just tuning my.cnf for a
larger memory box..
On Mon, 18 Aug 2003, Creigh Shank wrote:
> Have a very large database and due to performance requi
best guess, you need some database maintence..
> optimize table blah1, blah2, etc..
On Mon, 18 Aug 2003, Vinod Bhaskar wrote:
>
> Hi Friends,
>
> In my linux server (LOCAL), accessing data through the PHP scripts from
> MySQL (3.23.41)tables, it is taking more time. Earlier it was very fast.
Checkout: http://php.dreamwerx.net/forums/viewtopic.php?t=6
It's got streaming code..
What I do is if the type is unknown I always send application/octet-stream
and the browser usually identifies it..
Or check the file extension for the file in the database, and apply
content type based on that.
I'd double check this cronjob script... possible scenario.. kaibash idea
if you can prove it's invalid.
"> ServerB has a script that runs every 20 minutes, which does a very
quick/simple select from DB1, then loops though the results and does
updates/deletes on a different database server."
run
On Wed, 13 Aug 2003, Keith Bussey wrote:
> > Are you sure all connection attempts fail? not just insert attempts?
>
> Yes, i have it write to my log if the sock is empty (mysql_connect
> fails)...before it gets to the insert
But you mention mysql reports no connection errors... perhaps wait for
Possible?
Are you sure all connection attempts fail? not just insert attempts?
Server B does some updates/deletes... Chances are this causes some table
locks, which makes Server A unable to perform it's inserts until Server B
releases the lock.
On Wed, 13 Aug 2003, Keith Bussey wrote:
> Hi,
Consider using freeswan (http://www.freeswan.ca) to setup a VPN between
the 2 servers.. that way you can replicate between tunnel addresses..
Or you can spend some cash and buy some vpn appliances..
On Thu, 7 Aug 2003, System wrote:
> Hello All,
>
> How will i setup Mysql Replication btween t
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
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
Hopefully jeremyz will toll in.. he's probably hit it before ;)
On Thu, 31 Jul 2003, NEWMEDIAPLAN wrote:
>
> I was considering different boxes. But I'm courious to know if
> anyone here knows the possibility we have with mysql... just to foresee the
> crash.
>
> Just a software matter assuming w
it's like bash_history.. command history (used with up/back key mostly)
You want to get rid of it for good: ln -sf /dev/null .mysql_history
On Thu, 31 Jul 2003, Jean Hagen wrote:
> We're just getting started with MySQL on Linux; I was browsing my home
> directory and found a file called .mysq
I'm not sure you'd want to do that way... Perhaps 5+ replicated boxes from
a master that share the queries equally (hardware load balancer).. Might
be cheaper in hardware than buying some heavy horsepower box..
On Thu, 31 Jul 2003, NEWMEDIAPLAN wrote:
> Can mysql handle 5000 concurrent webuser
Also keep in mind.. even if for example PHP was faster with certain
functions.. Take that time + the time to pull the data from mysql and set
it up for manipulation via PHP could be more than asking mysql to do all
the work and just return a small resultset..
Just use a simple timer class to writ
I use an extraction layer between mysql and the application/db calls to
handle this.. typically it's only enabled in development to work out any bugs..
Might want to look at something like that..
On Thu, 24 Jul 2003, Miguel Perez wrote:
> Hi:
>
> I have a question: does anyone know if exists a lo
If you actually get binary data loaded into your table, DO NOT run a
select * from table command.. It will stream out all the data and it's
not pretty..
instead run a select col1, col2, length(binarycol) ..
On Tue, 22 Jul 2003, Steven Wu wrote:
> Hi Jeremy D. Zawodny:
> I did not get any
1st search list for binary storage to read about pro/cons (been debated
before)
If you still want to do it either use load_file, or a loader
application...
I don't reccomend using longblob to store big files.. Use the 64k blob
and inode/chunk the data.. better for streaming it out if that's wha
check /usr/local/var/servername.err /.log
or whereever your data files are.. perhaps it can't bind to an ip
address or something like that.. the logfile might help..
On Thu, 17 Jul 2003, Helen wrote:
> when I enter:
> cd /usr/local/mysql
> sudo chown -R mysql data/
> sudo echo
> sudo ./b
On Thu, 17 Jul 2003, Eben Goodman wrote:
> This comment confuses me:
> I have seem some sites code that actually open multiple connections to the
> same database..
I have worked on some larger sites that 30+ past and current
developers worked on.. Some good, some terrible.. The code typically
DOh! i mean script_append part ;) .. basically it's a garbage
collector..
On Thu, 17 Jul 2003 [EMAIL PROTECTED] wrote:
>
> Suggestion.. make a small script called closeall.php .. basically it has
> some code to force closed the mysql connection opened (be sure to run a
> close for all opene
Suggestion.. make a small script called closeall.php .. basically it has
some code to force closed the mysql connection opened (be sure to run a
close for all openened handles)
I have seem some sites code that actually open multiple connections to the
same database..
Add this file into php.ini u
Welcome to the word of JDBC ... mysql calls it connector/j @
http://www.mysql.com/products/connector-j/index.html
On Thu, 17 Jul 2003, [iso-8859-1] kalika patil wrote:
> Hello
>
> I want to know if there is java API to mySQL like its available for C and C++.
>
> Bye
> Kalika
>
> SMS using the Y
If you have a compiler.. probably any version you want... I'm pretty sure
I've compiled mysql on an older qube in the past (took forever)..
Cobalt may have binary distribution packages available for download.. I'd
check their site first.. may save you some time...
On Thu, 17 Jul 2003, Clint S
Keep in mind you need 2 things to happen:
A) the mysql server has to be bound/listening on the ip/interface you need
it to be. This is typically configured in my.cnf configuration file.
B) you need to ensure the mysql privlidges will allow access from other
hostnames/ip addresses.
If mysql isn
It says lost error during query.. but I'd be suspect if it even
succesfully connected/authenticated..
I'd do a quick check first to ensure your mysql server is listening on the
192.xxx interface.. if it's unix, netstat -atn
On Thu, 17 Jul 2003, zafar rizvi wrote:
> hi
> I am running one cen
Those are php notices (not warning or errors) .. change your ini error
reporting settings.. you can either disable those messages or correctly
initialize all variables before trying to use them.
I'd suggest posting your msg to PHP list..
On Wed, 16 Jul 2003, Prabu Subroto wrote:
> Dear my fr
THis is kinda offtopic.. it depends on what frontend you are using to
access mysql (php,java,perl,etc) ..
You just need to pull the binary data and output it with the correct http
headers and it will show up in a browser.. search the list for more
info. www.php4.com has an example using php..
Lord yea... don't get me wrong it would be nice.. but I'd start with say
1GB based on what your doing now.. just make sure the server has lots of
slots open for future upgrades if required. (don't let them stick in 256MB
sticks taking up 4 slots).. use larger size sticks to keep slots open..
O
take a look at:
http://www.php4.com/forums/viewtopic.php?t=6
or search the mailing list archive.. there are plenty of threads talking
about this:
For list archives: http://lists.mysql.com/mysql
On Wed, 9 Jul 2003, Dan Anderson wrote:
> Can anyone point me to a reference on how to insert ima
Avoid NAS... that's like dealing with mysql via NFS ...
Internal raid depending on controller type and disk configuration could be
faster than an external SAN... But chances are external SAN has alot more
scalability as far as adding more controller, cabinets and disks...
If it was my choice and
I just assumed your question was for mysql data only..
If you want total I use:
OS - raid 1 (2 X 18.2gb - 10kRPM)
DATA - raid 0+1 (# X 18.2gb - 15kRPM)
usually a dataset is comprised of 6-10 disks.. you could go larger with
the drive size.. but more spindles = more thruput
Swap isn't much of
My favourite for dedicated db servers (good amount of data, but a ton of
access, queries/sec) is raid 0+1 ... fast access, but requires a good number of
disks..
Be sure to use a good raid controller, multiple channels for the disks if
possible..
On Sat, 5 Jul 2003, Jim McAtee wrote:
> What w
Just shutdown mysql, move the data and create a symlink.. or start
safe_mysqld with --datadir= option
On Mon, 30 Jun 2003, Claudio Alonso wrote:
> Hi, I'd like to know if there's a way to change where the datadir is
> located.
> I've installed mysql in a Sun Solaris, in the /usr/local/mysql
>
Shouldn't be a problem.. if you already have a private link between sites
your set, if not drop in a vpn solution to ensure end to end security..
The only main difference betten your situation and most (all servers are
feet apart at LAN speed) is the WAN thruput/etc.. Mysql should keep
re-tryi
If you want to store images in the database, use a blob columntype.. And
take a look at this example alot of people have based mysql binary
storage off: http://www.php4.com/forums/viewtopic.php?t=6
good luck
On Sun, 29 Jun 2003, Digital Directory USA wrote:
> I am new to php and mysql, I have
I'd instead setup a 2nd backup server that's a slave to the master,
replicates all the time, keeps in sync.
At X time, stop replication/mysql, backup data to tape .. restart mysql
and it will catch up/re sync back to master..
On Thu, 26 Jun 2003, SAQIB wrote:
> > mysqlhotcopy does your lockin
I'm guessing blob data? ~1500MB / 400rows = ~3.75MB /row
On Fri, 6 Jun 2003, Jeremy Zawodny wrote:
> On Fri, Jun 06, 2003 at 09:36:08AM +0200, H M Kunzmann wrote:
> >
> > Hi all.
> >
> > I am running RH9.0 with MySQL 4.0.13
> >
> > I am trying to create a fulltext index on a 1.5GB table with
So you have no redundancy? 5 arrays of raid 0 (2 disks each) = lose a
disk and your pooched..
suggestion:
reconfigure to raid 0+1 (more than 2 disks a set) for added perf ?
On Fri, 6 Jun 2003, Sam Jumper wrote:
> What steps can be taken to speed up queries that show state="copy to tmp
> table"
I've used a simply shell script in the past.. run from cron to do it...
I just see someone posted a perl solution.. I've used a php one aswell..
#!/bin/sh
# DB OPTIMIZE SCRIPT - !! WARNING, DOES TABLE LOCKING DURING OPTIMIZES
user=root
pass=secret
host=10.1.1.1
db=mydb
[EMAIL PROTECTED]
mysql="/
Depending on size of data there are a few different methods... Just like
what most people do.. use plain insert statements with the data properly
escaped and shouldn't have any problem going in.
Pulling data out is pretty quick .. I can stream binary data out of my
mysql storage servers via our
Mascon can do it .. it's a win32 app..
On Tue, 27 May 2003, Thomas Hoelsken wrote:
> Hi,
>
> isn't there any other solution instead of using PHP just for filling an
> Blob!?
>
> I don't need php and would prefer any other way!
>
> Thanks,
> Thomas
>
> > -Original Message-
> > From: [EMAIL
Search the mailing list archives for this... There is a link to this
article:
http://www.php4.com/forums/viewtopic.php?t=6
I wonder if the mailinglist search was powered by google more people would
use it?
On Tue, 27 May 2003, Thomas Hoelsken wrote:
> Hi,
>
> I would like to fill an Blob with
99 matches
Mail list logo
