RE: Need older version of mysql (current version seeminly corrupts FTS tables)

2005-02-18 Thread Steven Roussey
> See: > http://downloads.mysql.com/archives.php Thank you. Nice link to have around. >> Key 3 is the FTS key. The others are a UNIQUE KEY (#1) and a KEY(#2). > >Do you have the same values for full-text parameters (ft_mit_word_len >for example)? Not at first. I had noticed that not long after

Need older version of mysql (current version seeminly corrupts FTS tables)

2005-02-17 Thread Steven Roussey
I have replaced one server with another, and the new one has everything new (RHEL 3, newest updates) and MySQL 4.0.23 (old one was RH9 and MySQL 4.0.18). We now get table corruptions constantly (it only takes a minute before several tables get marked as crashed). I'd like to revert to the 4.0.18 v

RE: Help with query performance anomaly

2004-11-12 Thread Steven Roussey
For production systems, I would never let the mysql optimizer guess a query plan when there are joins of big tables and you know exactly how it should behave. Once you think a query is finished, you should optimize it yourself. Use STRAIGHT_JOIN and USE INDEX as found here in the manual: http://de

RE: Upgrading MySQL erased all data

2004-11-02 Thread Steven Roussey
Thanks. I passed this on and he found what was lost. I guess since the data directory was owned by mysql, he could not find the databases when doing a MacOS file search. I impressed upon him to use a separate datadir as we do with our servers, thus bypassing this whole thing. Thanks again! -steve

Upgrading MySQL erased all data

2004-10-28 Thread Steven Roussey
Installing MySQL 4.1.7 (upgrading from 4.1.3) on MacOS X erased the contents of /usr/local/mysql/data -- the privs and data of the previous installation. FYI Luckily (and unfortunately) we have a backup of that database from last week. (The guy that did it here in the office is still in a bit of

RE: Problems with MySQL 4.0.20

2004-06-07 Thread Steven Roussey
> Thank you very much for your bug report! > And sorry if I doubted your report at the beginning; I hadn't thought > of the rpm script. No problem. I sometimes get bug reports that I know are impossible! Yet they weren't. This one I would have barely noticed if it had not knocked the slaves all of

RE: Problems with MySQL 4.0.20

2004-05-26 Thread Steven Roussey
> Hmm, I don't see any changes in ft-related files since 4.0.18 that could > cause it (there were bugfixes, but they affect only *searching* - that > is MATCH - and not *updating*). > > Can you create a test case ? Well, I put up a file in the secret folder a few days ago as referenced in a bug r

RE: Problems with MySQL 4.0.20

2004-05-26 Thread Steven Roussey
We start mysql with 'service mysql start' (we install from the RPM for linux). I've never seen mysql create binlog files under the name root before, and after reverting to an old version, it doesn't again. It created a big mess with all the slaves stuck at the end of an older binlog and not advanc

Problems with MySQL 4.0.20

2004-05-25 Thread Steven Roussey
We had some servers that were upgraded from 4.0.17/18 to 4.0.20 and had several problems thereafter: 1. Tables with FTS indices became corrupted, with queries on them causing segfaults on the servers. 2. BinLog files were getting created with ownership of root, not mysql. Then Mysql complains tha

thread stack issues

2004-05-20 Thread Steven Roussey
Since going from 4.0.18 to 4.0.20 (or 4.0.19) I now receive these warnings on startup: 040520 14:55:21 mysqld started 040520 14:55:21 Warning: Asked for 196608 thread stack, but got 126976 /usr/sbin/mysqld: ready for connections. Version: '4.0.20-standard' socket: '/tmp/mysql.sock' port: 3306

Quirk with max()

2004-04-22 Thread Steven Roussey
I've seen a quirk in Mysql behavior over the years when dealing with max(). In a query such as this: select max(somecol) from sometbl where id=# and otherthing=# (index is on id, but not on otherthing) We see the query run just fine (0.x seconds to run) almost all of the time. But

Re: Feature request related to COMPRESS and UNCOMPRESS functions

2004-03-01 Thread Steven Roussey
> Here is the background: Anyone that is running a huge system like MARC > that has millions of uncompressed blob records in huge tables, needs to be > able to migrate, in real-time and without down-time, to compressed blobs. > Therefore, we need a way to know if a given field is compressed or not

Re: [4.1.1] 1062 errors on non-unique index during data load

2004-02-23 Thread Steven Roussey
I saw something like this as well. Using 4.1.2 made it go away. Try doing a bk pull of the dev version of 4.1.2 and give it a go. -steve-- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Advise on High Availability configuration

2004-01-30 Thread Steven Roussey
I am wary of something so 'do it yourself'. Have you looked at ReHat's clustering solution? http://www.redhat.com/software/rha/cluster/ http://www.redhat.com/software/rha/cluster/manager/ I don't think it has any issue with InnoDB, key buffers, etc. I believe this solution works best for failove

RE: 4.1.1 FTS 2-level?

2004-01-14 Thread Steven Roussey
Thanks for the additional information. When 4.1.2 comes out, I'll give it a test and return with some stats on real world result times (for my data set at least). -steve- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EM

Re: Spatial Extension in MySQL 4.1.1-alpha

2003-12-16 Thread Steven Roussey
You did an insert this way: mysql> insert into geom values(GeomFromText('POINT(1,1)')); and expected results this way: mysql> select AsText(g) from geom; +---+ | AsText(g) | +---+ | Point(1 1)| +---+ 1 row in set (0.00 sec) The formatting of the POINT coo

4.1.1 FTS 2-level?

2003-12-09 Thread Steven Roussey
Does Mysql 4.1.1 have the two level index system integrated into it for full text searches? Thanks. :) -steve- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

