Try out query with UNION also
select A,B,C from
(select A,B,C from X
UNION
select A,B,C from Y)
group by A,B,C
having count(*)>1
From: Gian Karlo C
To: mysql@lists.mysql.com
Sent: Sunday, 2 October 2011 12:49 PM
Subject: Join 2 tables and compare then calculat
Try out functionality you desire with trigger to replicate data
From: Derek Downey
To: [MySQL]
Sent: Thursday, 29 September 2011 10:46 PM
Subject: Re: replication between two tables in same database
You could look into the sphinx engine http://sphinxsearch.com
innnodb_file per table creates ibdata files for each table and What to
do if some tables data are deleted frequently.
I have a innodb table which was truncated after 150GB in mysql database.
Reindl Harald wrote:
Am 02.10.2011 22:10, schrieb Dhaval Jaiswal:
Hi All,
How to shrink the Mysql
The meaning is:
increase max_connections
reduce wait_timeout
-- 28800 is wait 8 hours before closing out dead connections
same for interactive_timeout
increase key_buffer_size (> 7.8G) increase join_buffer_size
-- This keeps mysql from having to run to disk constantly for keys
-- Key buffer siz
Also i did run mysqlcheck and i did optimize and repair the database/table..
thanks
On Sun, Oct 2, 2011 at 9:19 PM, Joey L wrote:
> The section called: Variables to adjust: --when it says ">" -- does this
> mean I have to set it higher in my.cnf file ?? and if I have a "<" -- does
> this mean I
The section called: Variables to adjust: --when it says ">" -- does this
mean I have to set it higher in my.cnf file ?? and if I have a "<" -- does
this mean I have to set it lower ??
thanks...here is the info below you both asked for :
mysql> select count(*) from w6h8a_sh404sef_urls ;
+---
Thanks to all for your detailed info.
Hope Mysql community will add some solution for this in new release as to we
moved from MyISAM to InooDB for performance purpose.
On Mon, Oct 3, 2011 at 2:00 AM, Reindl Harald wrote:
> yes and after that you can do "optimize table" like for MYISAM
> "ibdata
yes and after that you can do "optimize table" like for MYISAM
"ibdata1", "ib_logfile0", "ib_logfile1" will still exists and
MUST NOT be removed but "ibdata1" will not grow endless
i do not know "other benefits" but they are enough
on the other hand - what are the benefits of having a dumb large
Currently in my database only 5 tables are of innodb engine.
"innodb_file_per_table" will create each file per table is it ? what are the
other benefits of it.
If so than again i have to follow the dump & restore procedure.
On Mon, Oct 3, 2011 at 1:50 AM, Reindl Harald wrote:
>
>
> Am 02.10.2
Am 02.10.2011 22:10, schrieb Dhaval Jaiswal:
> Hi All,
>
> How to shrink the Mysql ibdata1 files.
>
> The actual size of database is only hardly 10G, but ibdata1 is showing 73G
> full. I did some googling and found the following procedure.
>
> Do a mysqldump of all databases, procedures, t
Hi All,
How to shrink the Mysql ibdata1 files.
The actual size of database is only hardly 10G, but ibdata1 is showing 73G
full. I did some googling and found the following procedure.
Do a mysqldump of all databases, procedures, triggers etc
Drop all databases
Stop mysql
Delete ib
Did you fix the issue?
On Sun, Oct 2, 2011 at 4:05 PM, Singer X.J. Wang wrote:
> Are you sure? Do a show create table and send it to us please
>
>
>
>
> On Sun, Oct 2, 2011 at 10:02, Joey L wrote:
>
>> thanks for the quick reply!
>> My table is MyISAM
>> further top says this:
>> top - 10:01:29
I'd suggest mysqltuner. You can get it by using:
wget http://mysqltuner.pl
See what suggestions that makes
On 10/02/2011 06:44 AM, Joey L wrote:
> I have having issues with mysql db - I am doing a "select count(*) from
> table" -- and it take 3 to 4 min.
> My table has about 9,000,000 recor
thanks for the quick reply!
My table is MyISAM
further top says this:
top - 10:01:29 up 8:25, 4 users, load average: 1.42, 1.85, 2.69
Tasks: 338 total, 1 running, 337 sleeping, 0 stopped, 0 zombie
Cpu(s): 10.3%us, 0.9%sy, 0.0%ni, 56.6%id, 32.0%wa, 0.0%hi, 0.2%si,
0.0%st
Mem: 8198044
Is your table MyISAM or InnoDB?
A
On Sun, Oct 2, 2011 at 2:44 PM, Joey L wrote:
> I have having issues with mysql db - I am doing a "select count(*) from
> table" -- and it take 3 to 4 min.
> My table has about 9,000,000 records in it.
> I have noticed issues on my web pages so that is why i di
I have having issues with mysql db - I am doing a "select count(*) from
table" -- and it take 3 to 4 min.
My table has about 9,000,000 records in it.
I have noticed issues on my web pages so that is why i did this test.
I have about 4 gig of memory on the server.
Is there anything I can do to fix t
Hi,
On 1-10-2011 21:51, Halász Sándor wrote:
It is, of course, generally considered more natural to make equality
primary, not inequality, but that symbol that MySQL uses for
NULL-safe equality,<=>, looks much more like inequality than
equality.
The whole concept and the name of this operato
Hi All,
I decided to join and write to the list hoping someone could help and shed a
light on me.
Here's the scenario.
I have a database running in mysql 5.x in Centos 5. The database has 2
tables that is almost identical with some additional fields.
Table 1
Name, IPAddress, Description, Issue,
18 matches
Mail list logo
