LOAD INDEX INTO CACHE behaviour

index will be (worst case) 3.2-10e bytes but I certainly don't have 32G of RAM to load it into. How is LOAD INDEX INTO CACHE going to keep index access from disk-thrashing and do I need to manually tune key_buffer_size to take advantage of it? -- - michael dykman - [EMAIL PROTECTED] -- MySQL

Re: select only values 0

You can't conditionally select columns with a mere select statement.. In whatever langauge you are using to process (perl, Java, whatever) you are going to have to select the entire row and use locig to pick out the columns that you want - michael dykman On Thu, 2005-02-17 at 11:44, Jan

Re: MySQL and DNS problem

address the 'foo' resolves to when the server looks it up for example, $ host foo might translate to foo.domain.com - 20.20.20.21 [external ip] but foo is connecting as 192.168.1.21 [internal ip] and Mysql will reject the connection. -- - michael dykman - [EMAIL PROTECTED] -- MySQL

Re: JOIN Problem

AS 'division', COUNT(team_info.division) AS 'count', division_info.spots as 'spots' FROM division_info LEFT == OUTER == JOIN team_info ON division_info.division = team_info.division WHERE application='ACCEPTED' GROUP BY division_info.division -- - michael dykman - [EMAIL PROTECTED

Re: MySQL and DNS problem

On Thu, 2005-02-17 at 12:21, Ian Meyer wrote: Michael Dykman wrote: On Thu, 2005-02-17 at 10:41, Ian Meyer wrote: Hello everyone, We have a few MySQL servers (4.1.8) running on RedHat ES3. We're having problems when trying to use hostnames in the grant command. Example: create

Re: JOIN Problem

with odbc. thanks! From: Michael Dykman [EMAIL PROTECTED] To: Albert Padley [EMAIL PROTECTED] CC: \MySQL List\ mysql@lists.mysql.com Subject: Re: JOIN Problem Date: Thu, 17 Feb 2005 12:20:44 -0500 On Thu, 2005-02-17 at 12:08, Albert Padley wrote: I have the following 2 tables: CREATE

Re: UNIX_TIMESTAMP function

SELECT unix_timestamp(mydatetime), ... from mytable where DAYNAME(mydatetime) is not in('Saturday','Sunday'); On Thu, 2005-02-17 at 16:34, Jerry Swanson wrote: How to select datetime using UNIX_TIMESTAMP excluding Saturday and Sunday? -- - michael dykman - [EMAIL PROTECTED] -- MySQL

Re: Header files data types

/ On Thu, 2005-02-17 at 13:12, Mohsen Pahlevanzadeh wrote: Dears,I must use data type in C++,same MySQL type. But i don't name of their header files. Please guide me. -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: how to make question that check the last hour

. If it was a 'TIMESTAMP' this same value could be indexed easily and compared via the function TIMESTAMPDIFF() See http://dev.mysql.com/doc/mysql/en/datetime.html and http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html - michael dykman Jesper wrote on 15/02/2005 13:15:43

Re: Mysql kill fails

. Typically, the 'mysql.server' script is run as root. -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Tricky Join with Animal-DB

one pic for an animal)? Thank you for you ideas! Martin -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql heartbeat

. -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: insert...select with auto increment

? -steve I don't think you can anticipate the value but, if I under stand you correctly, this aught to work (I assume you got 31337 from last_insert_id(): insert into table (field1, field2) select (field1,field2) from table where autoincrement_key = 31337 -- - michael dykman - [EMAIL

Re: Compiling MySQL from source

is mysqld it still doesn't create mysqld file with mass of errors. Does anybody know hot to create mysqld ? Also, source code mysqld.cpp exists too. Thanks, Helena -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: developing an interface

' instead of 'lynx'? I have been a lynx user for years (I do a lot of work where I only have ssh/console access to my clients systems) but the newer elinks which I recently discovered is very nice with a cleaner, less cluttered screen. -- - michael dykman - [EMAIL PROTECTED] -- MySQL General

