machiel.richards wrote:
Good day guys
[snip]
. Each item in the text field is added in the field by entering
the country name then pressing enter and then entering the next, etc
. When exporting the data to a file (even when enclosing each field
within quotes) it still
Hi,
After analysing slow query log i found that some queries are not using index
and so i used the force index command in query and test it and now it starts
using index properly.Accordingly i implemented the same query with force index
in my application code and regeneratet the slow query
It seems that one of the tables we need to export and import
contains rows which is used for dropdown menus.
This has the following effect:
. Each item in the text field is added in the field by entering
the country name then pressing enter and then
I need your recommendation, I have the following config file need to
be optimized, can any one recommend any modification on this file,
lately mysql went slow with update procedure
# Example MySQL config file for medium systems.
#
# This is for a system with little memory (32M - 64M) where MySQL
Some other info you can post to the list to help us zero in on the problem:
1) What is the SQL used to update the tables
2) What is the table structure? Show Create Table mytablex
3) How long does it take for how many rows?
4) How busy is the CPU when the updates are occuring?
5) Show Status --
Hi:
I want to upgrade a master and slave server from mysql 4.1 to mysql 5.1.
I want to so something like follows:
1. Stop all write access to the master server.
2. Ensure that replication on the slave is caught up to the last change
on the master.
3. stop binary logging on the master.
4.
How about:
1 shut down the slave, upgrade it, restart it, let it catch up.
2 shut down the master, upgrade it, restart it, let the slave catch up.
?
On 1/12/10 12:34 PM, Lawrence Sorrillo sorri...@jlab.org wrote:
Hi:
I want to upgrade a master and slave server from mysql 4.1 to mysql
Also see http://dev.mysql.con/doc/refman/5.0/en/mysql-upgrade.html.
And make sure you make a backup before you do anything :)
-Original Message-
From: Tom Worster [mailto:f...@thefsb.org]
Sent: Tuesday, January 12, 2010 10:47 AM
To: Lawrence Sorrillo; mysql@lists.mysql.com
Subject: Re:
This is two upgrades done in sequence(the reload takes about three hours
per machine) . I can do what I am proposing in parallel.
Do you see it as problematic?
~Lawrence
Tom Worster wrote:
How about:
1 shut down the slave, upgrade it, restart it, let it catch up.
2 shut down the master,
Lawrence Sorrillo wrote:
Hi:
I want to upgrade a master and slave server from mysql 4.1 to mysql 5.1.
I want to so something like follows:
1. Stop all write access to the master server.
ok
2. Ensure that replication on the slave is caught up to the last change
on the master.
why? You
Hi:
I want to ensure that right after the reload that the same data is
present in both the master and the slave. They are in perfect sync. Then
I think its safe to consider starting binary logging and replication
etc. And after these are started, changes can start?
And in setting up
On Jan 12, 2010, at 12:36 PM, Lawrence Sorrillo wrote:
Hi:
I want to ensure that right after the reload that the same data is present in
both the master and the slave. They are in perfect sync. Then I think its
safe to consider starting binary logging and replication etc. And after these
Anyone have information they can provide on the performance hit of using
innodb_file_per_table?
I'd assume that since there are many individual tables that this would
slow performance, but perhaps not.
In a huge database, is this not a good idea, or a better one?
--
MySQL General Mailing List
There are a few articles on this at MySQL Performance Blog:
http://www.mysqlperformanceblog.com/?s=innodb_file_per_table+performance
On Tue, Jan 12, 2010 at 3:05 PM, Bryan Cantwell bcantw...@firescope.comwrote:
Anyone have information they can provide on the performance hit of using
Frankly, I didn't entirely understand what you were proposing. I got lost
around step 6.
Is the issue total time for the procedure or service downtime?
On 1/12/10 12:58 PM, Lawrence Sorrillo sorri...@jlab.org wrote:
This is two upgrades done in sequence(the reload takes about three hours
per
Hi,
The step 6 in simple terms is
Here we need to build two server ( both master and slave ). Instead of
building two server as it takes double the time of building in one server.
After building an server, make a copy of the first server files at OS level
and copy it to the server and start the
16 matches
Mail list logo