On 9/2/2010 3:31 PM, Julien Lory wrote:
Hello,
I've done lot of researches and tests but can't find any answer. I need
to share one table between two db, those two db are in the same path (
/var/lib/mysql/db1 & db2 ). I created symbolic links for db2 pointing to
the table in db1.
When I que
On 2 Sep 10, at 13:58, Jerry Schwartz wrote:
>> From: Jan Steinman [mailto:j...@bytesmiths.com]
>>
>>> From: "Jerry Schwartz"
>>>
>>> IMNSHO, never store dynamic data in a field unless you absolutely have to.
...
>> To do something similar in MySQL, I've used views (which is somewhat clumsy),
>-Original Message-
>From: Jan Steinman [mailto:j...@bytesmiths.com]
>Sent: Thursday, September 02, 2010 1:52 PM
>To: mysql@lists.mysql.com
>Subject: RE: Best method to keep totals
>
>> From: "Jerry Schwartz"
>>
>> IMNSHO, never store dynamic data in a field unless you absolutely have to.
On 9/2/2010 1:39 PM, neutron wrote:
Hello Johan,
Thanks for the reply.
On Thu, Sep 2, 2010 at 3:34 AM, Johan De Meersman wrote:
I suspect he is talking about the Temp Tablespace concept from Oracle, which
is different from a temporary table or a memory table.
MySQL will allocate a memory tab
I'm using Debian Lenny ( up to date ), so there is no app armor /
selinux / grsec :/
ii mysql-client-5.0 5.0.51a-24+lenny4 MySQL
database client binaries
ii mysql-common 5.0.51a-24+lenny4 MySQL
database common files
ii mysql-server-5.0
> -Original Message-
> From: Julien Lory [mailto:julien.l...@gmail.com]
> Sent: Thursday, September 02, 2010 12:31 PM
> To: mysql@lists.mysql.com
> Subject: Symlinks not working when pointing to another table.
>
> Hello,
>
> I've done lot of researches and tests but can't find any
Hello,
I've done lot of researches and tests but can't find any answer. I need
to share one table between two db, those two db are in the same path (
/var/lib/mysql/db1 & db2 ). I created symbolic links for db2 pointing to
the table in db1.
When I query the table from db2 I get this error :
Simple question about views:
I have a view such as:
create view combo as
select * from table1
union
select * from table2;
Where table1 and table2 are very large and identical and have a
non-unique key on field "id"..
when I do a:
select * from combo where id
> From: "Jerry Schwartz"
>
> IMNSHO, never store dynamic data in a field unless you absolutely have to.
I agree, and yet, it's so darned handy if it's a calculation you need quite
often.
In FileMaker Pro (hold the "boos," please :-) you can have calculated fields --
a "pseudo field" that hold
Hello Johan,
Thanks for the reply.
On Thu, Sep 2, 2010 at 3:34 AM, Johan De Meersman wrote:
> I suspect he is talking about the Temp Tablespace concept from Oracle, which
> is different from a temporary table or a memory table.
>
> MySQL will allocate a memory table for sort operation and the li
Hi Travis,
Sorry, bad copy/paste. That DELETE statement is wrong.
The application executes:
DELETE FROM clientinfo WHERE userid='x';
BR
AJ
On Thu, Sep 2, 2010 at 5:23 PM, Travis Ard wrote:
> Have you considered adding a secondary index on the units column for your
> delete queries?
>
Have you considered adding a secondary index on the units column for your
delete queries?
DELETE FROM clientinfo WHERE units='155618918';
-Original Message-
From: Alexandre Vieira [mailto:nul...@gmail.com]
Sent: Thursday, September 02, 2010 8:46 AM
To: John Daisley; joh...@pixelated.net
Hi Jangita,
I'm 15779 innodb_buffer_pool_pages_free from a total of 22400. That's 246MB
of 350MB free.
| Innodb_buffer_pool_pages_data | 6020 |
| Innodb_buffer_pool_pages_dirty| 1837 |
| Innodb_buffer_pool_pages_flushed | 673837 |
| Innodb_buffer_pool_pages_free | 157
Wow .. Cool that solved our problem...
Thanks a lott ..
On Thu, Sep 2, 2010 at 9:20 PM, Jangita wrote:
> On 02/09/2010 4:57 p, karthik kumar wrote:
>
>> Hi .. I am facing a problem in mysql.
>>
>> I am getting error 'Can not open connection' at the application
>> side which happens
On Thu, Sep 2, 2010 at 5:51 PM, wrote:
> Quoting Jangita :
>
>
>> Simply put: I want a solution that ensures that server 2 has all the data
>> at server 1 at any point in time; say server 1 suddenly fell into a pond :)
>> . I wouldnt want to open server 2 and find the last insert/update/delete
>>
On Thu, Sep 2, 2010 at 5:12 PM, Neil Aggarwal wrote:
> If server 1 and 2 are on the same local network, I would use
> a cluster.
>
As in NDB ? I've no personal experience with it - save for a sales talk by
MySQL guys some years back where we decided it was useless to us - but I
understand it has
Quoting Jangita :
Simply put: I want a solution that ensures that server 2 has all the
data at server 1 at any point in time; say server 1 suddenly fell
into a pond :) . I wouldnt want to open server 2 and find the last
insert/update/delete missing...
Ok so that rules out any asynchro
I had a similar problem and found a solution. My WAMP server could not serve
pages because the port that it was configured to utilize was in use by my
Skype app, which loaded first. All that I had to do, was quit out of Skype,
then start WAMP server, then restart Skype (which, I think, uses a diffe
On 02/09/2010 4:57 p, karthik kumar wrote:
Hi .. I am facing a problem in mysql.
I am getting error 'Can not open connection' at the application
side which happens at random timings. What i found was at whenever the
problem occurs it takes 70 secs for connecting to mysql server. Th
On 02/09/2010 4:46 p, Alexandre Vieira wrote:
John, Johnny,
Thanks for the prompt answer.
...
We also run some other applications in the server, but nothing that consumes
all the CPU/Memory. The machine has almost 1GB of free memory and 50% of
idle CPU time at any time.
TIA
BR
Alex
Increa
I am running a tool which just makes connection and closes it (using JDBC)
.. The JDBC connection never says 'Can not establish connection' .. I just
says ' at this time ' took 70 secs to establish a connection .. So my
guess was network was not a problem,( since connection was established bu
> Simply put: I want a solution that ensures that server 2 has all the
> data at server 1 at any point in time
If server 1 and 2 are on the same local network, I would use
a cluster. If they are located on physically separate networks,
I would use master-master replication.
Neil
--
Nei
You might want to have a good close look at the state of your network
before you consider mysql as a cause..
- michael dykman
On Thu, Sep 2, 2010 at 10:57 AM, karthik kumar wrote:
> Hi .. I am facing a problem in mysql.
>
> I am getting error 'Can not open connection' at the applicatio
On 02/09/2010 4:35 p, a.sm...@ukgrid.net wrote:
Clustering is a general term, do you know which one you are comparing
with replication? Clustering most typically refers to high availability
clustering or high performance clustering, which wouldnt
necessarily/normally imply any copy of the actual
Hi .. I am facing a problem in mysql.
I am getting error 'Can not open connection' at the application
side which happens at random timings. What i found was at whenever the
problem occurs it takes 70 secs for connecting to mysql server. The machine
is a high end quad core, 16 GB ram,
John, Johnny,
Thanks for the prompt answer.
mysql> SHOW CREATE TABLE clientinfo;
++--
On 02/09/2010 4:32 p, Johan De Meersman wrote:
On Thu, Sep 2, 2010 at 1:10 PM, Jangita mailto:jang...@jangita.com>> wrote:
...
Growth should be linear to the growth of customers, no ? :-)
I thought so too; but one customer = 1 customer record, plus all his
transactions, and also weirdly
Clustering is a general term, do you know which one you are comparing
with replication? Clustering most typically refers to high
availability clustering or high performance clustering, which wouldnt
necessarily/normally imply any copy of the actual data.
If you want a copy of your data on a
On Thu, Sep 2, 2010 at 1:10 PM, Jangita wrote:
> Hi Guys,
> We have a system that has been running along nicely for the past three
> months on a pc (4gb 1,8ghz,debian lenny pc). It is a telecom-financal
> system; slightly 2 hits per minute but growing exponentally as customers
> increase.
>
Grow
What is the hardware spec? Anything else running on the box?
Why are you replicating but not making use of the slave?
Can you post the output of SHOW CREATE TABLE?
Regards
John
On 2 September 2010 12:50, Alexandre Vieira wrote:
> Hi list,
>
> I'm having some performance problems on my 5.0.45-
Can you show us the table structure and sample queries?
On Thursday, September 2, 2010, Alexandre Vieira wrote:
> Hi list,
>
> I'm having some performance problems on my 5.0.45-log DB running on Solaris
> 8 (V240).
>
> We only have one table and two apps selecting, updating, inserting and
> delet
Hi list,
I'm having some performance problems on my 5.0.45-log DB running on Solaris
8 (V240).
We only have one table and two apps selecting, updating, inserting and
deleting massively and randomly from this table.
The table is very simple. All SELECTs,INSERTs,UPDATEs and DELETEs have only
one c
Hi Guys,
We have a system that has been running along nicely for the past three
months on a pc (4gb 1,8ghz,debian lenny pc). It is a telecom-financal
system; slightly 2 hits per minute but growing exponentally as customers
increase.
We have now bought two servers 12Gb RAM RAID blah blah; and
On 02/09/2010 7:19 a, James Corteciano wrote:
How could I put the dump data on web server and not the local disk on mysql
server?
Log into the web server and do it from there? or copy the file onto the
web server?
--
Jangita | +256 76 91 8383 | Y! & MSN: jang...@yahoo.com
Skype: jangita | GTalk
On 02/09/2010 10:53 a, Vikram A wrote:
Hi,
I have doubt on the execution time. Can any one help me!
Which operation will take much time INSERT or UPDATE ?
Thank you
Vikram
Depends on the type of data, but generally (and I say this lightly)
inserts are faster then updates; alot depends on
Did u check the logs on the db server, to see what the issue was.
regards
anandkl
On Thu, Sep 2, 2010 at 6:25 AM, monloi perez wrote:
> All,
>
> I'm not sure if this is the right mailing list since the specific mailing
> lists
> doesn't seem to meet my concern.
>
> For some reason mysql client
>From the mysqldump manpage, on the -T option:
Note
> This option should be used only when mysqldump is run on the same machine
> as the mysqld server. You must have the FILE privilege, and the server must
> have permission to write files in the directory that you specify.
>
In other words, you'v
I suspect he is talking about the Temp Tablespace concept from Oracle, which
is different from a temporary table or a memory table.
MySQL will allocate a memory table for sort operation and the like, up until
that table exceeds a preset limit, at which point it will automatically (and
costly !) be
Hi,
I have doubt on the execution time. Can any one help me!
Which operation will take much time INSERT or UPDATE ?
Thank you
Vikram
39 matches
Mail list logo
