Re: quick question on innodb_log_file_size

6:static MYSQL_SYSVAR_LONGLONG(log_file_size, innobase_log_file_size, The docs are wrong - I'll have that updated. Best regards Mark -- Mark Leith MySQL Regional Support Manager, Americas Sun Microsystems, Inc., http://www.sun.com/mysql/ -- MySQL General Mailing List For list archi

Re: Wrong PID

N', to switch to NPTL 'export LD_ASSUME_KERNEL=2.6.9', to switch back to LinuxThreads 'export LD_ASSUME_KERNEL 2.4.19'. I'd be interested in seeing if that stores the right PID for you whilst running under NPTL. Best regards Mark -- Mark Leith MySQL Regional Support Manage

Re: trigger that calls a webservice??

mcached and just use these anyway! ;) Cheers, Mark -- Mark Leith MySQL Regional Support Manager, Americas Sun Microsystems, Inc., http://www.sun.com/mysql/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Sun and mysql

: Marketing Potential. :) -- Mark Leith, Manager of Support, Americas MySQL AB, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Monitoring and analysis tool

Baron Schwartz wrote: Correct. But if you are willing to patch your server, you can: http://www.mysqlperformanceblog.com/2007/10/31/new-patch-for-mysql-performance/ This is in 5.1 as well now :) Regards Mark -- Mark Leith, Manager of Support, Americas MySQL AB, www.mysql.com Are you

Re: Monitoring and analysis tool

slow.log filename (can be wildcard), default is '*', i.e. match all -i NAME name of server instance (if using mysql.server startup script) -l don't subtract lock time from total time http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html

Re: run out of memory

Baron Schwartz wrote: Mark Leith wrote: And in practice, a 32bit binary is actually limited to around ~2.5-2.7G, rather than a full 4G. What are the practical memory limits for 64-bit binaries? I have heard that MySQL's indexing code is only 32-bit safe anyway, and I assume for exampl

Re: run out of memory

Baron Schwartz wrote: Mark Leith wrote: And in practice, a 32bit binary is actually limited to around ~2.5-2.7G, rather than a full 4G. What are the practical memory limits for 64-bit binaries? I have heard that MySQL's indexing code is only 32-bit safe anyway, and I assume for exampl

Re: run out of memory

4bit. And in practice, a 32bit binary is actually limited to around ~2.5-2.7G, rather than a full 4G. Cheers, Mark -- Mark Leith, Senior Support Engineer MySQL AB, Worcester, England, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list a

Re: MySQL Ends Enterprise Server Source Tarballs

uld require commercial binaries, not GPL binaries, as I understand. Cheers, Mark -- Mark Leith, Senior Support Engineer MySQL AB, Worcester, England, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Mysql monitering and performance tool

Baron Schwartz wrote: Mark Leith wrote: Baron Schwartz wrote: I stand corrected. I don't know why I didn't think of this! So you guys had to go the route of parsing InnoDB status too, huh? Fun, isn't it! Indeed, it is a rather interesting thing to do ;) Made even bet

Re: Mysql monitering and performance tool

istant future! Cheers, Mark -- Mark Leith, Senior Support Engineer MySQL AB, Worcester, England, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysql monitering and performance tool

full output (transactions and all) to the monitor screen (it just monitors for key statistics and alerts when necessary). Cheers, Mark -- Mark Leith, Senior Support Engineer MySQL AB, Worcester, England, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- MySQL General Maili

Re: Greater function ?

it's opposite LEAST().. Cheers, Mark -- Mark Leith, Senior Support Engineer MySQL AB, Worcester, England, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.

Re: Can't find file: 'general_log'

t any corresponding data files. If this is the case then just 'rm' the general_log.frm and slow_log.frm files from the mysql database directory, and all these errors should go away. Cheers, Mark -- Mark Leith, Support Engineer MySQL AB, Worcester, England, www.mysql.com Are you MySQ

Re: expire_logs_days

tinue discussion on there? Cheers, Mark -- Mark Leith, Support Engineer MySQL AB, Worcester, England, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: expire_logs_days

testing does show that it's not working for you. Cheers, Mark -- Mark Leith, Support Engineer MySQL AB, Worcester, England, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: expire_logs_days

a.pid drwxr-x--- 53 mysql wheel 1802 May 2 22:26 mysql drwxr-x---9 mysql wheel 306 May 3 10:52 test I declare 'No Bug Here' :) At least on the current versions of 5.0 (tested on 5.0.40), anyway. Cheers! Mark -- Mark Leith, Support Engineer MySQL AB, Worcester

Re: expire_logs_days

Mark Leith wrote: Juan Eduardo Moreno wrote: Hi, I'm experience using expire_log_days and don't work. I set this parameters in the CNF and when the time of ( for example 5 days) is in, don't delete anything. On my expirience, this parameters don't work ( 5.0.27). I