2,000,000 rows in FULLTEXT

2003-09-24 Thread Steven Roussey
could downgrade back a version and have it still work OK? Sincerely, Steven Roussey http://Network54.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Suboptimal index-usage with FULLTEXT-search

2003-09-17 Thread Steven Roussey
to say hello". Do the same with the search and suddenly things work a lot faster. And uglier... Sincerely, Steven Roussey http://Network54.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL 4.0.14 stops responding to PHP 4.3.2

2003-09-04 Thread Steven Roussey
> No, it turns out this is not the key. With mysql_connect() I'm actually > failing MORE often than with mysql_pconnect - so far it hasn't stayed > up 15 minutes without error. (Fortunately, I have a cron job checking > on it and restarting.) After the failed connection attempt, there will be a

RE: InnoDB and lots of UPDATES

2003-09-04 Thread Steven Roussey
> Use transaction: > > begin > update ... > update ... > ... > update ... > commit; > > This way you will only have a syncs to disk at every commit instead of every > update. This won't help -- I'm not doing a batch process. Each update is coming from a different connection... --steve- -- M

InnoDB and lots of UPDATES

2003-09-02 Thread Steven Roussey
I have a question about InnoDB and how it would handle updates on the order of about 3,000-5,000 a second. The UPDATEs update a single record on a primary key. In MySQL, it does a table lock thus serializing the updates. There are a few selects, though on a couple of orders of magnitude less often.

RE: Lots of FULLTEXT stuff (suggestions)

2003-08-25 Thread Steven Roussey
> Thanks for replying. Your posts that I've found when searching for > FULLTEXT information have had great ideas. :-) Searching millions of > posts efficiently and effectively isn't easy. :-( Heh. FULLTEXT does not scale very well once the files get bigger than your RAM. The redesign of the index

RE: Lots of FULLTEXT stuff (suggestions)

2003-08-24 Thread Steven Roussey
> Lots of stuff > STEMMING! (controlled more finely than server level I hope), multi-byte > character set support, proximity operators. Anything to get it closer to > Verity's full-text functionality. ;-) Yes, all these things would be nice... :) > And the FULLTEXT index shouldn't always be chose

RE: Slow results with simple, well-indexed query

2003-08-22 Thread Steven Roussey
After looking over your results, I would keep the dir1 index at least on the first and last table. But since this data is read only, why not reformulate the data for the queries you are going to make? This is the opposite of normalizing, and will require more disk space, and is not flexible, but i

RE: Slow results with simple, well-indexed query

2003-08-22 Thread Steven Roussey
Hmmm, just in case you can't change the table layout... Run this through MySQL. First I get rid of the other index I made, then add chained indexes so there is no need for data file lookup. Also, one direction of the query table join chain was not always using the indexes for the where. One direct

RE: Slow results with simple, well-indexed query

2003-08-22 Thread Steven Roussey
> All the indexes were single indexes, partly because I haven't > yet made the effort to understand composite index. I guess it's > time ;-). Oh. There are better places to start than this list. ;) The manual can be a great starting place, and several people on this list have written books about

