RE: Howto reduce size of MYISAM files after deleting records?

the server. - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 ---Original Message- --From: Dan Greene [mailto:[EMAIL PROTECTED] --Sent: Tuesday, October 28, 2003 10:59 AM --To: Dathan Vance Pattishall; Iago Sineiro; MySql Mail

RE: problem with MySQL and latest release of Mac OX X (Panther)

Can you post you’re my.cnf options / your query in question / how long have you seen it hang / what status it is in / and your show status vars. - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 ---Original Message

RE: problem with MySQL and latest release of Mac OX X (Panther)

Could you look at you’re hostname.err file and see if it says checking table? Also try mysql -A sampdb - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 ---Original Message- --From: Anderson, James H [IT] [mailto

RE: reproducible error 17

Thanks for the information. I to found a work around-a much uglier approach. For all ALTERs of a src table to work when synonyms of tables are present: perform the ALTER on the slave itself and add to skip-slave-errors=1060 This is a quick work around. Very very ugly. - Dathan Vance Pattishall

RE: bind params and default values

a similar question to perlmonks under the title DBI --bind --params column defaults -- - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

RE: DB not restoring from dump file

--for a column name but I checked this option out and I do not. -- --Where did I go wrong? - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 Look at that line and make sure there is not a DOS character line in it. This is what I can think

RE: Conversion

--or --MySQL? Can't help you out here. - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

RE: DB not restoring from dump file

Try changing the keyname unique to email. SO: UNIQUE KEY email (email) ---Original Message- --From: Chris W. Parker [mailto:[EMAIL PROTECTED] --Sent: Monday, October 27, 2003 11:04 AM --To: [EMAIL PROTECTED] --Cc: [EMAIL PROTECTED] --Subject: RE: DB not restoring from dump file --

RE: illusive query

---Original Message- --From: Larry Brown [mailto:[EMAIL PROTECTED] --Sent: Monday, October 27, 2003 11:32 AM --To: MySQL List --Subject: illusive query -- --Earlier I was given help understanding the need for using a left join. --This --was a precursory query to arrive at my final

RE: bind params and default values

- Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 ---Original Message- --From: sean peters [mailto:[EMAIL PROTECTED] --Sent: Monday, October 27, 2003 11:54 AM --To: Dathan Vance Pattishall --Subject: Re: bind params

RE: My Company DB Wars

way to win with managers. - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 ---Original Message- --From: Randy Chrismon [mailto:[EMAIL PROTECTED] --Sent: Monday, October 27, 2003 11:51 AM --To: [EMAIL PROTECTED

RE: reproducible error 17

---Original Message- --From: Guilhem Bichot [mailto:[EMAIL PROTECTED] --Sent: Monday, October 27, 2003 10:55 AM --To: [EMAIL PROTECTED] --Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] --Subject: RE: reproducible error 17 -- --Hi, -- --Are the master and slave located on two

RE: DB not restoring from dump file

this reserve key / column / table name then it will see it as an error. Hope this makes sense. - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 ---Original Message- --From: Chris W. Parker [mailto:[EMAIL PROTECTED] --Sent

why can't innodb_log_file_size change

size of log files must be 4 GB on 32-bit computers. The default is 5M. It doesn't say anything about not being able to increase the size of the log file after its been set. Any work a rounds? - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http

RE: Help obtaining DBI binaries

www.cpan.org or www.rpmfind.net comes in a package. Most perl distributions have this installed by default. - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 ---Original Message- --From: Daniel [mailto:[EMAIL

RE: XML support for MySQL

There is a project that was started to do this though. Do a google search, on master thesis XML and MYSQL. Maybe they have some code that can be contributed or you can use for a private branch. In the mean time it's easy to generate XML on a simple DTD in side your code. - Dathan Vance

RE: Auditing MySQL (EAI)

I am working on a Veritas backup solution where the data can exist on a remote file system and the snapshot exist elsewhere. This could be used in theory to attain your goal, with some additional code. - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http

reproducible error 17

. Performing a slave stop slave start does not work. Restarting the mysql server on the slave is the only method I found to recover from the error. Version of mySQL: 4.0.15 Kernel: Linux ef242.friendfinderinc.com 2.4.18-4smp #1 SMP Sun Apr 14 13:50:35 PDT 2002 i686 unknown *PATCHED* - Dathan Vance

RE: reproducible error 17

/ff_recent/#sql-17f7_c.MYI' (Error 17)' on query 'ALTER TABLE recentmembers_20 add have_children tinyint unsigned not NULL default 0'. Default database: 'ff_recent' Skip_counter: 0 Exec_master_log_pos: 348632736 Relay_log_space: 390689457 - Dathan Vance Pattishall   - Sr. Programmer

RE: MERGE table limitations

OS/FileSystem INODE limitation. How many files can fit into a directory? 64K on Redhat if you modify file-max - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 ---Original Message- --From: [EMAIL PROTECTED] [mailto

RE: Improving Query speed - any suggestions?

have to run it by hand to determine what the purpose of this query is. Then see if it can be rewritten. - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 ---Original Message- --From: Matt Babineau [mailto:[EMAIL PROTECTED

RE: Multithreaded?

On red hat systems threads show up in a normal processlist. Thoese are threads that your seeing, some for connections others to do some innodb tasks and/or replication. - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688

RE: Anyone using MySQL 4.x on Apple's G5?

Wouldn't code need to be added for mySQL to take advantage of memory mapping in a 64 bit system? I was under the impression that mysql in its current form has specific code to emulate the behavior thus the problem of memory mapping at high levels. - Dathan Vance Pattishall   - Sr. Programmer

RE: Fulltext vs Pattern Matching?

- Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 ---Original Message- --From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] --Sent: Wednesday, October 15, 2003 8:09 AM --To: [EMAIL PROTECTED] --Subject: Fulltext vs

RE: 4.0.15 skip-external-locking

---Original Message- --From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] --Sent: Wednesday, October 15, 2003 12:16 PM --To: Dathan Vance Pattishall --Cc: [EMAIL PROTECTED] --Subject: Re: 4.0.15 skip-external-locking -- --On Tue, Oct 14, 2003 at 10:49:16AM -0700, Dathan Vance Pattishall

4.0.15 skip-external-locking

, altered etc. - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688

RE: Connection Time Out

Look at your wait_timeout and interactive_timeout settings. They may be set to a low value. If your connection sleeps for these 2 vars mysql will disconnect you. - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688

thread_concurrency

threads, but the statement above seems to indicate that this is a Solaris specific option. Sthreads Pthreads Are a bit different, how does this option behave on Linux? Is concurrency dependent upon an execution state? - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc

RE: insert failure, move on question

# if using perl and DBI pseudo code die $ERROR if ($dbh-errstr() $dbh-errstr() !~ /Duplicate Error/); If $dbh-errstr() =~ /Duplicate Error/ do your specified logic Else Return inserted id - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http

RE: What do you recommend: MyISAM or INNODB?

- Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 ---Original Message- --From: Holly Chamberlain [mailto:[EMAIL PROTECTED] --Sent: Friday, October 10, 2003 11:01 AM --To: [EMAIL PROTECTED] --Subject: What do you

RE: Cannot start MySQL (errno 13)

Are you using symlinks? - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 ---Original Message- --From: Carol Andrejak [mailto:[EMAIL PROTECTED] --Sent: Friday, October 10, 2003 1:04 PM --To: mysql --Subject: Cannot

RE: Adding space to /var/lib/mysql

symlink - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688-- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Error Cant get stat

/usr/local/mysql/bin/perror 13 Error code 13: Permission denied Check your file permissions. - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 ---Original Message- --From: Randy Chrismon [mailto:[EMAIL PROTECTED

I've notice when running mysql interruptible sleep occurs

) are used to purposely produce a process / thread to force it into interruptible sleep? - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688

RE: Which is the best MySQL book?

MySQL the definitive guide to using, programming, and administering mySQL, version 2 by Paul Dubois, who is active on this list. - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 ---Original Message- --From: Anderson

RE: MySQL and Php

Goto www.devshed.com some nice resources there, from introductions to advance topics. - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 ---Original Message- --From: Casper Matthee [mailto:[EMAIL PROTECTED] --Sent

RE: web interface...

database to a web page? Depends which language your using. Perl, C++, Java, PHP, etc. all do it differently. -- --Thanks -- - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 -- MySQL General Mailing List For list archives

RE: web interface...

below ?php mysql_connect() ? h2 I connected /h2 ?php # do something else ? h2 More html /h2 Check out www.php.net and PHP for programmers by WOX publishing. This will help you out allot. - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http

RE: Help With a DATETIME Query PLEASE!

I'm under the impression that your over thinking the problem. LOOK-UP the functions DATE_SUB / INTERVAL / TIME_TO_SEC / TO_DAYS and the arithmetic should be easy. - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688

4.0.15 FULLTEXT INDEX

particular query. The second granularity that show full processlist displays did not indicate which query was the problem. If mysql.com is interested in this issue, I can send a copy the table format etc. In the meantime I have to drop the FULL TEXT INDEX. - Dathan Vance Pattishall - Sr

RE: Replication

---Original Message- --From: Luc Foisy [mailto:[EMAIL PROTECTED] --Sent: Friday, October 03, 2003 8:45 AM --To: MYSQL-List (E-mail) --Subject: Replication -- -- --If I have replication already active for a single database ( already --active between master and slave ) and I want to start

RE: changing TMPDIR for tempory file location

In my.cnf its called tmpdir change that location tmpdir=where you want tmp to be - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 ---Original Message- --From: dan orlic [mailto:[EMAIL PROTECTED] --Sent: Friday

RE: Multiple-Column Unique Index Redundancy

- Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 ---Original Message- --From: John Kornet [mailto:[EMAIL PROTECTED] --Sent: Friday, October 03, 2003 3:06 PM --To: [EMAIL PROTECTED] --Subject: Multiple-Column Unique

What are the effects of key_buffer on a dedicated slave

boost. In fact raising sort_buffer, read_buffer, read_rnd_buffer would be more of a win to reduce lock times so committal of the data happens faster. Is this observation wrong? Does raising key_buffer on a slave to around 50% of the memory available make a difference? - Dathan Vance

RE: What are the effects of key_buffer on a dedicated slave

---Original Message- --From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] --Sent: Tuesday, September 30, 2003 10:23 AM --To: Dathan Vance Pattishall --Cc: [EMAIL PROTECTED] --Subject: Re: What are the effects of key_buffer on a dedicated slave -- --That depends, of course. If your

RE: What are the effects of key_buffer on a dedicated slave [also]

---Original Message- --From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] --Sent: Tuesday, September 30, 2003 10:23 AM --To: Dathan Vance Pattishall --Cc: [EMAIL PROTECTED] --Subject: Re: What are the effects of key_buffer on a dedicated slave --Is that all your slave is doing

RE: What are the effects of key_buffer on a dedicated slave [also]

---Original Message- --From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] --Sent: Tuesday, September 30, 2003 11:24 AM --To: Dathan Vance Pattishall --Cc: [EMAIL PROTECTED] --Subject: Re: What are the effects of key_buffer on a dedicated slave --[also] -- --On Tue, Sep 30, 2003 at 11:07:59AM

RE: What are the effects of key_buffer on a dedicated slave

---Original Message- --From: Dan Nelson [mailto:[EMAIL PROTECTED] --Sent: Tuesday, September 30, 2003 11:35 AM --To: Dathan Vance Pattishall --Cc: [EMAIL PROTECTED] --Subject: Re: What are the effects of key_buffer on a dedicated slave -- --A better question to ask might be what is my

RE: What are the effects of key_buffer on a dedicated slave [also]

---Original Message- --From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] --Sent: Tuesday, September 30, 2003 11:51 AM --To: Dathan Vance Pattishall --Cc: [EMAIL PROTECTED] --Subject: Re: What are the effects of key_buffer on a dedicated slave --[also] -- --On Tue, Sep 30, 2003 at 11:36:30AM

RE: Key_buffer_size

The mysql database he is referring to is /var/lib/mysql/mysql where it holds the access rights for users, tables, columns, etc. That HAS to be MYISAM. - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 ---Original

RE: Question about the bin-log index

. Also lookup backlog to see how to automate this. -- -- --Robert Hamel - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

RE: replication setting

=filename To specify the location and name that should be used for the relay logs index file - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 ---Original Message- --From: Hsiu-Hui Tseng [mailto:[EMAIL PROTECTED

RE: mysqld error

---Original Message- --From: Joseph Donato [mailto:[EMAIL PROTECTED] --Sent: Thursday, September 25, 2003 12:12 PM --To: [EMAIL PROTECTED] --Subject: mysqld error -- --Folks, -- --When I try to start MySQL the mysqld just crashes. I looked at --/usr/lib/mysql/{hostname}.err file and I

RE: mySQL is slow with TCP/IP !!!

Use Linux! This is the solution. If you have to use windows will need to tweak your TCP settings Here is a tool that can help you. http://www.dslreports.com/front/drtcp.html - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go

RE: mySQL is slow with TCP/IP !!!

the Windows NT TCP stack settings by using the same tool on it. - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 ---Original Message- --From: Mojtaba Faridzad [mailto:[EMAIL PROTECTED] --Sent: Wednesday, September 24, 2003 2

RE: Mysqlhotcopy and incorrect database name error - We must be dense

/identity' --user=root --password=secretpassword \ db_1./^nice_table/ [EMAIL PROTECTED]:~/path/to/new_directory - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 ---Original Message- --From: Gilmore, Jason

RE: Mysqlhotcopy and incorrect database name error - We must be dense

I mean look at the --suffix - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 ---Original Message- --From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED] --Sent: Monday, September 22, 2003 1:26 PM --To: 'Gilmore

RE: load data

Copy the db from the master to the slave. - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 ---Original Message- --From: Aris Santillan [mailto:[EMAIL PROTECTED] --Sent: Friday, September 19, 2003 3:10 AM --To: [EMAIL

RE: Do I use Except?

Look up Left JOIN. This join will solve your problem. - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 ---Original Message- --From: Matt MacLeod [mailto:[EMAIL PROTECTED] --Sent: Friday, September 19, 2003 8:38 AM

RE: explain

No that says that it can figure out the where and prob wont use a key. The like is probably the cause. If it was going to use the primary key then the FIELD Key_used (something like that) would say PRIMARY. - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http

RE: MySQL/Cron problem

pool. - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 ---Original Message- --From: Jason Linden [mailto:[EMAIL PROTECTED] --Sent: Thursday, September 18, 2003 10:24 AM --To: [EMAIL PROTECTED] --Subject: RE: MySQL

I asked a question about slave compatibility between versions

Master 3.23.33 and up 4.0.0 4.0.1 4.0.3 and up Slave 3.23.33 and up yes no no no Slave 4.0.0 no yes no no Slave 4.0.1 yes no yes no Slave 4.0.3 and up yes no no yes - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http

add this to a wish list please.

has been encountered? And if anyone can let me know why these errors occur even when the table has been repaired within a month and the server has not ever been forced down that would help a DBA OUT! - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http

RE: Lock tables in myisam

- Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 ---Original Message- --From: electroteque [mailto:[EMAIL PROTECTED] --Sent: Wednesday, September 17, 2003 6:38 PM --To: [EMAIL PROTECTED] --Subject: Re: Lock

lost rows during repair. best method to get back those rows.

indicate a block position can and can I start the diff from there? - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688

Would it be worthwhile to have a tool that can alter a table when a db is offline

exist. - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688

RE: MySQL/Cron problem

LinuxThreads look like processes in a process list. There is only one mysqld instance and 11 connections to it. - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 ---Original Message- --From: Jason Linden [mailto

RE: what are some good options for reiserfs and mysql

Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 ---Original Message- --From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] --Sent: Wednesday, September 17, 2003 1:20 PM --To: Dathan Vance Pattishall --Cc: [EMAIL PROTECTED] --Subject: Re

RE: Mysql 4, Solaris 9 and Perl 5.8

and get it there. - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 ---Original Message- --From: Malka Cymbalista [mailto:[EMAIL PROTECTED] --Sent: Tuesday, September 16, 2003 3:16 AM --To: [EMAIL PROTECTED] --Subject

Replication question

message, and saw no solutions to this problem. Any suggestions? - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688

RE: SELECT only unique records

'; -- -- -- - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Querys Dropped/Connections Lost

Can you send you’re my.cnf options in /etc? You might have wait-timeout set. - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 ---Original Message- --From: Daniel Baughman [mailto:[EMAIL PROTECTED] --Sent: Friday

ERROR 1030: Got error 127 from table handler

/usr/local/mysql/bin/perror 127 Error code 127: Unknown error 127 127 = Record-file is crashed I've been getting this allot lately from mysql-3.23.54-57. Things that are not the cause: - mySQL has not been improperly shut down - threads are not being killed off Pattern emerged: High

RE: ERROR 1030: Got error 127 from table handler

FilesystemSize Used Avail Use% Mounted on /dev/sda5 97G 9.0G 82G 10% Plenty of disk space. ---Original Message- --From: Tom Roos [mailto:[EMAIL PROTECTED] --Sent: Wednesday, September 10, 2003 10:23 AM --To: Dathan Vance Pattishall; [EMAIL PROTECTED

RE: ERROR 1030: Got error 127 from table handler

-variable = wait_timeout=10 This is a RAID-5 with 128MB ICP Raid Card with 4GB of memory ---Original Message- --From: Richard Gabriel [mailto:[EMAIL PROTECTED] --Sent: Wednesday, September 10, 2003 10:32 AM --To: Dathan Vance Pattishall; [EMAIL PROTECTED] --Subject: Re: ERROR 1030: Got

RE: ERROR 1030: Got error 127 from table handler

AM --To: Dathan Vance Pattishall --Cc: [EMAIL PROTECTED] --Subject: Re: ERROR 1030: Got error 127 from table handler -- --On Wed, Sep 10, 2003 at 10:11:15AM -0700, Dathan Vance Pattishall wrote: -- -- /usr/local/mysql/bin/perror 127 -- Error code 127: Unknown error 127 -- 127 = Record-file

RE: How identify long running query etc?

mysqladmin proc mysqladmin kill ${Id} // The id that is causing the problem ---Original Message- --From: Bill Todd [mailto:[EMAIL PROTECTED] --Sent: Wednesday, September 10, 2003 11:51 AM --To: MySQL List (E-mail) --Subject: How identify long running query etc? -- --Using MySQL and

RE: Mysql bug

Not a bug look /etc/my.cnf Your default sock file might be in /tmp and the client is configure to look at /var/lib/mysql ---Original Message- --From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] --Sent: Tuesday, September 09, 2003 2:08 PM --To: [EMAIL PROTECTED] --Subject: Mysql bug --

record_rnd_buffer_size

http://www.mysql.com/doc/en/SHOW_VARIABLES.html states that record_rnd_buffer_size When reading rows in sorted order after a sort, the rows are read through this buffer to avoid a disk seeks. Can improve ORDER BY by a lot if set to a high value. As this is a thread-specific variable, one should

RE: Select from one table where ID not in another table

Use LEFT JOIN SELECT t1.*, t2.id FROM table1 as t1 LEFT JOIN table2 as t2 ON t1.id=t2.id WHERE t2 IS NULL; -- something like that -- ---Original Message- --From: Martin Moss [mailto:[EMAIL PROTECTED] --Sent: Tuesday, September 02, 2003 1:50 PM --To: [EMAIL PROTECTED] --Subject: Select

RE: It is secure to access MySQL thru internet?

I think your thinking of SSL. There is some work for mySQL that allows a sol connection and even some work to sol the replication over the net. Look for SSL on mysql.com ---Original Message- --From: Fortuno, Adam [mailto:[EMAIL PROTECTED] --Sent: Friday, August 29, 2003 12:59 PM --To:

RE: It is secure to access MySQL thru internet?

That seems like a lot of work to do when mysql has it built in. http://www.mysql.com/doc/en/Secure_basics.html 4.3.9.1 Basics Beginning with version 4.0.0, MySQL has support for SSL encrypted connections. To understand how MySQL uses SSL, it's necessary to explain some basic SSL and X509

RE: database from win to lin

Yes it will work, and it has been done before. Copy the *.MY* files and the *.frm files to the linux server. ---Original Message- --From: Dan J. Rychlik [mailto:[EMAIL PROTECTED] --Sent: Wednesday, August 27, 2003 11:31 AM --To: [EMAIL PROTECTED] --Subject: database from win to lin --

RE: How to Display Column heading after every 15 records display

I'm not sure what your request is. My gut instinct is to suggest for you to write some code (PERL / etc). Headers what headers, headers from the mysql client? ---Original Message- --From: sjonnalagadda [mailto:[EMAIL PROTECTED] --Sent: Friday, August 22, 2003 9:00 AM --To: [EMAIL

RE: Doing Differential backup

Veritas might be a good solution. I'm trying to find out if a mounted Veritas file system that stores only the snapshots while the data resides locally is possible. If so then backing up the data could happen every 5 min if necessary in my environment. Does anyone know if the Veritas software

RE: Master-Slave Replication

Type show slave status to figure out what the problem is on the slave. Type show full processlist on the master to see if the slave is connected waiting for binlog updates. Make sure the master is replicating.. Etc. ---Original Message- --From: Sanya Shaik [mailto:[EMAIL PROTECTED]

RE: Mast-Master Replication

I think you also want what ever the standby master gets a write /*assuming that the primary master where to go down or some other reason*/ the submaster needs to replicate that insert so In /etc/my.cnf Use log-bin server-id=different int then the master log-slave-updates replicate-* = replicate

Grown defects in a RAID array

I've notice that when grown defects (bad blocks on the disk caused by usage over time) that my dedicated mysql server is adversely effected. Since the action of Grown defects does not flush the table with a write lock-that the block marked as bad will effect prior to that block becoming a grown

RE: Mast-Master Replication

You can do it if you can handle primary key violations and don't have auto_increment columns in your tables. Race conditions can occur. ---Original Message- --From: Sanya Shaik [mailto:[EMAIL PROTECTED] --Sent: Wednesday, August 20, 2003 6:11 AM --To: [EMAIL PROTECTED] --Subject: Re:

RE: Replication question

Should be fine as long as the column on C has a default and is not a unique index. ---Original Message- --From: Jeff McKeon [mailto:[EMAIL PROTECTED] --Sent: Wednesday, August 20, 2003 6:05 AM --To: MySql --Subject: RE: Replication question -- --Nobody has any advice for this one? --

RE: moving MySQL

If you can't turn off your db use mysql_hotcopy and copy the data over NFS ---Original Message- --From: Brian Reichert [mailto:[EMAIL PROTECTED] --Sent: Wednesday, August 20, 2003 2:24 PM --To: Jon Miller --Cc: [EMAIL PROTECTED] --Subject: Re: moving MySQL -- --On Wed, Aug 20, 2003 at

RE: Problem to use mysql

There is actually a C++ mysql list that might be able to help you better then this one. ---Original Message- --From: Z. S.Ghand [mailto:[EMAIL PROTECTED] --Sent: Monday, August 18, 2003 9:49 AM --To: [EMAIL PROTECTED] --Subject: Problem to use mysql -- --Hi All; --I have written a small

RE: Table locking...

---Original Message- --From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] --Sent: Monday, August 18, 2003 10:42 AM --To: [EMAIL PROTECTED] --Subject: Table locking... -- --Hello, -- --I just have a question about the table locking in 3.23.56. If I am --inserting a --row into a table that

RE: Replication Problem

You can use an option in my.cnf slave-skip-error=list error nums separated by ,. The error below means that the master had a shutdown event and the slave can't tell if it added / deleted / changed that row or not. I wouldn't advise in skipping this error less you want your data to be

RE: Bi-directional Replication

mySQL can do that but will break on primary key violations. Also mySQL a slave can only have one master. Try log-slave-updates in my.cnf on the slave so A - B - A or you can have a replication ring A- B - C - A Make sure your server-id is unique among all master / slaves. ---Original

RE: Bi-directional Replication

---Original Message- --From: Mark T. Dame [mailto:[EMAIL PROTECTED] --Sent: Friday, August 15, 2003 1:38 PM --To: MySQL Mailing List --Subject: Re: Bi-directional Replication -- --On 08/15/03 16:01, Andreas wrote: -- -- I did this some time ago. -- -- Host A and B -- You just configure

replication and internals

Replicating queries where re-written to fix various bugs, most notably time and auto-increment bugs. Why doesn't replication also enforce rewriting INSERT INTO into INSERT DELAYED / etc. I've notice that the replicating thread in 3.23.5x will wait for a table instead of going onto another log

what are some good options for reiserfs and mysql

I want to get the most out of my Dedicated Red-Hat Linux 6 drive (3 RAID-1 / 3 RAID-10 ) mysql servers using Reiser-fs. Currently I have this in my fstab /dev/sda6 /var/lib/mysql reiserfsdefaults 1 2 I would like to turn off/on some options to get the most out of my

RE: MySQL Replication

Ack bad English in the 1st sentence I meant a slave server cannot have more then one master unless more then one mysqld processes is running on different ports i.e. port 3306 and port 3307. ---Original Message- --From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED] --Sent: Thursday

symlinking tables to a new db

What would be the draw backs of symlinking tables from say /var/lib/mysql/DB_A to /var/lib/mysql/DB_B since for a period of time of moving tables out of one directory (database) to another directory (database) the tables need to exist in both dbs until the migration is complete. Will this

<    1   2   3   >