RE: Unable to Create DB Connection

sed to the command line client first. BTW, The author of probably the best book ever written on MySQL frequently responds to e-mails on this list. Some well intended advice, get his book (MySQL Second Edition). <> Regards, Matt <> =>-Original Mes

Re: Parallel Processing

As I understand it mysql is a single process multi-threaded application. I have heard of some thread schedulers that allow for a certain granularity of determining where to run a particular thread / process. I think this is the purpose behind Sun's processor groups. Is there such a thing for Lin

Password function not working with latest 4.1 tree

>Description: with the latest 4.1 tree (from today) the PASSWORD() function returns random alpha-numeric text /[a-f0-9]/ 45 characters in length (which is too long for a password string). The string always starts with a * (asterisk). example:*95144feaa0f433f3f62c29

merge problems under 3.23.47?

; SELECT * FROM t_merge WHERE cpe_mac_id LIKE 1234; In testing, the problem only arises when the total line count of the two mapped tables reaches 20. Anyone have any ideas? - Matt - Before posting, please check: http://ww

Leap seconds

>Submitter-Id: >Originator:matt >Organization: >MySQL support: none >Severity: non-critical >Priority: low >Category: mysql >Class: sw-bug >Release: mysql-3.23.41 (Source distribution) >Environment: lrwxrwxrwx1 root ro

Procedures

Does any know if mysql has any kind of stored procedures? If not, is there any plans on including them? -matt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

GROUP BY on multiple fields apparently broken

; select One, Two, sum(Four) from test group by One,Two; -- fails select One, Two, sum(Four) from test group by concat(One,Two); -- succeeds >Fix: Use concat() to create a single group by element, but this isn't the right way to do it, surely! >Submitter-Id: >Orig

Host IP is not allowed to connect this MySQL server

Hello, I am trying to connect to a remote MySQL server of mine and I get this error " Host IP is not allowed to connect this MySQL server " If someone could give me the shortcut to this file so I can edit it to allow me in- It would be greatly appreciated. Thank

slave_net_timeout?

that. There is, however, a variable named 'slave_net_timeout.' I'm guessing that's the same thing? Looks like that manual ought to say ... set-variable = slave_net_timeout=# ... instead. Please CC me on any replies as I'm not su

trying to reset auto-increment

I manually entered into my database several rows with high values in the auto-increment column. I subsequently deleted the high value rows. I now am trying to reset the auto-increment. How do I reset it to the Max of the currently existing values? -matt [EMAIL PROTECTED

killed by SIGSEGV

idea how to get the fault to happen on demand - so this seems like a good enough way to start. If anyone can make any suggestions on tests/things to try then please do. Thanks, Matt This is what a typical log entry looks like: mysqld got signal 11; The manual section 'D

Re: killed by SIGSEGV

ig programs. This box has been fine though, I've compiled the kernel no problem 10s of times. Hopefully thats covered everything, thanks again - Matt. -- #!/usr/bin/perl $A='A';while(print+($A.=(grep{($A=~/(

killed by SIGSEGV

local/mysqlnew, then symlink ./var to where the db files really are. Is there anything else I need to change? I'll let you know how it goes. Thanks again, Matt -- #!/usr/bin/perl $A='A';while(print+($A.=(grep{($A=~/(...).{78}$/)[0]eq$_}" A A A " =~m{(...)}g)?"A&quo

INSERT value from another table

select this before hand with PHP and somehow store the result in a variable and then insert it? Thanks very much for the help. Cheers, Matt Rudderham - Before posting, please check: http://www.mysql.com/manual.php (the manu

delayed inserts and messages in the .err log

alues in the /etc/my.cnf per the mysql documentation. I am not extremely proficient with mysql and solaris. But, I did notice the log and was wondering if I should be concerned. Any input will be greatly appreciated. Thank you guys and gals :-) matt -- m@ "Like a clou

Probs with AUTO_INCREMENT column