RE: Slow results with simple, well-indexed query

2003-08-22 Thread Steven Roussey
> Here's the CREATEs, somewhat edited to remove parts not relevant > to this discussion, to save space: I never actually looked at your JOIN statement more than a quick glimpse, but I will (though not just right now). Before I do, can you try this (I still don't have data or I'd play with it mysel

RE: Slow results with simple, well-indexed query

2003-08-21 Thread Steven Roussey
> GOD! OK, sorry, I wasn't quite expecting this: > Wow! :) > > But what's the explanation for this huge improvement? Again, I > was always told the opposite, and the Manual itself says: ... Yes, and it is true (usually). But your EXPLAIN showed a filesort and that is bad. What happens is that i

RE: Slow results with simple, well-indexed query

2003-08-21 Thread Steven Roussey
> No, the contents can be of mixed case. Where does that leave things? **Index the length of the entire column.** It then should not need to have to do the filesort. Actually the binary option would not have really helped. The explain should say 'Using Index'. Get back to me on this and tell me th

RE: How to create a stop word file?

2003-08-21 Thread Steven Roussey
> how to separate each stop word in the list A different word on each line. -steve- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Slow results with simple, well-indexed query

2003-08-21 Thread Steven Roussey
> Executing just the search on the word table, with no joins to the > table with the dates, is still slow: Then it is not worth while to focus on anything else until you fix that. Are the contents of this field always in lower case? Is so, then change the column to a binary type. The explain says

Re: Searching on Two Keys with OR?

2003-08-14 Thread Steven Roussey
> "ORing on two different fields" is what I have been asking about :). This is not optimized, and I don't think it is set to be optimized until 5.1 (as per someone else's comment). > Using a composite index was suggested This is bad information. It works for AND, not for OR. You have two workar

RE: MYSQL Scalability on SMPs

2003-08-14 Thread Steven Roussey
> It looks like Igor comitted it to the 4.1 tree on the 2nd of this month: I'd assume that this change is necessary but not sufficient for the MySQL table type table locking issue... I know, I know, there is InnoDB for that, but there are reasons not to use it despite this particular wonderful ad

Re: replication problem

2003-08-08 Thread Steven Roussey
> So does anyone else have any ideas what is going on here? Shall I > report this as a bug? Did you post how you setup the servers to load the different my.cnf files? Hopefully you don't have one at a default location. Otherwise, it sounds like the config information is not properly set -- eithe

Re: MYSQL Scalability on SMPs

2003-08-07 Thread Steven Roussey
> MyISAM performance is limited right now by a global lock in the key > cache. However, I believe there is work going on to fix that in the > 4.1 tree. Really? I thought it was going to be fixed in the 5.1 tree, which will be years away from production quality. 4.1 would be really cool, but it se

RE: transactions with php

2003-06-18 Thread Steven Roussey
In http://www.mysql.com/doc/en/News-4.0.6.html * mysql_change_user() will now reset the connection to the state of a fresh connect (Ie, ROLLBACK any active transaction, close all temporary tables, reset all user variables etc..) So it is in there, starting with version MySQL 4.0.6. -steve- -

RE: How to have AUTO_INCREMENT ignoring 0?

