Sorry, probably a really simple thing, but when I try and start mysqld it
fails.
[EMAIL PROTECTED] yum.repos.d]# /sbin/service mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL:[FAILED]
I've checked the mysqld.log file and
Sorry folks - worked out why.
The ownership of the mysqld directory had been changed by another
application I'd installed.
Sorry!
-Original Message-
From: WebIT [mailto:[EMAIL PROTECTED]
Sent: 31 January 2007 09:53
To: mysql@lists.mysql.com
Subject: Error starting service
Sorry, probab
$ chown -R mysql:mysql yourdirectoryofmysql
On 1/31/07, WebIT <[EMAIL PROTECTED]> wrote:
Sorry, probably a really simple thing, but when I try and start mysqld it
fails.
[EMAIL PROTECTED] yum.repos.d]# /sbin/service mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MyS
Hi Mark
I would appreciate if we can define Under_extreme_conditions as you
have mentioned in this link below
http://archives.neohapsis.com/archives/mysql/2005-q3/0163.html
I would appreciate if you can give us a workaround for this, which
can eliminate this set autocommit =1 command being sent
Hi,
I'm using MySQL 4.1.15, WinXP and my problem is that
SELECT CHARSET(CONCAT(int_column, string_column)) FROM mytable;
always returns charset 'binary' and I need resulting charset to be same
as a charset of a string_column because I don't want to look for
charset of a column whenever I have t
I'm trying to wrap my head around a performance problem our institution is
having on our Mysql Server which hosts all of our logs from around campus.
Specifically our MailLogs tables.
What I'm having a hard time with is we have metadata such as:
CREATE TABLE mail00 (
host varchar(32) default
Dear MySQL developers and users,
Version 0.9.8 Beta of the PrimeBase XT storage engine for MySQL 5.1
has just been released.
PBXT is a transactional storage engine for MySQL which can be loaded
dynamically by the pluggable storage engine API of MySQL 5.1. Full
MVCC (multi-version concurre
The delete would definitely depend upon the size of the record set being
deleted, anyway assuming I comprehended your situation correctly ,I would
suggest using the Merge storage engine for your needs , and keep every
single day of data in a seperate MyISAM table, and merge all those tables
togeth
Hello, I think your major contributing problem is the database engine
that you are using, MYISAM. For this type of processing, I would highly
recommend you use INNODB to allow maximum concurrency and minimize your
outage. With all things considered, your processing by all estimates,
whether you a
Hi guys,
I know nothing about MySQL, but
please check this and make some bucks
http://www.anrdoezrs.net/click-2275618-10459013
Your friend,
Gabusa
Duncan Hill-3 wrote:
>
> On Tuesday 04 July 2006 21:33, Karl Larsen wrote:
>> I have not yet found how I can put a $ in front of all the money
>>
In the last episode (Jan 31), [EMAIL PROTECTED] said:
> I'm trying to wrap my head around a performance problem our
> institution is having on our Mysql Server which hosts all of our logs
> from around campus.
>
> Specifically our MailLogs tables.
>
> What I'm having a hard time with is we have m
Show Slave Status returns a bunch of stuff that I can't view in the command
line utility. When I use a visual tool, it shows me a bunch of different
fields, but I didn't see anything that looked like an error.
Slave_IO_State = "Connecting to master". Last_Errno is 0. So, from that
perspectiv
Also, given the error I got:
- Original Message -
From: "Michael DePhillips" <[EMAIL PROTECTED]>
To: "Jesse" <[EMAIL PROTECTED]>
Cc: "MySQL List"
Sent: Tuesday, January 30, 2007 7:57 PM
Subject: Re: Replication not working?
Should be almost instantaneous. Do a show slave status on t
Sorry, I hit send before I was actually done. So Given the error I am
getting:
070131 11:53:55 [ERROR] Slave I/O thread: error connecting to master
'[EMAIL PROTECTED]:3306': Error: 'Can't connect to MySQL server on
'Anchorman' (10061)' errno: 2003 retry-time: 60 retries: 86400
There a
In the last episode (Jan 31), Jesse said:
> Sorry, I hit send before I was actually done. So Given the error
> I am getting:
>
> 070131 11:53:55 [ERROR] Slave I/O thread: error connecting to master
> '[EMAIL PROTECTED]:3306': Error: 'Can't connect to MySQL server on
> 'Anchorman' (10061)' e
On Tue, 2006-10-17 at 10:15 -0600, Peter Gulutzan wrote:
> Hi,
>
> MySQL is looking for an authoritative, official statement
> which states all the current Hungarian collation rules.
> Please let other MySQL-using Hungarians (especially if you
> know a user group in Hungary) know about these
> que
Does anyone have any suggestions on how to solve the result weighting
problem? I have a client whose search results are becoming more and more
important, and the relevance demands on the results are not entirely
satisfactory...
The fields that are searched are code, name, small description and lar
Hello,
Can anyone point me to a section of manual or link how to reduce digits
after
a decimal sign?
I have a table
mysql> desc part;
+-+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+-+--+--+-+
Dimitar Vassilev asks:
Hello,
Can anyone point me to a section of manual or link how to reduce digits
after
a decimal sign?
I have a table
mysql> desc part;
+-+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+-+---
Mike,
It's likely because MySQL fulltext index defaults to a word length
of 4 characters or more. So "Ham" probably is not being indexed. You will
need to change the minimum word length. See
http://dev.mysql.com/doc/refman/5.0/en/fulltext-fine-tuning.html
Mike
(P.S. Send me a free ham
Mike:
:) I wish! Free ham for everyone!
I had already changed the min length to 2 actually - so that is not the
affecting factor...
It is more of an issue to prioritizing fields for relevance, and whether it
is possible to do this within a fulltext query, or whether it needs to be
done through
In the last episode (Jan 31), Mike Morton said:
> Mike:
>
> :) I wish! Free ham for everyone!
>
> I had already changed the min length to 2 actually - so that is not the
> affecting factor...
>
> It is more of an issue to prioritizing fields for relevance, and whether it
> is possible to do th
I have some data in a regular MySQL table called usplaces:
city |state|country|latitude |longitude |population|comments
-+-+---+-+---+--+
New York |NY |USA|40.704234| -73.917927|8008278 |Big Apple
Chicago |IL |USA
I find some code about role management in mysql5.2 's source code
" \mysql-5.2.0-falcon-alpha\storage\falcon "
Does MySQL 5.2 include support for roles based access control now? Does it be
supported by falcon engine?
Having a very bad time with the subject sorts of queries.
Here is a simple reproduction of the problem for me.
Perhaps I'm blind/stupid while looking at the docs,
or there's a bug...
mysql version 5.0.24-standard
simple schema:
mysql> desc people;
+---+--+--+-+
Michael Fischer wrote:
Having a very bad time with the subject sorts of queries.
Here is a simple reproduction of the problem for me.
Perhaps I'm blind/stupid while looking at the docs,
or there's a bug...
mysql version 5.0.24-standard
simple schema:
mysql> desc people;
+---+
26 matches
Mail list logo
