Thanks a lot.
I am writing script which will take backup and copy it to another box.
On Wed, Sep 17, 2008 at 11:14 AM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> Can u mount that file system on the slave db and take the backup so that u
> can avoid Network latency.
>
> regards
> anandkl
>
>
> On
Can u mount that file system on the slave db and take the backup so that u
can avoid Network latency.
regards
anandkl
On 9/16/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>
> Yes
>
> On Tue, Sep 16, 2008 at 6:39 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
>
>> Hi Krishna,
>> When u s
hi list.
I want to build a category system and a help system. I think that's a
very common task, and I'm curious about what's your SQLs to build these.
I'm really appreciated your sharing the table structure with me, Thanks.
Regards,
--
Fayland Lam // http://www.fayland.org/
Foorum based on
http://rpbouman.blogspot.com/2008/07/inspect-query-cahce-using-mysql.html
- parvesh
On Wed, Sep 17, 2008 at 1:15 AM, Edson Noboru Yamada <[EMAIL PROTECTED]> wrote:
> Hey, Guys
>
> Is there a way to know what queries are in the query cache?
>
>
> thanks
>
--
MySQL General Mailing List
For list a
See Thread at: http://www.techienuggets.com/Detail?tx=46643 Posted on behalf of
a User
HI,
first check the error log and find the position where the replication was
terminated.Now run the mysqlbinlog utility on the binarylogs file.
Now when you run the query will get the text format as a result
Hi Ananda,
1. Long term solution: When you upgrade to MySQL 5.1 partition the table
e.g. by time. This approach was used for 10s of years in the other DBs.
http://dev.mysql.com/tech-resources/articles/performance-partitioning.ht
ml
http://dev.mysql.com/tech-resources/articles/mysql_5.1_partition
Hey, Guys
Is there a way to know what queries are in the query cache?
thanks
On Tue, Sep 16, 2008 at 11:02 AM, Dave M G <[EMAIL PROTECTED]> wrote:
> MySQL List,
>
> I'm going through a post-hard-drive-crash process of reinstalling my whole
> operating system, and MySQL is acting very strange.
>
> I installed it as I always have done, by using Ubuntu's Synaptic Package
> Ma
Dave M G wrote:
[EMAIL PROTECTED]:~$ ps aux | grep mysql
And it said back to me:
root 11171 0.0 0.0 1772 532 ?S20:36 0:00 /bin/sh
/usr/bin/mysqld_safe
mysql11290 0.1 0.7 126708 15424 ?Sl 20:36 0:00
/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/m
MySQL List,
I'm going through a post-hard-drive-crash process of reinstalling my
whole operating system, and MySQL is acting very strange.
I installed it as I always have done, by using Ubuntu's Synaptic Package
Manager to install all the default packages for a LAMP server. Every
time before
Yes
On Tue, Sep 16, 2008 at 6:39 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> Hi Krishna,
> When u say remote server, do u mean the file system storing the backup is
> on a different machine.
>
> regards
> anandkl
>
>
> On 9/16/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>>
>> Hi,
>
Hi Krishna,
When u say remote server, do u mean the file system storing the backup is on
a different machine.
regards
anandkl
On 9/16/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> Currently, i am taking production server backup on hourly basis on the
> slave
> server. Is i
12 matches
Mail list logo