John Ratliff wrote:
I'm trying to use a grant statement to grant privileges to a user on a
set of database names.
e.g. for some user k, I want them to be able to have complete access to
any database named k_*.
I know this can be done. The test database is setup this way by default.
Here is wha
I'm administering a Red Hat machine which is used soley for MySQL. The
person working with the db has more than 15 million records in various
tables...they were trying to run some queries to create one table from
these many tables. When this was happening, they ran out of disk space.
They had ab
Gerald Taylor wrote:
I have a table called ratings.
It has 3 rows of interest
id foreign key to another table
quala quality rating
u the user who gave that rating
(also a foreign key into the users table)
Now I would like to select all the unique ids for which the average
qu
Robert Reed wrote:
Greetings.
I have a table that contains procedures and a table
that contains forms. Each procedure may have 1 or
more forms or it may have no associated forms. Each
form may be relevant to more than 1 procedure. The
procedure table has 1 entry per procedure. The forms
table m
Greetings.
I have a table that contains procedures and a table
that contains forms. Each procedure may have 1 or
more forms or it may have no associated forms. Each
form may be relevant to more than 1 procedure. The
procedure table has 1 entry per procedure. The forms
table may have more than
on 05/19/2004 08:36 AM, Brent Baisley at [EMAIL PROTECTED] wrote:
> I wouldn't upgrade until you know where the bottleneck is (CPU, disk,
> network, or RAM). Since you are using "professional" software, I
> wouldn't try to change the queries. Have you made changes to your
> my.cnf file? Since you
On Wed, May 19, 2004 at 11:36:38AM -0400, Brent Baisley wrote:
> I wouldn't upgrade until you know where the bottleneck is (CPU, disk,
> network, or RAM). Since you are using "professional" software, I
> wouldn't try to change the queries. Have you made changes to your
> my.cnf file? Since you h
David Blomstrom wrote:
1. When you talk about including dimensions in image
names, do you mean it literally? For example, if I
create an image in photoshop that measures 150px X
125px, I could save it as horse.jpg, or save it as
horse.150X125.jpg?
Yep, horse.150X125.jpg
And feel free to add any ot
Hello David,
Thursday, May 20, 2004, 2:21:37 AM, you wrote:
DB> --- Hassan Schroeder <[EMAIL PROTECTED]> wrote:
>> Actually, if you include the dimensions in your
>> image *names* --
>> which is a great timesaver -- you can store them as,
>> say
>>
>>ak.200x150.gif
>>
>> and retrieve as
>>
--- Hassan Schroeder <[EMAIL PROTECTED]> wrote:
> Actually, if you include the dimensions in your
> image *names* --
> which is a great timesaver -- you can store them as,
> say
>
>ak.200x150.gif
>
> and retrieve as
>
>SELECT
> img
> , SUBSTRING(img,4,3) AS width
> ,
David Blomstrom wrote:
> then all I have to do is replace $seg with the path to
> the image folder to display my images. The images
> don't even have to be the same size, since I have to
> enter each state's image individually, anyway.
> Actually, it would be more convenient if I could enter
> imag
On May 19, 2004, at 3:12 PM, David Blomstrom wrote:
Suppose I have a field that stores links that look
like this:
images/states/ak.gif"
width="100" height="75" />
images/states/wy.gif"
width="100" height="75" />
and another field that stores image links that look
like this:
images/maps/ak.gif"
widt
I have a table called ratings.
It has 3 rows of interest
id foreign key to another table
quala quality rating
u the user who gave that rating
(also a foreign key into the users table)
Now I would like to select all the unique ids for which the average
quality is below 1.5
so
On May 19, 2004, at 1:19 PM, David Blomstrom wrote:
All "conventional wisdom" I've ever come across for
this type of
application is that there's no advantage to keeping
the image in the db
itself. Just keep them as files on the server, store
a filename &/or
location in the db if necessary, and use
--- Michael Kruckenberg
<[EMAIL PROTECTED]> wrote:
>
> Having images in the database also makes scaling
> pretty simple in that
> we can add replicated slave machines for reading
> images.
I'm not yet familiar with scaling and "replicated
slave machines," but I'm beginning to see more uses
for
Jacob Elder wrote:
Thanks to everyone who helped me with this. I settled on breaking it down
into area code, exchange and subscriber. This is one of the most generous
lists I've ever had the pleasure of begging for help on.
I don't want to deter you from making the changes above, but it's pretty
Hi,
This behaviour is due to a bug (#3657) which has been solved and the
fix is on its way out.
Rgrds Mikael
2004-05-19 kl. 13.35 skrev Maciek Dobrzanski:
Hi,
I have configured MySQL Cluster on two machines with 2 DB nodes
(NoOfReplicas = 2) and 2 MySQL API nodes, one of each node type on both
sy
Part of the problem was the way the server settings were allocating
memory. The concat would work until a certain size and then the
suddenly failed to insert (inserted NULL). After the memory
configuration change, in terms of concatenating (with CONCAT) in
pieces, it seems to work at least
I have an application where I serve out blobs. I store the PDF files in blob fields
for two reasons.
1. I want to make an interface where staff can upload pdf's into the server but not
actually give them access to the server. I use my code to maintain the security of
who gets to write to wh
In a lot of cases storing images on the filesystem makes the most sense.
We store images in a database because we have multiple webservers that
need to both read and write images. Keeping them in MySQL makes this
easy. NFS isn't an option for us.
Having images in the database also makes scaling
On May 19, 2004, at 1:19 PM, David Blomstrom wrote:
I'd like to get some feedback on storing images in
MySQL databases. The stuff I've read so far suggests
that it's fairly difficult to work with images in
MySQL, and they also slow down databases.
I've also read that there isn't much you can do wit
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL Connector/J 3.0.12, a new version of the Type-IV all-Java JDBC
driver for MySQL has been released.
Version 3.0.12 is a bugfix release for the production tree that is
suitable for use with any MySQL version including MySQL-4.1 or MySQL-5.0.
Hi all,
Iá trying to install and use a MySQL binary distribution doing the folowing steps:
Download the file mysql-standard-4.0.20-pc-linux-i686.tar.gz
groupadd mysql
useradd -g mysql mysql
cd /usr/local
gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf -
I'd like to get some feedback on storing images in
MySQL databases. The stuff I've read so far suggests
that it's fairly difficult to work with images in
MySQL, and they also slow down databases.
I've also read that there isn't much you can do with
BLOB's that you can't do with PHP manipulating im
First of all check the *.err log in your data dir. It will likely give you
some clue as to what is happening.
-Original Message-
From: Laercio Xisto Braga Cavalcanti
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 19, 2004 3:08 PM
To: [EMAIL PROTECTED]
Subject: Installing Mysql binary dist
Thanks to everyone who helped me with this. I settled on breaking it down
into area code, exchange and subscriber. This is one of the most generous
lists I've ever had the pleasure of begging for help on.
--
Jacob Elder
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mys
--- Greg Willits <[EMAIL PROTECTED]> wrote:
> On May 19, 2004, at 1:19 PM, David Blomstrom wrote:
>
> All "conventional wisdom" I've ever come across for
> this type of
> application is that there's no advantage to keeping
> the image in the db
> itself. Just keep them as files on the server, st
I'm trying to use a grant statement to grant privileges to a user on a
set of database names.
e.g. for some user k, I want them to be able to have complete access to
any database named k_*.
I know this can be done. The test database is setup this way by default.
Here is what I tried:
grant all
You can try using the old-passwords option in the my.cnf file or you can try
building your ODBC driver from the bitkeeper source. I would check the
documentation to verify that the ODBC build you have supports the 4.1.+
servers.
-Original Message-
From: Arthur Maloney
To: [EMAIL PROTECTED
I am looking for a course in North America that provides mysql and vb.net or
c# training or a good text book or dvds.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have two mysql apps running on the same machine (OS X 10.3.3). A
mysql 3.23.54 on port 14551, and a mysql 4.0.16 on 3306. Each has a
config file specifying the port and a unique socket name in /tmp. They
have coexisted just peachy for a very long time.
Now however, w/o any changes to either M
In the last episode (May 19), Robert A. Rosenberg said:
> I have one suggestion to be added to the base code to assist in
> running multiple levels - Allow the --port=port_number parameter to
> take a list as opposed to only one number (so the server monitors
> more than one port and treats them as
Hello MySQL Listers,
Using myODBC 3.51.07, Win2k SP4, ADO 2.7 & mySQL5
If I make the connection when user account does not have a password it works.
If I set a password I get the error below ???
Which MySQL client is it referring to??
Any suggestions regarding connection string ??
err No -2147
At 15:09 -0500 on 05/18/2004, Paul DuBois wrote about Re: Running
more than one level of MySQL:
At 15:46 -0400 5/18/04, Robert A. Rosenberg wrote:
I have a site that is being hosted by an ISP which is running
version 3.23.52. When I questioned why that downlevel version and
not a 4.0 version (s
I have a subquery where I am retrieving Shipment information from the
DB. I want to LIMIT the result to '1' but I first need the results in
'ID' order.
When I use this subquery I don't get the FIRST row because the data is
not in ID order:
(SELECT TextValue FROM tblQuoteItems WHERE (Type = 6
I wouldn't upgrade until you know where the bottleneck is (CPU, disk,
network, or RAM). Since you are using "professional" software, I
wouldn't try to change the queries. Have you made changes to your
my.cnf file? Since you have enough ram to hold all the data, ram is
probably not your bottlene
> Could you provide structure of tables and some data for testing?
How? I tried to post a couple of zip files (2 mails, 10k each) but it
doesn't work.
Some data (and schema)
CREATE TABLE IF NOT EXISTS PARTITIONED2_1 (
ID int(3) unsigned NOT NULL DEFAULT '0' ,
DATA1 timestamp ,
PRIMARY KEY (
On Wed, May 19, 2004 at 08:47:28AM -0400, Brent Baisley wrote:
> Something that small shouldn't really need optimizing. What is the size
> of your data (mb?, gb?) and what does your query look like? If you are
> doing a wild card search on a large text field without a full text
> index, then tho
"Leonardo Francalanci" <[EMAIL PROTECTED]> wrote:
> I'm using MySql version 4.1.1.
> When I issue a query like
>
> (SELECT * FROM PARTITIONED_1_1 AS PARTITIONED, PARTITIONED2_1 AS
> PARTITIONED2 WHERE
> PARTITIONED2.ID=PARTITIONED.ID1) UNION (SELECT * FROM PARTITIONED_2_1 AS
> PARTITIONED, PARTITI
[EMAIL PROTECTED]
19.05.2004 15:46
An: [EMAIL PROTECTED]
Kopie: [EMAIL PROTECTED]
Thema: Re: Problem with UTF8 and upper case german umlaute
>At a guess, the problem wthe the upper case U-umlaut is that it contains
>the backslash character, which is a str
Hi,
I sent an email yesterday on this topic, but I just wanted to more
clearly and concisely re-phrase the question.
Is it possible for MySQL to run using less than 15Mb of memory?
If so, is it done using:
a) compile options / hacked code
b) configuration options
c) both
If I know the answer t
[EMAIL PROTECTED] wrote on 19/05/2004 14:28:02:
> Hallo,
>
> I am trying to migrate a IBM-DB2 database to MySQL (4.1.1-alpha,
> Gentoo-Linux and Win32) and all is working fine, except the UTF8 tables.
>
> So I have tried a simple example
>
> create table test (
> text varchar(100) char
To honestly answer your question, I would say try both and use whichever
method gives you the best performance in your application.
I don't actually know if the ZEROFILL option forces those zeroes onto the
disk during the write (so that the column is stored that way) or if it is a
signal to the e
I'm using MySql version 4.1.1.
When I issue a query like
(SELECT * FROM PARTITIONED_1_1 AS PARTITIONED, PARTITIONED2_1 AS
PARTITIONED2 WHERE
PARTITIONED2.ID=PARTITIONED.ID1) UNION (SELECT * FROM PARTITIONED_2_1 AS
PARTITIONED, PARTITIONED2_1 AS PARTITIONED2 WHE
RE PARTITIONED2.ID=PARTITIONED.ID1)
"Hongyu Sun" <[EMAIL PROTECTED]> wrote:
>
> I wonder if there exist a type of table which can allow for unlimited or at
> least more than 1024 columns? I know MaxDB has 1024 max columns.
>
Each table type has limitation on the number of columns. According crash-me page it's
3398 columns per tab
Hallo,
I am trying to migrate a IBM-DB2 database to MySQL (4.1.1-alpha,
Gentoo-Linux and Win32) and all is working fine, except the UTF8 tables.
So I have tried a simple example
create table test (
text varchar(100) character set utf8
) default charset=utf8;
insert into test values
Taylor,
You seem to be confusing your user interface with your database. You can
use a variety of techniques to get data from a user via a web page. The
exact methods available to you are dependent on your platform (the web
server and its operating system) and your processing language( ASP, PHP,
Something that small shouldn't really need optimizing. What is the size
of your data (mb?, gb?) and what does your query look like? If you are
doing a wild card search on a large text field without a full text
index, then those times may be the best you're going to get. Many times
it's about op
I think if you are looking for unlimited columns, you may want to
rethink your database structure. Databases are designed for unlimited
rows, not columns. Whatever data you were looking to put into unlimited
columns, should be put into rows in a related table. I usually do this
by adding a "qua
Trevor Price <[EMAIL PROTECTED]> wrote:
>
> What is the roadmap for fully compliant GIS?
>
> " The OpenGIS specification defines the following functions, which MySQL
> does not yet implement. They should appear in future releases. When
> implemented, they will provide full support for spatial a
Hi,
I have configured MySQL Cluster on two machines with 2 DB nodes
(NoOfReplicas = 2) and 2 MySQL API nodes, one of each node type on both
systems. The config is almost the same as the one of 2-node demo. The
cluster is working fine as long as all DB nodes are operational, but if one
of them is g
sorry Egor Egorov, Mutt sent the mail to your private inbox ;)
resending to the mailing list.
On Wed, May 19, 2004 at 02:02:29PM +0300, Egor Egorov wrote:
> Mohammed Sameer <[EMAIL PROTECTED]> wrote:
> > I'm running a MySQL server on a duel P III 1G, with 2 GB RAM.
> > MySQL 4.0.18 compiled from s
"Rocco Castino" <[EMAIL PROTECTED]> writes:
> I would like, for example, to get the records starting from row number 6
> (without, of course, working with the primary key, where the numbers could
> not necessarily be sorted as here):
> +++---+---+
> | id_example
Mohammed Sameer <[EMAIL PROTECTED]> wrote:
> I'm running a MySQL server on a duel P III 1G, with 2 GB RAM.
> MySQL 4.0.18 compiled from source.
>
> We have 2 webservers running apache, And this is the backend database server.
> The server is really slow.
> a select on a table with 138,247 rows take
sbraun <[EMAIL PROTECTED]> wrote:
>
> I have many tables to upload, but each time I try I get a syntax error
> 1064.
> What format should my table be in?
> I've been attempting to upload tab delimited text, but I can't get
> past an error in line 1.
> I can't see any errors.
>
How did you try
SQL
I have the problem like this under FreeBSD 5.2 with libkse (kernel
threads).
Server with high loading doesn't want to shutdown.
But server with low loading does.
> Steve,
>
> I have had this same problem exept the entire server does not hang, only
> one thread which experiences a signficiat s
Sasha Pachev:
> > I actually do have a fairly long chapter on that subject in "MySQL
(...)
> > would be willing if the opportunity presented itself. If somebody could
> > find a good way to sell it, I would write it.
Maybe you can publish something on a website as "MySQL Enterprise
Solutions - The
Hi,
Sasha Pachev wrote:
Hans-Peter Grimm wrote:
I just finished reading "High Performance MySQL". Congratulations to
the authors, it's a great book and I enjoyed reading it. Would be
great if someone now started to write "MySQL Internals" ;-)
I actually do have a fairly long chapter on that subje
Hi,
I'm running a MySQL server on a duel P III 1G, with 2 GB RAM.
MySQL 4.0.18 compiled from source.
We have 2 webservers running apache, And this is the backend database server.
The server is really slow.
a select on a table with 138,247 rows takes about 1.6 - 2+ seconds, I have about 50%
CPU id
59 matches
Mail list logo
