Query cache not working with JDBC driver?

2003-06-09 Thread Greg
JDBC driver, it won't use the cache when the it sends the same query. Does anyone have any clues why this is? I read somewhere that there's a problem when the driver uses compiled prepared statements and can't access the cache then, but other than that it should use the query cache, right? Thanks Greg

Re: replication problem

2003-07-31 Thread greg
Beacuse of this type of mail , i got listed on spam bag for using the mailing lists inform the linux comunity of my site , wich is a free service. If see this kind of junk on any mailing list ill make it my personal mission to have you domain fried Don't post unless it's goning to help the opens

Re: www.SQL-Scripts.com web site

2004-04-19 Thread Greg
Hello, Announcing the release of a new web site : www.SQL-Scripts.com At www.SQL-Scripts.Com you can find a collection of SQL Scripts for many different database system. Using our search system you can find scripts that you need quickly and simply. If you have scripts that you use why not lodge

ANN:www.SQL-Scripts.Com

2004-04-19 Thread Greg
Sorry no subject on the last email Hello, Announcing the release of a new web site : www.SQL-Scripts.com At www.SQL-Scripts.Com you can find a collection of SQL Scripts for many different database system. Using our search system you can find scripts that you need quickly and simply. If you have

Re: MySQL v SAB DB

2003-02-25 Thread Greg
SAPDB doesn't have collation (i.e. case-sensitivity). Be aware of this before you make a choice. While I was trialing it, the support was exceptional with very quick response from actual SAP engineers, but the lack of case-sensitivity was a show-stopper for me. Greg - Original Me

problem with d/l

2001-07-04 Thread greg
Hi, I can't download http://www.mysql.com/Downloads/mysqlgui/mysqlgui-win32-static-1.7.5-1.zip Can you help? Been trying several times and from several places thanks bye greg - Before posting, please check:

Re: problem with d/l

2001-07-04 Thread greg
//www.mysql.com/Downloads/mysqlgui/mysqlgui-win32-static-1.7.5-1.zip > Can you help? > > Been trying several times and from several places > > thanks > > bye > > > greg > - Before posting, plea

Poddible SHOW DATABASE || TABLE bug in 3.23.33

2001-03-08 Thread greg
>Description: SHOW DATABASE and SHOW TABLES and mysqlshow all return empty lists (i.e a nice list of blanks - no of blank lines equals number of databases / tables) >How-To-Repeat: Do a mysqlshow or SHOW DATABASES under mysql >Fix: >Submitter-Id: >Originator:Greg Cop

Installing Calendar 0.9.33 on Mac OS X

2001-10-25 Thread Greg
Newbie here who has PHP and MySQL going, but can't figure out how to install calendar. I suspect this is because I don't understand UNIX and permissions and which account I'm in. Here are the instructions edited: Unpack the calendar software in its own directory somewhere where your web server

Installing Calendar 0.9.33 on Mac OS X

2001-11-01 Thread Greg
Newbie here who has PHP and MySQL going, but can't figure out how to install calendar. I suspect this is because I don't understand UNIX and permissions and which account I'm in. Here are the instructions edited: Unpack the calendar software in its own directory somewhere where your web server

unlocking read only table

2001-05-16 Thread Greg
One of the tables of my database suddently became read-only; when I try to add a line, I get: ERROR 1036: Table 'Requests' is read only I'm alone working on this table, and didn't lock it. Does anyone know how I can unlock th

apache/php/modperl incomp?

2001-06-14 Thread Greg
pache/sbin/httpd definition of __dig_vec /Local/Library/Perl/darwin/auto/DBD/mysql/mysql.bundle definition of __dig_vec It occurs with both static and dso, but only from perl (php can access the DB with no error). What can I do?

Re: apache/php/modperl incomp?

2001-06-15 Thread Greg
hat it doesn't actually use this parameter ? Greg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread,

mysql on a locked media on windoze?

2001-02-02 Thread Greg
le to merge both client and server into a huge binary, or may the server can run run as a "side-application"? TIA Greg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://

mysql/DBD on Darwin/mosx

