On Fri, Jan 30, 2009 at 8:13 PM, will wrote:
> ok, cool. I was not sure if I could use logrotate with the mysql logs.
> Is it safe to delete what I have there at the moment? I need to free
> up some disk space.
>
this is what logrotate run before and after
[ -e /var/lock/subsys/mysqld ] && /bin/
ok, cool. I was not sure if I could use logrotate with the mysql logs.
Is it safe to delete what I have there at the moment? I need to free
up some disk space.
On Sat, Jan 31, 2009 at 5:07 PM, Bazooka Joe wrote:
> On Fri, Jan 30, 2009 at 7:54 PM, will wrote:
>> Hi,
>>
>> I am running mysql 5.0.3
Hi,
I am running mysql 5.0.32 on debian etch on a VPS. The /var/log/mysql
directory has grown to 5.8G, over 25% of the diskspace on my server.
Can the contents be deleted saftely?
Can mysql be configured to keep the log directory within, for example,
500mb (or whatever is considered reasonable)?
You didn't get a response on this one because you didn't really ask
any questions :-)
Baron
On Thu, Jan 29, 2009 at 4:38 PM, lance raymond wrote:
> Man, the forums are good, but lists are just so much easier! Anyway, I left
> post unanswered now and I need to get this problem solved, so I am ho
Hi Lance,
Please post specific queries and EXPLAIN output with the \G
terminator. It's likely your queries that are the problem, and
looking at 'ps' doesn't help you much.
On Fri, Jan 30, 2009 at 9:32 AM, lance raymond wrote:
> Sorry if this seems to be a double post, but not sure if the mysql
Gary,
I need to know a lot about your workload to say whether it will work
well on InnoDB with 4+ processors. You can check
http://www.mysqlperformanceblog.com/ for a lot of benchmarks in this
area. But in general, my opinion is that for most workloads, 4 total
processors (cores included) is rea
Hi Johan,
dirs and files exist (also chmodded to 777)
the strange thing is that this behaviour is on more than one slave,
I think it is a bug related to the Information Schema and to the fact I
use innodb_file_per_table.
Not being able to drop a database is definitely a bug, it seems that
somew
Olaf Stein writes:
> I think he only has one DB, I guess that is a provider restriction...
True. I would create a separate db for each application if I could.
rdc
--
Robert D. Crawford rd...@comcast.net
--
MySQL General Mailing List
For list archives:
* check on your filesystem if the directory actually still exists - rmdir on
a nonexisting dir might throw a non-zero exit
* Take your db offline and do an fsck. If you want, you could flush tables
with read lock, then mount -oremount,ro and then fsck - that'll keep your db
up for reads, at least.
I am banging my head.
First, is not a file permission problem.
I cant import data on some replication slaves either in binary, or from a
sql mysqldump.
I use one innodb file per table and I am importing only two databases on a
dozen.
After a few hours seem that the problem is with the name of
A few weeks back I was reading an article that said that INNODB doesn't take
adantage of servers using more than 4 processors. I think I also recieved this
as a reply some time ago as to the same thing.
I was wondering if this is indeed true. We are using 5.1.30 and wanted to
pickup a new du
> creating product tablesdone (273 sec).
Can you tell us what queries this code actually executes? This doesn't
tell us too much ;)
Walter
OlinData: Professional services for MySQL
Support * Consulting * Administration
http://www.olindata.com
On Fri, Jan 30, 2009 at 3:32 PM, lance raymond
MySQL Performance and Scalability Project - Issues and Opportunities
http://forge.mysql.com/wiki/MySQL_Performance_and_Scalability_Project_-_Issues_and_Opportunities
Next Thursday (February 5th), we're continuing our series of sessions on
MySQL performance measuring and improvements with Allan Pac
On Fri, Jan 30, 2009 at 9:32 AM, lance raymond wrote:
> basically I have an old fc5 machine running mysql 4.1 and a
> newer server running centos5 / mysql 5.0.45.
So, different hardware, different OS, different database server...
could be anything. I suggest you run EXPLAIN plans for the slow
qu
>IMO, offering a variety of input formats just creates one big mess.
>How often have you read some date notation and wondered which format was
>used - if all values are in the 1 to 12 range, you have to guess.
>
[JS] I agree 100%. I have to deal with dates from all over the world, and I
often have
I think he only has one DB, I guess that is a provider restriction...
On 1/30/09 8:52 AM, "Claudio Nanni" wrote:
> Robert,
>
> keep the two databases separated,
>
> that is on different mysql database (or schema as they are also called).
>
> If the wordpress blog is on a database named 'wpbl
Sorry if this seems to be a double post, but not sure if the mysql list send
yourself a copy (as I didn't get the 1st one). But a little has changed,
not much, but basically I have an old fc5 machine running mysql 4.1 and a
newer server running centos5 / mysql 5.0.45. The whole site is almost
unu
Robert,
keep the two databases separated,
that is on different mysql database (or schema as they are also called).
If the wordpress blog is on a database named 'wpblog' for example
import your dump in another newly created database.
Could just use those statement in the dump file
CREATE DATAB
Hi!
Konstantin Osipov wrote:
> * Michael Widenius [09/01/30 14:53]:
>
>> Its more important that we don't break things for current users than
>> try to be concerned about possible wrong usage that no one seams to do
>> or find important enough to complain about.
>
> Monty, I disagree with this
* Michael Widenius [09/01/30 14:53]:
> Its more important that we don't break things for current users than
> try to be concerned about possible wrong usage that no one seams to do
> or find important enough to complain about.
Monty, I disagree with this statement. Our current users use the
curr
Michael Widenius wrote:
> Bernt> We have a Norwgeian word for this "helpfullness":
> "bjørnetjeneste", but Bernt> I'm not sure what the english idiom would
> be.
A disservice. In German Bärendienst.
/Per Jessen, Zürich
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/m
Hi!
> "Bernt" == Bernt M Johnsen writes:
> Michael Widenius wrote (2009-01-24 02:07:54):
>> As Dmitri pointed out, we shouldn't deprecate '.' as substitute for
>> dates.
>>
>> Another things is that we should stop making decisions about
>> incompatible changes without listening
Hi!
> "Roy" == Roy Lyseng writes:
>> The question here is how PostgreSQL and ANSI does this and also what
>> is the logical interpretation of the number.
Roy> ISO 9075 (ANSI SQL) is very strict about this. It only allows TIME
Roy> literals with 3 or 4 digit groups, and it only allows th
23 matches
Mail list logo