Crespo Rincón [mailto:jcre...@warp.es]
Sent: Thursday, October 08, 2009 10:17 AM
To: Brown, Charles
Cc: Daevid Vincent; mysql@lists.mysql.com
Subject: Re: MYSQL slow query log in table.
2009/10/7 Brown, Charles cbr...@bmi.com:
Hello All. I would like to implement MYSQL slow query log in table
Make sure you have granted permissions in the db for root to connect from the
host you are trying to connect from. Something like
GRANT priv ON db.table TO 'root'@'hostname' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
regards
Regards
John Daisley
Mobile +44(0)7812 451238
Email
MySQL Server can be 32 or 64 bit and it shouldn't make a difference to PERL.
However, if you can run 64 bit, you should.
PERL and it's modules all need to be the same architecture. It doesn't matter
if they're 32 bit or 64 bit, as long as it's consistent with itself.
I see no reason why
Here is the error I am receiving ( I posted this issue in the recent past):
dyld: lazy symbol binding failed: Symbol not found: _mysql_init
Referenced from:
/Library/Perl/5.10.0/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle
Expected in: flat namespace
dyld: Symbol not found:
To: Gavin Towey
Cc: mysql@lists.mysql.com
Subject: Re: Mysql Perl DBI DBD Version Compatability for MAC OS 10.6
Here is the error I am receiving ( I posted this issue in the recent past):
dyld: lazy symbol binding failed: Symbol not found: _mysql_init
Referenced from:
/Library/Perl/5.10.0/darwin-thread
As far as I know, you can't,
you can do it with symbolic linking but not at run time.
So if you have a clue you can (pre)build empty databases using symbolic
linking and switching to the right one at run time.
Cheers
Claudio Nanni
2009/9/18 Manasi Save manasi.s...@artificialmachines.com
Hi
You can do that at runtime no problem, you just need to do OS calls for it.
r...@soulcake-duck:/var/lib/mysql# *mysqlshow*
++
| Databases |
++
| information_schema |
| mysql |
++
r...@soulcake-duck:/var/lib/mysql#
Meersman
Sent: 18 September 2009 10:30
To: Claudio Nanni
Cc: manasi.s...@artificialmachines.com; mysql@lists.mysql.com
Subject: Re: Mysql dynamic database location
You can do that at runtime no problem, you just need to do OS calls for
it.
r...@soulcake-duck:/var/lib/mysql# *mysqlshow
Nice!
Bit are you sure that database is nowhere in the information schema?
And/or innodb tablespace info
Claudio
Il giorno 18 set, 2009 11:30 m., Johan De Meersman vegiv...@tuxera.be ha
scritto:
You can do that at runtime no problem, you just need to do OS calls for it.
On Fri, Sep 18, 2009 at 12:54 PM, Claudio Nanni claudio.na...@gmail.comwrote:
Nice!
Bit are you sure that database is nowhere in the information schema?
didn't think of that :-) Just checked, and the table in remotedb appears and
vanishes in information_schema.tables as you create and remove
You can't make the database, table or field names dynamic with
prepare, only values. Prepare allows you to cache the execution plan,
which wouldn't be valid on a different table.
On Mon, Sep 14, 2009 at 7:09 AM, Manasi Save
manasi.s...@artificialmachines.com wrote:
Hi All,
I have a query about
On Mon, Sep 14, 2009 at 11:15 PM, Kaushal Shriyan
kaushalshri...@gmail.comwrote:
Hi,
I have enabled ubuntu backports in Ubuntu 8.04 to install mysql-5.1
server, but i dont find it after apt-get update ?
Please suggest/guide
Thanks,
Kaushal
Hi, the options from discussion in Ubuntu
On Sat, Aug 29, 2009 at 12:09 PM, Manasi Save
manasi.s...@artificialmachines.com wrote:
Hi All,
I have a query which gives an error of lock wait timeout only this
transaction is running with 2 records in the table.
The query is :
Update Test
Set TestFlag = 1
Where TestID = 5;
Can
Hi,
You are right. The storage engine i m using is InnoDB. but then my concern
is why this simple update query takes so long. Is it true that if its
innodb table then even after specifying where condition it scans all
indexed rows. I am bit confused as mysql.com have mentioned on there site
that
Increase your Innodb_buffer_pool_size. It will solve your problem.
Thanks,
Krishna
On Sat, Aug 29, 2009 at 10:39 AM, Manasi Save
manasi.s...@artificialmachines.com wrote:
Hi All,
I have a query which gives an error of lock wait timeout only this
transaction is running with 2 records in
On Mon, 24 Aug 2009, Mike Scully wrote:
Hello, all.
=20
Can any of you share with me the names of any third-party tools or
appliances that you are using to encrypt your MySQL databases? I am
doing a search and would like to narrow down the initial search list.
Thanks!
=20
Mike
I use
: Tuesday, August 25, 2009 2:08 AM
To: Mike Scully
Cc: mysql@lists.mysql.com
Subject: Re: MySQL Encryption - Third-party tools
On Mon, 24 Aug 2009, Mike Scully wrote:
Hello, all.
=20
Can any of you share with me the names of any third-party tools or
appliances that you are using
You have to execute each command using the mysql command:
@echo off
mysql -u root -ppass --database test truncate table t1
mysql -u root -ppass --database test load data infile
On Saturday, August 8, 2009, DAREKAR, NAYAN (NAYAN)
nayan.dare...@alcatel-lucent.com wrote:
Hi Guys,
I need a
Aternatively, you can put all your MySQL commands into a single script
and excute that at the command like
===
-- contents of command file
truncate table cdma_dsr;
load data from infile ...
--end of command file
==
mysql -u user -p mydatabase
jing,
Please modify your my.cnf file.
在 2009-7-16,下午2:56, TianJing 写道:
Hi all,
i am trying to install mysql 5.1.35 in my linux platform, i do it from
source distribution, but there is a serious problem when i login it,
the error message is bellow:
*shell mysql -p -u root
Enter password:
thanks,
my.cnf file is as follow:
[client]
#password = your_password
port= 3306
socket = /export/data1/apps/local/mysql/mysql.sock
# The MySQL server
[mysqld]
datadir=/export/data1/apps/local/mysql/data
socket = /export/data1/apps/local/mysql/mysql.sock
Hi TianJing, all!
TianJing wrote:
Hi all,
i am trying to install mysql 5.1.35 in my linux platform, i do it from
source distribution, but there is a serious problem when i login it,
the error message is bellow:
*shell mysql -p -u root
Enter password:
Welcome to the MySQL monitor.
russbucket wrote:
I have been using the Linux version of MySQL for five years, also used it
on a Windows ME system even though documents said you couldn't. Recent a
friend asked me to help him get it up and running on a Windows Vista
system.
I was looking for the system configuration
Can you show the CREATE TABLE for your REF_SEQ table?
The explain output says using where which means that MySQL will have to
post-filter rows after the storage engine retrieves them. It also means the
query may benefit from different/better indexing.
On Mon, Jul 13, 2009 at 12:04 AM, TianJing
the REF_SEQ is defined below, the col DNA_SEQ is a string such as
ATGCGGTTA,
| REF_SEQ | CREATE TABLE `REF_SEQ` (
`SEQ_ID` int(11) NOT NULL auto_increment,
`REF_ID` int(11) NOT NULL,
`START_POSITION` int(11) NOT NULL,
`END_POSITION` int(11) NOT NULL,
`DNA_SEQ` text,
`DNA_QUALITY`
I see that index_ref_start is defined on Ref_Id and Start_Position. Mysql
only uses the left-most column of this index. Drop and re-add this key only
defined as
INDEX idx_ref_start(start_position)
and see if that helps.
Your explain you sent this time is not even using the index.
In your
sorry for my careless,the sql should be select * from REF_SEQ where REF_ID =
3 and START_POSITION between 3 and 803;
the explain output is :
mysql explain select * from REF_SEQ where REF_ID = 3 and START_POSITION
between 3 and 803;
-Original Message-
From: russbucket [mailto:russbuc...@nwi.net]
Sent: Friday, July 10, 2009 12:09 PM
To: mysql@lists.mysql.com
Subject: MySQL Windows version
I have been using the Linux version of MySQL for five years, also used
it on
a Windows ME system even though documents said you
It looks like MySQL is using both columns in the key for that query, since
the key_len is 8, but for some reason it says it is still using where.
What happens when you only select these fields: seq_id, ref_id,
start_position, end_position?
Does the query speed up? I had a table that had some
On July 13, 2009 12:03:49 pm Carlos Williams wrote:
If I am looking for a application that will connect to MySQL and allow
me to make database / table / user / permission modifications via a
graphical tool, is there something specific out there you guys
recommend? I have been doing everything
Yup. That was what I was looking for. Thanks!
On Mon, Jul 13, 2009 at 3:27 PM, Rayr...@stilltech.net wrote:
On July 13, 2009 12:03:49 pm Carlos Williams wrote:
If I am looking for a application that will connect to MySQL and allow
me to make database / table / user / permission modifications
Did you even look here:
http://dev.mysql.com/downloads/gui-tools/5.0.html
-Original Message-
From: Carlos Williams [mailto:carlosw...@gmail.com]
Sent: Monday, July 13, 2009 12:43 PM
To: Ray
Cc: mysql@lists.mysql.com
Subject: Re: MySQL GUI Tools
Yup. That was what I was looking
yes,it is more faster that i select every cols except the TEXT col,but
unfortunately i need the TEXT cols for next step.
2009/7/14 Johnny Withers joh...@pixelated.net
It looks like MySQL is using both columns in the key for that query, since
the key_len is 8, but for some reason it says it is
B J Ambrose wrote:
russbucket wrote:
I agree with you, but phpMyAdmin is not available for Windows that I'm
aware of. The person I'm helping today is a windows user and except for a
little Access Experience does not do databases well. I have the database
set up in mysql so thats what I am
1. Don't use SELECT *. Only grab the cols that you only need. Also
make sure you have an index on min_position and max_position. After
that if your query isn't faster please show us the output of running
EXPLAIN select * from table_name where start_postion between
min_postion and
max_postion .
thanks for reply,
i hava an index on the start_position,the min_postion and the max_postion is
constant value, the output of the query is:
explain select * from REF_SEQ where START_POSITION between 3 and
803;
You are still doing SELECT * . Do you really need to return all of the
columns in that table or just COL1, COL2, COL5 for example. Only grab
the columns you are actually going to use.
On Mon, Jul 13, 2009 at 12:23 AM, TianJingtianj...@genomics.org.cn wrote:
thanks for reply,
i hava an index on
sorry fo that, but i really need all cols in the table, i think the problem
maybe caused by one of the col which is text type, each record of this col
has 2000 characters. this makes the size of record more biger.
2009/7/13 Darryle Steplight dstepli...@gmail.com
You are still doing SELECT * .
Numeric indexing is a lot faster. You definitely shouldn't use text or
varchar types as column types for you min and max values. Do an ALTER
TABLE on any column only hold numeric values and switch them to int
or mediumint.
On Mon, Jul 13, 2009 at 12:36 AM, TianJingtianj...@genomics.org.cn
i do not use text for start_postion,i use int for it. the only col which
defined to text is characters such as ABTGDSDFSGFDG etc.
2009/7/13 Darryle Steplight dstepli...@gmail.com
Numeric indexing is a lot faster. You definitely shouldn't use text or
varchar types as column types for you min
Marcus Bointon wrote:
On 10 Jul 2009, at 17:18, mos wrote:
Is there a Windows application that works like
phpMyAdmin? I tried MySQLAdmin on my Linux system, but I could not
cut and
paste SQL Commands into the editor.
You could run php (and thus phpmyadmin) on windows - in contrast with
russbucket wrote:
I have been using the Linux version of MySQL for five years, also used it
on a Windows ME system even though documents said you couldn't. Recent a
friend asked me to help him get it up and running on a Windows Vista
system.
I was looking for the system configuration
russbucket wrote:
I agree with you, but phpMyAdmin is not available for Windows that I'm aware
of. The person I'm helping today is a windows user and except for a little
Access Experience does not do databases well. I have the database set up in
mysql so thats what I am hoping to get him
At 11:08 AM 7/10/2009, russbucket wrote:
I have been using the Linux version of MySQL for five years, also used it on
a Windows ME system even though documents said you couldn't. Recent a friend
asked me to help him get it up and running on a Windows Vista system.
I was looking for the system
On 10 Jul 2009, at 17:18, mos wrote:
Is there a Windows application that works like
phpMyAdmin? I tried MySQLAdmin on my Linux system, but I could not
cut and
paste SQL Commands into the editor.
You could run php (and thus phpmyadmin) on windows - in contrast with
earlier versions, 5.3
-Original Message-
From: russbucket [mailto:russbuc...@nwi.net]
Sent: Friday, July 10, 2009 11:09 AM
To: mysql@lists.mysql.com
Subject: MySQL Windows version
I have been using the Linux version of MySQL for five years, also used
it on
a Windows ME system even though documents
2009/7/3 xiaolongnvo xiaolong...@126.com:
mysql集群
有四个数据节点1 2 3 4,有大量的数据,前3000w条存在节点1中,以后的存在节点3上,1 2一组,3 4一组,能实现吧?怎么实现啊?
还有就是现在有三个表,想在节点1上存着表1 ,2的数据,节点三上存着表3的数据,怎么实现啊?
发这里要用英文啊。不然别人怎么看得懂哦。
Please use English.
Translation:
We have lots of data on four data node: 1, 2, 3, 4. The formerly 300
That's impossible to say with the limited information you've provided; however,
try this script for some basic tuning suggestions. It should make sure you're
not doing anything crazy:
https://launchpad.net/mysql-tuning-primer
Regards,
Gavin Towey
-Original Message-
From: fa so
If you do not want to use InnoDB at all, add this line to /etc/my.cnf under the
[mysqld] section
skip_innodb
Then do the following
service mysql stop
rm -f /var/lib/mysql/ibdata1 /var/lib/mysql/ib_logfile[01]
service mysql start
This will totally and cleanly disable InnoDB on the DB server
On Thu, Jun 04, 2009 at 01:27:34PM -0600, Timothy Smith wrote:
Dear MySQL users,
MySQL Community Server 5.1.35, a new version of the popular Open
Source Database Management System, has been released. MySQL 5.1.35 is
recommended for use on production systems.
For an overview of what's new
Hi
After further investigation it would appear that I needed to update the
mySQL ODBC connnecter to the latest version.
Thanks
Neil
On Wed, Jun 3, 2009 at 6:43 PM, Gavin Towey gto...@ffn.com wrote:
Niel,
I don't use ASP, but it sounds more like a syntax error in your script.
Niel,
I don't use ASP, but it sounds more like a syntax error in your script.
http://classicasp.aspfaq.com/general/how-do-i-prevent-invalid-use-of-null-errors.html
However, if you're still having problems, please give us the exact query you're
running, the table structure, and the Code snippet
Per Jessen wrote:
It happened agaIn this morning, but slightly different:
[snip]
thd=0x7fe0140c7e00
Attempting backtrace. You can use the following information to find
out where mysqld died. If you see no messages after this, something
went terribly wrong...
Cannot determine thread,
Per Jessen wrote:
I have just discovered that my mysql server was restarted this
morning, which is what gave me the 2013. In the log I found this:
[snip]
It happened agaIn this morning, but slightly different:
[snip]
thd=0x7fe0140c7e00
Attempting backtrace. You can use the following
Per Jessen wrote:
This weekend we completed migrating a large(ish) mysql server from
5.0.26 on 32bit to 5.0.51a on 64bit. Everything went relatively
smoothly, until this morning when I noticed an application had choked
on getting Error 2013 Lost connection to MySQL server during query.
I
Michael Dykman wrote:
It might be helpful if you could tell us how you affected your data
migration
Sorry, I'm not familiar with reporting problems in/on mysql.
The data migration was done with a full database dump (mysqldump) from
the 32bit system, then a reload on the new 64bit system.
just a thought: Did you run mysql_upgrade after the import?
On Mon, May 25, 2009 at 10:19 AM, Per Jessen p...@computer.org wrote:
Michael Dykman wrote:
It might be helpful if you could tell us how you affected your data
migration
Sorry, I'm not familiar with reporting problems in/on mysql.
Michael Steinfeld wrote:
just a thought: Did you run mysql_upgrade after the import?
No, I didn't - I didn't think of it as I really only moved the data
across.
best regards
Per Jessen, Zürich
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Per Jessen wrote:
Michael Steinfeld wrote:
just a thought: Did you run mysql_upgrade after the import?
No, I didn't - I didn't think of it as I really only moved the data
across.
Okay, have done a mysqlcheck --check-upgrade - came back all clean. I
don't see a need to run
Have you tried running the offending SQL manually against you new
installation? Does it come back clean in the isolated case? Is there
anything else which runs against this database at night? crons?
Could you post the script that you are running to give some context to
the statement which winds
On Mon, May 25, 2009 at 11:19 AM, Per Jessen p...@computer.org wrote:
Per Jessen wrote:
Michael Steinfeld wrote:
just a thought: Did you run mysql_upgrade after the import?
No, I didn't - I didn't think of it as I really only moved the data
across.
I suspect that will solve your issue.
Michael Dykman wrote:
Have you tried running the offending SQL manually against you new
installation? Does it come back clean in the isolated case?
No, not manually, but the job/the SQL is run several times a day, maybe
2-3 times per hour.
Is there anything else which runs against this
Per Jessen wrote:
Michael Dykman wrote:
Have you tried running the offending SQL manually against you new
installation? Does it come back clean in the isolated case?
No, not manually, but the job/the SQL is run several times a day,
maybe 2-3 times per hour.
I've also just run the query
Given the new hardware, I'm now suspecting the RAID controller. I have
seen misconfigured RAIDs or bad RAID drivers take out a server in just
such a manner. I had a debian server connected to an EMC SAN.. As
debian isn't supported, we had this open-source driver which gave us
no end of problems.
Michael Dykman wrote:
Given the new hardware, I'm now suspecting the RAID controller. I have
seen misconfigured RAIDs or bad RAID drivers take out a server in just
such a manner. I had a debian server connected to an EMC SAN.. As
debian isn't supported, we had this open-source driver which
The issues that we saw only came to light under stress. The
application I am referring to ran under a fair bit of load at the best
of times but it was during sustained spikes that the flaws in our
driver made themselves apparent.
Mind you, we weren't using JFS, so I'm not sure how that would
Hi Per,
Maybe you need to beef up your CONNECT_TIMEOUT setting in your .my.cnf
file. Are these queries appearing in your slow query logs?What is your
LOG_QUERY_TIMES set too?
Here are some other settings you may want to play around wtih
CONNECT_TIMEOUT
INTERACTIVE_TIMEOUT
WAIT_TIMEOUT
Darryle Steplight wrote:
Hi Per,
Maybe you need to beef up your CONNECT_TIMEOUT setting in your .my.cnf
file. Are these queries appearing in your slow query logs?What is your
LOG_QUERY_TIMES set too?
Here are some other settings you may want to play around wtih
CONNECT_TIMEOUT
I tried it on win32, it worked but the server failed under heavy load.
I'd suggest running mysql on a 64 bit Linux machine instead.
Jw
On Thursday, May 21, 2009, Krishna Chandra Prajapati
prajapat...@gmail.com wrote:
Hi,
How much performance improvement we can get using large_page_size in
.
-Original Message-
From: Daevid Vincent [mailto:dae...@daevid.com]
Sent: Wednesday, May 20, 2009 4:49 PM
To: mysql@lists.mysql.com
Cc: 'Gavin Towey'; 'Claudio Nanni'
Subject: RE: mySQL slave IO Running and SQL Running
Well, in 90% of our cases it is. Most often caused by some dumb-ass
(usually
Yeah Daevid! I know very well the issue!
first set the slave to READ ONLY
[mysqld]
read-only
then there is a configuration option to tell the server to skip some type of
errors automatically
slave-skip-errors=
problems.
-Original Message-
From: Claudio Nanni [mailto:claudio.na...@gmail.com]
Sent: Wednesday, May 20, 2009 12:49 PM
To: Daevid Vincent
Cc: mysql@lists.mysql.com
Subject: Re: mySQL slave IO Running and SQL Running
Yeah Daevid! I know very well the issue!
first set the slave to READ
To: Claudio Nanni; Daevid Vincent
Cc: mysql@lists.mysql.com
Subject: RE: mySQL slave IO Running and SQL Running
Please note that this is *NOT* a way to get them synched again
In fact if you have to skip a replication statement on the
slave then it is usually a sign your slave has different
Hi Niel,
What version is the mysql dump from? Are you importing to a different version?
Could you show the line from the file that is generating the error?
Regards,
Gavin Towey
-Original Message-
From: Neil Aggarwal [mailto:n...@jammconsulting.com]
Sent: Tuesday, May 19, 2009 6:56 AM
, (832)245-7314, www.JAMMConsulting.com
Eliminate junk email and reclaim your inbox.
Visit http://www.spammilter.com for details.
-Original Message-
From: Gavin Towey [mailto:gto...@ffn.com]
Sent: Tuesday, May 19, 2009 1:05 PM
To: Neil Aggarwal; mysql@lists.mysql.com
Subject: RE: mysql
pas n'importe
quel effet légalement obligatoire. Étant donné que les email peuvent facilement
être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité
pour le contenu fourni.
From: n...@jammconsulting.com
To: mysql@lists.mysql.com
Subject: RE: mysql not able to import
: Tuesday, May 19, 2009 2:37 PM
To: n...@jammconsulting.com; mysql@lists.mysql.com
Subject: RE: mysql not able to import mysqldump file
Neil-
http://wiki.seas.harvard.edu/geos-chem/index.php/Floating_poin
t_math_issues
so a value this large or small would only be true for 8byte
double
i tried this one
PURGE { BINARY | MASTER } LOGS
{ TO '*log_name*' | BEFORE *datetime_expr* }
but for some reason it didn't purge any bin file.. so i tried our expired...
on the my.cnf waited for a while and it was deleted...
is there a requirement to use purge i have 5.0.51a-0.rhel4
12, 2009 2:53 PM
To: edb...@edberg-online.com
Cc: Rilawich Ango; mysql@lists.mysql.com
Subject: Re: mysql-bin maintenance
i tried this one
PURGE { BINARY | MASTER } LOGS
{ TO '*log_name*' | BEFORE *datetime_expr* }
but for some reason it didn't purge any bin file.. so i tried our expired
Computer memory is not bit-addressable, how can you store a bit as an
independent data unit ?
Other than as part of a record, there are no C data types (which is
used to implement MySQL kernel) that can
process bit as a data type.
If i miss the context, please advise me back.
thanks
On Mon,
On Sun, May 10, 2009 at 10:12 PM, Moon's Father
yueliangdao0...@gmail.com wrote:
Hi.
MySQL only has one datatype called bit, but its smallest storage is one
byte.
How to save a bit on disk, but not a byte?
In some cases, CHAR(0) NULL can actually use one bit on disk. You
either store the
On Mon, May 11, 2009 6:41 pm, Rilawich Ango wrote:
Hi,
In the master database, there are plenty of mysql-bin.X. It
occupied almost all the disk space. As I know, the files should be removed
by issuing reset master. Below are my questions. -Do I need to stop
replication before issuing reset
Thanks for your sincerely reply.
On Mon, May 11, 2009 at 11:04 PM, Baron Schwartz ba...@xaprb.com wrote:
On Sun, May 10, 2009 at 10:12 PM, Moon's Father
yueliangdao0...@gmail.com wrote:
Hi.
MySQL only has one datatype called bit, but its smallest storage is one
byte.
How to save a
kengheng wrote:
Hi All, I've performed a upgrade from 4.1.22 to 5.0.81, the
mysql_upgrade performed well on all tables repairing, however, after
upgrade the same db from 5.0.81 to 5.1.33, a few tables got the error
as below:
Error: Unknown table engine 'InnoDB'
error: Corrupt
Any
A DB politics between mysql oracle again
Thats quite ironic given recent events :)
--
Linux web infrastructure consulting, cr...@codenation.net
Free live poker tournament listings, http://www.g5poker.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
You have 2 queries that are probably blocking everything. They are in
the update state.
| 30 | root | localhost | bsm | Query | 138 | update | insert into
upbcgww03
values(/var/tmp/zypp.067D9R/zypp-trusted-kr9rzhrO,trustdb.gpg,1200,b18a1a
| 30 | root | localhost | bsm | Query | 138 |
Dimitar,
Just looking over the server status, it looks
like you have a high rate of temp table to disk.
Created_tmp_disk_tables 5454
Created_tmp_files 1010
Created_tmp_tables 3
I would try increasing the max_heap_table_size.
Increasing the tmp_table_size alone wouldn't be
If you have the slow query log enabled, grab some
slow queries from there and run EXPLAIN.
From there, you can figure out how the optimizer is executing the query.
I found that approach to be very useful in
optimizing individual queries and making indexing decisions.
I can't quite make out
Hi Dan,
Yes, actually, I already know that parallel performance will be much
improved, however, I was expecting more improvement on single threads as
well, since the specs say that it takes 40 clock cycles just to access the
FPU on the T1, but something like 6 clock cycles on the T2. So just
In the last episode (Apr 22), Rod Heyd said:
I've been running mysql on a T1000 (Ultrasparc T1) system for several
years now, and while I've been happy with the performance overall, the
poor floating point capability on these systems has been a disappointment.
Recently, I got my hands on a
On Wed, Apr 22, 2009 at 1:27 PM, Dan Nelson dnel...@allantgroup.com wrote:
In the last episode (Apr 22), Rod Heyd said:
I've been running mysql on a T1000 (Ultrasparc T1) system for several
years now, and while I've been happy with the performance overall, the
poor floating point
At 03:49 PM 4/22/2009, you wrote:
On Wed, Apr 22, 2009 at 1:27 PM, Dan Nelson dnel...@allantgroup.com wrote:
In the last episode (Apr 22), Rod Heyd said:
I've been running mysql on a T1000 (Ultrasparc T1) system for several
years now, and while I've been happy with the performance overall,
AZZOPARDI Konrad wrote:
Hello people,
I do not know if this the right listI am migrating a very basic application from an older mysql version 4.1.9-standard to a new mysql version 5.0.45 {RedHat default package}. I have migrated DB data from one to the other and all data seems to be there
Konrad,
AZZOPARDI Konrad schrieb:
Hello people,
I do not know if this the right listI am migrating a very basic application from an older mysql version 4.1.9-standard to a new mysql version 5.0.45 {RedHat default package}. I have migrated DB data from one to the other and all data seems
Thanks for you reply.
I read the official document and found the variable called
thread_concurrency could only affect on solaris.
On Sat, Apr 11, 2009 at 5:04 AM, mos mo...@fastmail.fm wrote:
At 06:00 AM 4/10/2009, you wrote:
Hi.
If the server has 16 cores, how to set parameters to make
Innotop can satisfy you demand.
On Thu, Apr 16, 2009 at 4:36 PM, Hitesh Shah hrs...@gmail.com wrote:
Hello,
I'd like to know if there is a command line tool I can run to collect
vital health information for a remote mysql server (just like
mysqltop) for 5.0 - I often see mysql swapping to
You could try this:
http://www.consol.de/opensource/nagios/check-mysql-health
(in German but should be self-explanatory).
Cheers,
Andrew
-Original Message-
From: Gabriel - IP Guys [mailto:gabr...@impactteachers.com]
Sent: 15 April 2009 10:12
To: replicat...@lists.mysql.com
Cc:
I'd just write a perl script to do it and return the appropriate status
code/message to nagios. Shouldn't be hard at all. PhP or any language that
can talk to mysql would work, too. You just mentioned the position, you'll
have to compare the names of the binlog files as well: position 100 in
I would not compare binlog positions. I would use mk-heartbeat from
Maatkit. It tells the truth in a much simpler and more direct way.
Instead of checking things that indicate your data is being
replicated, just replicate some data and check the data itself.
--
MySQL General Mailing List
For
What kind of query do you use?
I think that MySQL is scalable in using best query on the multi-core ( or
SMP ) server.
It is same on InnoDB and MyISAM on over 4-cores.
Regards,
Genie Japo
-Original Message-
From: Moon's Father [mailto:yueliangdao0...@gmail.com]
Sent: Friday, April
901 - 1000 of 9139 matches
Mail list logo