2001-02-02 Thread Greg
System(strtol.o) definition of _strtol ../blib/arch/auto/DBD/mysql/mysql.bundle definition of _strtol I wasn't able to find any reference to "_strol" in the sources, what's going on??? TIA Greg - Before posting

mysqladmin shutdown timeout

2001-02-02 Thread Greg
I can run mysqld by the book on MacOS X but trying to shut it down with "mysqladmin -u root -p shutdown" timeout after a long time, leave the daemon running... What can I do ? TIA Greg - Before posting, please chec

Multiple defs of strtol.o (was RE: Mysql/DBD Error)

2001-02-06 Thread Greg
brary/Frameworks/System.framework/Versions/B/System(strtol.o) definition of _strtol /Local/Library/Perl/darwin/auto/DBD/mysql/mysql.bundle definition of _strtol PLEEEAAASE help me!!! Greg - Before posting, please check:

Re: i'm at a complete loss?

2006-05-29 Thread Greg Maruszeczka
On Sun, 28 May 2006 20:17:53 -0400 "Daniel McQuay" <[EMAIL PROTECTED]> wrote: > Hello list, > > I just installed MySQL on my FreeBSD box here at home and am having a > few problems with privileges. I can connect to mysql using; mysql -u > mysql and there is no password needed. However, when I try

RE: Installing MySQL on Windows Server 2003 Standard x64 Edition

