Hi list,
I have a rather serious problem that i really dont know how to solve,
Every 8-12 day my mysql server stops responding and i get the error code
that indicates that max_connections are full, the problem is that i have
checked all of
my code over and over again to se that every connections
Hi
there a are a couple of things that I have found cause occasional lock ups.
running out of temp space - MySql builds temp files on bigger queries and if
it runs out of temp disk space it grinds to a halt, which causes all the
following queries to queue up until max_connections is exceeded.
mysql has about 50GB of temp space to work with so thats not the problem.
Its strange because the server is not that loaded and around 12-04 at
night no cronjobs that affects mysql or general server performance are
being run.
Is is possible to se how many queued up questions mysql has at the
Hi list,
I m writing a perl program and would like to use it (wiht mysql
command) to determine whether a field name is (or is part of) a primary
key of a table.
If you know how to handle this, please drop me a line.
Thanks and Happy New Year.
Sam
--
MySQL General Mailing List
For list
Does anyone have a sample of a simple update statement I can run to update a
field in a table to all uppercase values.
Any help or web references are appreciated.
Sam
For columns in a statement $sth, DBD:mysql maintains a boolean array named
is_pri_key.
PB
-
- Original Message -
From: sam wun
To: mysql@lists.mysql.com
Sent: Saturday, January 01, 2005 7:58 AM
Subject: How to determine a field is part of the primary key in a table?
Raphael Matthias Krug wrote:
Hi Shawn,
I printed the manual, but as I am not such a database guru I was not
able to transfer this knowlegde into an select-statement. Thanks for
your realtimehelp.
Is it possible to do an select-query with soundex like the following
examble?
select nn from
It would be nice if phpMyAdmin would kindly note that on their website...
Also, when I run a phpInfo()... it says i have the 3.23.49 could this
be a contributing factor?
On Sat, 1 Jan 2005 15:55:27 +0700, Willy Sudiarto Raharjo
[EMAIL PROTECTED] wrote:
Has anyone had any problems installing
The problem is not with phpmyadmin, the problem is with php. If you install
4.3 of php it will not work with mysql 4.1.8 or any version mysql 4.1 or
5.0. It will only work if you turn on the short passwords option in 4.1.
I've not tried it on 5.0 lately. You can get it installed but it takes a
What kind of box is this? According to you're my.cnf it looks like it's a
either a dual with hyperthreading or a quad box.
I don't see that you have your slow query log turned on, this should be the
first thing you should do in my opinion. This is what mine looks like.
### Slow Query
Sasha
P.S. I have a theory that a habit of printing computer documentation is a
road block to becoming a guru. At least, I have not yet encountered a
guru that printed much, while at the same time it seems like a
struggling user prints a lot. You cannot be 100% sure about the cause and
effect
Dear Sir,
I have written a paper on Mysql http://en.wikibooks.org/wiki/Programming:MySQL
Will you please go through it and make corrections where ever necessary?
Shantanu Oak
[EMAIL PROTECTED]
http://oksoft.blogspot.com
--
MySQL General Mailing List
For list archives:
Mikael Fridh wrote:
Kevin A. Burton wrote:
This is a bug.
Feature.
Putting system configuration information on a unix machine in /var..
.yeah... thats not a feature.
In fact, you don't need those configuration statements in the first
place. You could just as well initiated the slave
13 matches
Mail list logo