Re: !! Help with query: Where Date = MAX(Date)

where start_date = '20050204') Any help much appreciated Graham I think this conveys the idea: SELECT year, month FROM `dc_months` WHERE start_date = '20050204' ORDER BY start_date DESC LIMIT 1 -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List

Re: Cant connect to mysql error :20031 /10061

to the server. - michael dykman On Fri, 2005-02-04 at 12:48, [EMAIL PROTECTED] wrote: Hi I've a question I have a delphi program that connects to a mysql database via obdc, and works perfect in the lan and in the server, I want to know if I can enter the database if I have the program installed

Re: help please : ERROR 2006: MySQL server has gone away

was related to the data-directory permissions.. Having sorted it out, the server has been extremely stable under heavy load for several continuous months now. - michael dykman On Thu, 2005-02-03 at 08:38, Marois, David wrote: We still have the problem... In the error log, I have nothing

Re: Social Networking querys

several times) by the time you are down to the 6th degree. The efficiency has an exponential inverse relationship to the degree. - michael dykman On Wed, 2005-02-02 at 10:47, listsql listsql wrote: Since I read about Foaf [ http://www.foaf-project.org/ ], I become interested with Social

Re: Best way to store numeric data?

single-precision FLOAT column. A precision from 24 to 53 results in eight-byte double-precision DOUBLE column. -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Pulling a database schema out of a unknown MySQL database?

The easiest route is to use mysqldump with the --no-data option. it will dump the full schema info including feign keys, etc. -- michael dykman On Wed, 2005-02-02 at 13:31, Dan Stromberg wrote: I have a system with set of web pages that use PHP and a MySQL database. Apparently the old

Re: Best way to store numeric data?

I stand corrected.. I thought I recalled that the IEEE for double precision offered 18 digits of accuracy (been years since I looked at it) but a little research shows me 15. - michael dykman On Wed, 2005-02-02 at 14:02, Roger Baklund wrote: Michael Dykman wrote: [...] The MySQL

Re: Best way to store numeric data?

of, oh, 12 places to the left of the decimal. It seems like a waste. -Galen On Feb 2, 2005, at 7:02 PM, Michael Dykman wrote: I stand corrected.. I thought I recalled that the IEEE for double precision offered 18 digits of accuracy (been years since I looked at it) but a little

Re: mysqld ended Can't get mysql running

Debra, look in /opt/mysql/data for an error file which should contain some hint of why it stopped.. could be many things.. permissions on the data files, full disk broken paths, etc... - michael dykman On Tue, 2005-02-01 at 15:43, Debora Gomes.unitech wrote: Hi ALL it reports

Re: Problem with SELECT SQL_CALC_FOUND_ROWS

state = 'CA' limit 0, 5 Very odd that this happens, I am running MySQL 4.1.9 Thanks, Matt Babineau Criticalcode w: http://www.criticalcode.com p: 858.733.0160 e: [EMAIL PROTECTED] -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http

RE: Problem with SELECT SQL_CALC_FOUND_ROWS

library versions especially any shared ones.. If you have a test system you can use, you might consider experimentally building both PHP and MySQL from source and explicitly set them to use the same versions of any shared libraries? Might be a bit of overkill... - michael dykman On Tue, 2005-02

Re: make test grant_cache test failing

running your test as a regular user and this should fix itself. -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: creating a new user with mysql on 4.0.20a

on where they are logged in from. GRANT ALL ON llcopy.* TO auser.'%' IDENTIFIED BY 'thepassword'; -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Enum or Int

? Best regards Olivier Salzgeber -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http

Re: Login question

PROTECTED]' (Using password: YES) Argh... your help is appreciated. Respectfully, ASP -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Python library for cluster support?