2006-08-25 Thread Greg Joss
Go to Control Panel>System>Advanced. Click Environmental Variables and Find the PATH variable under System Variables and add the full path, i.e. c:\Program Files\...\mysql\bin to the variable. -Original Message- From: David Lazo [mailto:[EMAIL PROTECTED] Sent: Friday, August 25, 2006 2:54

Re: Zip Code & Distance

2006-08-29 Thread Greg Donald
7;t know how accurate that would be. Does anyone have any ideas? http://www.cryptnet.net/fsp/zipdy/ -- Greg Donald http://destiney.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Returning a Value from a Stored Procedure

2006-10-08 Thread Greg Lindstrom
the recently inserted record (it's more a problem on how to *get* the id value to return than how to return it). If anyone can show me how to do this or point me to the appropriate documentation, I would be grateful. --greg

Re: storing images in the database

2006-10-11 Thread Greg Donald
rick/tricks-sept-2001.php?article=tricks-sept-2001&kind=tr&id=2033&open=1&anc=0&view=1 -- Greg Donald http://destiney.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: UDF failure

2005-07-06 Thread Greg Fischer
c/mysql/en/c-api-prepared-statements.html Functions: http://dev.mysql.com/doc/mysql/en/stored-procedures.html Hope that helps. Greg On 7/6/05, Gleb Paharenko <[EMAIL PROTECTED]> wrote: > Hello. > > > > >When attempting to load a new function with the mysql cli client the

Re: Stored Procedure in MySQL 5.x

2005-07-15 Thread Greg Fischer
So, remove the "//" and insert the "$$" and it will work great. Greg On 7/15/05, Scott Hamm <[EMAIL PROTECTED]> wrote: > How effective is Stored Procedure in MySQL 5.x? > > -- > Power to people, Linux is here. > > -- Greg Fischer 1st Byte Solution

Re: Why does query load faster after executing 2nd time? (Query Caching DISABLED, Key-Cache already fully loaded)

2005-07-17 Thread Greg Whalin
Filesystem buffering? pow wrote: Hi everyone, Im puzzling over why a query loads faster the second time I execute it. I am sure it is not query cached, because that is off. I also made sure that the key that is used was already cached b4 i even executed the query the first time. So it is not l

Re: Make a report like this...

2005-07-20 Thread Greg Fortune
You might try --xml or --html with a different separator. Greg -- Greg Fortune Enterprise Systems Eastern Washington University Phone: 509-359-6690 Email: [EMAIL PROTECTED] On Wednesday 20 July 2005 03:28 pm, Dan Bolser wrote

Data sync offline

2005-08-24 Thread Alex Greg
Hi, Our company is considering migrating some tablesfrom MyISAM to InnoDB, as it has row-level locking and other improvements over MyISAM. However, one of the things we do at the moment is rsync the MySQL data directory to our development server every night over an 2Mbps ADSL connection (as we h

Re: Linux+AMD64+MySQL.

2005-08-30 Thread Greg Whalin
RV Tec wrote: Folks, I'm used to run MySQL (4.0) with OpenBSD (3.7). Now I've decided to give Linux a shot, to see if I could gain some serious performance. The server I'm using is a dual Opteron 246, with 2GB RAM, LSI MegaRAID 320. CentOS 4.1 x86_64 seems to be a good OS. Although I though

Re: compare tables from two systems

2005-10-05 Thread Greg Donald
systems? We are sure the structure of > the tables are all the same and we need to compare the > data. Any advice is welcome. Thanks. mysqldump -l -B db1 > db1.sql mysqldump -l -B db2 > db2.sql diff db1.sql db2.sql > diff.sql -- Greg Donald Zend Certified Engineer MySQL Core Certification http://destiney.com/

Re: How do you set a Primary Key when uploading data into a table?

2005-10-10 Thread Greg Donald
ne. > > Any help is appreciated. Add an auto_increment option to your Id field. -- Greg Donald Zend Certified Engineer MySQL Core Certification http://destiney.com/

Re: Can't start mysql 5.0.15

2005-11-11 Thread Greg Maruszeczka
Saffa Kemokai wrote: > I am unable to start mysql after several trials and fixes. I compiled > a mysql 5.0.15 source for FreeBSD 5.3. It doesn't seem to have placed > the files in their proper locations. Below is what I keep getting and > I don't know now how to get it working. What do I need to

Re: Band width consume

2005-12-07 Thread Alex Greg
On 12/4/05, Luiz Rafael Culik Guimaraes <[EMAIL PROTECTED]> wrote: > Dear Friends > > Is their an Page with data of how much bandwidth mysql consume when using > remote servers? mysql> show status like 'Bytes_%'; +++ | Variable_name | Value | ++---

Re: GUI (linux X based or web based) for mysql

2005-12-16 Thread Greg Maruszeczka
Dotan Cohen wrote: I keep a lot of personal information in a MySQL database. I have a few querys premade for the wife to use, but we have gotten to the point where we need a solution for her to be able to run her own queries. She is NOT about to learn SQL, and myPHPadmin is a little too compicate

Re: problems with old isam tables

2006-01-12 Thread Greg Fortune
file. When upgrading between major versions (4.0, 4.1, 5.0, 5.1, etc), it's always wise to make a full backup of the data files and a full backup of the database using mysqldump. The output from mysqldump is just SQL so it is always the safest route if you run into problems. Greg Fortun

Re: problems with old isam tables

2006-01-12 Thread Greg Fortune
Also, you may find that check table/repair table are able to fix the problem. See http://dev.mysql.com/doc/mysql/en/Table_maintenance.html for more information. Greg On Thursday 12 January 2006 08:28, Greg Fortune wrote: > That looks a little odd. Do isam tables have a .myi file for e

Re: Query: Order for the Earliest Latest date

2006-01-24 Thread Greg Fortune
In addition to the id_Site, you also need to grab the MAX(Time) so you have something to sort by. This requires a little trick known as a "groupwise maximum." See http://dev.mysql.com/doc/mysql/en/example-Maximum-column-group-row.html for an explanation and some examples. Greg F

Re: Innodb table locked on delete

2006-02-10 Thread Greg Whalin
Innodb is indeed row level locking. You are likely thinking of BDB which uses memory page level locking. gw sheeri kritzer wrote: > Innodb is not row-level locking -- it's memory-page-level-locking. A > memory page is usually small, so it's almost like row-level locking, > but not quite. Perha

Re: Replication from multiple masters?

2006-03-01 Thread Greg Donald
http://dev.mysql.com/doc/refman/5.1/en/replication-features.html MySQL only supports one master and many slaves. -- Greg Donald Zend Certified Engineer MySQL Core Certification http://destiney.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: manage multiple mysql servers on different hosts?

2006-03-01 Thread Greg Donald
ariables' returns, plus what databases exist on each server, are there > any tools that can do that? Can phpMyAdmin manage multiple mysql > servers? Additional MySQL servers can be defined in phpMyAdmin's config.inc.php file. -- Greg Donald Zend Certified Engineer MySQL Core Certific

Re: Update or insert with a single SQL statement?

2006-03-31 Thread Greg Donald
ment (since my ISP limits > the total number of calls I can make in a day) that will either > insert a new record if the referring domain is not already in there, > or simply update the timestamp if the referring domain is already in > there. > > Possible? REPLACE INTO http://dev.my

Re: Tuning a Server with >10,000 databases

2006-04-01 Thread Greg Whalin
Gary Huntress wrote: > > > David Logan wrote: >> mos wrote: >> >>> At 09:27 PM 3/31/2006, you wrote: >>> I have been offering free database hosting for over 4 years and I've been doing it on a shoestring.My last MySQL server was a generic 1GHz system with 256MB RAM running Redh

Re: Query time taken on disk

2014-07-14 Thread greg . lane
t you are looking for utilizing these tools that make performance schema much easier to use and under stand. Greg -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: How to keep myqsl backup server

2006-11-24 Thread Alex Greg
I need to create an application where i will be requiring a backup server like when one server fails i can switch automatically to the other server hosted somewhere else , now the data needs to be consistent on both the servers, one sol is i keep automated backups on the primary server and restore

Re: Replication error: Unable to get certificate

2006-11-27 Thread Alex Greg
Master_SSL_Allowed: Yes Master_SSL_CA_File: /root/.mysql/cacert.pem Master_SSL_CA_Path: /root/.mysql/ Master_SSL_Cert: /root/.mysql/client-cert.pem Master_SSL_Cipher: Master_SSL_Key: /root/.mysql/client-key.pem Seconds_Behind_Mast

Re: What is the "db.opt" ?

2006-12-11 Thread Alex Greg
Would like to know what is the archive "db.opt". http://www.google.co.uk/search?q=mysql+db.opt&start=0&ie=utf-8&oe=utf-8&client=firefox-a&rls=org.mozilla:en-US:official -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Gaining statistics from MySQL

2007-02-21 Thread Alex Greg
On 2/20/07, Clyde Lewis <[EMAIL PROTECTED]> wrote: I'm looking to find a way to determine the number of transactions that a particular database is processing each min/hour/day/month/year http://dev.mysql.com/doc/refman/4.1/en/show-status.html http://dev.mysql.com/doc/refman/4.1/en/server-statu

Re: how would mysqld restart affect dynamically set global variables?

2007-03-14 Thread Alex Greg
We're running mysql 4.1.20. If I understand the manual correctly, I can change max_connections while mysqld is running without restart mysqld to make the change take effect Correct. But what if mysqld restarts later in some other situations, like machine reboot, would my (global) change on ma

Re: Repair query overloading server

2007-03-14 Thread Alex Greg
On 3/8/07, Gary Sewell <[EMAIL PROTECTED]> wrote: I'm having a problem with a single repair query seemingly taking over the whole server. I'll try and explain…. Large table or 1.2m rows, running a repair on this causes the query queue to grow and grow and finally max out. The problem isn't tabl

Re: Innodb corruption help needed!

2007-03-14 Thread Alex Greg
On 3/11/07, Jean-Sebastien Pilon <[EMAIL PROTECTED]> wrote: I am running a mysql database server and we experienced a power failure. The mysql server does not want to restart because innodb is corrupted. Version info: Mysql version 4.1.11-Debian_4sarge7-log Debian sarge Reiserfs filesystem Wha

Re: Default root password not blank?

2007-03-14 Thread Alex Greg
On 3/13/07, Merlin <[EMAIL PROTECTED]> wrote: I just compiled mysql4.1.22 on a suse 9.3 machine. All went fine, but when I try to change the password I get prompted for one. So I hit return as it is supposed to be blank, right? But it seems to be not: /usr/local/mysql/bin # ./mysqladmin -u root

Re: MySQL Benchmarking

2007-03-15 Thread Alex Greg
On 3/14/07, Clyde Lewis <[EMAIL PROTECTED]> wrote: System Configuration: Sun Microsystems sun4u Sun Fire E2900 System clock frequency: 150 MHZ Memory size: 65536 Megabytes CPU: 12 @ 1200 MHz I'm looking for a tool that will allow us to determine the max number of databases that can run in a sin

Re: find a particular record.

2007-06-29 Thread Alex Greg
I am doing this to move data from one table to other and getting below error. How can check this particular record at this row number 921888 in dats_tem table. insert into reports1.dats1 select * from dats_tem; ERROR 1292 (22007): Incorrect datetime value: '-00-00 00:00:00' for column 'P_LAS

Re: General Query Log -- No Timestamp

2007-06-29 Thread Alex Greg
On 6/26/07, Brown, Charles <[EMAIL PROTECTED]> wrote: The MYSQL general query log does not include timestamp of queries that it logs because queries are logged many many seconds before they are executed. Which version of MySQL are you running? I'm running 5.0.22 on my desktop, but I'm fairly s

Re: key on the month portion of a date field

2005-02-09 Thread Greg Fortune
) Then, add an index on that column and test your queries against the new index. I'd be surprised if you saw much increase in speed, especially as your data set grows. Greg On Wednesday 09 February 2005 09:17 am, Gabriel B. wrote: > Short Version: > is there any way to make an index

Re: Innodb auto increment - reset itself automatically?

2005-02-11 Thread Greg Whalin
http://dev.mysql.com/doc/mysql/en/innodb-auto-increment-column.html Rishi Daryanani wrote: Hi, My database is mostly made up of MyIsam tables, and some InnoDB tables. One particular Innodb table works fine with an auto increment field. The table is updated often, records being added and deleted at

Re: INSERT queries hang on amd64

2005-02-16 Thread Greg Whalin
. Greg Donny Simonton wrote: I know this may be strange, but have you turned on innodb on the box? Even if don't use it? I have 8 amd64 boxes and have never experienced this problem you are talking about. They range from single proc to quad proc. Never this problem but all of them have i

Re: wikipedia down, slashdot covering, mysql mentioned

2005-02-22 Thread Greg Whalin
Wikipedia. Greg [EMAIL PROTECTED] Meetup.com Daniel Kasak wrote: Scott Haneda wrote: There is a thread over at /. about WikiMedia being out due to a power outage <http://slashdot.org/articles/05/02/22/0151213.shtml?tid=95> MySql is getting bashed pretty hard in some cases as apparently, in

Re: wikipedia down, slashdot covering, mysql mentioned

2005-02-22 Thread Greg Whalin
I was under the impression that fsync() was only buggy in Linux in the 2.4 kernels. Is it still problematic in 2.6 series? Greg -- [EMAIL PROTECTED] Meetup.com Heikki Tuuri wrote: Peter, a buggy fsync() in Linux is one of the possible reasons here. If an InnoDB tablespace gets corrupt in a

Re: wikipedia down, slashdot covering, mysql mentioned

2005-02-22 Thread Greg Whalin
Daniel Kasak wrote: Greg Whalin wrote: Many data centers do not allow customers to install their own UPS inside the rack. I am not sure if this is the case with Wikipedia, but it is definitely the case at the data center we are hosted in. I would love to shove one in after reading the horror

Innodb - raw partition vs filesystem store?

2005-02-23 Thread Greg Whalin
recent experiences of LiveJournal/Wikipedia sway these answers? Just going over some thoughts in my head and want to see if any good discussion can come from this? Greg -- [EMAIL PROTECTED] Meetup.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: wikipedia down, slashdot covering, mysql mentioned

2005-02-24 Thread Greg Whalin
be complaining that MySQL isn't ACID-compliant because it can't survive a fire. -Rich Exactly. No ACID database can ensure integerity in such a situation. Postgres, Oracle, or any other transactional DB would have suffered the same fate in these two cases (LiveJournal, Wiki). Greg -- MyS

Re: Innodb - raw partition vs filesystem store?

2005-02-24 Thread Greg Whalin
perience (running mysql on Opteron + linux 2.6.10 w/ myisam tables), we have seen very slow performance when running intensive IO operations (deleting 20 million rows from a 50 col table) and we have experienced a greater number of index corruption on the opterons than on our intel dbs. Greg -- [E

Re: wikipedia down, slashdot covering, mysql mentioned

2005-02-24 Thread Greg Whalin
Rich Lafferty wrote: On Thu, Feb 24, 2005 at 09:10:32AM -0500, Greg Whalin <[EMAIL PROTECTED]> wrote: Exactly. No ACID database can ensure integerity in such a situation. Postgres, Oracle, or any other transactional DB would have suffered the same fate in these two cases (LiveJournal

Innodb and Linux 2.6 Async I/O ??

2005-02-28 Thread Greg Whalin
Just found and read this study: http://www.distlab.dk/badger/Publications/report0403.ps and was curious to see if anyone has any additional thoughts as to the contents? Greg -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: Join Limits

2005-03-07 Thread Greg Fortune
Any chance of condensing some of the flag fields into bit fields? Alternatively, can you represent the variables as (rule id, variable name, variable value) in a single table rather than using lots of columns/tables? Greg Fortune On Monday 07 March 2005 10:31 am, Kevin Cowley wrote

Re: what is select_limit (and what is it used for)?

2005-03-07 Thread Greg Fortune
oduct joins that output millions of lines of data. Greg Fortune On Monday 07 March 2005 10:48 am, Caron, Christian wrote: > Hi, > > the default "select_limit" is set to 1000. What does this mean and how can > it affect a server? > > Is there some information out there

Re: remove trailing character

2005-03-10 Thread Greg Fortune
How about UPDATE table set email = TRIM(TRAILING '>' FROM email) http://dev.mysql.com/doc/mysql/en/string-functions.html Greg Fortune On Thursday 10 March 2005 03:29 pm, Scott Haneda wrote: > I managed to mess up and email storage addresses are in the format of > [EMAIL PR

Re: subqueries *not* using indexes for IN clause

2005-04-04 Thread Greg Whalin
unusable in IN() statements which is how most people use subselects IMO. greg Kevin A. Burton wrote: http://www.peerfear.org/rss/permalink/2005/04/02/BrokenMySQLSubqueries Whats up with this? As far as I can tell MySQL subqueries in 4.1.x releases are totally broken with IN clauses The major

Re: zip code search within x miles

2005-04-15 Thread Greg Donald
On 4/15/05, Scott Haneda <[EMAIL PROTECTED]> wrote: > How are sites doing the search by zip and coming up with results within x > miles? Is there some OSS zip code download that has been created for this? http://marc.theaimsgroup.com/?l=php-general&m=110547634827453&w=2

Re: MySQL not using optimum disk throughput.

2005-05-06 Thread Greg Whalin
6 is not a good solution. Yet, Mysql recommends exactly this config and in fact, does not seem to even support (via support contract) a 2.4 solution for Opteron + Mysql. Greg Dathan Pattishall wrote: What kernel are you running. If your running 2.6.x use the deadline scheduler or downgrade to 2.4.

Re: MySQL not using optimum disk throughput.

2005-05-06 Thread Greg Whalin
Kevin Burton wrote: Greg Whalin wrote: We have seen the exact same thing here. We used the deadline scheduler and saw an immediate improvement. However, we still saw much worse performance on our Opteron's (compared to our older Xeon boxes). We ended up rolling back to Fedora Core 1 2

Re: MySQL not using optimum disk throughput.

2005-05-06 Thread Greg Whalin
uch w/ production dbs) and ended up rolling back to 2.4. Kevin Burton wrote: Kevin Burton wrote: Greg Whalin wrote: Deadline was much faster. Using sysbench: test: sysbench --num-threads=16 --test=fileio --file-total-size=20G --file-test-mode=rndrw run So... FYI. I rebooted with elevator=dea

Re: MySQL not using optimum disk throughput.

2005-05-07 Thread Greg Whalin
similar reports (from Friendster) about their use of Suse 2.6 and Opterons being similarly slow. We are currently running MyIsam tables, but plan on switching to Innodb in the next month or two btw, so our performance problems are w/ MyIsam. Greg Peter Zaitsev wrote: On Fri, 2005-05-06 at 19:01

Re: Opteron HOWTO?!

2005-05-09 Thread Greg Whalin
I am all in favor of this idea. Currently, this info is scattered all over the web, and finding it can be time consuming (even w/ Google). I see lots of people jumping the same hurdles, so a central location for this info seems it would greatly benefit the community. Greg Kevin Burton wrote

Re: MySQL not using optimum disk throughput.

2005-05-09 Thread Greg Whalin
Kevin Burton wrote: Greg Whalin wrote: I suspect this is an OS issue. Our Opteron's were completing large data update queries aprox 2-3 times slower than our Xeons when running under 2.6. After a switch to 2.4, Opteron's are faster than the Xeons. I mentioned NPTL bein

Re: MySQL not using optimum disk throughput.

2005-05-09 Thread Greg Whalin
Kevin Burton wrote: Greg Whalin wrote: We are currently running 2.3.2 (Fedora Core 1) on our Opterons. When we were still running linux 2.6, we were on 2.3.3 (Fedora Core 2). Yeah... we were being bitten by 2.3.2's NPTL implementation for MONTHs before I heard a rumor that the Internet Ar

Re: Opteron HOWTO?!

2005-05-10 Thread Greg Whalin
correct? Any problems w/ ext3? Sorry to bombard you w/ questions, but we have had nothing but horrible performance using Opterons, and any specifics you can give would help to clear up this mess. I know that I am not the only person who is seeing this flakyiness. Thanks, Greg Dathan Pattishall

Re: Preventing slaves from falling behind masters...

2005-05-12 Thread Greg Whalin
Donny Simonton wrote: With Mysql you should ONLY use RAID10. Everything else is not worth your time. I would argue that a large stripe (RAID0) would be a better solution for slaves in a large replicant network. Why waste the drive space and performance on a RAID10 when you have multiple replic

Re: SATA vs SCSI

2005-05-12 Thread Greg Whalin
Newer SATA drives are supporting command queueing, which should really help their performance. I think when SATA-2 becomes more available, SATA will start being a more viable choice and start rivaling SCSI performance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

Re: 4.1.12 Crashing on Mandrake 10.1

2005-05-19 Thread Greg Whalin
Hmmm, I downloaded source and compiled, and had an instant segfault. Rolled back to 4.1.11. I assumed it was something funky w/ my compile, but after reading all the above posts ... ??? Mark Matthews wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Donny Simonton wrote: I'm not sure but I

Re: Seriously.. When are we going to get subqueries?!

2005-06-07 Thread Greg Whalin
They do use indexes if you use them to build derived tables and are pretty fast. The only case where I see them not using indexes when I think they should is when you use a sub-query for an IN() clause. Kevin Burton wrote: OK... Subqueries in 4.1 are totally broken. They don't use indexes.

Re: Seriously.. When are we going to get subqueries?!

2005-06-08 Thread Greg Whalin
le because they do not use indexes correctly. This is a legitimate complaint, and one that I personally hope Mysql looks into and repairs. I echo Kevin's thoughts and I rarely even have a use for sub-queries (given I got used to them not being available). Greg -- MySQL General Mailin

Re: Seriously.. When are we going to get subqueries?!

2005-06-09 Thread Greg Whalin
Jeff Smelser wrote: On Thursday 09 June 2005 01:26 pm, George L. Sexton wrote: Another limitation in MySQL is that you can only have one timestamp column with a default of CURRENT_TIMESTAMP. How many friggin times do I have to say that this is not an issue with 4.1 and above? Which, BTW,

Re: PHP MySQL connection problem

2005-06-10 Thread Greg Donald
might check your network cards. Had this happen to me once. Reseated the card in the database server, fixed it right up. -- Greg Donald Zend Certified Engineer http://destiney.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql/radius populate db question

2003-11-28 Thread Greg G
CT on RADIUS.attrib to radius@'%';) What I don't understand is how I was able to do it from the command line but it's not working from the perl script? Any advice? Thanks. -Greg G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Query Help

2003-12-02 Thread Greg Jones
l Front gives me the following error: 'You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select l2.ltsysid from lientrak as l2 where l2.lientraknum like' I am running MySQL Front version 2.5, and MySql version 4.0.15. Thanks, Greg

Debug options for mysqlimport?

2003-12-02 Thread Greg G
looking for is to get the text of warnings that were generated during and import. -Greg G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

4.0.16 doesn't like my Berkley DB version!

2003-12-03 Thread Greg G
The configure script appears to really be checking for 3.2.9, in any case. I'm going to override this for now, but I wanted to know if that's going to cause problems down the road. Thanks. -Greg G -- MySQL General Mailing List For list archives: http://lists.mysql.com

Openssl support?

2003-12-04 Thread Greg G
I compiled MySQL 4.0.16 --with-openssl --with-vio and when I look at the variables, "has_openssl" is set to "NO". What could have happened to cause this? -Greg G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://li

Openssl support?

2003-12-04 Thread Greg G
I compiled MySQL 4.0.16 --with-openssl --with-vio and when I look at the variables, "has_openssl" is set to "NO". What could have happened to cause this? -Greg G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://li

Re: Openssl support?

2003-12-04 Thread Greg G
I realized that I should probably mention that I've got OpenSSL 0.9.7c installed. I'm seeing this on both Solaris and Debian hosts. I compiled MySQL 4.0.16 --with-openssl --with-vio and when I look at the variables, "has_openssl" is set to "NO". What could have

with-openssl failing?

2003-12-05 Thread Greg G
x27;m not seeing any errors during the configure or compile phases. Thanks. -Greg G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

[REPOST] Openssl support not activated?

2003-12-08 Thread Greg G
gure or compile phases. What could have happened to cause this, and how can I fix it? Thanks. -Greg G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Is mySQL right for me??

2003-12-08 Thread GREG BARBER
on of queries that are then arranged on the output page according to preset positioning instructions. Regards Greg MAIL IS CONFIDENTIAL. If you have received this e-mail in error, please notify us by return e-mail and delete the document. If you are not the intended recipient you are hereby not

[RE-REPOST] Openssl support not activated?

2003-12-10 Thread Greg G
d Debian hosts. I'm not seeing any errors during the configure or compile phases. What could have happened to cause this, and how can I fix it? Thanks. -Greg G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: [RE-REPOST] Openssl support not activated?

2003-12-11 Thread Greg G
Mark Matthews wrote: Greg G wrote: I'm still having trouble figuring this out. Please help! I compiled MySQL 4.1.1 --with-openssl --with-vio and when I look at the variables with mysqladmin, "has_openssl" is set to "NO". I've got OpenSSL 0.9.7c installed. I

Re: [RE-REPOST] Openssl support not activated?

2003-12-11 Thread Greg G
7;s probably the problem. :) However, I didn't get any messages when running configure. I've even specified --with-openssl-include and --with-openssl-lib since the --with-openssl directory doesn't seem to be getting using to determine those directories. I'm not sure what's happening. I have a lot of trouble debugging configure. -Greg G

Re: [RE-REPOST] Openssl support not activated?

2003-12-12 Thread Greg G
had to do the same thing in the dbug, mysys, extra, regex, isam, merge, innobase/*... I gave up after a few of these. Any ideas where to go from here? This is for mysql 4.0.16, openssl 0.9.7c and gcc 2.95.4 on a Debian linux box (2.2.20). Thanks. -Greg G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL with SSL enabled

2003-12-17 Thread Greg G
know if you manage to get SSL working during the compile phase. I found an open bug ( http://bugs.mysql.com/bug.php?id=1915 ) which pretty much indicates that you're not going to be able to build in SSL support. -Greg G -- MySQL General Mailing List For list archives: http://lists.mysq

4.0.17 - Still no SSL joy

2003-12-26 Thread Greg G
such file or directory make[2]: *** [strxmov.o] Error 1 make[2]: Leaving directory `/usr/local/src/mysql-4.0.17/strings' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/src/mysql-4.0.17' make: *** [all] Error 2 -Greg G -- MySQL General Mailing List For list archives: htt

  1   2   3   4   >