Personally, I would have to disagree. I have just completed a year-long
uni project whereby we built some software that stored massive images in
InnoDB tables. We found that the performance was (at very worst)
comparable to the alternative method.
Additionally, this method is better on many
Description:
Latest source code from the BK source repository for 4.0 doesn't compile
on SCO OpenServer 5. Error is undefined reference to pthread_key_delete
in libmysys.a(my_thr_init.o). It appears that recent modifications make
use of pthread_key_delete. FSU-pthreads 3.5
Chris Nolan wrote:
Personally, I would have to disagree. I have just completed a
year-long
uni project whereby we built some software that stored massive images
in InnoDB tables. We found that the performance was (at very worst)
comparable to the alternative method.
Additionally, this
you could very well do that, and frankly that is how alot of websites
work.
Yep, including one I run. That site has to generate img and a href links
for visitors, and it seems far easier to return /pics/imagefoo.jpg then
the image itself and decide how to embed that into the page.
But
Really? In both cases, it's just bits on a disk. In the case where you
don't have access to a shared file repository for your client apps, you
haven't got the option of just storing paths.
Regards,
Chris
On Sat, 2003-12-13 at 23:30, Sime wrote:
Chris Nolan wrote:
Personally, I would have to
Talk about a decent reply!
For web site stuff, having control over everything is pretty much a
requirement (if you want to do anything non-trivial). The way that I
serve images from the database is by parsing URLs and I've found that
the performance is very good. The fact that I can move stuff
Forgot something in my other reply.
With the NAS - what's to say that MySQL's retrieval and network protocol
is not more efficient than whatever is running on your NAS boxes?
Conversely, MySQL's current 16 MB per transfer limitation may very well
not allow it to act in this role at all.
Ah, the
With the NAS - what's to say that MySQL's retrieval and
network protocol
is not more efficient than whatever is running on your NAS boxes?
Well, currently we work like so:
Client - Webserver/Application Server - Database
The database returns file names to the application/webserver (yes,
i have done that
C:\mysql
but it will say
'mysql' is not recognized as an internal or external command, operable program or
batch file
there must be something else i'm missing...
Paul DuBois [EMAIL PROTECTED] wrote:
At 18:21 -0800 12/12/03, Betta Jazzy Brown wrote:
I have installed MySql
Try c:\mysql\bin\mysql.exe
If that works, then put c:\mysql\bin the system's path.
- Original Message -
From: Betta Jazzy Brown [EMAIL PROTECTED]
To: Paul DuBois [EMAIL PROTECTED]; Betta Jazzy Brown
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Saturday, December 13, 2003 8:48 AM
Subject:
have you changed the directory to the mysql/bin directory? normally when
you get this error you're not in the correct directory. if mysql is in
C:\mysql you'll need to be in the c:\mysql\bin and then excecute C:\mysql
HTH
Jeff
KEWL...that worked...
one more question...
to put it into the system's path, do i just type at the command prompt
C:\put c:\mysql\bin
??? if not...how do i do that???
Gerald R. Jensen [EMAIL PROTECTED] wrote:
Try c:\mysql\bin\mysql.exe
If that works, then put c:\mysql\bin the system's
nevermind...i figured it out
:oD
thanks for all the help...
MANY MANY MANY more questions to come
-b-jazzy
Betta Jazzy Brown [EMAIL PROTECTED] wrote:
KEWL...that worked...
one more question...
to put it into the system's path, do i just type at the command prompt
C:\put c:\mysql\bin
At 6:48 -0800 12/13/03, Betta Jazzy Brown wrote:
i have done that
C:\mysql
but it will say
'mysql' is not recognized as an internal or external command,
operable program or batch file
there must be something else i'm missing...
This is not a MySQL issue. It's a PATH issue.
Either set your
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
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
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
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
ok...i set the path properly...
in the command line, i did this:
C:\C:\mysql\bin;C:\WINNT;C:\WINNT\COMMAND
then, i am able to just type in mysql and it will begin...
BUT...after i close the command prompt, once i reopen it, and type in mysql, it goes
and says that mysql is not a command or
If you are using Windows 2000, do the following to set the path. If you have
Windows NT, the steps are similar, but slightly different after the System
icon part (I can't remember exactly).
START - Settings - Control Panel - System icon - Advanced tab -
Environment Variables button
Then, in the
Why don't you check the Help utility for your particular operatiing system?
This is not a MySQL issue, and there are several ways you can accomplish it
depending on which version of the Microsoft Windows O/S you have.
- Original Message -
From: Betta Jazzy Brown [EMAIL PROTECTED]
To:
Hi,
On Sat, 13 Dec 2003, Chris Nolan wrote:
1. We all know that InnoDB can be backed up hot (by various means). I
know that there are a few MS SQL Server (ick) and DB2 lovers in the
group I'll be meeting with this week. I also know that these two
databases do a form of online backup.
Given
Hi --
24 hours ago I did a 'mysqlhotcopy' of a working database, then
inadverntently did an 'rsync' copy of that copy, _over_ the working
database tables.
Today, mysql is saying Can't read dir ./thedatabase/' when I start up
a conversation. :(
Meanwhile, Perl scripts have been working on that
On Sat, Dec 13, 2003 at 06:39:08PM -0500, Jeff Gordon wrote:
24 hours ago I did a 'mysqlhotcopy' of a working database, then
inadverntently did an 'rsync' copy of that copy, _over_ the working
database tables.
Today, mysql is saying Can't read dir ./thedatabase/' when I start up
a
I have an openoffice document that is a contract. It has several fields that need to
be filled at the time of signing. I want to have a form that is accessible form a
webpage, that will automatically put the filled data into the contract and then save
it in the mysql database under the
Hello all,
Still a newbie with MySQL, I am running version 4.01 and a Linux box. We
are writing information
into the tables at a regular rate approx 20 time per hour. with 22 rows
of information.
What I am trying to work out is how to read the last 22 rows of
information that has been written
Hi Vanessa,
I don't think I saw a reply to this...
You can just reconnect to MySQL if you get this error. :-) Trying to
send the query a second or third time may also make the client try to
reconnect again.
Hope that helps.
Matt
- Original Message -
From: Kiky
Sent: Friday,
Hi Peter,
You can probably safely have at least 1000-2000 tables in a single
database.
Hope that helps.
Matt
- Original Message -
From: peter
Sent: Friday, November 28, 2003 12:03 PM
Subject: newbie question
Hi
I am a webdesigner/hosting reseller
my question is this:
I am
Hi Alejandro,
Yeah, this issue has come up before. It's not possible to GRANT DROP on
temp tables without GRANTing DROP on the whole database.
The temp tables will be dropped when the client disconnects you know,
right? And if you want to empty the table or reuse it, you should be
able to
Hi Chris,
I don't know exactly what you mean by ALTER being as good as OPTIMIZE...
But yes, an ALTER that recreates the data file (as ALTER ... ORDER BY
does) will defragment the data file too.
However, OPTIMIZE also analyzes the key distribution (I don't know if
it's remembered after an ALTER
AFAIK databases like mysql usually dont (and cant) guarantee that they
will maintain the order of rows the same way they were inserted - it's
that whole 'relational' thing, methinks.
the official way would be to simply add a timestamp field (which gets
filled automagically every time you insert
Hey everyone :-)
This is my first post to the list and I would like to thank everyone for
this great resource. I'm relatively new to mySQL and a novice at PHP, but
here is a description of what I am trying to do. My objective is to create
a database that will provide variables for a series of
Hi!
Thanks for the detailed reply!
Regarding the hot backup method that the other guys use, sounds like a
dodgy method of doing anything to be honest. It would have to have a
fairly decent performance hit...
Regarding the rollback of ALTER, DROP and RENAME statements, the main
use that I've
Hi!
There are plenty of funky ways to do this. :-)
The easiest and fastest way would simply need an AUTO_INCREMENT column
on your table. Then, you might be able to do something like this (with
MIGHT being the operative word):
SELECT * FROM table ORDER BY auto_inc_column DESC LIMIT 22;
I've
On Sun, Dec 14, 2003 at 02:08:07PM +1100, Chris Nolan wrote:
Hi!
Thanks for the detailed reply!
Regarding the hot backup method that the other guys use, sounds like a
dodgy method of doing anything to be honest. It would have to have a
fairly decent performance hit...
It's going to have
35 matches
Mail list logo