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
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 f
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 cou
On Mon, Jan 11, 2010 at 11:38 AM, Keith Murphy wrote:
> 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
> da
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
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: mysql@
On Mon, Jan 11, 2010 at 10:49 AM, Baron Schwartz 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 product
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 Log_event::read_log_event()
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 retu
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
On Mon, Jan 11, 2010 at 10:35 AM, Baron Schwartz wrote:
> Victor,
>
> On Sun, Jan 10, 2010 at 1:20 PM, Victor Subervi
> 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
> inste
Victor,
On Sun, Jan 10, 2010 at 1:20 PM, Victor Subervi 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 other tables for the sh
Matt,
On Thu, Jan 7, 2010 at 3:10 PM, Matt Neimeyer 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
Percona Inc: Servi
On Monday 11 January 2010 12:33, Mihamina Rakotomandimby wrote:
> (Correction, seel below)
>
> > Jørn Dahl-Stamnes :
> > > > 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
(Correction, seel below)
> Jørn Dahl-Stamnes :
> > > 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 sol
> Jørn Dahl-Stamnes :
> > > 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, but by "
SHOW ENGINE innodb STATUS\G
On Mon, Jan 11, 2010 at 3:35 PM, F.A.I.Z.A.L 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
>
> mysql> s
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?
Cheer
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 = wrote:
> 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
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 th
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
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
wrote:
> On Monday 11 January 2010 08:53, Mihamina Rakotoma
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 wrote:
> Hi
>
> mysqld process taking high cpu utilization (100%), how to reduce the cup
> utilization
>
> it is running under so
On Monday 11 January 2010 08:53, Mihamina Rakotomandimby wrote:
> > Jørn Dahl-Stamnes :
> > 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
24 matches
Mail list logo