needs to included during compilation? Thanks Matt __ 123India.com - India's Premier Portal Get your Free Email Account at http://www.123india.com - Before

Re: Probs with AUTO_INCREMENT column - thanks

Right, only on an INTEGER col, as documented [sheepish grin] thanks all matt On Mon, 07 May 2001, Peter Pentchev wrote: > > On Mon, May 07, 2001 at 07:21:59AM -0700, [EMAIL PROTECTED] wrote: > > > > Hi all, > > > > I've started using MySQL for the f

SNMP monitoring of mysql servers

Hi all, We have an implementation of mysql servers, and are looking for a decent SNMP monitoring package for them. We are looking to monitor replication, queries per second, throughput, and slow queries. Are there any decent packages that easily integrate? Regards, Matthew Juszczak -- MyS

Random Hangs, Linux AMD 64, 5.0.22 AB Binaries

ame behaviour. I'm stumped, and wondering if anyone has some ideas on how to proceed? Thanks, Matt. [1] We started from the Debian package for version 5.0.22-2bpo1 found here: deb-src http://www.backports.org/debian sarge-backports main and compiled it with --with-openssl [2] Production :

Re: Random Hangs, Linux AMD 64, 5.0.22 AB Binaries

0 r-xp fe:00 51481171 /home/matt/mysql/install/mysql-standard-5.0.22-linux-x86_64-glibc23/bin/mysqld 00a05000-00b68000 rw-p 00505000 fe:00 51481171 /home/matt/mysql/install/mysql-standard-5.0.22-linux-x86_64-glibc23/bin/mysqld 2aee5000-2aeea000 r-xp 08:01 343428 /

Re: Random Hangs, Linux AMD 64, 5.0.22 AB Binaries

On 7/13/06, Jim Winstead <[EMAIL PROTECTED]> wrote: Sounds like the well-known problem with Debian stable's glibc on x86_64: http://hashmysql.org/index.php?title=Opteron_HOWTO#pthread_rwlock_wrlock_hang_with_nptl Just for the record, this resolved it for us. We applied the patch mentioned to t

How to SELECT something (CONCAT) and search the field

e closest I found to try and do what I want to do. I alread tried this: SELECT concat(first_name, ' ', last_name) as fullname FROM user... This did not work. If anyone has any ideas on how to search for users when the first_name and last_name fields are broken up I'm all ears!

Thanks for the help

Thanks for the help, I'll give some of these examples a try~!!! Thanks, Matt Babineau Criticalcode 858.733.0160 [EMAIL PROTECTED] http://www.criticalcode.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[

Some query help

220) ORDER BY distance ASC So I hope you can see what I am trying to get after. Basically I need to fins a distance that can fit each of the numbers in the list. So if 2200 is in the list, 2250 works. If 400 is in the list, 622 works. Thanks for the help on this! Thanks, Matt Babineau Criticalc

RE: Storing huge amount of binary data

Sometimes, the easiest way to do this is to use the file system of the linux machine to store the files, and make reference to them in the DB...storing not data in the DB and getting rid of all your possible problems. Thanks, Matt Babineau Criticalcode 858.733.0160 [EMAIL PROTECTED] http

Searchable/Sortable Encrypted Fields in MySQL?

ddition, I wouldn't be able to install an encrypted file system on the database server). Any suggestions? Thanks much, Matt

MySQL install problems on OSX 10.4

I've just installed MySQL 4 4.1.12_1 +server using darwinports but I can't seem to get past this error. After installing it tells me that it cold not resolve my IP. Mattys-iMac-G5:/opt/local/bin matty$ sudo -u mysql ./mysql_install_db Password: WARNING: The host 'Mattys-iMac-G5' could not be looke

MySQL-Max & Mandriva

go that route should I go ahead and get MySQL 5 while I'm at it? Thanks, Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

comma-separated JOINS

