Dear all,
I have a doubt regarding fetching data from large tables.
I need to fetch selected columns from a 90Gb Table 5Gb index on it.
CREATE TABLE `content_table` (
`c_id` bigint(20) NOT NULL DEFAULT '0',
`link_level` tinyint(4) DEFAULT NULL,
`u_id` bigint(20) NOT NULL,
`heading`
More than 20163845 rows are there and my application continuously insert
data in the table.
daily i think there is a increase in 2.5 Gb in that table.
Thanks
Chris Tate-Davies wrote:
How many rows is that???
On Tue, 2011-11-15 at 16:05 +0530, Adarsh Sharma wrote:
Dear all,
I have a
You might want to have a look at partitioning that table. It'll be a
considerable downtime, but if done right it'll speed up a lot of your selects.
- Original Message -
From: Adarsh Sharma adarsh.sha...@orkash.com
To: mysql mysql@lists.mysql.com
Sent: Tuesday, 15 November, 2011
Hi,
I am trying to install Mysql on linux which I don't have a root access. I have
done the folowing :
1. Download source files from http://dev.mysql.com/downloads/mysql/ and un-tar
thwm
2. configure the instalation using ./configure as:
CFLAGS=-O3 CXX=gcc CXXFLAGS=-O3 -felide-constructors
2011/11/14 18:01 +, Rob Tanner
So what are those files and can I delete all but the most recent?
And if you look up replication, as others already have said, you will find that
the command reset master will do just that--if, as Harald hinted, you really
_want_ replication, or at least
mysqld_safe might not know where your config file is located. You can
specify it's location at the command line with
--defaults-file=file_name
alternatively, you could specify the location of your log file thus:
--log-error=file_name
other options found at
In mysql 5.0 ,how to check how big a database is?
Thanks
2011/11/14 18:01 +, Rob Tanner
So what are those files and can I delete all but the most recent?
And if you look up replication, as others already have said, you will find that
the command purge binary logs to 'mysql-bin.' will do just that--if, as
Harald hinted, you really _want_
On 11/15/2011 2:10 PM, Angela liu wrote:
In mysql 5.0 ,how to check how big a database is?
Thanks
See Database size at http://www.artfulsoftware.com/queries.php
PB
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Thanks, this is really helpful.
From: Peter Brawley peter.braw...@earthlink.net
To: mysql@lists.mysql.com
Sent: Tuesday, November 15, 2011 12:41 PM
Subject: Re: how to check how big a database is
On 11/15/2011 2:10 PM, Angela liu wrote:
In mysql 5.0 ,how to
I have been struggling with installing MySQL 5.5.17 on a Mac running OS
10.7. My machine had 5.5.15 on it.
I keep getting user denied access messages (Error 1045). I thought at
first it was a matter of a password not being flushed from a previous
installation and went through repeated install
You showed us a link which explains how you uninstalled MySQL.
Perhaps you could tell us how you installed it? IT would certainly
shed some light on the subject. If you are using a pre-built package
for OS/X, the issue is likely with the package. If you are installing
from source, there is an
12 matches
Mail list logo