Thank u krishna.
On 7/3/07, krishna chandra prajapati <[EMAIL PROTECTED]> wrote:
Hi,
Yes, it is possible. the command i have given in my previous email will
make u to connect from mysql database server. The command below will make
you to connect from the client computer
The command is " grant a
Hi,
Yes, it is possible. the command i have given in my previous email will make
u to connect from mysql database server. The command below will make you to
connect from the client computer
The command is " grant all privileges on *.* to 'user1'@'192.169.6.%'
identified by password"
The command b
Hi Krishna,
If i execute a new grant statement, then the new previlage will over ride
the old previlage, if this happens, then i will not be able to connect from
other client machines. I want to connect from client also from the local
host.
Is this possible.
regards
anandkl
On 7/3/07, krishna c
Hi Everybody,
The user which has been created with all previleges on all db, will only
work from the client machine only. If you want to access from the mysql
database server you have to create a user "grant all privileges on *.* to
'%'@'localhost' identified by password". I hope this should work
On Mon, 2007-07-02 at 21:19 -0700, Ed Lazor wrote:
> I have a 400mb database. The first query to tables takes about 90 seconds.
> Additional queries take about 5 seconds. I wait a while and run a query
> again; it takes about 90 seconds for the first one and the rest go quickly.
> I'm guessing d
I have a 400mb database. The first query to tables takes about 90 seconds.
Additional queries take about 5 seconds. I wait a while and run a query
again; it takes about 90 seconds for the first one and the rest go quickly.
I'm guessing data is being loaded into memory which is why things speed up
I am limiting text to 50 chars in mysql field by varchar(50) ( UTF-8
enabled)
but what if the user enters 50 japanese chars, does mysql accomodate it OR
we have to consider some buffer during design ?
--
Cathy
www.nachofoto.com
On Mon, July 2, 2007 21:10, Hiep Nguyen wrote:
>
> take your advice, i looked in to JOIN and i got the idea. but i noticed
> that in order to use JOIN, don't you need to have the same column name in
> both tables? i just don't see it in your example here. is there
> something that i'm missing?
On Mon, 2 Jul 2007, Christophe Gregoir wrote:
CREATE TABLE `tags` (`tagid` INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
`location` VARCHAR(255) NOT NULL DEFAULT '') ENGINE=INNODB;
CREATE TABLE `dimension_type` (`id` ..., `type` VARCHAR(255) NOT NULL DEFAULT
'') ENGINE=INNODB;
CREATE TABLE `tags
Hi,
Could someone please help me to get rid of "Using temporary; Using filesort"
from the following SQL statement?
SELECT a.document_id AS id, attr_name AS name, attr_value AS value, attr_order
AS ord FROM attributes a INNER JOIN status s ON (a.document_id = s.document_id)
WHERE update_flag
Hello,
I've got a strange issue and was curious if anyone might be able to
shed some light on the issue. About 2-3 times an hour (not
predictable) we see huge bursts of syscall behavior (150,000-200,000
over a 2 second interval). This is on MySQL-5.1.14 on a Solaris 10
AMD64 box.
Using DTrace we
... we are using file-per-table.
also, it occurred to me after sending my first email: perhaps innodb is
already doing something under the hood to make sure the tables are in
the same state on startup as they were left on shutdown
Les
--
MySQL General Mailing List
For list archives: http:/
we are doing a checksum on our Innodb tables before we shut the server
down (Windows) so that when we restart, we can compare the before and
after. the reason for this is we are encrypting files in between data
collection sessions, and we are making double sure we haven't munged our
data.
however,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL Connector/J 5.1.2 beta, a new version of the Type-IV pure-Java JDBC
driver for MySQL has been released.
Version 5.1.2 is suitable for use with any MySQL version including MySQL-4.1,
MySQL-5.0, MySQL-5.1 beta or the MySQL-6.0 Falcon alph
CREATE TABLE `tags` (`tagid` INT(11) UNSIGNED AUTO_INCREMENT PRIMARY
KEY, `location` VARCHAR(255) NOT NULL DEFAULT '') ENGINE=INNODB;
CREATE TABLE `dimension_type` (`id` ..., `type` VARCHAR(255) NOT NULL
DEFAULT '') ENGINE=INNODB;
CREATE TABLE `tags_shape_dimensions` (`tag` INT(11) UNSIGNED, `dim
On Mon, 2 Jul 2007, Borokov Smith wrote:
Or:
Tag
ShapeDimension (type enum('height', 'thickness', etc), value VARCHAR() or
INT())
TagsShapeDimensions (FOREIGN KeY TAG, FOREIGN KEY ShapeDimension)
1 less table
Greetz,
boro
Rajesh Mehrotra schreef:
Hi,
You can do this in four tables:
1.
On Mon, 2 Jul 2007, Rajesh Mehrotra wrote:
Hi,
You can do this in four tables:
1. Tag
2. Shape (with an additional field, let us call it X, describing how
many data elements each shape has)
3. ShapeElements : one record describing each data element (length,
width etc.) for each shape. Record co
Or:
Tag
ShapeDimension (type enum('height', 'thickness', etc), value VARCHAR()
or INT())
TagsShapeDimensions (FOREIGN KeY TAG, FOREIGN KEY ShapeDimension)
1 less table
Greetz,
boro
Rajesh Mehrotra schreef:
Hi,
You can do this in four tables:
1. Tag
2. Shape (with an additional field, let
Hi,
You can do this in four tables:
1. Tag
2. Shape (with an additional field, let us call it X, describing how
many data elements each shape has)
3. ShapeElements : one record describing each data element (length,
width etc.) for each shape. Record count for each shape: X
4. Data Table : "X" numb
is this list working? my last post failed? re-try.
T. Hiep
-- Forwarded message --
Date: Mon, 2 Jul 2007 05:53:17 -0700 (PDT)
From: Hiep Nguyen <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Subject: database structure
Hi all,
i'm seeking for help/suggestion on how to create
The original message was received at Mon, 2 Jul 2007 07:44:14 -0500 from
216.128.196.211
- The following addresses had permanent fatal errors -
mysql@lists.mysql.com
- Transcript of session follows -
... while talking to host lists.mysql.com.:
550 5.1.2 ... Host unknown (Name ser
Hi all,
i'm seeking for help/suggestion on how to create relationship for this
scenario:
I have one table (tag) with the following fields:
tagid, location, weight, grade, heat, shape, diameter, length, width,
height, ... (and many other fields)
what i want to do is move the shape field in
Hi,
Pls try altering the engine type from 'MyISAM' to 'InnoDB'
mysql > alter table `tablename` ENGINE='InnoDB';
Just try out. I'm not sure. But there are issues over 'MyISAM' engine' and
table corruption. Pls look into the link
http://dev.mysql.com/doc/refman/5.0/en/corrupted-myisam-tables.h
Hi,
just try like:
mysql> create procedure mi()
-> begin
-> declare done int default 0;
-> declare table_name varchar(50);
-> declare cur1 cursor for select tables.table_name from
information_schema.tables where table_schema='test' and table_type='BASE
TABLE' and engine='MyISAM';
hello
I am still facing the same problem..
MyISAM table corruptionI am getting following errors
mysql> use DB1;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> check table tables1;
+--
Thank you for your information.
It's really helpful.:)
It seems that I'll have to dig deep into the fulltext search functionality.
2007/7/2, ViSolve DB Team <[EMAIL PROTECTED]>:
Hi,
There are some words which are drawn as "Stop words" [Words which are not
searchable in Fulltext Database]. To kn
26 matches
Mail list logo