query involving 5 or 6 tables and WHERE arguments which do not deal with the relationships. I would like to assure the efficiency of this query. Thanks in advance, Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[

Why are posts to this list showing up in my inbox?

I am using outlook express to view this mailing list, I do not need the posts actually mailed to my account, how can I address this? Thanks in advance, Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Why are posts to this list showing up in my inbox?

68 665 - Mobile +61 8 8408 4259 - Fax -----Original Message- From: Matt Monaco [mailto:[EMAIL PROTECTED] Sent: Tuesday, 29 November 2005 1:40 PM To: mysql@lists.mysql.com Subject: Why are posts to this list showing up in my inbox? I am using outlook express to view this mailing list, I do not

Re: comma-separated JOINS

in message news:[EMAIL PROTECTED] > Matt, > > >When using JOINS by the simply supplying a comma separated list of > tables in > >the FROM clause, is the ON argument normally associated with a join > intended > >to be addressed in the WHERE clause, or should ON stil

Re: comma-separated JOINS

I just wanted to thank you for such a thorough response, it has helped me a lot as I've always ignored the existence of joins. Thanks, Matt <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > The sequence you use to JOIN a set of tables is sometimes determined >

Re: Windows - logging into MySQL

Well stupid questions are usually responded to with simple answers like rtfm. You'd think you'd be able to at least be able to install a version of the daemon that's still supported before you get into advanced topics like mysql -h ""Beauford"" <[EMAIL PROTECTED]> wrote in message news:[EMAI

Re: about mysqld

I am having similar issues. I moved a copy of mysqld_safe to init.d and removed the old startup script, this had the effect of lowering the number of processes from about 30 something to 7 or 8. However mysqld_safe now appears as a subprocess of rc and under mysqld_safe is mysqld and under t

Re: Social Network, linking members

probuly sounds like noobish! or silly but what i would do is have a new table with 2 colums the first will be a login id and the second will be a login id and i would just do like ... id1 id2 JohnJoe JohnAlex JohnFred Joe Fred FredAlex would mean John as Alex, Fred

Half Hour Sub-query in MySQL vs. 5 Seconds in VFP?

re than a few of those solutions suggested precalculating the distance between zipcodes which only works if the distances are known (only allow 10, 50 and 100 mile radi for example) Any ideas? Thanks in advance! Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Half Hour Sub-query in MySQL vs. 5 Seconds in VFP?

re zip, longitude and latitude but it used zip. It seems like a better index would be longitude or latitude? On the primary query, even though there is an index on custzip it doesn't say it's using ANY indexes. I should probably leave well enough alone... but I'm curious. Thanks again!

Re: Half Hour Sub-query in MySQL vs. 5 Seconds in VFP?

On Fri, Jun 19, 2009 at 11:27 AM, Brent Baisley wrote: > It sounds like you want to use spatial indexes, but they only became > available in v4.1 > http://dev.mysql.com/doc/refman/5.0/en/create-index.html > http://dev.mysql.com/doc/refman/5.0/en/using-a-spatial-index.html That "feels" like the rig

CONCAT with IF?

get any meaningful results if I used it in a where clause... Any ideas on ways I can do this? Thanks! Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Removing Duplicate Records

n to do "INSERT ... ON DUPLICATE KEY..." which gets back to modifying the spaghetti code from option 1. Thanks in advance for your advice. Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Removing Duplicate Records

Ah... Yes. Good point. I like this because I was planning on keeping the output somewhere for a while. (In case we need an "accounting" at some point) So it will be easy enough to dump what's being deleted to the screen while we loop over our candidates. Thanks! On Tue, Jul 14, 2009 at 10:16 AM,

Converting VFP SQL to MySQL

red" queries... I've already manually converted "system" queries and I'm frustrated to the point of giving up and adding a column "untested" and let the end user figure it out but that seems bad from the standpoint of "lazy" and "poor customer exper

Picking Collation Confusion

utine to check for and "correct" collations but then do I need to worry about existing data? Thanks for the advice! Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Renaming a Database

on OSX running a stock MySQL 4.x installation and two are on Windows and I'm not certain the version without checking. Thanks! Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Renaming a Database

ice is stopped it should >> simply find the new instance. > If you have InnoDB tables, there will be a problem. InnoDB maintains the > database name in the shared tablespace, and it will no longer be able to > find those tables. Nope. These are entirely MyISAM tables... So I will p

Re: Renaming a Database

t; New York, NY 10013 > 212-625-5307 (Work) > 201-660-3221 (Cell) > AIM & Skype : RolandoLogicWorx > redwa...@logicworks.net > > -Original Message- > From: Matt Neimeyer [mailto:m...@neimeyer.org] > Sent: Wednesday, August 19, 2009 9:27 AM > To: Paul DuB

mysqldump warning or actual error?

see in mysqldump --help)? Is it truely harmless? Thanks Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

ALTER TABLE order / optimization

h modification on its own line. Thanks! Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

VFP to MySQL Query Optimization

f the select but I'm not sure if that would be better... (IE id in (select contid1 from documents union select contid2 from documents) etc) Any advice or is this the best I'm going to get until I can reorganize the underlying structure? Thanks! Matt -- MySQL General Mailin

Bug? Distinct AS with Order By

quot;productid as myvalue,productname as mydisp" where the values are different. Ultimately I can sort the array I end up with but it seems like this should work. Especially since it did in 4.x. Am I crazy? Doing something wrong? Thanks! Matt -- MySQL General Mailing List For list archives: h

Probability Selects

this but still take into account frequency of use? Thanks in advance! Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

How to purposely corrupt a table

that I can shoot an e-mail to appropriate support personnel to repair the table in question. So two questions really, 1) Does anyone know a good way to cause this to happen, and 2) is there already something written that would assist in this? Thank you, Matt -- MySQL General Mailing Lis

