On 10/9/06, Ow Mun Heng [EMAIL PROTECTED] wrote:
On Mon, 2006-10-09 at 11:42 +0700, Ady Wicaksono wrote:
Is your MSSQL data structure contain such foreign key?
If yes, my isam is not suitable for you
Actually, you know what? I don't really know.
How does one go about checking?
Dump it to
Hi,
The difference is noticeable (sometimes 15 seconds), as it is being performed
on a webpage. The slow server is running at 100mb and ping times to the
database server are 1ms or less.
Could the problem with be IIS ?
Thanks
Neil
Date: Sun, 8 Oct 2006 17:17:07 -0500 To:
On Mon, 2006-10-09 at 13:02 +0700, Ady Wicaksono wrote:
On 10/9/06, Ow Mun Heng [EMAIL PROTECTED] wrote:
On Mon, 2006-10-09 at 11:42 +0700, Ady Wicaksono wrote:
Is your MSSQL data structure contain such foreign key?
If yes, my isam is not suitable for you
Actually, you know what? I
Hi,
Yes, it still allows duplicate (equal) rows to be inserted :(
Show us the result of your SELECT * from wl_users
Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database
Robert DiFalco wrote:
Here's an odd one.
I have a table called Elements and another table called ElementNames.
The ElementNames table has a unique ID and a VARCHAR display name. The
Elements table has a ElementName.ID, a node ID, a rule ID and some other
stuff.
I have an index on the NameID,
m i l e s wrote:
Hi,
Can anyone tell me if this is the correct syntax for a self reference
Index ?
-- ALTER TABLE `RPI_CTYPE` ADD FOREIGN KEY (`RPI_CT_REPLCID`)
REFERENCES `RPI_CTYPE`(`RPI_CT_ID`);
-- CREATE INDEX RPI_H_REPLCID_idxfk ON RPI_HOW (RPI_H_REPLCID);
If you try it what
Hi,
I have a database where the database character set is utf-8 and some rows
are ascii.
I want to save the results of some queries, and SELECT ... INTO OUTFILE
looks like an easy way to do it. But I need the output in ucs-2. Is there
any way to specify the charset for SELECT ... INTO OUTFILE,
Hi all,
I have installed MySql 4.1 in my system. when I tried to run Mysql , I
always gets this error.
Could not start MySql service on a local computer
Error 1067: the process terminated unexpectedly.
Any help is highly appreciated.
Regards,
Renish
- Original Message -
From:
Hi,
User can also specify character set during the SELECT operation also with
CHARACTER SET or charset.
Use mysqlcharset utf 8
before issuing SELECT query.
For Instance:
If you do not say SET NAMES or SET CHARACTER SET, then for SELECT column1 FROM
t, the server sends back all the values
He's dropping the table just prior to running the problematic query,
so I don't think optimizing the destination table will make a
difference. Optimizing the source might speed it up a little, but
he's looking at a difference of 2 minutes to 74 minutes if I'm
understanding correctly when simply
How to speed up query of indexed column with 5M rows?
I have a table with more than 5M rows. (400M .MYD 430M .MYI).
It took 27 seconds to do a common select...where... in the index column.
I can not bear the long run.
Vmstat show that system was bounded by IO busy.(Always more than 13000
bowen -
Right now, it appears your performance hinges on I/O to the disk drive.
The reason you are seeing fast performance when querying against the
primary key(SELECT COUNT(*)) is it is only reading from the index,
which is probably all in memory. When you do a SELECT * even when
against an
Dan Buettner wrote:
bowen -
Right now, it appears your performance hinges on I/O to the disk drive.
The reason you are seeing fast performance when querying against the
primary key(SELECT COUNT(*)) is it is only reading from the index,
which is probably all in memory. When you do a SELECT *
hello,
I have an application were rows are recorded every minute or so in bursts of
about 5-10 simultenous to a MyISAM table with AUTO_INCREMENT field. Though they
are saved in serial order (one of the other in a single row per insert) there
is very short time between each two inserts.
Hi,
I would like to install the new versin of mysql but currently i have mysql
version 3.23 running...
I need to have 2 version of mysql running at the moment in win2000 for
different app.
what is the steps for me to install the new version of mysql without causing
error and able to run
Hi All,
Just wanted to know if it would be faster/better to implement this
option into my.cnf
innodb_file_per_table = 1
which would essentially make each table a file on it's own rather than
have it all in 1 file.
My belief is that it would be slightly more advantageous compared to 1
BIG file.
I have an interesting suggestion with regard to SELECT COUNT(*)
In the book Oracle8i Certified Professional DBA Certification Exam Guide (ISBN
0072130601),
page 78 talks about what Oracle does to evaluate SELECT COUNT(*). The asterisk
inside the
parentheses informs Oracle to look for any
Hi,
I'm running FreeBSD 6.1, mysql 5.0.24a(binaries from mysql ab) and are
running some benchmarks using sysbench, what kind of performance should
i expect?
The machine is a Dell poweredge 1800 with the cerc raid controller (two
sata disks in raid1).
sysbench command:
sysbench --test=oltp
For some reason it's not using the index on the owner field (flow_fk_owner), it's doing a full table scan. Which also explains the
i/o results from vmstat. Since MySQL is not using the index, that means it determined a full table scan would be quicker (MySQL
doesn't always get this right).
You
In the last episode (Oct 09), Ow Mun Heng said:
Just wanted to know if it would be faster/better to implement this
option into my.cnf
innodb_file_per_table = 1
which would essentially make each table a file on it's own rather
than have it all in 1 file. My belief is that it would be
DBTools Software is pleased to announce the new DBManager Professional 3.4.0
Enterprise Edition.
This is a major update with plenty of bugs fixed and new improvements to the
application. See the details:
NEW FEATURES AND IMPROVEMENTS
- Added Context Menu for Default Servers
- Diagram Designer
At 22:43 +0100 10/8/06, Deckard wrote:
Hi,
Yes, it still allows duplicate (equal) rows to be inserted :(
Best Regards,
Deckard
I don't see the test case I asked for.
If you're seeing that records are duplicate except that they
differ in ID value, that doesn't count as duplicate. But in
Hi Paul,
Now, i have this:
CREATE TABLE wl_users(wl_user_id INT NOT NULL AUTO_INCREMENT PRIMARY
KEY, name VARCHAR(255) NOT NULL, email VARCHAR(50) NOT NULL, password
VARCHAR(40) NOT NULL, UNIQUE (wl_user_id, email)) TYPE=MyISAM;
and the issue persists :(
Best Regards,
Deckard
Paul DuBois
Now, i have this:
CREATE TABLE wl_users(wl_user_id INT NOT NULL AUTO_INCREMENT PRIMARY
KEY, name VARCHAR(255) NOT NULL, email VARCHAR(50) NOT NULL, password
VARCHAR(40) NOT NULL, UNIQUE (wl_user_id, email)) TYPE=MyISAM;
and the issue persists :(
Show us the data you're inserting into this
At 17:17 +0100 10/9/06, Deckard wrote:
Hi Paul,
Now, i have this:
CREATE TABLE wl_users(wl_user_id INT NOT NULL AUTO_INCREMENT PRIMARY
KEY, name VARCHAR(255) NOT NULL, email VARCHAR(50) NOT NULL, password
VARCHAR(40) NOT NULL, UNIQUE (wl_user_id, email)) TYPE=MyISAM;
and the issue persists :(
Hi,
Now it's working :)
CREATE TABLE wl_users(wl_user_id INT NOT NULL AUTO_INCREMENT PRIMARY
KEY, name VARCHAR(255) NOT NULL, email VARCHAR(50) NOT NULL, password
VARCHAR(40) NOT NULL, UNIQUE (name, email, password)) TYPE=MyISAM;
Thank you all.
Warm Regards,
Deckard
Martijn Tonies wrote:
What is the cardinality of the flow_fk_owner index?
If the number of distinct owners is low, say 50, then the 'flow_fk_owner'
index contains 50 sets of 100,000 rows with the same key. Even if you run
ANALYZE TABLE or OPTIMIZE TABLE, if the key distribution of the owner across
the table (not the
- Original Message -
From: Dan Nelson [EMAIL PROTECTED]
To: Ow Mun Heng [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Monday, October 09, 2006 9:12 AM
Subject: Re: InnoDB, 1 file per table or 1 BIG table?
In the last episode (Oct 09), Ow Mun Heng said:
Just wanted to know if it
In the last episode (Oct 09), James Eaton said:
From: Dan Nelson [EMAIL PROTECTED]
I don't think that the number of files has any impact on query
speed. The advantage file-per-table gives you is the ability to
recover unused space easily by running OPTIMIZE TABLE. With a
single tablespace,
On Oct 9, 2006, at 7:15 AM, Ow Mun Heng wrote:
Hi All,
Just wanted to know if it would be faster/better to implement this
option into my.cnf
innodb_file_per_table = 1
which would essentially make each table a file on it's own rather than
have it all in 1 file.
My belief is that it would be
- Original Message -
From: Bruce Dembecki [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Cc: Ow Mun Heng [EMAIL PROTECTED]
Sent: Monday, October 09, 2006 3:13 PM
Subject: Re: InnoDB, 1 file per table or 1 BIG table?
There are some minor performance benefits here when run against
On Mon, 2006-10-09 at 15:42 -0600, James Eaton wrote:
- Original Message -
From: Bruce Dembecki [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Cc: Ow Mun Heng [EMAIL PROTECTED]
How do you go about converting InnoDB databases from the single tablespace
to those using the
On Mon, 2006-10-09 at 14:13 -0700, Bruce Dembecki wrote:
On Oct 9, 2006, at 7:15 AM, Ow Mun Heng wrote:
Hi All,
Just wanted to know if it would be faster/better to implement this
option into my.cnf
innodb_file_per_table = 1
which would essentially make each table a file on it's
Currently I run an 'updater' script to run through a directory of .sql files
using something like this in PHP:
$COMMAND = mysql .$OPTION['db_prefix'].$db. .$mydir.$filename;
system($COMMAND, $ret);
What would be the equivallent way to to this in a PHP mysql_query(); way?
I see
Daevid Vincent wrote:
Currently I run an 'updater' script to run through a directory of .sql files
using something like this in PHP:
$COMMAND = mysql .$OPTION['db_prefix'].$db. .$mydir.$filename;
system($COMMAND, $ret);
What would be the equivallent way to to this in a PHP
+---++-+--+-+---+-+--++--++-+
| Table | Non_unique | Key_name| Seq_in_index | Column_name |
Collation | Cardinality | Sub_part | Packed | Null | Index_type |
Comment |
Hi all,
I have installed MySql 4.1 in my system. when I tried to run Mysql , I
always gets this error.
Could not start MySql service on a local computer
Error 1067: the process terminated unexpectedly.
Any help is highly appreciated.
Regards,
Renish
--
MySQL General Mailing List
For
- Original Message -
From: Renish [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, October 09, 2006 5:02 PM
Subject: Fw: simple database query
- Original Message -
From: Renish [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, October 06, 2006 12:55 PM
Subject:
- Original Message -
From: Renish [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, October 09, 2006 4:56 PM
Subject: Fw: simple database query
- Original Message -
From: Renish [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, October 05,
Hi all,
I have installed MySql 4.1 in my system. when I tried to run Mysql , I
always gets this error.
Could not start MySql service on a local computer
Error 1067: the process terminated unexpectedly.
Any help is highly appreciated.
Regards,
Renish
--
MySQL General Mailing List
For
Hi all,
I have installed MySql 4.1 in my system. when I tried to run Mysql , I
always gets this error.
Could not start MySql service on a local computer
Error 1067: the process terminated unexpectedly.
Any help is highly appreciated.
Regards,
Renish
my name is alan madsen.
while i am very well grounded in complex systems and database
management that is archaic by today's standards, i am looking
at a creating a server-side php/mysql environment for a very
simple database application with only the experience of recent
light reading and
my name is alan madsen.
while i am very well grounded in complex systems and database
management that is archaic by today's standards, i am looking
at a creating a server-side php/mysql environment for a very
simple database application with only the experience of recent
light reading and
Renish koshy wrote:
Hi all,
I have installed MySql 4.1 in my system. when I tried to run Mysql , I
always gets this error.
Could not start MySql service on a local computer
Error 1067: the process terminated unexpectedly.
Stop sending this message!
We get the idea!
The more you send it,
Why does mysql drop index very very slow in a large table?
I have a large table with more than 5M rows, and many indexes. Now I
want to drop some of them. But it seems that mysql can not handle this
very well. It takes a very long time (more than half an hour) to do ,
and make me unbearable.
I don't know if it will work - but have you tried using SOURCE in the mysql
query?
-Original Message-
From: Daevid Vincent [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 10, 2006 11:01 AM
To: mysql@lists.mysql.com
Subject: What's the PHP equivallent of mysql mydb somefile.sql
Xp
- Original Message -
From: Visolve DB Team [EMAIL PROTECTED]
To: Renish koshy [EMAIL PROTECTED]
Sent: Tuesday, October 10, 2006 11:42 AM
Subject: Re: Query Help plss
Hi,
On which platform?
Thanks
ViSolve DB Team.
- Original Message -
From: Renish koshy [EMAIL PROTECTED]
- Original Message -
From: Renish
To: Visolve DB Team ; mysql@lists.mysql.com
Sent: Tuesday, October 10, 2006 12:35 PM
Subject: Fw: Query Help plss
- Original Message -
From: Renish
To: mysql@lists.mysql.com ; Visolve DB Team
Sent: Tuesday, October 10, 2006 12:34 PM
Hi
The .err file shows that the service is stopped Normally and no error was
found. sure the service is properly shutdown.
Try,
a)
net stop mysql
mysqld-nt remove
mysqld-nt install
net start mysql
b)
Also run 'services.msc' and double click on the mysql service, make sure its
comming from
Hi,
Hope this link will you.
http://mysql.binarycompass.org/doc/refman/4.1/en/can-not-connect-to-server.html
Thanks,
ViSolve DB Team.
- Original Message -
From: Visolve DB Team [EMAIL PROTECTED]
To: Renish [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Tuesday, October 10, 2006
50 matches
Mail list logo