Re: expire_logs_days

(on 5.0.40) and will see how it works out. Cheers! Mark -- Mark Leith, Support Engineer MySQL AB, Worcester, England, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://li

Re: Need help with query

ping, order by etc., and finally HAVING clauses are done (where one can use a column alias, when not available within a WHERE clause). However, you should be able to use them in an ORDER BY - as they do exist at that point - so I'm not sure that issue would have been related to this.

Re: Alias a function result?

use is *not* the alias but the individual column. Results of an aggregate function are *never* available in a WHERE clause. You need a HAVING clause. Ahh indeed, I was only looking at the aliasing of the group concat function. :) Teach me for skimming emails! Mark -- Mark Leith, Suppor

Re: Alias a function result?

ture? Perfectly legal, will not get changed. :) Cheers, Mark -- Mark Leith, Support Engineer MySQL AB, Worcester, England, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:ht

Re: Need SUPER Privilidge for UPDATE?

anual: http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html Triggers within 5.0 require the user (within the DEFINER clause, or executing the statement against the table when using CURRENT_USER) to have the SUPER privilege. Within 5.1 this moves to the TRIGGER privilege. Best regards M

Re: Strange Crashing Error - Assertion failed: fixed == 1, file item.h, line 1601

/upload o Link this in the bug report as well Do you have any way to reproduce this as yet? Cheers, Mark -- Mark Leith, Support Engineer MySQL AB, Worcester, England, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://

Re: Fulltext problem

your test, keeping in mind the above. Cheers, Mark -- Mark Leith, Support Engineer MySQL AB, Worcester, England, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Sort Select by List

ION will give index accesses, the "tricks" on the ORDER BY will cause filesorts (although, they will still likely be in memory unless you the table is large, again). You should of course EXPLAIN and tune accordingly (with response times as well). Cheers, Mark -- Mark Leith, Supp

Re: Sort Select by List

rder of office = 'Exec', 'VP', 'Dir'... Thanks, order by right(office,1) or make an extra column for ordering Or be really smart :) SELECT * FROM team ORDER BY office='Exec' DESC,office='VP' DESC,office='Dir' DESC; Not ma

Re: date_add function

s instance. UPDATE this_table SET this_date = '$this_date', future_date = '$this_date' + INTERVAL 90 DAY; Same thing still applies really.. And quote your dates... Cheers, Mark -- Mark Leith, Support Engineer MySQL AB, Worcester, England, www.mysql.com Are you M

Re: date_add function

(), future_date = NOW() + INTERVAL 90 DAY; This is probably along the lines of what you want.. Cheers, Mark -- Mark Leith, Support Engineer MySQL AB, Worcester, England, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lis

Re: How can i drop tables with the same predix by using only one single statement?

drop_table_prefix('test', 't')// Query OK, 0 rows affected (0.01 sec) mysql> SHOW TABLES// ++ | Tables_in_test | ++ | a1 | | a2 | ++ 2 rows in set (0.00 sec) Hope this helps. Mark -- Mark Leith, Support

Re: need help on before insert trigger

OK, 1 row affected (0.00 sec) mysql> SELECT * FROM bookmarks// +--+--+ | id | title| +--+--+ | one | one bookmark | | xxx | hawt xxx sex | +--+--+ 2 rows in set (0.27 sec) Cheers, Mark -- Mark Leith, Support Engineer MySQL AB, Worcester, En

Re: forcing leading 0 for numeric fields

from zeros; +--+--+--+ | i| j| k| +--+--+--+ | 0023 | 3244 | 0123 | +--+--+--+ 1 row in set (0.08 sec) Make sure you specify the length of the digits that you would like padded to within the INT specification. Best regards Mark -- Mark Leith, Support

Re: PRINT statement?

user -BN dbname < file.sql mysql -u root -BN -e "SHOW DATABASES" etc. Regards Mark -- Mark Leith, Support Engineer MySQL AB, Worcester, England, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql

Re: UPDATE question

you are swapping values: UPDATE table_name SET FIELD4 = (@tmp:=FIELD4), FIELD4 = FIELD1, FIELD1 = @tmp; Best regards Mark -- Mark Leith, Support Engineer MySQL AB, Worcester, England, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archi

Re: How to find size of my database

hat given for Index_length within SHOW TABLE STATUS / INFORMATION_SCHEMA.TABLES as well. Of course, this is not an easy method to use, there is no simple command to quickly analyze this data (yet), it's mostly a manual process reading through the dump file - however shouldn't be that har

Re: describe table : improvement

