MYCNF

Hi All, I am working on the mysql tuning (my.cnf). I would like to know that, if the parameters of mysql are too high or uneven. Then what is the impact on mysql. Whether mysql can crashed or what else. There is any tool or script which can show how much ram is being utilised. Thanks, Krishna

Re: temporary tables on disk?

Michael explained it well, but just to say it a different way, the temporary table is created as an intermediate step in the table, and is implicit, not explicit. So it's not "sent" to the slave -- the query is sent to the slave, and if the query optimizer makes the same decisions on the slave

Re: temporary tables on disk?

Temporary tables only exist for the length of time that the connection that created them remains connected and are only visible to that connection. There is no reason to replicate these to a slave at all, as no client connecting to that slave would ever be able to see them. - michael dykman On

temporary tables on disk?

according to http://dev.mysql.com/doc/refman/4.1/en/internal-temporary-tables.html temporary tables can sometimes be written to disk as myisam. in replication are these myisam temp tables sent to the slaves as myisam tables or in memory tables? -- MySQL General Mailing List For list archives:

RE: Query to find less than 3 char string

Pain in the neck when you can't find the word "red" in a catalog. I know the problem. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com

Re: log files and upgrading

I don't think there is any way to lock down the general log to a single database.. perhaps if you tell us what you are trying to accomplish, we might be able to propose something.. As of today, 5.0.45 is the recommended install version. http://dev.mysql.com/downloads/mysql/5.0.html - micha

Trigger COMMENT question

Hey all, Is there any way to add a COMMENT to a trigger like for a stored proc. Ideally it would be the same mechanism like for the stored proc but other options are welcome too. I basically need this for a tool that I am writing that outputs everything about a database that is available (schemas,

Query to find less than 3 char string

Just wondering if anyone out there may have a workaround to being stuck on a shared server with the default string matching set to more than 3 chars. I know that Navicat searches for 3 and under chars on my catalog when it's connected and that offered me some form of hope. On top of that I'm w

RE: Query to find "foo" within "(foo)"

If you want to match only "(johnie)" or " johnie ", then you could use a regular expression test. They can get as complicated as your brain will tolerate. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.

Re: Query to find "foo" within "(foo)"

thomas Armstrong wrote: If you need something more complicated, such as only ignoring "(", then you need to get more complicated. You might even need a regular expression. I'm to browse: http://dev.mysql.com/doc/refman/5.0/en/regexp.html http://www.wellho.net/regex/mysql.html You know, you don

log files and upgrading

Is it possible to log information to the general log file only for a specific database? We are currently running MySQL 4.0.15. We are planning on moving to a new server so and will upgrade MySQL. What is the latest most stable version that is recommended? Thanks for any information. -- Mal

Re: Falcon and Foreign Key Constraints

> On Thu, Sep 20, 2007 at 11:20:19AM +0200, Martijn Tonies wrote: > > I thought that Falcon supported FKs, but in my test, it doesn't? > > > > Can someone confirm this? > > The Falcon storage engine does not currently support foreign keys. > (The underlying engine does have support for them, but

Re: Falcon and Foreign Key Constraints

On Thu, Sep 20, 2007 at 11:20:19AM +0200, Martijn Tonies wrote: > I thought that Falcon supported FKs, but in my test, it doesn't? > > Can someone confirm this? The Falcon storage engine does not currently support foreign keys. (The underlying engine does have support for them, but this functiona

Falcon and Foreign Key Constraints

Hi, I thought that Falcon supported FKs, but in my test, it doesn't? Can someone confirm this? Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle & MS SQL Server Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Datab

Re: Query to find "foo" within "(foo)"

> If you need something more complicated, such as only ignoring "(", then you > need to get more complicated. You might even need a regular expression. I'm to browse: http://dev.mysql.com/doc/refman/5.0/en/regexp.html http://www.wellho.net/regex/mysql.html Thank you very much! > > Regards, > > J

Re: Query to find "foo" within "(foo)"

Thank you Chris for your answer. On 9/19/07, Chris Sansom <[EMAIL PROTECTED]> wrote: > > Well I'm hardly the world's greatest expert, but I'm curious as to > why you're always separating '%' from 'johnie' with a space, because > that way it will only find Johnie if he has a space before or after >

Re: Query to find "foo" within "(foo)"

Thank you Michael for your answer. On 9/19/07, Michael Dykman <[EMAIL PROTECTED]> wrote: > The whitespace counts... try LIKE '%johnie%' (or better '_johnie_' .. > the underscorematches any single character). I want to match '(johnie)' and not 'johnies' or 'aljohnier', what it's the query does wi