Selecting all minimum values

Hi, I have the following table. How can I select the lowest `place` for each `query` for each `date` (some queries appear twice as they have a different `fullurl`). Thanks for your help. Matt [code] +---+---+++ | place | query

Unbiased opinion needed on access control procedure

ser to the database. Could cause problems with old code, etc. if passwords aren't changed. Which option do you use in your setup? Which do you see more fit? Thanks, Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL Data Vanishing with FireFox

e". This is using PHP 4.3.11 with MySQL 3.23.58 on Apache 2.0.51 on a Fedora system (of unknown version) Thanks in advance... Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL Data Vanishing with FireFox

nt, or truncates $_GET at a different length or some other equally obscure thing but still that the STATEMENT differs and I have something to start tracing from. Here the statement is identical on both browsers and one fails and the other doesn't. Any other ideas? Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Storing a linked list

t "reuse" those hops somehow but not sure. Can anyone recommend a good way to store this data? Thanks! -Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Different max_packet_size sizes

ter/slave/setup? Thanks, Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Master database server continues to crash

may be causing our issues? Or is this most likely a hardware issue? Thanks, Matt One of the outputs in the Error log (there are many more): Version: '5.0.27-standard-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL) mysqld

MySQL 4.1.9 - Requesting Optimization Tips

cache_type = 1 read_buffer_size=2M read_rnd_buffer_size=8M -- Regards, Matt Florido -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL 4.1.9 - Requesting Optimization Tips

Paul DuBois wrote: At 19:21 -0800 2/17/05, Matt Florido wrote: I'm wondering if anyone can provide any tips as to how to conserve resources. Currently, I see 10 instances of mysqld running. Each instance is approximately 18MB. For my application of MySQL, I don't require a large

RE: How to Version Control a database

s being done - if it is mostly developmental/code/objects, then the above method seems to work well - if the work is mostly represented in data, then it won't really apply! Cheers, Matt -Original Message- From: Will Merrell [mailto:[EMAIL PROTECTED] Sent: 20 February 2005 14:00 To:

RE: using between