2003-06-18 Thread Steven Roussey
Just a note on this subject. We have a field that uses 0 to mean something special too. It was a bad idea that is on my TODO list to fix some day. (The corresponding table used 0 to mean something special, and then joined to the table with the autoindex. The fix is too use null in that other table

RE: RAID hardware suggestions/experience

2003-06-18 Thread Steven Roussey
> A lot of table scans do to bitmasked column values. > Such that the above query will not utilize a key. That statement gave me a cold shiver up my spine. You could try an inverted index or match-cache technique, or denormalization. These type of techniques are very app specific, but can reduce

RE: RAID hardware suggestions/experience

2003-06-18 Thread Steven Roussey
2 x 2.8 GHZ Xeon 4 GB of RAM 5 15K SCSI Drives ICP SCSCI RAID control card with 1 Gb of ram on it. I just bought 30 of these boxes to build out my mysql farm for close to 400-600 queries a second with 60 connections a second of mix read / writes. What kind of queries are you doing? Our s

RE: RAID hardware suggestions/experience

2003-06-18 Thread Steven Roussey
> What sort of throughput are you seeing in that setup? God, I can't remember anymore. I can run a test again though. If you have one you want me to run, just send it. We don't have other people's money to spend, so all our disks are U160 18GB 15K IBM. They were less than $100 each when we got the

RE: Triggers

2003-06-18 Thread Steven Roussey
Just a couple of quick notes: 1. While I use PHP CLI for a lot of things (can we say cron?), it is not a sufficient replacement for triggers. What happens when someone is using the Mysql command prompt to alter data? Or using a non-PHP application? 2. While I agree that having application code ra

Re: transactions with php

2003-06-18 Thread Steven Roussey
> If you're using a non-persistent connection, PHP will close the > connection when the script terminates, and the MySQL server will roll back > implicitly. For a non-persistent connection, the connection remains open > and you may not see the rollback behavior your expect. I thought this was fi

RE: RAID hardware suggestions/experience

2003-06-18 Thread Steven Roussey
After testing a lot of different configurations (which was quite a headache), I came up with the following. First of all, for both speed and reliability, you will want SCSI. The list of reasons are quite long for SCSI, and as you are doing research on the subject, it is an obvious choice and I don'

RE: Problem with replication and corrupting tables

2003-02-19 Thread Steven Roussey
Hi, And fixed. Sorry for the waste of time. Only 4 days before I was set to replace the disk the database was on, and it is going bad. :( -steve- sql,query - Before posting, please check: http://www.mysql.com/manual.php

RE: Problem with replication and corrupting tables

2003-02-19 Thread Steven Roussey
Hi, mysqlbinlog -j | mysql works fine. I used -o instead of -j before. So I answered my last question. When doing this: mysqlbinlog -j | more I see that it had advanced to the query after the one with the problem in the trace file. In fact, the query succeeded and was there after a REPAIR T

RE: Using mysqlbinlog to restore blob data

2003-02-19 Thread Steven Roussey
Rick, I am able to restore from logs that had binary data (even though the output looked real strange and messed up the terminal window). I did have a problem once when I tried filtering data between mysqlbinlog and mysql. Be careful if you do that. What version of mysql are you using? I have no

RE: Problem with replication and corrupting tables

2003-02-19 Thread Steven Roussey
Quick question: Are the binlog and relaylog files the same format? Initial tests seem to indicate that they are the same. Can I use mysqlbinlog -o | mysql to get the slave more up to date (without having the slave SQL thread running)? I tried the above but the from 'show slave status' seemed w

RE: Problem with replication and corrupting tables

2003-02-18 Thread Steven Roussey
Below is a trace (--debug=d,enter,exit,info,error,query,general,where: O,/tmp/mysqld.trace) of the slave thread. This is the best I can do as far as a bug report. No other queries were running and the slave I/O thread was idle (I firewalled its connection to the master/rest of the world). Without

RE: Bug in ORDER BY

2003-02-18 Thread Steven Roussey
I'm glad you found the problem! Sorry my suggestion did not work. I'm still confused on why you have quotes around the field names in the order by part of the query, though. All the best! -steve- - Before posting, please chec

RE: Problem with replication and corrupting tables

2003-02-18 Thread Steven Roussey
An update. I'm now running the debug version on the slave. I could not trace out 'info' since it wrote way too much to the trace file. What I did find that was unique when the table crashed is this: handle_slave_sql: query: insert into forums_posts_new_3 ( w_search: error: Got errno: 0 from

RE: Bug in ORDER BY

2003-02-17 Thread Steven Roussey
> SELECT * FROM EventList ORDER BY 'EventDate', 'EventOrder' LIMIT 50; I'm surprised you happened to get anything in order. Maybe the message got simplified by the list manager, but did you really mean to order by a constant string? Why not: SELECT * FROM EventList ORDER BY `EventDate`, `

RE: Problem with replication and corrupting tables

2003-02-17 Thread Steven Roussey
Today I added --myisam-recover=FORCE,BACKUP,QUICK However, replication seems to not honor that setting. I have a master that can average 7000qps and last forever, and a slave that can only last 12 minutes at 1/10 the qps. :( Next, I guess, is to download the debug version from MySQL and see what

Problem with replication and corrupting tables

2003-02-15 Thread Steven Roussey
Hi all, I have a problem with replication, that while repeatable for me very easily, I can not come up with a way for others to repeat it without all our tables and binlogs (tens of gigabytes). So I'm simply going to describe things here and see if anyone else has experienced anything similar or m

Help debugging a stuck FTS thread

2003-02-10 Thread Steven Roussey
V4.0.9 How can I use the mysqld.sym file via gdb? It doesn't like the format. Copying the stacktrace into another file where I have to edit out a bunch of junk from gdb for resolve_stack_dump is a bit slow. It seems that two processes have hung for a while. All the slots have filled up even thoug

Re: proposal: new back end tailored to data mining very large tables

2003-02-03 Thread Steven Roussey
reference to denormalization didn't make any sense to me. What level of normal form are you expecting? Sincerely, Steven Roussey http://Network54.com/ - Before posting, please check: http://www.mysql.com/manual.php (t

RE: partitionong MyISAM tables??

2003-02-03 Thread Steven Roussey
e table. Sincerely, Steven Roussey http://Network54.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <

Re: How to speed things up in MySQL ?

2003-01-26 Thread Steven Roussey
> I guess the reason for this is that the I have a some blob fields whitch are > all used.. (each record consist of approx 600 KB...) There it is. MySQL's MyISAM will get the whole record even if it only needs a part. You can try InnoDB as it does it differently. [At some point I may try and add

RE: RE: MySQL in combination with PHP problem

2003-01-24 Thread Steven Roussey
> I'm using temporary tables for this but there is a problem. > Temporary tables are visible trough the entire connection. So in future > one browser window can interact (can display) with results from another > browser window. Does anyone have a sugestion how to solve this? You could do something

Aborted connections.../mysqladmin flush-hosts

2003-01-22 Thread Steven Roussey
sure if the issue lies with the version change or just coincident with it. Can anyone confirm this behavior? Sincerely, Steven Roussey http://Network54.com/ - Before posting, please check: http://www.mysql.com/manual.php

RE: mysqlstat (WAS Re: Optimizing Ext3 for MySQL)

2003-01-22 Thread Steven Roussey
s without constant re-compiling. I'll also get the advantage of having it work with several languages on a record basis, rather than a table basis... Now if only I had a paying job, I could focus on it and get it done quicker... Sincerely, Steven Roussey http://Network54.com/ -

RE: mysqlstat (WAS Re: Optimizing Ext3 for MySQL)

2003-01-22 Thread Steven Roussey
g mess. Yikes! > It'll sorta like a vmstat the watches the output of SHOW STATUS, > mostly the Com_* counters Poor man's version: watch mysqladmin extended-status Sincerely, Steven Roussey http://Network5

Re: Optimizing Ext3 for MySQL

2003-01-15 Thread Steven Roussey
I use ext3 and have a qps of anywhere from 2800-8000 and use the defaults with no problems. Have you tried: iostat -k 1 to look at your disk access? What kind of disks are they anyhow? IDE or SCSI? RAIDed? In what fashion? Lastly, you said that this is a script that is running, right? The tab

RE: How can we tell if we're maxing out MySQL/InnoDB capacity?

2003-01-02 Thread Steven Roussey
- Yesterday happened to be one of the busiest days for us ever on our MySQL backed web site. For the entire day MySQL was hit with up to 1200 queries/second, and many queries were being delayed at least 2-15 seconds. - I know how you feel. We were hitting 7700 qu

RE: How can we tell if we're maxing out MySQL/InnoDB capacity?

2003-01-02 Thread Steven Roussey
- Yesterday happened to be one of the busiest days for us ever on our MySQL backed web site. For the entire day MySQL was hit with up to 1200 queries/second, and many queries were being delayed at least 2-15 seconds. - I know how you feel. We were hitting 7700 qu

Mysql versions, disks, speed, FTS, and EXPLAIN feature request (SELECT [CALC_RESOURCES])

2002-12-20 Thread Steven Roussey
Hi all! I wanted to thank the MySQL team for making such a great product! We moved from 3.23 to 4.0.x a couple of months ago and everything works great. Just upgraded to 4.0.6 and glad to see it work out of the box without a rev 4.0.6a. Those glib issues were such a pain! 4.0.5a and 4.0.6 have be

RE: Odd Slowness in 4.0.5a with binlog

2002-12-11 Thread Steven Roussey
then what you described happens. Sincerely, Steven Roussey http://Network54.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To req

Odd Slowness in 4.0.5a with binlog

2002-12-07 Thread Steven Roussey
How it had 0 processes running is beyond me...) Sincerely, Steven Roussey http://Network54.com/ sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

InnoDB and ALTER TABLE ... ORDER BY

2002-11-27 Thread Steven Roussey
Does InnoDB support ALTER TABLE ... ORDER BY ...? If it weren't for this command, we would never get the continuous great performance we get from MySQL. And it keeps us from ever really considering InnoDB. :( Sincerely, Steven Roussey http://Network5

Manual stuff missing

2002-11-20 Thread Steven Roussey
There seems to be nothing in the Manual about a lot of things. For example, the utilities mysqldumpslow, and mysqlcheck, etc. Sincerely, Steven Roussey http://Network54.com/ - Before posting, please check: http

MySQL saturating Fast Ethernet after 3500 qps?

2002-11-19 Thread Steven Roussey
the client is seeing slow queries, but the MySQL server is not. Will Gigabit Ethernet alleviate this problem? TIA! Sincerely, Steven Roussey http://Network54.com/ - Before posting, please check: http://www.mysql.com

RE: CPU Load extremely high with MySQL 4.0.4

2002-11-19 Thread Steven Roussey
OK, it seems to be working. The load is not spiraling out of control. :) Sincerely, Steven Roussey http://Network54.com/ > -Original Message- > From: Lenz Grimmer [mailto:[EMAIL PROTECTED]] > Before I make a 4.0.5a release of the Linux binaries (and finally announce > 4

Re: CPU Load extremely high with MySQL 4.0.4

2002-11-18 Thread Steven Roussey
ssue. I just tried it and our load went from 1 to 145 in 20 seconds... Sincerely, Steven Roussey http://Network54.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.c

Re: MySQL + PHP : "Commands out of sync; You can't run this command now"

2002-11-18 Thread Steven Roussey
Comment out the body of the _restore_connection_defaults in php_mysql.c file in PHP. Recompile, etc. Or don’t use persistent connections. Should be fixed in PHP 4.3.   See http://bugs.php.net/?id=19529 for more info. Sincerely, Steven Roussey http://Network54.com

RE: How much data can MySQL push out?

2002-11-01 Thread Steven Roussey
ch is Frys Electronics. So I just went and bought a case, power supply, dual Athlon MP 1800s, and 2GB of RAM. And Ultra160 dual channel RAID 0 configuration of six drives (10K rpm I think...). And an extra case for the drives. Lots of fans. Oh, and a screwdriver. OS: RedHat Linux 7.3. Sincerel

RE: How much data can MySQL push out?

2002-10-31 Thread Steven Roussey
time. Sincerely, Steven Roussey http://Network54.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[

RE: How much data can MySQL push out?

2002-10-31 Thread Steven Roussey
t + freshmeat + geocrawler + linux.com + newsforge + sourceforge + OSDN.com + ThinkGeek + MediaBuilderNetwork >= 134,000,000). Replication not yet warranted for us. MySQL rocks! > But this has nothing to do with SQL or QUERYs. :) True, so I'll shut up now. Sincerely, Steven Rous

