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 know
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;
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';
-
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
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
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 mysql@lists.mysql.com...
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
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
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,
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
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.
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,
-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
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.
... 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:
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
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
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
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?
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
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
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 data
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.
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
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
25 matches
Mail list logo