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
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:
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
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
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
Hi,
I have the following database objects in a purely InnoDB database:
--
CREATE TABLE Person (
PersonIDint not null PRIMARY KEY,
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 =
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
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
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
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
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
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
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 play
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 need
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 and
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
the a form Comes up
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
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
c7
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
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,
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 mysql@lists.mysql.com
Sent:
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)
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
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
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
[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
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 and
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)
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
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
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
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.
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 seems
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
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 normaly a
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
38 matches
Mail list logo