RE: Query Cache

t has been returned from the Cache rather than the Direct from Raw Tables. Hope that is a bit clearer Cheers Skex -Original Message- From: Eric Bergen [mailto:[EMAIL PROTECTED] Sent: 07 December 2004 17:30 To: Alexis Cheshire Cc: [EMAIL PROTECTED] Subject: Re: Query Cache 'show'

RE: Query Cache

Do you know if this is available thru the C API .. Could a User Defined Function be written to return this? Any more ideas would be great.. Thanks Skex -Original Message- From: Eric Bergen [mailto:[EMAIL PROTECTED] Sent: 07 December 2004 16:50 To: Alexis Cheshire Cc: [EMAIL PROTECTED

Query Cache

Hi, Is there a way to access if a Query is returning its record from QUERY_CACHE or not? E.g. $sql="SELECT * FROM TABLE"; $result=db_query($sql); print $result; //If query NoT returned from mysql_query_cache() //Would Output something like: Array["status"]["cached"]=0; Array["status"]["count"]

Help with SLOW query

Help: (and apologies if this is posted to the wrong list..)(pls let me know where to post if so.. Thx ;-) I have *inherited* an App that uses PHP / MySQL. THe internal search function within the application that I am supporting uses the following DB Table structure and runs the Query below to r

Scratch with alias in MySQL

like this: stmt = con.createStatement(); Alternatively I execute this query in MySQLFront and it's work fine, obviously the statement is not UPDATABLE!! I think: the answer is that RecordSet UPDATABLES or SCROLL_SENSITIVE doesn´t work with alias, is that correct?? Any coments... Thanks in advanc

RE: mysql memory usage

Sorry, but I disagree :/ I always used 250MB of key buffer, and MySQL never allocates more than 50MB, in my database. Read buffer is only allocated when full scans are done. Join buffer is allocated when there are joins without index use. Sort buffer is allocated when needed, and etc... Alexis

RE: mysql memory usage

Hi, I think that MyISAM uses the key buffer only if needed. The same happens with almost all the other buffers (read buffer, sort buffer, etc.). ;) Alexis -Original Message- From: Benjamin KRIEF [mailto:[EMAIL PROTECTED] Sent: segunda-feira, 3 de Novembro de 2003 21:00 To: [EMAIL

FW: performance while creating indexes

but you can try setting your sort buffer to a high value. ;) Alexis -Original Message- From: William Baker [mailto:[EMAIL PROTECTED] Sent: segunda-feira, 3 de Novembro de 2003 19:37 To: [EMAIL PROTECTED] Subject: Re: performance while creating indexes Now why didn't I think of a single

RE: LIMITS

Just do Select ... limit 50, 15; (if i'm wrong, see MySQL manual, Section LIMIT Syntax) ;) Alexis -Original Message- From: Cummings, Shawn (GNAPs) [mailto:[EMAIL PROTECTED] Sent: quinta-feira, 16 de Outubro de 2003 16:49 To: [EMAIL PROTECTED] Subject: LIMITS when I do a que

Re: MYSQL table crashed and doesn't repair

Execute in shell myisamchk --help This will list a serie of options to repair your tables. Obviously, this only works to MyISAM tables. ;) Alexis Quoting Stanley Joseph <[EMAIL PROTECTED]>: > Dear All , > A few tables of my database crashed and are not getting repaired .What is &g

Re: slow performance with large "or" list in where

mysql prompt like this: mysql> source fileName; (for help, type 'help' in mysql prompt) Is this your problem? ;) Alexis Quoting Marc Slemko <[EMAIL PROTECTED]>: > If I do a query such as: > > SELECT * from foo where fooid = 10 or fooid = 20 or fooid = 03 ... >

Recover deleted records

.MYD and .MYI files still appear to be showing the original data. Thanks Alexis SQL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

Recover deleted records

Hi, I've managed to delete all the records in a table, well haven't we all done it sometime!, and was wondering whether it's possible to recover them. I notice that the .MYD and .MYI files still appear to be showing the original data. Than

MyIsam Table Damage

SQL ... I have a myisam table that registers documents in my database .. There is a longtext field for the actual document data in HTML the table (file , MYD) is about 1.2 MB, but from 300 records it had only reports 6 ... I use repair table extended and works fine until I get and error no en

RE: storing PDF files in mysql ?????

database just add time to the loading of a page, albeit it very minimal, but as I am designing a site which will host huge numbers of photos, this will make a big difference. Any thoughts or advice on this topic will be most appreciated. Regards Alexis -Original Message- From: kayamboo

Obtaining a count of the First and Last values

e in a MySQL Query? The main place where I fall down is when trying to COUNT upon the SUM of a set of values, especially when trying to GROUP BY it. MTIA Alexis - Before posting, please check: http://www.mysql.com/manual.php (t

Obtaining a count of the First and Last values

e in a MySQL Query? The main place where I fall down is when trying to COUNT upon the SUM of a set of values, especially when trying to GROUP BY it. MTIA Alexis - Before posting, please check: http://www.mysql.com/manual.php (t

Innodb Tables in MySql 4.0 ?

Ive just downloaded Mysql Max 4.0 binary distribution for Windows ... Does this distribution supports Innodb tables ? How do I turn on this feature ? I follow the instruction (modifying my.ini to include support for innodb ) buy Mysql does not start ( I am using Winmysqladmin ) and I am using my

RE: NewBie Question; Backups?

Yes I've seen most of MySQL USERS use BACKUP tables instead of mysqldump ... I don't know if it's for the fact the is easieste to restore? -Original Message- From: Michael Collins [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 9:59 AM To: MySQL List Cc

RESTORE ??? RE: NewBie Question; Backups?

Thanks and How DO I RESTORE IT ??? -Original Message- From: Tyler Longren [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 9:43 AM To: ROGGER ALEXIS VASQUEZ MARTINEZ; [EMAIL PROTECTED] Subject: Re: NewBie Question; Backups? mysqldump -uusername -ppassword -hhostname

NewBie Question; Backups?

How do I make a Backup of a MYSQL database ,,, It is simple as just copying the files of each table ? or exists a command to make backup ( including TEXT Fields ) ? Thanks -Original Message- From: Michael Widenius [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 10:51 AM To:

How to Get the New Number inserted in a AutoIncrement Field

I know that this is a old question, but I really need to know how can I get the number that Mysql use in a autoincrement field of a record I just inserted ... Is there any function like LAST_INSERTED or something like that ... Thanks a lot ---

GEMINI Table Type

Hi : First of all I've test for a short period MYSQL, I think is great ,,, recently I was navigating MYSQL.COM and I found and read about the dispute with MYSQL.ORG I enter the site to see what it was ... I notice they promote a type of table name GEMINI ... that support the ACID properties ... W