唯一的账户root没有密码，服务可以启动 ps -e | grep mysqld 有进程mysqld_safe,mysqld n 个
我想改/加密码，mysqladmin -uroot 返回错误，连不上服务器
to Xiaodong: 你说得原来的协议指的是?
thank u all.
On 9/7/05, 王静 [EMAIL PROTECTED] wrote:
/usr/local/mysql--
On 9/7/05, Gu Lei [EMAIL PROTECTED] wrote:
王静 写道:
hi all.
i've installed MySQL
Hello, currently I run mysql 3.x on Mac OS X 10.3.
I have about as much ram in the machine as I can, and have tunes it the best
I can, however, I still see the performance drop pretty badly at times.
After reading this:
http://www.anandtech.com/mac/showdoc.aspx?i=2436 I suspect OS X is just
not
On 9/7/05, Ben [EMAIL PROTECTED] wrote:
What linux where you using?
RedHat linux 2.4.21
A blank password is not a good idea, I'm
not sure if it is allowed anyway.
yeah, i know. so what i'm trying to do is adding/changing password for
the only account root with the tool mysqladmin. but the
yeah, i can access the database server normally with the client mysql.
it works all right. the point is mysqladmin doesn't work.
Thank u.
On 9/7/05, 王静 [EMAIL PROTECTED] wrote:
On 9/7/05, Ben [EMAIL PROTECTED] wrote:
What linux where you using?
RedHat linux 2.4.21
A blank password is not
hi ,
I wanted to check the following condition and if it is
success i wanted to display a massage.I tried as
follows. but no luck. nothing displayed.
$dbQuery = results;
$result = mysql_query($dbQuery) or die(Couldn't get
file list);
if (!isset($result))
{echo NULL;}
//if
Kane Wilson wrote:
I wanted to check the following condition and if it is
success i wanted to display a massage.I tried as
follows. but no luck. nothing displayed.
$dbQuery = results;
$result = mysql_query($dbQuery) or die(Couldn't get
file list);
if (!isset($result))
{echo NULL;}
Hi all,
I've installed MySQL db server 4.1.14 + Administrator + Control Center
for test purposes on Windows 2003 Server Standard. Then I deinstalled
everything, deleted all files which were not deleted by the uninstall
process (search for mysql) + deleted also the entries in the registry
which
Hello,
I have the following table:
CREATE TABLE `list_datas_1` (
`list_id` bigint(20) NOT NULL,
`locale_id` bigint(20) NOT NULL,
`record_id` bigint(20) NOT NULL,
`segment_0` longtext,
`segment_1` longtext,
`segment_0_sk` longblob,
`segment_1_sk` longblob,
KEY `record_id`
Try redoing from scratch but this time dont use a client
just use command line!
yeah, i can access the database server normally with the client mysql.
it works all right. the point is mysqladmin doesn't work.
Thank u.
On 9/7/05, 王静 [EMAIL PROTECTED] wrote:
On 9/7/05, Ben [EMAIL PROTECTED]
Hello.
$dbQuery = results;
Have you forgotten to put '$' before the 'results'? Do you
have display_errors = On in your php.ini?
Kane Wilson [EMAIL PROTECTED] wrote:
hi ,
I wanted to check the following condition and if it is
success i wanted to display a massage.I
Hello.
so why does 'explain select * from files where
(pathref,version)=(129286,0);' scan the whole table?
It is documented that this syntax can't be optimized yet. See:
http://dev.mysql.com/doc/mysql/en/row-subqueries.html
Jason Pyeron [EMAIL PROTECTED] wrote:
On Tue, 6 Sep
Hello.
max_question resource exceeded.
It is somehow related to the user privileges. See:
http://dev.mysql.com/doc/mysql/en/user-resources.html
Start mysqld with --skip-grant-tables and fix the user's limits.
Does someone know which files or registry entry/entries must be
Hello.
This index is not used at all for the select ?
substring(segment_0_sk,1,677) - a function is applied
to the indexed column. In my opinion, MySQL isn't so smart
to understand that this is a prefix. If you want to order only
on the prefix of your text column, think about
Hello.
Have a look here:
http://dev.mysql.com/doc/mysql/en/gone-away.html
christophe charron [EMAIL PROTECTED] wrote:
Hi,
i've got the same kind of problem but not in a dump, in a restore. I
tried to restore it in a MyIsam type table but i have the same error.
Could other server
Loffler Thomas J. wrote:
Hi all,
I've installed MySQL db server 4.1.14 + Administrator + Control Center
for test purposes on Windows 2003 Server Standard. Then I deinstalled
everything, deleted all files which were not deleted by the uninstall
process (search for mysql) + deleted also the
Hi all,
Thanks for your replies,
Found the solution. I had the data directory on another harddisk + did not
delete it after the deinstallation.
cheers, Thomas
t.j. loeffler
swiss federal institute of technology
department of
Attempts to do make test prior to installation, to check that I'm
installing something workable, give:
quote
neelix hgs 63 % gmake test
cd mysql-test; perl mysql-test-run.pl perl mysql-test-run.pl --ps-protocol
No ndbcluster support
Killing Possible Leftover Processes
Removing Stale Files
---snip--
Given any two dates, MySQL can tell if a third date is within
that range.
That's easy.
To actually return a list of all dates between any arbitrary
pair of dates requires some form of loop (v5.0+) or a lookup
into a table populated with all possible dates (any version
that
Hi,
I have reported the bug a while ago, but it seems not all bugs are taken
seriously. I reported it and one of the researchers couldn't replicate the
problem, so I provided a sample project in ASP.NET where the problem can be
seen very easily, but nobody reacted (probably because the status
Hi everyone, Im executing the following query:
SELECT *
FROM
table1
WHERE
table1.field1 = 'A' AND table1.field2 = 'B'
LIMIT 0,10
I also need to get the total record count for the above query, but
without the limit clause (limit is for pagination purposes)
Is there any way to extract this total
Hi,
I've tried that there is no problem with that. Mysql creates bigger tmp
tables from time to time. We had this problem with a specific query onyl
I sad had, as last night I tried again and it worked. Beats me...
Server was not rebooted, mysql was not restarted and the available space
Description:
I am running a MySQL 4.1.14-standard server on one HP Alpha machine. It is
configured
to act as a replication master. When I start a replication slave on a different
HP Alpha
machine, using the same binary distribution, the slave fails. This is part of
the slave's
error log file:
Description:
We have distributed applications which make extensive use of the
get_lock() function
to acquire a system-wide lock. Occasionally, all copies of a given
application
block attempting to acquire a lock on the same lock string. Using
is_used_lock() reports
I suppose that you have to change the status to Open, or people suppose
that there aren't any changes. It would be nice that it would be tested
in ASP.NET because it can be simply a problem with of type conversion in
.NET, I haven't see the problem (and I don't work with .NET).
M DR wrote:
Hi!!
$dbQuery = select * from table where 1 ;
$result = mysql_query($dbQuery) or die(Error trying to execute the query:
.mysql_error());
If(mysql_num_rows($result)1){ //also: ==0 works
echo NULL;
-Original Message-
From: Kane Wilson [mailto:[EMAIL PROTECTED]
Sent: Wednesday,
After you execute your select/limit statement you can execute
select found_rows()
It returns the number of rows thbat the previous query would have returned
if the limit wasn't applied. See: http://dev.mysql.com/doc/mysql/en/information-functions.html.
Regards,
E
Hi everyone, Im
Just add SQL_CALC_FOUND_ROWS to your select statement:
SELECT SQL_CALC_FOUND_ROWS COUNT(*)...;
The you can execute a special query to figure out how many rows
would have been returned without the LIMIT clause.
SELECT FOUND_ROWS();
On Sep 7, 2005, at 6:15 AM, pow wrote:
Hi everyone, Im
As you've probably read in the article, the hardware isn't too bad,
it's OS X that is slowing things down.
I would first go the free route. Download YellowDog Linux and install
that on your current Mac hardware. That will give you a big boost
when the load starts to climb. I've installed
Brent Baisley wrote:
If you do go the new hardware route, I wouldn't go with SCSI is you
only have $2K to spend. S-ATA2 based drives would give you similar
performance to SCSI, but at a big cost savings. SCSI's big
performance advantage was in command queueing which SATA2 drives now
Is it normal for MySQL migration 1.14 rc to leave MS Access open when it is
done with migration (leaving ldb file)?
Scott
--
Please avoid sending me Word or PowerPoint attachments.
See http://www.gnu.org/philosophy/no-word-attachments.html
Hello.
You want to check out the FOUND_ROWS() function:
http://dev.mysql.com/doc/mysql/en/information-functions.html
BTW, similar question was asked recently.
pow [EMAIL PROTECTED] wrote:
Hi everyone, Im executing the following query:
SELECT *
FROM
table1
WHERE
RTFM - It is online, it has an index, and it is searchable:
http://dev.mysql.com/doc/mysql/en/select.html (hint: look for the phrase
how many rows on this page)
If you looked in the index for rows, you would find the function
ROW_COUNT() (which is close but not exactly what you wanted).
Thank you guys so much !!!
I found the answer to all my problems regarding charsets with MySQL
dumps.
Here are the code lines:
CREATE TABLE `foo` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`foo` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
Am I correct in the statment second query is faster? This query gets
executed several million times.
mysql explain select A.* from files as A where A.pathref=129286 and
version=(select max(version) from files as B where A.pathref=B.pathref);
On Wed, 2005-09-07 at 08:30 -0600, Cory Robin wrote:
Brent Baisley wrote:
If you do go the new hardware route, I wouldn't go with SCSI is you
only have $2K to spend. S-ATA2 based drives would give you similar
performance to SCSI, but at a big cost savings. SCSI's big
performance
On 9/7/05, Brent Baisley [EMAIL PROTECTED] wrote:
As you've probably read in the article, the hardware isn't too bad,
it's OS X that is slowing things down.
Interesting article. Helped me make my decision between OS X, and
Debian on our xServes. It appears bypassing the gui, and running a
Very sorry for having troubled all regarding the seemingly stupid rtfm
garnering request for help.
But in my attempt to make the question as simple and succinct as
possible, i forgot to state one EXTREMELY important chunk of information.
I can't use SQLCALCFOUNDROWS because there is a subqry
Then eliminate the subquery and SQL_CALC_FOUND_ROWS will be an option for
you again. If you would like some help refactoring your query, I
volunteer. If I can't help, I know there are several others on the list
just as capable as I (or more so).
Shawn Green
Database Administrator
Unimin
I am migrating from MS SQL Server to MySQL 4.1.
I have code in my ColdFusion/SQL Server application that went something
like this:
cfquery name=insertquery
SET NOCOUNT ON
INSERT INTO TABLE ()
SELECT @@IDENTITY AS adid
SET NOCOUNT OFF
/cfquery
That whole block was processed in coldfusion as a
Hi there.
I started a different thread on this, but then I realized I might not have
to use InnoDB for this.
Let me explain what I wish to achieve.
I want to create records in an established table. I then want them locked
(either by locking the whole table or by individual record) so that they
On 9/7/2005 1:17 PM Ryan Stille intelligently wrote:
I am migrating from MS SQL Server to MySQL 4.1.
I have code in my ColdFusion/SQL Server application that went something
like this:
cfquery name=insertquery
SET NOCOUNT ON
INSERT INTO TABLE ()
SELECT @@IDENTITY AS adid
SET NOCOUNT
it might be best to ask this in the cf forums, however did
you try to separate the statements with a ; ? I haven't tried
2 query statements for MySQL in cfquery...yet ;-) Also I
believe MySQL 3.23+ supports @@identity
Yes I've tried semicolons after the statements, and I've tried setting
On Sep 6, 2005, at 11:09 PM, Scott Haneda wrote:
After reading this:
http://www.anandtech.com/mac/showdoc.aspx?i=2436 I suspect OS X
is just
not going to cut it.
So while I think it is beneficial to be open to new things at all
times, there are as always two sides to any story. The
In the last episode (Sep 07), Rich said:
I started a different thread on this, but then I realized I might not
have to use InnoDB for this.
Let me explain what I wish to achieve.
I want to create records in an established table. I then want them
locked (either by locking the whole table
on 9/7/05 11:11 AM, Chris Martin at [EMAIL PROTECTED] wrote:
I'd definitely try those first before forking out 2 grand.
Its not that I really have a choice, I do not have a spare mac around, so I
need new hardware no matter what. To move OS's on a live mysql server and
then get the new one up,
on 9/7/05 2:40 PM, Bruce Dembecki at [EMAIL PROTECTED] wrote:
We're happy with our Mac based MySQL servers in many respects. We've
got some 64 bit issues that are causing a little grief, so we're
looking at our options... Obviously working with Apple and MySQL to
determine the real reason for
Unless I am totally off base here, the mysql docs tell very little in
regards to how to performance tune mysql.
So far I have found this article to help:
http://www.databasejournal.com/features/mysql/article.php/10897_1402311_3
But it still leaves me with a ton of questions.
For starters, and
Scott Haneda wrote:
Hello, currently I run mysql 3.x on Mac OS X 10.3.
I have about as much ram in the machine as I can, and have tunes it the best
I can, however, I still see the performance drop pretty badly at times.
After reading this:
http://www.anandtech.com/mac/showdoc.aspx?i=2436 I
For hardware we are just assembling generic Athlon 64 boxes.
I just put together two Dual core A64 4400+ boxes as web
servers, running them as a two node cluster.
My new DB box is a Dual core 4400+ with 4gigs of memory
and 10k sata drives. I know some folks have had trouble with
the 10k
Yeah, 64 bit isn't working... we can set the memory partition for
InnoDB to some big number, like say 10G or more (on the 16G Xserves),
and it will launch, so it has 64 bit OS and 64 bit MySQL Binaries...
We get past the first hurdle, but in practise it just doesn't run...
It works fine
on 9/7/05 8:42 PM, Bruce Dembecki at [EMAIL PROTECTED] wrote:
Yeah, 64 bit isn't working... we can set the memory partition for
InnoDB to some big number, like say 10G or more (on the 16G Xserves),
and it will launch, so it has 64 bit OS and 64 bit MySQL Binaries...
We get past the first
And one other thing... our smallest load database server was a pair
of G4 XServes, running about 300 queries per second, taking 5%CPU on
the top display (which on OS X is 5% of one CPU) We ran the same
load on a pair of Sun V440 Quad processor with 16Gbytes of memory and
it used 30 -
http://dev.mysql.com/doc/mysql/en/insert-select.html
There are 2 forms of INSERT INTO statement
1. INSERT INTO tbl_name (...) VALUES(...);
2. INSERT INTO tbl_name (...) SELECT ...;
there's no : INSERT INTO tbl_name (...) VALUES(...) SELECT ...;
its either ... or in MySQL i.e. aither provide
53 matches
Mail list logo