query that way. MySQL should beable to reduce the amount of rows it needs to look at pretty quickly this way. Matt Babineau Criticalcode w: http://www.criticalcode.com p: 858.733.0160 e: [EMAIL PROTECTED] -Original Message- From: Rob Brooks [mailto:[EMAIL PROTECTED] Sent: Friday, March 25

MySQL 5.0.3-beta has been released

re that all updates are executed in a serialized fashion, because they are executed serialized when binlog is replayed. (Bug #7879) * Fixed a rare race condition which could lead to FLUSH TABLES WITH READ LOCK hanging. (Bug #8682) * Fixed a bug that caused the slave to

re: problem with mysql-max-5.0.3 for Solaris 8 32 bit

ke a bit to propagate out to the mirrors (probably 8-10 hrs). Thanks for notifying us about this. Matt -- Matt Wagner, Production Engineer MySQL AB, www.mysql.com Northfield, MN, USA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL 4.1.11 has been released

s separate per-statement events. For a server serving as a replication master, this caused replication to fail when the event was sent to slave servers. (Bug #8436) Enjoy! Matt -- Matt Wagner, Production Engineer MySQL AB, www.mysql.com Northfield, MN, USA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Field property question!

Can I setup a table so that no matter how data is entered into it (web form, command line) The data in one of the columns ALWAYS gets converted to uppercase? I remeber MSSQL had this feature of being able to apply a function to a field in its configuration. Thanks! Matt

RE: Field property question!

ay 10, 2005 10:58 AM To: Matt Babineau; mysql@lists.mysql.com Subject: RE: Field property question! [snip] Can I setup a table so that no matter how data is entered into it (web form, command line) The data in one of the columns ALWAYS gets converted to uppercase? I remeber MSSQL had this feature of

MySQL 4.1.12 has been released

for auto-increment not working with INSERT..SELECT and NDB storage engine. (Bug #9675) Enjoy! Matt -- Matt Wagner, Production Engineer MySQL AB, www.mysql.com Northfield, MN, USA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http:/

Re: MySQL 4.1.12 has been released

>> http://dev.mysql.com/downloads/ and mirror sites. > > How long is it before the Dec OSF downloads are updated usually? Dan, We had to skip Dec OSF for this release due to some unresolved build problems. Sorry. Matt -- Matt Wagner, Production Engineer MySQL AB, www.mysql.c

Re: MySQL 4.1.12 has been released

equest is already in to our web team to update the download page, should be coming up shortly. Matt -- Matt Wagner, Production Engineer MySQL AB, www.mysql.com Northfield, MN, USA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Repairing/Restoring a Database

While updating a record in a database, I inadvertantly forgot a "where" statement; so instead of changing just one record, I changed all 900 records in the database. I've been trying to figure out how to fix this. My latest backup (through mysqldump) was about fifteen days ago. I'm fine with res

Re: Repairing/Restoring a Database

One more note for anyone else who runs into this problem: before running the source command, I dropped the database, recreated it, and then ran the mysqldump file into the empty database. Matt > On 5/25/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > You can try do

Re: Repairing/Restoring a Database

Thank you *SO* much, Shawn. Doing it manually did the trick. I'm sure you know how frustrating this can be. I really, really appreciate your help. Whew! best, Matt On 5/25/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > You can try doing the same steps, but break it do

MySQL 5.0.6-beta has been released

27; tables being written twice to the binary log. (Bug #9149) * `InnoDB': Prevent `ALTER TABLE' from changing the storage engine if there are foreign key constraints on the table. (Bug #5574, Bug #5670) * `InnoDB': Fixed a bug where next-key locking doesn't allow the insert which does not produce a phantom. (Bug #9354) If the range is of type `'a' <= uniquecolumn', `InnoDB' lock only the RECORD, if the record with the column value `'a'' exists in a CLUSTERED index. This allows inserts before a range. * `InnoDB': When `FOREIGN_KEY_CHECKS=0', `ALTER TABLE' and `RENAME TABLE' will ignore any type incompatibilities between referencing and referenced columns. Thus, it will be possible to convert the character sets of columns that participate in a foreign key. Be sure to convert all tables before modifying any data! (Bug #9802) * Provide more informative error messages in clustered setting when a query is issued against a table that has been modified by another `mysqld' server. (Bug #6762) Enjoy! Matt -- Matt Wagner, Production Engineer MySQL AB, www.mysql.com Northfield, MN, USA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql 'start' spawns 10 instances of mysqld

Hi Scott, Those aren't processes. There is 1 process with many threads and your system is reporting them as separate processes. :-) Hope that helps. Matt - Original Message - From: "Scott Stingel" Sent: Monday, December 01, 2003 4:47 PM Subject: mysql 'start

[OT] Importing content from Word

atabase so that it can be searched by the site administrators. There would also be an original copy of the word doc uploaded to the server. Is there a way of doing this? Cheers, Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.

Query to emulate what mysqldump does

Hey All- Are there any query equivalencies to mysqldump? I am looking for a way to get a complete database dump via php and I don't have access to the system CLI to run mysql dump. TIA- Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

RE: Query to emulate what mysqldump does

php file using exec...see > > http://www.php.net/exec > http://www.mysql.com/mysqldump > > looks like > > $foo = exec("mysqldump database [options]"); I thought about that Jay, but the mysql server is not on the webserver machine. Any other suggestions? -Matt

RE: Query to emulate what mysqldump does

On Wed, 2003-12-03 at 15:22, Jay Blanchard wrote: > [snip] > I thought about that Jay, but the mysql server is not on the webserver > machine. Any other suggestions? > [/snip] > > phpmyadmin will allow you to connect to the remote MySQL server and do > dumps What if I don't have phpmyadmin availa

Re: fulltext search speed issue with SQL_CALC_FOUND_ROWS

You might want to try your fulltext search IN BOOLEAN MODE to see if that runs any faster. :-) Hope that helps. Matt - Original Message - From: <[EMAIL PROTECTED]> Sent: Thursday, December 04, 2003 9:13 AM Subject: fulltext search speed issue with SQL_CALC_FOUND_ROWS > I h

Re: Named Pipe crashes on MySQL (4.1.1 alpha) WinXP

Hi Ed, Yeah, I just installed today's 4.1.1-alpha-nt on Win2k SP3 and get the same thing. :-( Sucks, 'cause named pipes are a lot faster for me than TCP/IP. And I was really looking forward to this release. It's just not the same with TCP/IP. :-( Matt - Original Messag

RE: Problem with mysqlimport

If the the file is on the same machine as your shell is running, specify --local when running mysqlimport. Matt -Original Message- From: Paweł Filutowski [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 10:27 AM To: [EMAIL PROTECTED] Subject: Problem with mysqlimport I tryed

RE: Asking again... please help me!!!

MySQL doesn't return HTTP error codes. Your problem is not with mysql but with Dreamweaver's browser not being pointed at a running webserver. Did you set up Apache (or some other server) when you set up PHP and prove that both are functioning? Matt -Original Message- From:

RE: Problem with mysqlimport

Paul, --local is a valid option for mysqlimport in 3.23.49 according to the manual. (Source: http://www.cict.fr/app/mysql/manual.html#mysqlimport) What is the entire command you are using? Matt -Original Message- From: Paweł Filutowski [mailto:[EMAIL PROTECTED] Sent: Tuesday, December

RE: How to READ/WRITE directly on MyISAM data files ?

There's no way to "hide" a row. However, I can think of a zany solution. Update your tables using a hash of all the data in the row. That way you don't need an id field. Fair warning: this is not a GOOD solution but it does address the problem. Matt -Original Message

Re: Lost connection to MySQL server during query - pls help

Hi Vanessa, I don't think I saw a reply to this... You can just reconnect to MySQL if you get this error. :-) Trying to send the query a second or third time may also make the client try to reconnect again. Hope that helps. Matt - Original Message - From: "Kiky&quo

Re: newbie question

Hi Peter, You can probably safely have at least 1000-2000 tables in a single database. Hope that helps. Matt - Original Message - From: "peter" Sent: Friday, November 28, 2003 12:03 PM Subject: newbie question > Hi > I am a webdesigner/hosting reseller > my ques

Re: Temporary tables rights

le to TRUNCATE it, I think. And actually, if you can TRUNCATE the other tables (if the DELETE privilege allows it), isn't that just as bad as DROPping them? :-) Matt - Original Message - From: adburne To: [EMAIL PROTECTED] Sent: Friday, December 12, 2003 11:31 AM Subject: Temporary tab

Re: ALTER TABLE .. ORDER BY

rds. :-) Hope that helps. Matt - Original Message - From: "Chris Elsworth" Sent: Wednesday, December 10, 2003 12:49 PM Subject: ALTER TABLE .. ORDER BY > Hello, > > Just a quickie. Does anyone know if issueing an ALTER TABLE t ORDER BY c > is as good as an OP

Spatial Extension in MySQL 4.1.1-alpha

; select AsText(g) from geom; +---+ | AsText(g) | +---+ | Point(1 1)| +---+ 1 row in set (0.00 sec) Does anyone know what I am missing? Thanks, Matt --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.543 / Virus Database: 33

RE: Spatial Extension in MySQL 4.1.1-alpha

eomFromText('POINT(1 1)') ); Query OK, 1 row affected (0.00 sec) mysql> SELECT AsText(g) FROM geom; ++ | AsText(g) | ++ | POINT(1 1) | ++ 1 row in set (0.00 sec) mysql> Thanks again, Matt -Original Message- From: Paul DuBois [mai

How boolean full-text search finds matches?

ficant. Then I tried adding a wild-card to the end of words in another search (the wild-card did not make more rows match as far as I know), but that made it a little slower (I'd expect that, if anything). Is there any explanation for why adding wild-cards would make a search faster? Th

How boolean full-text search finds matches?

ficant. Then I tried adding a wild-card to the end of words in another search (the wild-card did not make more rows match as far as I know), but that made it a little slower (I'd expect that, if anything). Is there any explanation for why adding wild-cards would make a search faster? Th

Re: MySQL 4.0.17 has been released

e-sensitive like on *nix. e.g. *Force* the case used in queries match that of the directory/file name... Matt - Original Message - From: "Reverend Deuce" Sent: Wednesday, December 17, 2003 3:41 PM Subject: Re: MySQL 4.0.17 has been released > I agree, 100%. We live in a m

Re: high water mark

ou want to reclaim the deleted space, you can do so by running OPTIMIZE TABLE. Be aware that it may take awhile to run on a large table! Hope that helps. Matt - Original Message - From: "jamie murray" Sent: Wednesday, December 17, 2003 2:42 PM Subject: high water mark Guys,

Binaries for PocketPC

Hi, Does anyone know of a MySQL distribution for the PocketPC? Thanks, Matt --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.543 / Virus Database: 337 - Release Date: 11/21/2003 -- MySQL General Mailing List For list

Re: show processlist

d things to see which index to use, if any, when looking up rows in a table. Now we both know. ;-) Hope that helps. Matt - Original Message - From: "Andrius Jakas" Sent: Thursday, December 18, 2003 6:08 AM Subject: show processlist > Hi, > > show processlist display

Re: How boolean full-text search finds matches?

Hi Sergei! Thanks for replying again. I hope I'm not wasting too much of your time with my questions! :-) - Original Message - From: "Sergei Golubchik" Sent: Thursday, December 18, 2003 7:17 AM Subject: Re: How boolean full-text search finds matches? > Hi! >

  1   2   3   4   5   6   7   >