Marc MENDEZ wrote:
Hi,
I work under Mandrake 10.1
First, I have a .my.cnf, which works quite well, since I can enter mysql
without entering any password.
Even mysqladmin works !
But, I have a batch process run by crontab as root, which tests if mysql
is running (mysqladmin version --silent).
Hi,
I work under Mandrake 10.1
First, I have a .my.cnf, which works quite well, since I can enter mysql
without entering any password.
Even mysqladmin works !
But, I have a batch process run by crontab as root, which tests if mysql is
running (mysqladmin version --silent).
Unfortunately, this
Hello Michael,
thx, I know normalisation.
BUT normalisation isn't always the best (fastest) way to store, or select
the datas, this is why I don't use it most time.
Often I'm testing my projects with normalisation and without and my last
very big problem with big select statements is very fast wi
Charlie Schaubmair wrote:
> Hello,
>
> I want to do a query where I only gt the results by a numeric value:
>
> select * from MyTable where 1 IN someFieldInMyTable
> I know this query doesn't work, but maybe anyone knows what I mean.
>
> 1 can be a value betwenn 1 and 23
> someFieldInMyTable is n
Daniel Kasak wrote:
Chris wrote:
Could be a simple network issue too.. are pings fast/slow?
Pings are very fast.
The reason I asked about that last one was some of the suggestions on
this page:
http://www.debuntu.org/2006/07/21/75-how-to-optimize-mysql-response-time/
OK. I've had a read
Chris wrote:
> Could be a simple network issue too.. are pings fast/slow?
Pings are very fast.
> The reason I asked about that last one was some of the suggestions on
> this page:
>
> http://www.debuntu.org/2006/07/21/75-how-to-optimize-mysql-response-time/
OK. I've had a read of that, and it s
Daniel Kasak wrote:
Chris wrote:
I'd see if you can get logging enabled.
I will do that next visit, yes. I was pushed for time - in between 2
other commitments, and wasn't expecting problems.
When the pauses happen try a 'show process list;' and see what else
mysql is doing at the time. May
Chris wrote:
> I'd see if you can get logging enabled.
I will do that next visit, yes. I was pushed for time - in between 2
other commitments, and wasn't expecting problems.
> When the pauses happen try a 'show process list;' and see what else
> mysql is doing at the time. Maybe you have a deadl
Daniel Kasak wrote:
Hi all.
I discovered a very strange and painful problem on a customer's system
last night.
I have built a gtk2-perl GUI front-end for accessing data in a MySQL
database. It works remarkably well on my laptop, and was working
remarkably well on their system as well, but somet
Hi all.
I discovered a very strange and painful problem on a customer's system
last night.
I have built a gtk2-perl GUI front-end for accessing data in a MySQL
database. It works remarkably well on my laptop, and was working
remarkably well on their system as well, but something has recently
happ
CREATE FUNCTION CharValIsNumeric (v VARCHAR(15))
RETURNS boolean
BEGIN
declare i, l int(2);
set l=char_length(v);
set i=1;
while (i <= l) and (substring(v,i,1) in
('1','2','3','4','5','6','7','8','9','0')) do
set i=i+1;
end while;
What if the string (v)
Brian E Boothe wrote:
hey guys ;
it's not Customers Per issue it's the other way around "issues per
customer"
i enter in Customer 1 and then down the road i wanna add a issue
associated with that customer, so goto that customer and Click "Add issue"
the a form Comes up and i add the issue an
[EMAIL PROTECTED] wrote:
Hi,
There is a problem with CPU utlization when using INNODB. The CPU
utilization goes to 100% in a dual processor solaris box. With the same
setup, myISAM uses only 60% of the CPU.
As I said before, stuff like 'count(*)' queries cannot use an index in
innodb - if y
It sounds as if you're using the PHP HTTP module. You probably want
the HTTP_Client module instead as it has a method for doing POSTs.
In general you should use GET for HTTP requests which only solicit
information from another server and don't request that server to
change anything store
At 09:34 AM 8/16/2006, you wrote:
Hi all,
I am working on a problem where I need to select data from my own
database, and then post it to another website (using the Get) method.
After having wasted about 4 days trying http_request, $_Get and whatnot, I
stumbled upon the header command. So far,
A little more searching also uncovered this, which appears to be right
up your alley:
http://dev.mysql.com/doc/refman/4.1/en/gone-away.html
On 8/16/06, Dan Buettner <[EMAIL PROTECTED]> wrote:
At first blush, I'd look into a few different possibilities -
- An idle connection timeout is being en
At first blush, I'd look into a few different possibilities -
- An idle connection timeout is being enforced on a persistent connection pool
- Too many individual connections are overwhelming a Windows server
(see
http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server-on-windows.html)
It's PHP I believe, oscommerce web site, MySQL 4.0.27. this is for an associate
of ours and I am not much of a PHP programmer, strickly Perl :)
Mike
- Original Message -
From: "Dan Buettner" <[EMAIL PROTECTED]>
To: "Mike Blezien" <[EMAIL PROTECTED]>
Cc: "MySQL List"
Sent: Wednesday,
Mike, can you provide more details? OS platform, networking overview,
types of apps experiencing this error (PHP app, mysql cli, etc), does
it happen with local as well as network connections, etc.
This will help us help you.
Dan
On 8/16/06, Mike Blezien <[EMAIL PROTECTED]> wrote:
Hello,
oc
Hello,
occassionally we come accross this error:
2013 - Lost connection to MySQL server during query
not all the time, but now and then, no real pattern that we can see of find in
the logs. but appear to happen mainly with SELECT's
is there a way to fix this or trace it down to a cause?
TIA
VenuGopal Papasani wrote:
> Once again i send the table data:
>
> Code Period Value
> c12004 22
> c12005 10
> c22005 15
> c32005 20
> c42005 15
> c52005 5
> c62005 30
>
You were right. Its a global privilege not a table one. I granted it at
a global level. it can't be granted at the databae level
Dan Buettner wrote:
> Curtis, you might need to make sure 'admin'@'localhost' has 'FILE'
> privileges in the proper database, for load data infile. Note that
> 'adm
Gerald L. Clark said:
> Brian E Boothe wrote:
>> hey guys ;
>>it's not Customers Per issue it's the other way around "issues per
>> customer"
>> i enter in Customer 1 and then down the road i wanna add a issue
>> associated with that customer, so goto that customer and Click "Add
>> issue"
>> t
Brian E Boothe wrote:
hey guys ;
it's not Customers Per issue it's the other way around "issues per
customer"
i enter in Customer 1 and then down the road i wanna add a issue
associated with that customer, so goto that customer and Click "Add issue"
the a form Comes up and i add the issue an
hey guys ;
it's not Customers Per issue it's the other way around "issues per
customer"
i enter in Customer 1 and then down the road i wanna add a issue
associated with that customer, so goto that customer and Click "Add issue"
the a form Comes up and i add the issue and Click Add issue, i ne
At 09:43 AM 8/15/2006, Randy Paries wrote:
On 8/15/06, mos <[EMAIL PROTECTED]> wrote:
At 09:24 AM 8/15/2006, you wrote:
>Dan
>
>thanks for the help
>so i will remove the redundant keys
>below is the explain plans
>but here is the weird part.
>I exported the database and imported into a testDB to
First of all, I think your post is intended to the PHP mailing list, this is
the MySQL list.
Assuming that you need to send information to the other web site without
actually entering it, you could setup a system with a simple Web Service
running on your "receiving" web server, and just call it f
Hi all,
I am working on a problem where I need to select data from my own
database, and then post it to another website (using the Get) method.
After having wasted about 4 days trying http_request, $_Get and whatnot,
I stumbled upon the header command. So far, the only way I have been
able to
Hi all,
I am working on a problem where I need to select data from my own
database, and then post it to another website using the Get method.
After having wasted about 4 days trying http_request, $_Get and whatnot,
I stumbled upon the header command. So far, the only way I have been
able to ac
Hi,
In my earlier post, I was making a mistake (though I didn't do so in
the posted text!) - I was passing the dob (the date field) in the
ddmm format. When I passed the date field in mmdd format, the
stored procedure ran fine and the record got inserted. The problem is
MySQL hangs/goes
Hi,
There is a problem with CPU utlization when using INNODB. The CPU
utilization goes to 100% in a dual processor solaris box. With the same
setup, myISAM uses only 60% of the CPU.
Could someone please let me know what could be the problem. There are
some other processes running on the same b
Hi,
I am replying to my own post - only to add that in response to the
MySQL misbehaving, I just kill it and restart it. More than once, I
also restarted the service, drop the database and re-created the
database and all the tables, procedures, triggers, grants, etc. But
still when I call the st
Hi,
There is a problem with CPU utlization when using INNODB. The CPU
utilization goes to 100% in a dual processor solaris box. With the same
setup, myISAM uses only 60% of the CPU.
Could someone please let me know what could be the problem. There are
some other processes running on the same b
Hello,
i'm new about triggers...
I'm trying to create one trigger: it may insert into a column the user
that insert the record...
my table->
CREATE TABLE `test`.`t2` (
`s1` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`utente` VARCHAR(80) NOT NULL DEFAULT '',
PRIMARY KEY(`s1`)
)
ENGINE = In
Hi,
I have the following database objects in a purely InnoDB database:
--
CREATE TABLE Person (
PersonIDint not null PRIMARY KEY,
Sorry, query was wrong... has to be:
SELECT *, CONCAT(',',someFieldInMyTable,',') as wherefield FROM MyTable
WHERE wherefield LIKE '%,1,%'
Mike van Hoof schreef:
Hey Charlie,
maybe there is, but i don't know why... because when you do a like
query it also finds the 21 when you do a like on
Hey Charlie,
maybe there is, but i don't know why... because when you do a like query
it also finds the 21 when you do a like on the 1.
what you maybe can do (not tested) is:
SELECT *, CONCAT(',',someFieldInMyTable,',') as wherefield FROM MyTable WHERE
wherefield='%,1,%'
Now your someFieldIn
Charlie Schaubmair schreef:
Hello,
I want to do a query where I only gt the results by an numeric value:
select * from MyTable where 1 IN someFieldInMyTable
I know this query doesn't work, but maybe anyone knows what I mean.
1 can be a value betwenn 1 and 23
someFieldInMyTable is normaly
Hello,
I want to do a query where I only gt the results by an numeric value:
select * from MyTable where 1 IN someFieldInMyTable
I know this query doesn't work, but maybe anyone knows what I mean.
1 can be a value betwenn 1 and 23
someFieldInMyTable is normaly a list like: 1,2,3,4,5,6,9,21
Rhys Johnson wrote:
Thanks for the reply Chris
I seem to have the remote database working just as fast as the local one
after comparing the my.cnf settings. Query times have dropped from 3.6s
to 0.4s. However, now when I log in from a shell prompt remotely into
mysql it takes about 10s for my pa
40 matches
Mail list logo
