Please check out http://q4m.31tools.com/*. *It is a message queue storage
engine with sql interface. Havent used it in a production setup though we
did some tests.
--
Thanks
Alex
http://alexlurthu.wordpress.com
I would also add Baron's maakit http://www.maatkit.org/ ( innotop ) for
innodb details to the arsenal.
On Fri, Jun 20, 2008 at 3:11 PM, Ian Simpson <[EMAIL PROTECTED]> wrote:
> I tend to use the 'mytop' program, which shows the average
> queries/second for the entire lifetime and for the last 5
ps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
> sda 88.47 782.20 998.77 9046888130 11551757459
>
> The new server, which is just trying to handle replication
>
> Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
> sda 77.83 1367.55 2914.72 358474084 764029986
>
> Thanks,
&
sk about the RAID settings.
>>
>> Variable_name: innodb_flush_log_at_trx_commit
>>Value: 1
>> Variable_name: sync_binlog
>>Value: 0
>> Variable_name: innodb_locks_unsafe_for_binlog
>>Value: OFF
>>
>> Thanks
>>
>
Please check if the my.cnf configurations to be the same.
What are your configuration parameters in terms of innodh flush log trx
commit , bin logging, sync binlog and innodb unsafe for binlog ?
If the systems have raid, check if the BBWC is enabled on the new host and
WB is enabled.
On Fri, J
Chain replication is fine as long as reading stale data from the last slave
in your chain is ok. the staleness depends on the write throughput and
capacity of the intermediate slaves. But Chain replication with circular
replication is a definite no no in prod since if any intermediate fails, you
wi
How about looking at the .frm file of the table.
On 11/28/07, Richard Edward Horner <[EMAIL PROTECTED]> wrote:
> FYI, this did not work :)
>
> Thanks though!
>
> Rich(ard)
>
> On Nov 23, 2007 3:37 AM, Paul McCullagh <[EMAIL PROTECTED]>
> wrote:
> > Maybe this will work:
> >
> > SHOW CREATE TABLE t
You can set pager command to grep out unwanted fields.
On 11/28/07, bruce <[EMAIL PROTECTED]> wrote:
> hi..
>
> simple question!!
>
> mysql> show slave status
>
> returns a number of fields, with information on the status of the slave. is
> there a way to only return the field(s) i'm interested in
The second query might be faster due to caching.
On 11/26/07, Alexander Bespalov <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have a problem with SELECT speed. The first execution takes up to several
> minutes while the next (with the same statement) takes not more then several
> seconds.
>
> The statem
select * from Products order by Visited desc limit 10; should give
you the top 10 products.
On 9/5/07, Tomas Abad <[EMAIL PROTECTED]> wrote:
>
> HI All,
>
>
>
> I have a Table and want to know the most visited products.
>
>
>
> Products
>
> - Id
>
> - Name
>
> -
reply inline
On 9/5/07, Olaf Stein <[EMAIL PROTECTED]> wrote:
>
> delete from geno_260k where ident=(select ident from geno_260k where a1=0
> group by ident having count(a1)>25);
When a sub query returns more than one row in a where clause, then "="
should be replaced by the "in" .
--
Th
stop slave;
change master to master_log_file='Relay_Master_Log_File' ,
master_log_pos=Exec_master_log_pos;
#Get the values for the above command from your show slave status output.
start slave;
The above process should fix your problem.
On 9/4/07, Russell E Glaue <[EMAIL PROTECTED]> wrote:
>
The checksum errors might be due to various reasons. We had similar issue
where we restored the database multiple times, replaced the ram sticks
nothing helped. Finally we drilled down the issue to the chassis. Recommend
testing the restore on a different machine to rule out any hardware issue.
--
I am not sure whether you are talking about innodb_thread_concurrency. If so
please check out
http://www.mysqlperformanceblog.com/2006/06/05/innodb-thread-concurrency for
more details. Innodb_thread_concurrency works on linux.
Thanks
Alex
On 8/29/07, Andrew Braithwaite <[EMAIL PROTECTED]> wrote:
If you want to track the schema level changes, updates, inserts etc you
always have the binlogs/update logs. If you want to track select queries
also you have the general query log. Check out
http://dev.mysql.com/doc/refman/4.1/en/log-files.html for the different logs
available. Of course be wary o
To have a good understanding on the show innodb status output checkout
http://www.mysqlperformanceblog.com/2006/07/17/show-innodb-status-walk-through/
One area you can look at is the "LATEST DETECTED DEADLOCK". But in most
cases have found calculations on the status variables more helpful.
--
Ale
On 8/7/07, Tharabar <[EMAIL PROTECTED]> wrote:
>
> SELECT `field1`,`field2`,`field3` FROM 'table' WHERE `field5` LIKE
> '%keyword%1' AND `field5` LIKE '%keyword2%'
The most trivial way to speedup a query is to add an index on the columns
that are being used in the where clause. But doing 'LIKE' o
Hi Ace,
If you cant affort downtime and if you are using innodb try removing auto
extend on the current data file and create a datafile in a different
partition and put autoextend on the same. If you are using MyISAM , you can
move few tables to different disk use symlinks.
--
Thanks
Alex
http:
.
--
Thanks
Alex
http://blog.360.yahoo.com/alex.lurthu
On 7/9/07, Ananda Kumar <[EMAIL PROTECTED]> wrote:
Hi Alex,
Thanks a lot,
I missed on taking the "exe_master_log position" value.
If i start from Read_Master_Log_Pos: 106683511, will it cause any harm.
regards
anandkl
On 7/9/07,
Anand,
If the dump was taken from the slave then the binlog positions that were
dumped out are that of the slave. Now you might do 2 things :
1. Setup a slave of your master
To do this use the binlog positions that you obtained using the
command show slave status on your slave. The master
You havent mentioned which version of mysql your are on. If on an older
version i would recommend the option --opt. Also if you are running a dump
using single-transaction option on a loaded system with writes, things might
slow down significantly due to different versions of rows which the serve
On 7/6/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
How does the cpu power influence the speed of a query?
Sort is a cpu intensive process.
*Check if you are suffering from locks on the tables you look up.*
Also, was the table in the system where the queries are running faster
rebuilt r
On 7/6/07, Ananda Kumar <[EMAIL PROTECTED]> wrote:
-- CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.03',
MASTER_LOG_POS=311;
As see in the mysqldump is saying to start recovery from bin-log file "'
mysql-bin.03'" and position="MASTER_LOG_POS=311",
You need to use the positions specif
On 7/6/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
How does the cpu power influence the speed of a query?
Sort is a cpu intensive process.
*Check if you are suffering from locks on the tables you look up.*
Also, was the table in the system where the queries are running faster
rebuilt r
Hi,
Run explain plan on both the machines and post the same.
~Alex
On 7/4/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hello Ananda,
yes, the testmachine has the same data.
Regards,
Spiker
--
GMX FreeMail: 1 GB Postfach, 5 E-Mail-Adressen, 10 Free SMS.
Alle Infos und kostenlose Anmeldu
Chris,
Did you check if there are any user level MAX_USER_CONNECTIONS restriction
set while granting access ?
Thanks
Alex
On 7/4/07, Chris Faust <[EMAIL PROTECTED]> wrote:
Folks,
I'm wondering is someone could help us in trying to resolve the above
error,
we have read through what threads
Ratheesh,
If you still want to place you blob data in the database, seperate out the
blob storage to a seperate table. This will help you alleviate few of your
performance and maintenance problems.
~Alex
On 6/22/07, Steve Edberg <[EMAIL PROTECTED]> wrote:
At 12:11 PM +0530 6/22/07, Ratheesh
On 5/15/07, Micah Stevens <[EMAIL PROTECTED]> wrote:
I think you may be able to get around this by using multiple key
buffers? (MySQL 4.1 or later)
key buffers caches only index data and they dont help with sorting like
sort_buffer. they dont impact innodb engine. even while using multiple key
On 5/15/07, Ananda Kumar <[EMAIL PROTECTED]> wrote:
Hi Alex,
Thanks for the info,
For the second question, do you mean i should restore the entire backup or
just that one file from my backup.
All the files should be from the same backup. AFAIK, MySQL doesnt have an
option to recover only one d
On 5/15/07, Christoph Klünter <[EMAIL PROTECTED]> wrote:
I have set the sort_buffer_size to 1G but even this doesn't help.
Any hints ? Should we try a 64Bit-OS ?
setting sort_buffer_size to 1GB is not recommended. it is a thread specific
configuration parameter which means each thread will
On 5/15/07, Ananda Kumar <[EMAIL PROTECTED]> wrote:
Hi All,
I have take a mysqldump of my entire database, is it possible to restore
just one table from this mysqldump.
Yes thats possible.
cat | grep "tablename u want to restore" > mysql -u
user -ppassword should do it.
Also, i have take
the ask lies in expire_logs_days. If you set this to optimal number of days,
logs older than the configured days will get purged.
~Alex
On 5/15/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> One question about this, is it safe to turn of log_bin?
i think, you can. the log is necessary for
check if you are seeing any access denied errors in the mysql error log.
~Alex
On 5/14/07, richard <[EMAIL PROTECTED]> wrote:
Ian P. Christian wrote:
> richard wrote:
>
>> as far as I can see, these commands select which db's to replicate on
>> the slave that currently exist on the master serv
techincally yes you can have. replication is all about the queries that are
getting executed on the master will be executed on the slave. So , if the
database that exists on the master exists on the slave , then you should
have no problems.
Thanks
Alex
On 5/14/07, richard <[EMAIL PROTECTED]> wro
On a different note just running a slave will not help when there is some
accidental deletion of data or tables or databases. Hence have a slave as
Mikhail mentioned and also run regular backups on the slave. Preferably a
tar of your mysql server after shutting it down, also ensure you have
log-bi
35 matches
Mail list logo