le you can add a comment using COMMENT keyword: CREATE TABLE a_table ( a_column CHAR(30) CHARSET utf8 COMMENT 'Some comment' ); Is this... what you needed ? -- Gabriel PREDA Senior Web Developer Best regards Mark -- Mark Leith, Support Engineer MySQL AB, Worcester, England, www.mys

Re: Random 'select permission denied' since upgrade to 5.0.18

d around fairly quickly - so it's a fairly obvious one every time I see it now ;) Best regards Mark -- Mark Leith, Support Engineer MySQL AB, Worcester, England, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://list

Re: Random 'select permission denied' since upgrade to 5.0.18

I'm not very comfortable tweaking these values in a production environment while I have no indication that it could solve the problem. Jorrit It seems you are running in to Bug #7209: http://bugs.mysql.com/bug.php?id=7209 This is fixed in 5.0.19 now. Best regards Mark -- Mark Leith, Suppo

Re: innodb in 4.1.18

e MyISAM files). Correct, to move any InnoDB tables between machines you need: o All ib data files o All ib logfiles o All related database directories and frm files o Your my.cnf/ini http://dev.mysql.com/doc/refman/5.0/en/innodb-backup.html Regards Mark -- Mark Leith, Support Engineer MySQL A

Re: Please help: recovering db from crash

of the Essentials package. I tried to install a similar setup on another server, then copy the data\ folder over. The MySQL service starts, but I am not able to login, even as root. Is there anyone who can advise me on the recovery steps? Appreciate your feedback! -- Mark Leith, Support

Re: Accountability with MySQL

ways, I don't see a great problem (when weighing them against extra costs, in both space and speed). If you can get away with not using NULL as well, then great. This argurment will, however, carry on between "academia" and "the real world" for at least the next 4000 year

Re: mysql on Windows

Hi Neil, Neil Tompkins wrote: Is anyone running mySQL on Windows 2003 server platform. Are there any known problems ? There is a known bug for Windows 2003 - bug #12071: http://bugs.mysql.com/bug.php?id=12071 You should use 4.0.19 or 5.0.19. Best regards Mark -- Mark Leith, Support

Re: Same question, better example

the example. Best regards Mark -- Mark Leith, Support Engineer MySQL AB, Worcester, England, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: database link

CHAR(5) SQL> insert into [EMAIL PROTECTED] values (100,1,'test','test',1,1,'PG'); 1 row created. ---change prompts--- mysql> use sakila Database changed mysql> select max(film_id) from film; +--+ | max(film_id) | +-

RE: colum totals

as this doesn't work too well on statements that have multiple GROUP BY columns ;) You can read more about WITH ROLLUP here: http://dev.mysql.com/doc/mysql/en/group-by-modifiers.html Mark Leith > -Original Message- > From: Tony Leake [mailto:[EMAIL PROTECTED] &g

RE: Date Ranges

--++ | seconds_diff | minutes_diff | hours_diff | +--+--++ | 2592000 |43200 |720 | +--+--++ 1 row in set (2.78 sec) Query OK, 0 rows affected (2.97 sec) Hope this helps, Mark Mark Leith Cool-T

RE: Change Datatype (time)

#x27;ve got a column which is > time datatype and I'd like to return the values in a > vb-compatible datatype. > You can use DATE_FORMAT() for this: http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html Mark Mark Leith Cool-Tools UK Limited http://www.cool-tools.co.uk htt

RE: Can I use the information from "SHOW STATUS" in a SELECT statment ?

be supported or not, but it would be nice to grab the output of a SHOW command in a cursor, I was discussing this in #mysql on freenode last night as it happens.. Mark Mark Leith Cool-Tools UK Limited http://www.cool-tools.co.uk http://leithal.cool-tools.co.uk -- No virus found in this outg

RE: Why can't I revoke usage from user?

evoke usage on *.* from frank; Query OK, 0 rows affected (0.00 sec) mysql> show grants for frank; +---+ | Grants for [EMAIL PROTECTED]| +---+ | GRANT USAGE ON *.* TO 'frank'@'%' | +

RE: how to change ft_max_word_len value beyond 254

characters. I recently built a dictionary table for fun, with ~500,000 words from the English language in the table, so I can verify this for you if you want ;) Perhaps your false misses are due to something else, such as ft_min_word_len, or the values being in more than 50% of the rows etc.

RE: "mysql" database characterset

rset for MySQL > 4.1 and up? > > With regards, > > Martijn Tonies > Database Workbench - tool for InterBase, Firebird, MySQL, > Oracle & MS SQL Server Upscene Productions > http://www.upscene.com Database development questions? Check > the forum! > http://www.da

RE: GRANT EXECUTE in MySQL 4.1

effect at all until 5.0.something. This is all documented in the "Privileges provided by MySQL" manual page I believe.. EXECUTE on a GLOBAL level would, of course, allow the grantee to call any stored procedure. HTH Mark Mark Leith Cool-Tools UK Limited http://www.cool-tools

