I'm newbie to mysql and I want to install mysql under Centos 5.8 using
MySQL-server-5.5.37-1.linux2.6.i386.rpm, I use following command to intall mysql
#[root@master software]# rpm -ivh MySQL-server-5.5.37-1.linux2.6.i386.rpm
Preparing...
Am 04.05.2014 08:29, schrieb EdwardKing:
I'm newbie to mysql and I want to install mysql under Centos 5.8 using
MySQL-server-5.5.37-1.linux2.6.i386.rpm, I use following command to intall
mysql
#[root@master software]# rpm -ivh MySQL-server-5.5.37-1.linux2.6.i386.rpm
Preparing...
Hello,
mysqladmin and mysql command-line client is included in MySQL-client
package.
mysql_secure_installation is included in MySQL-server but it's a perl
script which calls mysql command-line client internally.
Thus, you should install MySQL-client-*.rpm and try again.
Regards,
2014-05-04
2010/11/4 Changying Li lchangy...@gmail.com:
PRIMARY KEY (`threadid`),
KEY `dateline` (`dateline`),
KEY `forumid_2` (`forumid`,`thread_type_id`,`visible`,`sticky`,`dateline`),
KEY `forumid` (`forumid`,`visible`,`sticky`,`dateline`)
) ENGINE=InnoDB AUTO_INCREMENT=660 DEFAULT CHARSET=utf8;
yes, I tried :
mysql explain SELECT forumid,visible,sticky,dateline FROM `abc` WHERE
`forumid` = 25 AND `visible` = 1 AND `sticky` = 0 order by dateline \G
*** 1. row ***
id: 1
select_type: SIMPLE
table: abc
type: ref
On Fri, 2010-11-05 at 15:46 +0800, Changying Li wrote:
yes, I tried :
mysql explain SELECT forumid,visible,sticky,dateline FROM `abc` WHERE
`forumid` = 25 AND `visible` = 1 AND `sticky` = 0 order by dateline \G
*** 1. row ***
id: 1
CREATE TABLE `abc` (
`threadid` int(11) NOT NULL AUTO_INCREMENT COMMENT '主题id',
`thread_type_id` int(11) DEFAULT NULL COMMENT '主题类别表id',
`forumid` smallint(6) DEFAULT NULL COMMENT '主键id',
`title` varchar(250) DEFAULT NULL COMMENT '标题',
`lastpost` int(11) DEFAULT NULL COMMENT '最后回复时间',
Hello.
As said at:
http://dev.mysql.com/doc/mysql/en/query-cache-how.html
A query will not be cached, if it uses TEMPORARY tables.
Homam S.A. [EMAIL PROTECTED] wrote:
Why MySQL insists on ignoring the query cache whenever
I use the same query repeatedly to populate a temp
Why MySQL insists on ignoring the query cache whenever
I use the same query repeatedly to populate a temp
table?
So I have:
create temporary table MyTable
select SQL_CACHE * from SomeTable WHERE (A bunch of
criteria) limit 1000;
SomeTable is a read-only table.
If I issue the query without
for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
- Original Message -
From: Martijn Tonies [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Friday, January 28, 2005 10:05 PM
Subject: Re: Why MySQL is very slow in dropping indexes?
This extreme
Dropping an index on a MyISAM table should be
instantaneous. It should only take as long as deleting
the idx file from the file system. But it's taking
almost as long as creating the index itself!
Here's my queries and time they took:
/*[10:58:17 AM][367172 ms]*/ alter table MyTable add
index
Homam S.A. [EMAIL PROTECTED] wrote on 01/28/2005 02:27:51 PM:
Dropping an index on a MyISAM table should be
instantaneous. It should only take as long as deleting
the idx file from the file system. But it's taking
almost as long as creating the index itself!
Here's my queries and time they
Homam S.A. wrote:
This extreme slowness in dropping a simple index in
MySQL defeats the whole strategy of dropping indexes
on some tables before a huge insert operation.
See http://dev.mysql.com/doc/mysql/en/alter-table.html ,
especially these bits:
Note that if you use any other option to ALTER
Homam S.A. wrote:
Dropping an index on a MyISAM table should be
instantaneous. It should only take as long as deleting
the idx file from the file system. But it's taking
almost as long as creating the index itself!
Here's my queries and time they took:
/*[10:58:17 AM][367172 ms]*/ alter table
This extreme slowness in dropping a simple index in
MySQL defeats the whole strategy of dropping indexes
on some tables before a huge insert operation.
See http://dev.mysql.com/doc/mysql/en/alter-table.html ,
especially these bits:
Note that if you use any other option to ALTER TABLE
many advanced features that MySQL dowsn't provide, first question that
hits my mind is why is it so?
Why MySQL is used more in comparison
to MaxDB
I am unable to find any genuine reason
behind this, hope you can help me out
Thanks Regards...
Pratik Ajmera
Tata Consultancy Services
Raheja
in comparison to MySQL. If I
link this with the fact that MaxDB provides many advanced features that
MySQL dowsn't provide, first question that hits my mind is why is it so?
Why MySQL is used more in comparison to MaxDB
I am unable to find any genuine reason behind this, hope you can help me
out
Chris Nolan wrote:
The answers are wide and varied:
* History - MySQL has been an open source product for longer
* Flexibility - MySQL's different table types are ideal for some situations
* Performance - MySQL is the fastest database on the planet for most tasks
* Support - There are massive
I am with a problem in one query of simple DELETE.
#1205 - Lock wait timeout exceeded; Try restarting transaction
Why mysql LOCK this line and does not allow that I delete, if I did not
emit none stantment of LOCK?
Please, help me!
Bruno Rodrigues Silva
Brazil.
--
MySQL General Mailing List
I just installed mysql binary in my Linux system.
I tried ./bin/safe_mysqld
also tried /etc/init.d/mysqld start
the system always give me starting MySQL [OK] information.
Then the mysqld ended running.
/etc/init.d/mysqld status
gives me information like
mysql dead but subsys locked
Hi!
I have a little pb with indexes.
when I make an explain on my query I have strange results.
my query looks like this
select *
from LIST l, WIN c
where l.ID_LIST=c.ID_LIST and l.KEY = '421' and l.ACTIF='1';
table LIST :
ID_LIST(primary key), KEY, ACTIF, ...
table WIN
ID_WIN(primary key),
Are you trying to use a download manager?. If so .. it didnt work for me.
Disable it, and it will work.
vicente
-Mensaje original-
De: Alex Shi [mailto:[EMAIL PROTECTED]]
Enviado el: miércoles, 12 de diciembre de 2001 23:46
Para: [EMAIL PROTECTED]
Asunto: Why MySQL GUI download don't
Alex Shi writes:
I tried to download MySQL GUI from these links:
http://www.mysql.com/Downloads/mysqlgui/mysqlgui-win32-static-1.7.5-2.zip
and
http://www.mysql.com/Downloads/mysqlgui/mysqlgui-linux-static-1.7.5-1.tar.gz
But all these don't work.
Alex
Hi!
Please try another mirror,
I tried to download MySQL GUI from these links:
http://www.mysql.com/Downloads/mysqlgui/mysqlgui-win32-static-1.7.5-2.zip
and
http://www.mysql.com/Downloads/mysqlgui/mysqlgui-linux-static-1.7.5-1.tar.gz
But all these don't work.
Alex
- Original Message -
From: Matthew Darcy [EMAIL
Hi can u tell me which version mysql can run under xp ?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
Howard Picken [EMAIL PROTECTED] wrote:
I'm trying to import a csv file into a db.
all text fields are enclosed and all fields are , delimited.
the file is 900 records long.
The error I'm getting is..
ERROR 1062 at line 1: Duplicate entry '127' for key 1
Your ID field is type 'TINYINT'
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 25 April 2001 2:31 PM
To: Howard Picken
Subject: Why MySQL db will only allow 127 records imported?
Your message cannot be posted because it appears to be either spam or
simply off topic to our
: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 25 April 2001 2:31 PM
To: Howard Picken
Subject: Why MySQL db will only allow 127 records imported?
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must
On Friday 02 March 2001 18:22, Boulat Khakimov wrote:
Hi guys,
I'm wondering why you prefered mySQL overe Postgres , they are both open
source,
and accorting to many people Postgres is more powerful and stable than
mySQL.
Trivial installation and update on my Linux Redhat box thanks to the
Hi guys,
I'm wondering why you prefered mySQL overe Postgres , they are both open
source,
and accorting to many people Postgres is more powerful and stable than
mySQL.
I've been using mySQL for awhile myself, but recently, I've been
extremely frustrated
by mySQLs bugginess ... the BDB
Boulat Khakimov wrote:
Hi guys,
I'm wondering why you prefered mySQL overe Postgres , they are both open
source,
and accorting to many people Postgres is more powerful and stable than
mySQL.
I've been using mySQL for awhile myself, but recently, I've been
extremely frustrated
by
I'm wondering why you prefered mySQL overe Postgres , they are both open
source,
and accorting to many people Postgres is more powerful and stable than
mySQL.
Hmm... It's free, robust, damn fast, small footprint, lots of free add on software
available, it's free.
The other thing
Yes MySQL has excellent support :) Thats why I use MySQL and ASTA MySQL Server. Both
of these are excellent produtcs.
Cheers
Mike
-Original Message-
FROM: [EMAIL PROTECTED]
TO: [EMAIL PROTECTED]
DATE: Fri 3/2/01 11:08
SUBJECT: Re: Why MySQL?
I'm wondering why you prefered mySQL
On Fri, 2 Mar 2001, Evan James Dembskey wrote:
I chose MySQL for our products because I could NOT get postgres to run
on
SCO Openserver, even though it was supposed to be supported.
I tried for 2 months to get help on the postgress mailing list.
Nobody offered ANY help.
olivefan wrote:
why mysql eat my memory over 1G?Please help me!Thank you!!!
server1:DELL6300,4cpu,4G memory.solaris5.7 for X86 .
mysql start command:nohup /usr/local/bin/safe_mysqld -O key_buffer=128M -O
35 matches
Mail list logo
