Hi
I am using Mysql 4.1 on
CPU 2 Xeon 3.0 Ghz + 2 Virtual (Hyperthreads) (I think it is not using the 2nd
processor)
Memory 4GB
I think that the read from the HDD is 50mb per 1 sec, but I am not sure.
I have very big problem with performance, because there are very bad search
queries, but
One way to do this would be to issue a 'stop slave;' on the slave
you are taking a backup from just before the backup starts. Then
issue a 'show slave status\G' to get the master log file and
position. You can use this to setup the new slave properly.
ok, thanks, I was thinking it'd be a
Hi,
I am hoping someone here can help me. I have an Ubuntu 8.04 server that
has worked FINE for months. The other day, the client rebooted it. They
shut it down properly and then later started it up again. (The server
was not experiencing any problems when they did it, there were other
please follow my earlier suggestion and place
long_query_time=NumberOfSecs
min_examined_row_limit=MinNumberOfRowsToExamine
in my.cnf or my.ini
start mysqld --log-slow-queries[=file_name]
documentation available at
http://dev.mysql.com/doc/refman/5.1/en/slow-query-log.html
Shalom
Martin Gainty
At the risk of getting spanked for not finding this in the documentation,
I'm asking a simple question:
Can I tell when a table was created?
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX:
At 10:28 AM -0400 5/5/09, Jerry Schwartz wrote:
At the risk of getting spanked for not finding this in the documentation,
I'm asking a simple question:
Can I tell when a table was created?
Try
show table status
or
select table_name,create_time from information_schema.tables
Johnny Withers schrieb:
Well, I think an update after insert is the only way. Other than
perpopulating another table with possibe crc values then usinga join:
Select id from testtable
Inner join crctable on testtable.id=crctable.id
Where crctable.crcval='xxx'
Just be sure to index the
that is one weird opening statement
select * from information_schema.tables where
table_name='DATABASE_NAME.TABLENAME';
Martin
May the Schwartz be with you -- Spaceballs
__
Disclaimer and Confidentiality/Verzicht und Vertraulichkeitanmerkung/Note
I would have said to look at the creation date of the .frn file, but there
is also a field called create date in the show table status command and
the 2 dates often differ. Anyone know why they do?
On Tue, May 5, 2009 at 9:28 AM, Jerry Schwartz
jschwa...@the-infoshop.comwrote:
At the risk of
One way to do this would be to issue a 'stop slave;' on the slave
you are taking a backup from just before the backup starts. Then
issue a 'show slave status\G' to get the master log file and
position. You can use this to setup the new slave properly.
ok, thanks, I was thinking it'd be
The create date in show table status is metadata held in the table
itself wheras the create data on the .frm file is when that file was
created - i.e. if you copy the data files (without preserving
attributes) it will have a new creation date on the filesystem but the
metadata of the table will
One way to do this would be to issue a 'stop slave;' on the slave
you are taking a backup from just before the backup starts. Then
issue a 'show slave status\G' to get the master log file and
position. You can use this to setup the new slave properly.
ok, thanks, I was thinking it'd be
MAS! wrote:
btw, I have to get the Master_Log_File and Read_Master_Log_Pos or
Relay_Master_Log_File and Exec_Master_Log_Pos to start the new slave
correctly !?
If the Master_Log_File and Exec_Master_Log_Pos are not equivalent,
you'll want to note the Exec_Master_Log_Pos value as that is the
Are the values of these variables all accessible via the command: show
variables?
Josh Miller wrote:
MAS! wrote:
btw, I have to get the Master_Log_File and Read_Master_Log_Pos or
Relay_Master_Log_File and Exec_Master_Log_Pos to start the new slave
correctly !?
If the Master_Log_File and
Thanks, I knew it had to be something simple. Now I can clean out my save
this in case you make a mistake tables.
-Original Message-
From: Steve Edberg [mailto:sbedb...@ucdavis.edu]
Sent: Tuesday, May 05, 2009 11:00 AM
To: Jerry Schwartz; mysql@lists.mysql.com
Subject: Re: Creation date
Lawrence Sorrillo wrote:
Are the values of these variables all accessible via the command: show
variables?
If the Master_Log_File and Exec_Master_Log_Pos are not equivalent,
you'll want to note the Exec_Master_Log_Pos value as that is the value
which determines where in the binary logs
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
Tom Worster wrote:
On 5/5/09 4:42 PM, Richard S. Crawford rscrawf...@mossroot.com wrote:
On Tue, May 5, 2009 at 1:34 PM, PJ af.gour...@videotron.ca wrote:
I'm coming up with a bit of a quandry: how to enter and retrieve an
identical book title with different authors.
It is rather
Yes, Triggers... I so rarely use them I forget they exist.
On Tue, May 5, 2009 at 10:22 AM, Thomas Pundt mli...@rp-online.de wrote:
Johnny Withers schrieb:
Well, I think an update after insert is the only way. Other than
perpopulating another table with possibe crc values then usinga join:
20 matches
Mail list logo