Re: How much data can MySQL push out?

2002-10-31 Thread Steven Roussey
I like our ranking there... I'll check what our bandwidth utilization is. We don't have a problem yet. Sql query Sincerely, Steven Roussey http://Network54.com/ - Before posting, please check: http://www.mysql.

Re: Thread Thrashing and 3.23.53a

2002-10-31 Thread Steven Roussey
It is no fun on a production server, I know. However, this helped MySQL AB in tracking down the issue we experienced. Could do the same for you. PS: What OS? Sincerely, Steven Roussey http://Network54.com/ - Before posti

RE: Tips for LARGE system

2002-10-21 Thread Steven Roussey
ents though. If things are partitionable, then some thinking about that upfront will do you a world of good later. Depend on your application though. > 7) I'd also appreciate any input from people who have used > official mysql support before. We have used their support and it was

Re: Updated MySQL 3.23.53a binaries now available

2002-10-20 Thread Steven Roussey
relief! Thanks for all the work to resolve this! Sincerely, Steven Roussey http://Network54.com/?pp=e sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Changes to PHP/MySQL extension

2002-10-08 Thread Steven Roussey
amp;link->conn)->user); strcpy (passwd, (char *)(&link->conn)->passwd); mysql_change_user(&link->conn, user, passwd, ""); #endif return 0; } And change the two copies of this: if (connect_timeout != -1) to