client libraries built for 3.x and the 4.1 servers which support clusters. you might have to rebuild python against a 4.1 library On Wed, 2004-07-28 at 00:32, Joe Wong wrote: Hi, may I know of the current MySQL python library supports MySQL cluster or not? Regards, - Wong -- - michael

Re: daisy-chaining replication

TO ...' and the error log is substantially the same. On Tue, 2004-07-27 at 14:59, Paul DuBois wrote: At 14:31 -0400 7/27/04, Michael Dykman wrote: Hello, I'm running a development build of 4.1.3 and trying to set up of chain of replication servers. The first level of replication works

Re: daisy-chaining replication

TO ...' and the error log is substantially the same. On Tue, 2004-07-27 at 14:59, Paul DuBois wrote: At 14:31 -0400 7/27/04, Michael Dykman wrote: Hello, I'm running a development build of 4.1.3 and trying to set up of chai thank you again Paul, I did miss that one altogether, but that does

Re: Spamcease ?

that I have to validate my email at Spamcease. Looking at the mail header mail seems to come from tgpnexus.com? Anybody else getting this type of emails? Alexander Newald -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com

daisy-chaining replication

lend me a clue? -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL and SSL

could someone please tell me which versions of mysql support SSL connections for both clients and replication slaves? thank you. -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: INSERT if record NOT EXISTS

you. Regards, Adai. -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

File size limits with mysql 4.1

this or have any practical advice on how to transcend this limitation? -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: File size limits with mysql 4.1

the way. On Mon, 2004-07-26 at 14:19, Paul DuBois wrote: At 12:48 -0400 7/26/04, Michael Dykman wrote: I am using a development build of 4.1.3 (the last 4.1.3 release I think; mysql-4.1.3-beta-nightly-20040628) so I suppose I have this coming, but here goes: As I am running on RH Enterprise

Re: File size limits with mysql 4.1

I apologize for my skepticism of 15 minutes ago. I finally _read_ http://dev.mysql.com/doc/mysql/en/Table_size.html carefully, and indeed your suggestion is dead on. thank you again. On Mon, 2004-07-26 at 14:19, Paul DuBois wrote: At 12:48 -0400 7/26/04, Michael Dykman wrote: I am using

Re: select * on all current?

all current dateposted per office? i have tried.. sql select * from datafiles where dateposted current(); And i think its wrong, i could not find how to get it. -- Louie Miranda http://www.axishift.com -- Louie Miranda http://www.axishift.com -- - michael dykman

Re: how to switch off logging?

will affect mysql performance. - michael dykman - [EMAIL PROTECTED] J S wrote: Hi, I would like to switch off the logging that creates the large files below (in the mysql data directory) Could someone tell me how to do this please? Thanks, js. # ls -l total 5418648 -rw-rw 1 mysqlmysql

Re: Upgrade from 3.23 to 4.0 - mysql.sock error

/mysql/mysql.sock. - michael dykman - [EMAIL PROTECTED] Jough P wrote: Greetings all, I recently upgraded from mysql 3.23 to 4.0 on a Fedora box. I moved the old installation to a directory called old_mysql in my home directory. I can start the new installation using mysqld_safe . Now, when I

Re: pattern matching - but in reverse

time would be much more efficient. A procedural script/program to convert historical data would also be pretty straightforward. - michael dykman - [EMAIL PROTECTED] Luke Majewski wrote: Hi everyone, ok, so I know how to use RLIKE to match regular expressions. However, let's say I have an isbn

Re: How to get count(id) when count is zero?

This should work select C.cId cc, count(D.catId) dd from C left outer join D on C.cId = D.catId group by cc; - michael dykman - [EMAIL PROTECTED] Kapoor, Nishikant wrote: Hello List, It sounds like a simple query but I have spent quite a few hours already, and still do not have

what is the appropriate forum to discuss test errors?

error. As of this mornings patch, I'm back to failing on test #2. Can anyone suggest the best place to get some advice on this? - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

<    1   2   3   4   5