A workaround is to use mysqlhotcopy to snapshot the table and also only copy
the header to the MYI file. Then delete the original and rename the copy back
to the original. This will effectively drop all indexes and should take no
more time than what the disk takes to copy the .my* files.
-
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]>;
Sent: Tuesday, October 10, 2006 11:03 AM
Subject:
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 f
- 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
Subjec
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
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"
Cur
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.
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, th
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 knowin
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 knowin
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
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 lis
- 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,
- 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
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 lis
+---++-+--+-+---+-+--++--++-+
| Table | Non_unique | Key_name| Seq_in_index | Column_name |
Collation | Cardinality | Sub_part | Packed | Null | Index_type |
Comment |
+-
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
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?
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 tabl
On Mon, 2006-10-09 at 15:42 -0600, James Eaton wrote:
> - Original Message -
> From: "Bruce Dembecki" <[EMAIL PROTECTED]>
> To:
> Cc: "Ow Mun Heng" <[EMAIL PROTECTED]>
> How do you go about converting InnoDB databases from the single tablespace
> to those using the table-per-file file o
- Original Message -
From: "Bruce Dembecki" <[EMAIL PROTECTED]>
To:
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
benchmarks... but tin
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 sl
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 t
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
To: "Ow Mun Heng" <[EMAIL PROTECTED]>
Cc:
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 would be faster
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 in
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:
>> No
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 :(
> 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 int
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 wrot
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
that
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 b
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 sh
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 --mysql
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 non-nul
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.
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 (ad
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 concur
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.
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 SE
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 in
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
bi/s,
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 S
Hi,
User can also specify character set during the SELECT operation also with
CHARACTER SET or charset.
Use mysql>charset 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
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: "Ch
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,
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 ha
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, No
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 develo
48 matches
Mail list logo