FW: Bug #19529 [Com]: Occational "Commands out of sync" errors

2002-10-07 Thread Steven Roussey
but I can see where this would be part of the need. Sincerely, Steven Roussey http://Network54.com/?pp=e -Original Message- From: PHP Bug Database [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 5:03 am To: [EMAIL PROTECTED] Subject: Bug #19529 [Com]: Occational "Comma

MYSQL_OPT_CONNECT_TIMEOUT

2002-10-01 Thread Steven Roussey
If MYSQL_OPT_CONNECT_TIMEOUT is set before mysql_connect() or mysql_real_connect() and the value is set to zero, what is the expected behavior? (Reason: PHP now does this as the default.) Sincerely, Steven Roussey http://Network54.com/?pp=e

RE: MySQL errors in newer PHP 4.2.3

2002-09-19 Thread Steven Roussey
, Steven Roussey http://Network54.com/?pp=e > -Original Message- > From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]] > > Hi, > > Same problem for me, although it was already here with 4.2.0 for me (well > it > seems to be also a high QPS problem...). The problem seems

MySQL errors in newer PHP 4.2.3

2002-09-19 Thread Steven Roussey
Since updating to 4.2.3, we have been getting intermittent errors of "Commands out of sync". Anyone else see this? Sincerely, Steven Roussey http://Network54.com/?pp=e php,sql,query - Before posting, please chec