RE: Table and Data access only through procedures

TE permissions. To add the privileges with the example above would be "GRANT EXECUTE ON PROCEDURE admin.update_user_password TO .." to each user that you want to allow to update a password. Hope this helps out a little with the original question as well.. Mark Mark Leith Cool-Tools U

RE: STORED PROCEDURE

> -Original Message- > From: Mark Leith [mailto:[EMAIL PROTECTED] > Sent: 02 August 2005 15:56 > To: mysql@lists.mysql.com > Subject: RE: STORED PROCEDURE > > > -Original Message- > > From: Scott Hamm [mailto:[EMAIL PROTECTED] > > Sent:

RE: STORED PROCEDURE

> -Original Message- > From: Scott Hamm [mailto:[EMAIL PROTECTED] > Sent: 02 August 2005 15:38 > To: [EMAIL PROTECTED] > Cc: Mysql > Subject: Re: STORED PROCEDURE > > On 8/2/05, Mark Leith <[EMAIL PROTECTED]> wrote: > > > > CREATE PROCEDURE title

RE: STORED PROCEDURE

CREATE PROCEDURE title() BEGIN DECLARE title VARCHAR(255); SET title = '%Unconditional%'; SELECT title; END; // mysql> CALL title()// +-+ | title | +-+ | %Unconditional% | +-+ 1 row in set (0.01 sec) HTH Mark Mark Leith

RE: Null & alphabetic order

ORDER BY IF(col IS NULL, 1, 0), col > > Michael > Or simply: ORDER BY col IS NULL, col Which will probably be *slightly* faster.. Mark Mark Leith Cool-Tools UK Limited http://www.cool-tools.co.uk -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.

RE: Maximize mysql ini for 4gig big query win 2003 box

memory, applications with be getting 2Gb.. You can read more about this here: http://www.microsoft.com/whdc/system/platform/server/PAE/PAEmem.mspx Basically, add a \3GB switch to your boot.ini file. Then you can start look at tuning the memory on MySQL as well.. HTH Mark Mark Leith Cool-Tool

RE: how to run a file in MySQL

Hi Joppe, Use SOURCE or \. to execute the filename: mysql> SOURCE E:\SQL\MySQL\test_tables.sql Database changed ++ | Tables_in_test | ++ | a | | academies | . HTH Mark Mark Leith Cool-Tools UK Limited http://www.cool-tools.co

RE: 5.03 Still crashes on win32

ugs.mysql.com would be helpful if you do.. Cheers, Mark Mark Leith Cool-Tools UK Limited http://www.cool-tools.co.uk -Original Message- From: Martijn Tonies [mailto:[EMAIL PROTECTED] Sent: 29 March 2005 10:39 To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: Re: 5.03 Still crashes o

RE: referencial integrity problem

Foreign keys are only supported within InnoDB tables (on both sides).. Mark Mark Leith Cool-Tools http://www.cool-tools.co.uk -Original Message- From: Philipp Snizek [mailto:[EMAIL PROTECTED] Sent: 22 February 2005 10:30 To: Mysql List (E-mail) Subject: referencial integrity problem

RE: auto-increment stops at 127

Change the column from a TINYINT (which has a maximum value of 127), see here: http://dev.mysql.com/doc/mysql/en/numeric-types.html HTH Mark Mark Leith Cool-Tools UK Limited http://www.cool-tools.co.uk -Original Message- From: mel list_php [mailto:[EMAIL PROTECTED] Sent: 14

RE: Question: InnoDB transaction and table changes

-- ---+ 1 row in set (0.00 sec) See: http://dev.mysql.com/doc/mysql/en/cannot-roll-back.html HTH Mark Mark Leith Cool-Tools UK Limited http://www.cool-tools.co.uk -Original Message- From: Ville Karjalainen [mailto:[EMAIL PROTECTED] Sent: 04 February 2005 13:59 To: m

RE: Cannot create Windows service for MySql. Error: 0

t; which will delete the current installed service. If you can't get to this (i.e the install dir has been removed) - with the new installer you can use a different name for the service, such as MYSQL41. HTH Mark Mark Leith Cool-Tools UK Limited http://www.cool-tools.co.uk -Origina

RE: Stored Procedure?

ing system would be fantastic as well!! Mark -Original Message- From: Rhino [mailto:[EMAIL PROTECTED] Sent: 30 November 2004 16:04 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Stored Procedure? - Original Message - From: "Mark Leith" <[EMAIL PROTECTED]

RE: Stored Procedure?

k fail, it will first of all execute another procedure (send_admin_email), passing the message along with the substitued username to be used as the message body. It will then generate an application error to the user with another procedure. Don't get me wrong Rhino, your example was great, a