Re: Too many connections

[Vladislav Vorobiev]

2008/8/5 Krishna Chandra Prajapati [EMAIL PROTECTED]:
 Hi All,

 I am trying to connect to mysql server. Buts, Its giving  too many
 connections.  How to increase the max_connection on mysql server.

 When i am giving mysql -u root -ppassword
 Still, its giving too many connections.

 How to solve this problem.


set-variable=max_connections=your value

in my.cnf and restart mysql server. I think this is a problem.


Vladislav

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: debian-sys-maint

[Vladislav Vorobiev]

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 server. It gives warning it don't found the
 debian-sys-maint user.

Corrupt Mysql-Debian installation?
What kind of Debian version? Etch, Testing, Sid??
Try to purge and reinstall mysql-server.

-- 
Best Regards
Vlad Vorobiev
http://www.mymir.org

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: debian-sys-maint

[Vladislav Vorobiev]

 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 mysql-server (make backup of your data)
dpkg -r mysql*
dpkg --purge mysql*
apt-get install mysql-server

-- 
Best Regards
Vladislav Vorobiev
http://www.mymir.org

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: order by in query

[Vladislav Vorobiev]

2008/1/2, Edward Kay [EMAIL PROTECTED]:

 
  Hello i use this query:
 
  select i.item_id
  from orders o
  INNER JOIN item i ON i.nr=i.nr

 Should the line above not be
 ... ON i.nr = o.nr ?

Autch. thank you! It works now.


-- 
Best Regards
Vlad Vorobiev
http://www.mymir.org

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]