Re: upgrade 3.23 -> 4.0.3 question

2002-08-30 Thread Steven Roussey
with 4.0.3 in that it works fine for a few queries, but when I let it go at a normal 3000 queries per second it choked up and died (much like 3.23.51 -- by the way, which 3.23.x are you using now?). Thanks! Sincerely, Steven Roussey http://Network54.com/?pp=e

RE: MySQL 4.0 and LIKE "%string%"

2002-08-29 Thread Steven Roussey
That optimization is for fields without an index AFAIK. Sincerely, Steven Roussey http://Network54.com/?pp=e sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

RE: 4.0.3 crashes every 5 seconds.

2002-08-28 Thread Steven Roussey
Lastly, we use the .tar.gz file of the linux binary made by MySQL AB. Sincerely, Steven Roussey http://Network54.com/?pp=e > -Original Message- > OS is ReadHat Linux 7.3 > Glib is 2.2.5 > Kernel is 2.4.18-10smp > > Two Athlon MPs and 1.

RE: 4.0.3 crashes every 5 seconds.

2002-08-28 Thread Steven Roussey
Also, OS is ReadHat Linux 7.3 Glib is 2.2.5 Kernel is 2.4.18-10smp Two Athlon MPs and 1.5Gb RAM. Sincerely, Steven Roussey http://Network54.com/?pp=e > -Original Message- > From: Lenz Grimmer [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 28, 2002 12:49 am >

