I have 400 AMD 64 box 60 of which have 8 GB of data use for databases. Each
server does about 5K qps and many of our clusters do > 30K qps. We use Suse
Enterprise Linux 8. I've done numerous benchmarks to know that AMD Operton
is a better platform over XEONS period.
DVP
----
Dath
Fix your mysql privileges
http://dev.mysql.com/doc/mysql/en/GRANT.html
DVP
Dathan Vance Pattishall http://www.friendster.com
> -Original Message-
> From: Hossain, Ashfaq (Ashfaq) [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, December 01, 2004 8:39 AM
> To: [EMA
Create a myISAM table and put the table on a RAM DISK. It will support
everything that heap does and more, like ranges (< 4.1 only allows Hash
lookups).
CREATE TABLE (
..
) INDEX DIRECTORY = /dev/shm DATA DIRECTORY = /dev/shm
DVP
----
Dathan Vance Pattishall h
ur tables are not index properly, your doing a lot of table scans.
Your biggest perf. Gain will come from changing your schema and or
optimizing your queries.
DVP
----
Dathan Vance Pattishall http://www.friendster.com
> -Original Message-
> From: Shaun [mailto:[EMAIL PROT
perror 13
System error: 13 = Permission denied
The mysql user cannot read the /root filesystem.
DVP
Dathan Vance Pattishall http://www.friendster.com
> -Original Message-
> From: Gail Lange [mailto:[EMAIL PROTECTED]
> Sent: Thursday, November 18, 2004 10:23 AM
>
original size.
The data will grow as large as the filesystem will allow it since the data
is autoextended.
Innodb datafiles contain the index and the data in one file for 4.0.x. This
means that data will be the size of the columns + the indexes + some padding
per row.
DVP
Dathan Vance
table scan is faster and will not use the index.
To improve throughput:
Put the 60K ints into a temporary table. Next join against this temporary
table. This join forces the optimizer to translate the range into an
eq_ref-one of the fastest type joins.
DVP
Dathan Vance Pattishall
3306
DVP
Dathan Vance Pattishall http://www.friendster.com
> -Original Message-
> From: A. Clausen [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 17, 2004 1:21 PM
> To: MySQL Mailing List
> Subject: MySQL Behind Firewall
>
> We are running MySQL 3
Has anyone does any benchmarks with mysql, AMD and gcc 3.4? Gcc 3.4 is
suppose to support AMD specific instructions giving a boost in performance.
DVP
Dathan Vance Pattishall http://www.friendster.com
You need to reinstall your mysql api library to talk to mysql-4.1.7: 4.1.7
has a different auth implementation that is more secure then the 3.23 mysql
protocol which your using. I suggest you link against the C-api that comes
with 4.1.7.
DVP
Dathan Vance Pattishall http
Strace the thread to see what it's cycling on. Sending a HUP signal should
shut it down.
Since max is a dynamic binary ie not statically built you might have some
weird operation with your environment.
DVP
Dathan Vance Pattishall http://www.friendster.com
> -Original
Are you linking against an old library binary?
DVP
Dathan Vance Pattishall http://www.friendster.com
> -Original Message-
> From: V. M. Brasseur [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 03, 2004 10:19 AM
> To: MySQL Listserv
> Subject: Undefined sy
DVP
Dathan Vance Pattishall http://www.friendster.com
> -Original Message-
> From: ian douglas [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 02, 2004 9:30 AM
> To: [EMAIL PROTECTED]
> Subject: Replication basics
>
> Hi everyone,
>
> I&
No it's not a bug. Look up the DBI documentation and change the mysql_sock=
location in your code OR in /etc/my.cnf define the mysqld.sock file to be
stored in /tmp.
DVP
Dathan Vance Pattishall http://www.friendster.com
> -Original Message-
> From: Caron, Christ
DVP
Dathan Vance Pattishall http://www.friendster.com
> -Original Message-
>
> So, is there a faster way to insert/index the data? Would a different
> table or
> index type improve performace?
Use Load data from infile .. IGNORE ... u might get a bett
No look at Relay_Master_Log_File and Exec_master_log_pos for the position of
that master log file. The Master_Log_File indicates what position the IO
thread is on.
DVP
Dathan Vance Pattishall http://www.friendster.com
> -Original Message-
> From: Marvin Wright [mailto:
.
This would be optimal since the index remains in memory. Increase your
tmp_table_size to 64 MB your prob going to tmp_table and mysql uses this
buffer for some internal optimizations. Also try increasing range alloc
block size a little bit, you might see a 5% perf boost.
DVP
Dathan Vance
we do more then 1 billion queries
per day on less servers then Live Journal (source from mySQL conference). If
I get permission from my bosses to release the benchmarks I will send it to
the list.
DVP
Dathan Vance Pattishall http://www.friendster.com
> -Original Message-
>
That might be a word defined in the stopword file, excluding full text
lookup on.
Stop words are words like
The
As
In
If
And so on.
DVP
Dathan Vance Pattishall http://www.friendster.com
> -Original Message-
> From: joe mcguckin [mailto:[EMAIL PROTECTED]
> Sent
Vance Pattishall http://www.friendster.com
> -Original Message-
> From: Emmett Bishop [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 13, 2004 8:25 AM
> To: [EMAIL PROTECTED]
> Subject: Error 2013
>
> Howdy all,
>
> I got this error while running a rou
see what queries are taking a long time to
execute and are covering many rows-look for table scans.
DVP
Dathan Vance Pattishall http://www.friendster.com
> -Original Message-
> From: Tucker, Gabriel [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 13, 2004 9:35 AM
&g
passed to it, mysql will crash because it just hit the
2 GB limit.
Does this explain your issue, no not necessarily but it's good to add and
might explain some weird experiences.
DVP
----
Dathan Vance Pattishall http://www.friendster.com
> -Original Message-
> From:
DVP
Dathan Vance Pattishall http://www.friendster.com
> -Original Message-
> From: sean c peters [mailto:[EMAIL PROTECTED]
> Sent: Monday, August 09, 2004 1:43 PM
> To: [EMAIL PROTECTED]
> Subject: mysqld_multi & different server versions
>
> So am i
INSERT INTO Suggestion SELECT partnumber,qty from Sales Limit 1,100;
DVP
Dathan Vance Pattishall http://www.friendster.com
> -Original Message-
> From: C.F. Scheidecker Antunes [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 29, 2004 2:01 PM
> To: [EMAIL PROTECTE
are
buggy. Use SUSE 2.4 or RedHat 7.3 2.4.23aa_vm
DVP
Dathan Vance Pattishall http://www.friendster.com
> -Original Message-
> From: Batara Kesuma [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 27, 2004 9:39 PM
> To: [EMAIL PROTECTED]
> Subject: Kernel 2.4 and 2
due to our AMD solution and
some mySQL optimizations Friendster is FAST.
DVP
----
Dathan Vance Pattishall http://www.friendster.com
> -Original Message-
> From: Miles Keaton [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 27, 2004 1:48 PM
> To: [EMAIL PROTECTED]
> Subject:
> -Original Message-
> From: Free Grafton - CCB [mailto:[EMAIL PROTECTED]
> Sent: Monday, May 24, 2004 11:29 AM
> To: [EMAIL PROTECTED]
> Subject: Dual Master Configuration
>
> Can someone show me how a configuration file (my.cnf) would look to
> have dual MySQL masters.
Its more the
s not defined as a primary key, so running analyze table will get things
into perspective.
DVP
Dathan Vance Pattishall http://www.friendster.com
> -Original Message-
> From: Eamon Daly [mailto:[EMAIL PROTECTED]
> Sent: Monday, May 17, 2004 7:32 AM
> To: [EMAIL PRO
SHOW TABLE STATUS to get the count of each table, then your application adds
the number in the Rows field from each of the tables returned.
DVP
Dathan Vance Pattishall http://www.friendster.com
> -Original Message-
> From: Gustavo Andrade [mailto:[EMAIL PROTECTED]
R u sure your printing out the correct array (hash) field? Did you connect
to the db? Is mysql_error reporting an error?
DVP
Dathan Vance Pattishall http://www.friendster.com
> -Original Message-
> From: news [mailto:[EMAIL PROTECTED] On Behalf Of T. H. Grejc
> Sen
> -Original Message-
> From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 13, 2004 4:03 PM
> To: Dathan Vance Pattishall
> Cc: 'Tim Cutts'; 'MySQL List'
> Subject: Re: InnoDB filesystem
>
> On Thu, May 13, 2004 at 04:
> -Original Message-
> From: Tim Cutts [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 13, 2004 7:11 AM
> To: MySQL List
> Subject: Re: InnoDB filesystem
>
>
> On 13 May 2004, at 3:34 pm, Dan Nelson wrote:
>
> >>> Pros: performance and bypassing the filesystem cache.
> MySQL can't use
> -Original Message-
> From: Lou Olsten [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 13, 2004 6:45 AM
> To: [EMAIL PROTECTED]
> Subject: InnoDB Questions
>
> Need someone with some insight or experience with InnoDB (Heikki?? :-)
>
> a) Where does InnoDB store all of this information
> -Original Message-
> From: news [mailto:[EMAIL PROTECTED] On Behalf Of Jon Drukman
> Sent: Thursday, May 13, 2004 3:21 PM
> To: [EMAIL PROTECTED]
> Subject: avoiding "Locked" threads
>
> I've got a very high traffic discussion forum database that is
> constantly running into a problem
Look at some of the features of 4.1.1
http://dev.mysql.com/doc/mysql/en/Spatial_extensions_in_MySQL.html
> -Original Message-
> From: Douglas Phillipson [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, May 12, 2004 1:41 PM
> To: [EMAIL PROTECTED]
> Subject: ESRI GIS products support lacking
Off of the top of my head you can basically do a combination of all letters
in big or (use IN) list. It should be pretty fast. I'm personally leaning to
using REGEXP in mySQL yet, that would match the letters in a string and not
exclude others, unless explicitly told to. Using a REGEXP is slow.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, May 11, 2004 7:42 AM
> To: Dathan Vance Pattishall
> Subject: RE: my.cnf setup
>
> Thanks for the feedback!
>
> I have made the changes you suggested. I do have a ques
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Monday, May 10, 2004 2:23 PM
> To: [EMAIL PROTECTED]
> Subject: my.cnf setup
>
> I am running a mysql server off a Dell 2650.
> Dual 2.8Ghz Intel Xeon processors
> 1 Gig of RAM
>
> The MySQL data comes up r
Check to see if beyond is in your stopword file.
> -Original Message-
> From: Richard Baskett [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 06, 2004 2:12 PM
> To: MySQL
> Subject: Fulltext searching
>
> Ok having some problems with MySQL's fulltext search. I have the fields
> that I ne
Yes
Use SQL_CALC_ROWS
And then SELECT FOUND_ROWS()
> -Original Message-
> From: William Wang [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 06, 2004 2:12 PM
> To: [EMAIL PROTECTED]
> Subject: use LIMIT and get total count
>
> Hi,
>
> In MySQL, I do:
>
> mysql> SELECT * FROM my_table
WHERE id = id = '"$category."' AND active ='y' AND order is not NULL ORDER
by order,title
> -Original Message-
> From: Eve Atley [mailto:[EMAIL PROTECTED]
> Sent: Monday, May 03, 2004 2:24 PM
> To: [EMAIL PROTECTED]
> Subject: Need correct 'order by' syntax where field does not contain
> "
Do you want the binary or the src code?
http://dev.mysql.com/downloads/index.html
If you want the developer repo go here.
http://dev.mysql.com/doc/mysql/en/Installing_source_tree.html
> -Original Message-
> From: Hassan Shaikh [mailto:[EMAIL PROTECTED]
> Sent: Friday, April 23, 2004 12
Use indexes. Make sure your indexes are on the right side of the where
clause ie.
SELECT col1,col2 from tablewithproperindexes where col3=const_index_lookup.
Or you can use a dirty read as your transaction model to help out a TINY
bit.
--
DVP
> -Original Message-
> From: [EMAIL PROTECT
SHOW KEYS FROM
> -Original Message-
> From: sbv chris [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 22, 2004 7:26 AM
> To: [EMAIL PROTECTED]
> Subject: query mysql data dictionary
>
> Hi, I'm trying to find a way to find the primary keys in a table and find
> constraints on a table
You can use replace into, but note it cannot do
Replace into table VALUES (1,2,3,col4+1);
> -Original Message-
> From: Andy Ford [mailto:[EMAIL PROTECTED]
> Sent: Friday, April 23, 2004 3:59 AM
> To: [EMAIL PROTECTED]
> Subject: update if insert fails
>
> Hi
>
> Is there such a statem
Paul book is killer, I have the 1st and second addition - but to answer your
question the mySQL client can save commands, but if your looking for
something in mySQL itself to do that it can't. To create tables you can do
something like this.
%>mysql -h -uroot -p -f <
The ddl file (text file) ca
2004 8:01 AM
> To: Dathan Vance Pattishall
> Subject: RE: InnoDB Load Problem
>
> I've been keeping tabs on this thread and would just
> like to know how to tell what the buffer pool ratio
> is. What is it a ratio of? What command do I run to
> take a look at it?
>
&
better interaction with your hardware makeup.
This all assumes that your queries are already optimized.
--
DVP
> -Original Message-
> From: Marvin Wright [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 20, 2004 5:13 AM
> To: Mechain Marc; Marvin Wright; Dathan Vance Pattisha
4.0.18 does not support Unicode. The JDBC driver tries to set the UNICODE
charset but can't because this mysql version cannot store Unicode data as a
charset. If you used 4.1.1, which is alpha it supports the charset and
correlations.
My suggestion is this. Store the blobs on NAS as UNICODE text.
Use INNODB and use FK constraints / cascades.
> -Original Message-
> From: LastingImages [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 21, 2004 6:33 PM
> To: [EMAIL PROTECTED]
> Subject: Creating Relationships
>
> OK I am a umber newbie. And I have decided to change that. I was
> w
This might work for you although I would just fix my connection ;)
http://freshmeat.net/projects/mysql_proxy/
> -Original Message-
> From: Alexander Newald [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 21, 2004 5:36 PM
> To: [EMAIL PROTECTED]
> Subject: unstable mysql connection
>
http://dev.mysql.com/doc/mysql/en/News-4.0.x.html
> -Original Message-
> From: Bhaskar Borthakur [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 21, 2004 4:45 PM
> To: Dathan Vance Pattishall; [EMAIL PROTECTED]
> Subject: RE: ERROR 1030: Got error 127 from table handle
No, there is no reason to covert them to INNODB unless you want an ACID
compliant table format, and have disk space to spare.
MYISAM support a wide variety of mySQL featured, such as full text searches,
a key buffer, and a few other nice things such as a being able to get a row
count in ms time.
Left click on the binary and look at the access permissions.
> -Original Message-
> From: vasanthsena x [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 21, 2004 2:50 PM
> To: [EMAIL PROTECTED]
> Subject: Uninstall mysql
>
> Hi,
>
> I tried to uninstall mysql from win Xp.however it did
If I'm reading my Spanish correctly
http://www.mysql.com/products/mysql/
Its not going to get much better then this.
> -Original Message-
> From: María de los Angeles Vargas [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 21, 2004 8:48 AM
> To: [EMAIL PROTECTED]
> Subject: bajar mysql
Depends on your result set size and your query cache hit rate, which all can
be figured out from a show status command.
--
DVP
> -Original Message-
> From: Mark [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 21, 2004 3:43 PM
> To: [EMAIL PROTECTED]
> Subject: 64M too much?
>
> Hello,
Use explain [INSERT YOUR SELECT STATEMENT]
Verify your using keys and if you are using keys ensure that the join say
eq_ref and the first key is const. If this is the case then this is the
fastest possible join you can do for the statement below.
--
DVP
> -Original Message-
> From: kamle
Store the result set in a array of hashes and loop through that array to
build the rest of the form.
--
DVP
> -Original Message-
> From: Scott Swaim [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 21, 2004 12:17 PM
> To: Mysql
> Subject: reuse results set
>
> I have a form that does
You need to flush privileges to get the new ones active or restart mysql.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 21, 2004 12:55 PM
> To: [EMAIL PROTECTED]
> Subject: problem
>
> hi,
> I reinstalled mysql again and did what
There is a delete bug where frequent deletes can cause table corruption.
Upgrade to 4.0.18 -- I believe its been fixed by now.
> -Original Message-
> From: Bhaskar Borthakur [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 21, 2004 1:30 PM
> To: [EMAIL PROTECTED]
> Subject: ERROR 1030: G
re that your indexes are
proper.
One last note if your doing many many small quiries think about tweaking
your innodb_thread_conncurrency setting -- Ignore
innodb_thread_io_conncurrency unless you want to change code.
--
Dathan Vance Pattishall
Sr. Database Engineer / Sr. Programmer
Friendster Inc.
Use JFS, unless your database server is going to have many many (on the
order of 10K) small tables use Reiser.
JFS hands down is faster for various mixed environments of reading / writing
/ random access etc.
--
DVP
-Original Message-
From: Daniel Kasak [mailto:[EMAIL PROTEC
Can you start it with strace running and see where it fails? I suspect its
an issue with finding the group file. If this is the cause you will need to
build mySQL yourself.
Btw please send arch / version / system hardware spec.
--
DVP
> -Original Message-
> From: Mozzi [mailto:[EMAIL PRO
You can also use pae for any one process to address 4 GB of ram on a 32 bit
system.
--
DVP
> -Original Message-
> From: Tim Cutts [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 14, 2004 2:05 PM
> To: Adam Erickson
> Cc: [EMAIL PROTECTED]
> Subject: Re: MySQL Cluster
>
>
> On 14 Apr
All you had to do what
CHANGE MASTER TO MASTER_LOG_POS=,
MASTER_HOST=, MASTER_USER=,
MASTER_LOG_FILE=
This essentially forces mySQL to redownload the relay logs and stay in sync.
Its call rewinding the replication thread.
--
DVP
> -Original Message-
> From: Jeff McKeon [mailto:[EMAIL
Try truncate table. It essentially drops the table and recreates it.
--
DVP
> -Original Message-
> From: Arthur Radulescu [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 08, 2004 10:36 AM
> To: [EMAIL PROTECTED]
> Subject: autoincrement column
>
> Before switching to version 4.0.18 of
Try setting it to 4096M
--
DVP
> -Original Message-
> From: Keith Thompson [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 23, 2004 12:46 PM
> To: [EMAIL PROTECTED]
> Subject: innodb_buffer_pool_size limit
>
> Is there a limit on what innodb_buffer_pool_size can be set in 4.0.17
> (64-bi
Did you run out of disk space? If not what transaction model are you using?
Is it repeatable read? If so, are you allowing the transaction to finish
with a commit? If not your filling your transaction log and that's how your
getting this message. Call commit on the session OR SET AUTOCOMMIT=1 on
co
What version of mySQL are you using, 4.0.19 (not yet released) fixes
something similar to what you have described.
--
DVP
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 31, 2004 7:49 PM
> To: [EMAIL PROTECTED]
> Subject: urgent help need
This is all dependent on your OS's unlimit sizes, FS INODE limit, and mySQL
table type. Generally is about 64K for databases and tables if you use
myISAM / LINUX / EXT3
--
DVP
> -Original Message-
> From: Mark.he [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 31, 2004 9:42 PM
> To: [E
Try seeding your rand.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 31, 2004 12:57 PM
> To: [EMAIL PROTECTED]
> Subject: group by & order by rand() problem
>
> I have this table:
>
> mysql> select * from banners;
> ++-+
Your access permissions are not valid.
Add user pete with a password to your grant tables as configured with PHPBB
Or
Add skip-grant-tables in you're my.cnf config file.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 31, 2004 11:09 AM
Can you send the error message? It might be a timeout problem which is a
mySQL configuration issue. (Look at wait_timeout in my.cnf)
> -Original Message-
> From: Andrew Loughe [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 31, 2004 10:30 AM
> To: [EMAIL PROTECTED]
> Subject: mysqlhotc
> -Original Message-
> From: joe collins [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 30, 2004 1:26 AM
> To: MySQL
> Subject: ibdata1 size
>
> HI,
>
> the ibdata1file in mysql\data has reached a size of 10Mb in just over a
> week, the database I have set up is quite limited, only 7
Tips on managing very large tables for myISAM:
1) Ensure that the table type is not DYNAMIC but Fixed.
=> Issue the show table status command.
=> Look at Row Format
=> if Row Format != Dynamic the your ok else get rid of varchar type
columns
=> Reason:
Your myISAM table c
s to read every row
of the master and compare it with every row of the slave once the master
and slave are in-sync.
Anyone have better solution?
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-Original Message-
-->From: joffrey leevy [mailto:[EMAIL PROTECTED]
-->Sent: Wednesday, November 12, 2003 9:58 AM
-->To: [EMAIL PROTECTED]
-->
read_buffer=2M
write_buffer=2M
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-Original Message-
-->From: rmck [mailto:[EMAIL PROTECTED]
-->Sent: Tuesday, November 11, 2003 5:27 PM
-->To: Dathan Vanc
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-Original Message-
-->From: rmck [mailto:[EMAIL PROTECTED]
-->Sent: Tuesday, November 11, 2003 3:17 PM
-->To: [EMAIL PROTECTED]
-->Subject: Error 12
Look at GRANT on mysql.com
GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFITED BY '';
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-Original Message-
-->From: Randall Perry [mailto
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-Original Message-
-->From: Brian Snyder [mailto:[EMAIL PROTECTED]
-->Sent: Tuesday, November 11, 2003 1:12 PM
-->To: [EMAIL PROTECTED]
-->Subject:
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-Original Message-
-->From: Brian Snyder [mailto:[EMAIL PROTECTED]
-->Sent: Tuesday, November 11, 2003 12:51 PM
-->To: [EMAIL PROTECTED]
-->Subje
mySQL already does that look at /var/lib/mysql/mysql.sock=. You can add
skip-networking to my.cnf not to allow tcp connections at all.
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-Original Message-
--&g
Create one.
Look in your base directory under support-files
Look for my-small.cnf
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-Original Message-
-->From: Admin-Stress [mailto:[EMAIL PROTECTED]
-
The parser does not execute the query before it parses it. Thus you
cannot do that. Use Code, and or have an idea what the INTERVAL UNIT is
prior to executing the query.
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
Anyone use Veritas FlashSnap to back up data or even better yet mySQL
databases over NFS?
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-Original Message-
-->From: Chen, Mao [mailto:[EMAIL PROTECTED]
-->Sent: Monday, November 10, 2003 2:25 PM
-->To: [EMAIL PROTECTED]; [EMAIL PROTECTED
Use analyze table to calculate cardinality.
- 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]
-->Sent: Thursday, November 06, 2003 4:46
- 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]
-->Sent: Thursday, November 06, 2003 3:41 PM
-->To: [EMAIL PROTECTED]
-->Subjec
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-Original Message-
-->From: Arnoldus Th.J. Koeleman [mailto:[EMAIL PROTECTED]
-->Sent: Thursday, November 06, 2003 1:24 PM
-->To: [EMAIL PROTECTED
U could always use a PRIMARY key on an auto_increment column.
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-Original Message-
-->From: Mike Brando [mailto:[EMAIL PROTECTED]
-->Sent: Thursday, November
On the list I thought I saw that they where expecting it to come out
this month to mid December
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-Original Message-
-->From: Jon Hancock [mailto:[EMAIL PRO
What do you mean by relations? Like table relations such as with FK in
innodb?
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-Original Message-
-->From: Robert Morgan [mailto:[EMAIL PROTECTED]
-
Can you send show keys from campaign_t.
I bet you can solve your problem by running analyze table.
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-Original Message-
-->From: Eric Anderson [mailto:
hours and repairing them as the issue develops.
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-Original Message-
-->From: Jon Wagoner [mailto:[EMAIL PROTECTED]
-->Sent: Monday, November 03, 2003 11:
You need to GRANT the appropriate privs-for the slave in question to
replicate from the master on the master. Look up Grant on mysql.com
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-Original Mess
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
Could you look at youre 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] [
Can you post youre 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 Mess
t
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; Ia
1 - 100 of 259 matches
Mail list logo
