Krishna Chandra Prajapati wrote:
Hi all,
Mysql on debian operating system has debian-sys-maint user. What is the role
of this user debian-sys-maint.
Read the /etc/mysql/debian-start file to see everything that debian does
when mysql starts up. It uses the debian-sys-maint user for all of thos
This is one of the few decisions the debian package maintainers made
that I disagree with, but the idea is that when you install mysql, there
is this user created with a random password. This gives the package
maintainers a way to script updates in SQL if necessary to run on the
database during
Hi All,
On mysql production server one of the innodb component
Innodb_buffer_pool_pages_free =1 . Although there are no issue with the
performance with the server. What should be the optimum value of
Innodb_buffer_pool_pages_free.
Thanks,
--
Krishna Chandra Prajapati
> mysql server started with warning and working properly. But it is not
> stopping and not restarting.
> Server version: 5.0.32-Debian_7etch1-log Debian etch distribution
I have never had problems with mysql installation on Debian.
I would try to reinstall mysql.
Something like this:
killall -9
Hi ,
mysql server started with warning and working properly. But it is not
stopping and not restarting.
Server version: 5.0.32-Debian_7etch1-log Debian etch distribution
Krishna Chandra Prajapati
On Jan 4, 2008 11:04 AM, Vladislav Vorobiev <[EMAIL PROTECTED]>
wrote:
> Hello,
>
> > Mysql on deb
Hello,
> Mysql on debian operating system has debian-sys-maint user. What is the role
> of this user debian-sys-maint.
> After stopping mysql. If i delete all the things from mysql data directory.
> Executed mysql_install_db to create mysql directory with mysql data
> directory and start mysql se
Hi all,
Mysql on debian operating system has debian-sys-maint user. What is the role
of this user debian-sys-maint.
After stopping mysql. If i delete all the things from mysql data directory.
Executed mysql_install_db to create mysql directory with mysql data
directory and start mysql server. It
Hi All,
I was trying to change the data directory of mysql on debian. I have added
two thins in my.cnf
innodb_data_home_dir = /data/mysqldata/
datadir = /data/mysqldata/
Then restarted mysql server. mysql shows there is no innodb storage engine
available. after then i again verified my.cnf. all s
Gunnar,
us = user (things like MySQL/PHP/Apache)
sy = system (memory management / swap space / threading / kernel
processes and so on)
ni = nice (apps running only when nothing else needs the resource)
id = idle (extra cpu cycles being wasted)
wa = wait state (io wait for disk/network/memory)
Martin,
I took a quick look at the tools that you mentioned. Seems you are
heavily involved in Java :)
We don't use Java at all, and other than using cron (which I do use for
backups and standard stuff like that) not really what I am looking for.
After thinking about this, I suspect that t
On Jan 3, 2008 4:23 PM, Tanner Postert <[EMAIL PROTECTED]> wrote:
> When I try to add a force index (PRIMARY) after the media table to try and
> make is use PRIMARY, rather than TYPE, the optimizer switches and uses no
> key at all.
It usually knows better than you do about indexes.
> I've tried
Hello,
Thanks. I read the document, but unfortunately it didn't tell me anything
new..
One of the things I am a bit confused about is:
top - 22:08:12 up 6 days, 7:23, 1 user, load average: 4.36, 3.30, 2.84
Tasks: 134 total, 1 running, 133 sleeping, 0 stopped, 0 zombie
Cpu0 : 61.3% us,
Hi,
Thanks.
mysql> show processlist;
++---+---+---+-+--+--+--+
| Id | User | Host | db| Command | Time
I have the following 2 tables:
CREATE TABLE media (
id int(10) unsigned NOT NULL auto_increment,
user_id int(10) unsigned default NULL,
title varchar(255) NOT NULL,
description text NOT NULL,
`hash` varchar(255) NOT NULL,
length float(9,2) NOT NULL,
created timestamp NOT NULL default
Martin,
Martin Gainty wrote:
3 ideas come to mind-
cron and or cruisecontrol for off-hours scripting
ant for handling cross-platform scripting
maven for implementing dependency checking as well as the ability to
pull from online repositories
I will take a look at these. I am certainly famili
Hi,
I hope this finds itself as an answer to my last post. I'm new to this email
message format of lists.
It turns out that the problem with the join was that I had a column being
selected that I removed from my posting example for brevity which was
causing the select to fail. The extra c
3 ideas come to mind-
cron and or cruisecontrol for off-hours scriptingant for handling
cross-platform scriptingmaven for implementing dependency checking as well as
the ability to pull from online repositories
Youtube.comI worked with a company last summer that implemented identical
functional
Matthew Stuart wrote:
> I have a DB that has a field in it that currently just holds single or
> double numbers - these numbers are basically a reference to a category
> in which the particular record should be displayed. However I have now
> been asked if I can make it so that a particular record
Matthew Stuart wrote:
> I have a DB that has a field in it that currently just holds single or
> double numbers - these numbers are basically a reference to a category
> in which the particular record should be displayed. However I have now
> been asked if I can make it so that a particular record
Hi,
I am trying to join a bunch of tables together. I want a row for each
"learner", and on the row, I want some "user", "centre", "client" and
"centreManager" information if there is any. Thus, I am trying to outer join
from the "learner" table to 4 other tables. The query I have so far is bel
Everyone,
So, I have been thinking recently about automation. This morning I
listened to a talk by one of the three dbas at Youtube (from the MySQL
Users Conference last year). Think about that. They mentioned
100,000,000 pageviews in one day (the data was from 2006). And THREE
dbas. Of
Use CONCAT().
SELECT CONCAT('/',your_field,'/') 'newData' FROM your_table.
Then use similar logic to do an UPDATE statement, i.e. UPDATE your_table SET
your_field = CONCAT('/',your_field,'/')
You need to first make sure that the field you are trying to update is a
VARCHAR, because as it stands
I have a DB that has a field in it that currently just holds single
or double numbers - these numbers are basically a reference to a
category in which the particular record should be displayed. However
I have now been asked if I can make it so that a particular record
can be displayed in mo
Hi,
On Jan 3, 2008 9:28 AM, GF <[EMAIL PROTECTED]> wrote:
> I need to create a view, about a ranking.
> The select from which I generate the view has a "ORDER BY" and I need
> to have a column in that select that shows the position of the object
> in that ranking.
>
> I have searched on google, an
I need to create a view, about a ranking.
The select from which I generate the view has a "ORDER BY" and I need
to have a column in that select that shows the position of the object
in that ranking.
I have searched on google, and I have found that it's possibile to do
it using the SET command and
25 matches
Mail list logo
