On Monday 11 January 2010 08:53, Mihamina Rakotomandimby wrote:
Jørn Dahl-Stamnes sq...@dahl-stamnes.net :
I have checked the local DNS and 'r2-d2' and 'r2-d2.dahl-stamnes.net'
resovl to the same IP-addresse.
What's wrong?
Reverse resolution?
I have checked that, and reverse DNS is OK -
what is your my.cnf setting.
Also did u check slowquery.log for any sql's not using index or not using
the right index.
On Mon, Jan 11, 2010 at 1:21 PM, F.A.I.Z.A.L sac.fai...@gmail.com wrote:
Hi
mysqld process taking high cpu utilization (100%), how to reduce the cup
utilization
it is
use mysql;
select * from user;
see if you able to see 'r2-d2' entry in this table.
also you can try this
grant all on . to 'root'@'%' idenfified by
'secret-password';
regards
anandkl
On Mon, Jan 11, 2010 at 1:40 PM, Jørn Dahl-Stamnes
sq...@dahl-stamnes.netwrote:
On Monday 11 January 2010
On Monday 11 January 2010 09:55, Ananda Kumar wrote:
use mysql;
select * from user;
see if you able to see 'r2-d2' entry in this table.
also you can try this
grant all on . to 'root'@'%' idenfified by
'secret-password';
I just found the cause of the problem... /etc/nsswitch.conf.
It
Hi Kumar,
thanks for your reply.. here is my my.cnf file. i don't see anything here.
what is this slowquery.log?, where it will be?
---
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using
looks like u have not setup slow query log parameter.
If this is a non-production db, shut it down and add this parameter, unser
[mysqld]
log-slow-queries = /var/lib/slowqueries.log.
Or execute
SHOW ENGINE STATUS\G;
You will get to know what all activities are going on ur db and check if
there
i try this
mysql SHOW ENGINE STATUS\G;
ERROR 1286 (42000): Unknown table engine 'STATUS'
ERROR:
No query specified
after setting the parameter in my.cnf which u provided. it is not showing
mysql show engine status;
ERROR 1286 (42000): Unknown table engine 'status'
what i have to do now?
Cheers
SHOW ENGINE innodb STATUS\G
On Mon, Jan 11, 2010 at 3:35 PM, F.A.I.Z.A.L sac.fai...@gmail.com wrote:
i try this
mysql SHOW ENGINE STATUS\G;
ERROR 1286 (42000): Unknown table engine 'STATUS'
ERROR:
No query specified
after setting the parameter in my.cnf which u provided. it is not showing
Jørn Dahl-Stamnes sq...@dahl-stamnes.net :
I have checked the local DNS and 'r2-d2' and
'r2-d2.dahl-stamnes.net' resovl to the same IP-addresse.
What's wrong?
Reverse resolution?
I have checked that, and reverse DNS is OK - both resolve to
192.18.2.22
I read you solved your problem,
(Correction, seel below)
Jørn Dahl-Stamnes sq...@dahl-stamnes.net :
I have checked the local DNS and 'r2-d2' and
'r2-d2.dahl-stamnes.net' resovl to the same IP-addresse.
What's wrong?
Reverse resolution?
I have checked that, and reverse DNS is OK - both resolve to
192.18.2.22
I
On Monday 11 January 2010 12:33, Mihamina Rakotomandimby wrote:
(Correction, seel below)
Jørn Dahl-Stamnes sq...@dahl-stamnes.net :
I have checked the local DNS and 'r2-d2' and
'r2-d2.dahl-stamnes.net' resovl to the same IP-addresse.
What's wrong?
Reverse resolution?
I
Matt,
On Thu, Jan 7, 2010 at 3:10 PM, Matt Neimeyer m...@neimeyer.org wrote:
What's the best way to select names at random from this but still take
into account frequency of use?
Here's the link I usually send clients:
http://jan.kneschke.de/projects/mysql/order-by-rand/
--
Baron Schwartz
Victor,
On Sun, Jan 10, 2010 at 1:20 PM, Victor Subervi victorsube...@gmail.com wrote:
Hi;
I have a shopping cart that will spawn a tmp table for every shopping cart
instance. Would it be better to create a separate database for these instead
of having them in the same database as all the
On Mon, Jan 11, 2010 at 10:35 AM, Baron Schwartz ba...@xaprb.com wrote:
Victor,
On Sun, Jan 10, 2010 at 1:20 PM, Victor Subervi victorsube...@gmail.com
wrote:
Hi;
I have a shopping cart that will spawn a tmp table for every shopping
cart
instance. Would it be better to create a
Victor,
That strikes me as messy. Each tmp table has as many rows as necessary for
the products that are to be bough. To do as you say I would have to create a
table with a zillion rows to accommodate however many products I *predict*
buyers would buy. Therefore, I guess I should probably
I think what he's trying to accomplish is not truly random, but to use the
probability that's indicated in the second field of the table:
1, Aaron, 0.240
3, Abe, 0.006
13, Adrian, 0.069
So there would be a probability of 0.240 that the call returns Aaron, a
probability of 0.006 that it
I tried to look at the binary logs by using phpMyAdmin, but got an error:
SQL error:
SHOW BINLOG EVENTS LIMIT 0, 30;
MySQL said:
#1220 - Error when executing command SHOW BINLOG EVENTS: Wrong offset or I/O
error.
From the error-file:
100111 16:15:40 [ERROR] Error in
On Mon, Jan 11, 2010 at 10:49 AM, Baron Schwartz ba...@xaprb.com wrote:
Victor,
That strikes me as messy. Each tmp table has as many rows as necessary
for
the products that are to be bough. To do as you say I would have to
create a
table with a zillion rows to accommodate however many
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
-Original Message-
From: F.A.I.Z.A.L [mailto:sac.fai...@gmail.com]
Sent: Monday, January 11, 2010 2:51 AM
To:
Victor,
Don't want to butt in, and not trying to be rude, but he gave you advice.
You don't seem inclined to take it. How else can he, or anyone else, help
you? Clearly you don't understand some fundamental issue about relational
databases. If you can't just accept his suggestion to put all carts
On Mon, Jan 11, 2010 at 11:38 AM, Keith Murphy bmur...@paragon-cs.comwrote:
Victor,
Don't want to butt in, and not trying to be rude, but he gave you advice.
You don't seem inclined to take it. How else can he, or anyone else, help
you? Clearly you don't understand some fundamental issue
Victor,
The temporary table solution is not a good one. Use a single table and store
each item put into a cart identified by the session ID of the user. A
process should clean out this table periodically since there are shoppers
that abandon carts from time to time.
The design of this table
At 09:56 AM 1/11/2010, Johnny Withers wrote:
Victor,
The temporary table solution is not a good one. Use a single table and store
each item put into a cart identified by the session ID of the user. A
process should clean out this table periodically since there are shoppers
that abandon carts
Good day guys
I previously requested information regarding the exporting
of data which needs to be imported into oracle.
We are however still struggling with the data though and
maybe someone can give me some ideas...
It seems that one of
24 matches
Mail list logo