Error starting service

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

RE: Error starting service

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,

Re: Error starting service

$ 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

FW: With Ref to the set autocommit =1

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

CONCAT(int_col, string_col) and charset and collation problems

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

Database Layout (Design) Question

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)

PBXT Storage Engine 0.9.8 with Referential Integrity released

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

Re: Database Layout (Design) Question

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

RE: Database Layout (Design) Question

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

Re: Money

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

Re: Database Layout (Design) Question

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

Re: Replication not working?

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

Re: Replication not working?

Also, given the error I got: - Original Message - From: Michael DePhillips [EMAIL PROTECTED] To: Jesse [EMAIL PROTECTED] Cc: MySQL List mysql@lists.mysql.com Sent: Tuesday, January 30, 2007 7:57 PM Subject: Re: Replication not working? Should be almost instantaneous. Do a show slave

Re: Replication not working?

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

Re: Replication not working?

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)' errno:

Re: Hungarian collation

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

Fulltext relevance and weighting....

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

rounding digits after decimal sign

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 |

Re: rounding digits after decimal sign

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 |

Re: Fulltext relevance and weighting....

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

Re: Fulltext relevance and weighting....

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

Re: Fulltext relevance and weighting....

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 this

Better way to query table converted from SQL to RDF format?

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

Does MySQL 5.2 include support for Roles Based Access Control?

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?

WHERE (NOT) EXISTS problem

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;

Re: WHERE (NOT) EXISTS problem

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;