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 ev
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
reason
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: 860.67
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 crcva
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
wrote:
> At the risk of getting spanked for not
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 not
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
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 you
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 enoug
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 w
Tom Worster wrote:
> On 5/5/09 4:42 PM, "Richard S. Crawford" wrote:
>
>
>> On Tue, May 5, 2009 at 1:34 PM, PJ 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 unbelievable what contortions
Yes, Triggers... I so rarely use them I forget they exist.
On Tue, May 5, 2009 at 10:22 AM, Thomas Pundt 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:
>>
>> Select id
Thank you very much for all answers
I will trying Triggers and the example with the update after an INSERT.
Ant then, I use the best for me;-)
Thunder
Yes, Triggers... I so rarely use them I forget they exist.
On Tue, May 5, 2009 at 10:22 AM, Thomas Pundt wrote:
Johnny Withers schr
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 ideas?
THnaks.
--
22 matches
Mail list logo