How to supply two database names

2002-08-28 Thread Steven Roussey
I have two database names that I would like binlog to ignore, how do I do that? binlog-ignore-db=db1 works OK for db1, but binlog-ignore-db=db1 db2 binlog-ignore-db=db1,db2 do not work. Sincerely, Steven Roussey http://Network54.com/?pp=e sql,query

RE: 4.0.3 crashes every 5 seconds.

2002-08-28 Thread Steven Roussey
It did not occur to me under after I sent the last email, that the binlog does not log every query. For our site, it does not even log every database. So I'm going to look a bit harder at the other log file... Sincerely, Steven Roussey http://Network54.com/

RE: 4.0.3 crashes every 5 seconds.

2002-08-28 Thread Steven Roussey
be found in the log file. I wish there was a web accessible version of the source so I could quickly go look at it (like PHP's lxr.php.net)... Sincerely, Steven Roussey http://Network54.com/?pp=e > -Original Message- > From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]] > Sen

4.0.3 crashes every 5 seconds.

2002-08-27 Thread Steven Roussey
the sym file... I guess I rushed to download too quickly... I'll write back with more info soon. Sincerely, Steven Roussey http://Network54.com/?pp=e - Before posting, please check: http://www.mysql.com/manual.php

FULLTEXT out of slow query log

2002-08-09 Thread Steven Roussey
Is there a way to not have mysql put fulltext searches in the slow query log? Sincerely, Steven Roussey http://Network54.com/?pp=e - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

4.0.2 mysqld.sym.gz is empty

2002-08-09 Thread Steven Roussey
I can't look up a MySQL 4.0.2 crash since the mysqld.sym.gz is empty! Can someone at MySQL email me the file, please. Pretty please. Thanks! Sincerely, Steven Roussey http://Network54.com/?pp=e query - Before po

RE: Load problems with 3.23.51

2002-07-12 Thread Steven Roussey
Just a note: I tried MySQL 4.0.2 and it works fine. Seems to be only 3.23.51 built by MySQL itself that has the issue. Releases before, and now a release after (albeit a 4.0.x version) work fine. Sincerely, Steven Roussey http://Network54.com/?pp=e > > I have MySQL 3.23.47 running on our

RE: Load problems with 3.23.51

2002-07-02 Thread Steven Roussey
Just an update: I installed a new fresh version of RedHat 7.3 (smp Athlon) and a new copy of MySQL 3.23.51, but the problem remains. Sincerely, Steven Roussey http://Network54.com/?pp=e - Before posting, please check

RE: Load problems with 3.23.51

2002-06-30 Thread Steven Roussey
0 read_chan This is obviously different. 3.23.47 is in tcp_data_wait. 3.23.51 is usually doing nothing (!) or in suspend. Odd. Sincerely, Steven Roussey http://Network54.com/?pp=e > -Original Message- > From: Michael Bacarella [mailto:[EMAIL PROTECTED]] > Sent: Saturday, June 29

RE: Load problems with 3.23.51

2002-06-29 Thread Steven Roussey
to do with it? Tomorrow I'll try doing my own compile with gcc3.1. Note the other guy that had the same problem that went away after he compiled it himself: http://marc.theaimsgroup.com/?l=mysql&m=102537522606976&w=2 In that case, I doubt he has the altered glibc compiled in. Cou

  1   2   >