Questions regarding Query cache usage

2010-06-08 Thread Machiel Richards
Good morning all I would like to try and find out how you can see what is using the query cache. My reason for asking is the following: On one of our client databases, the query cache is set to 128Mb and the usage always varied between 5% and 53%

Re: Error 1064

2010-06-08 Thread Carsten Pedersen
Brad Scott skrev: Any line beginning with just a number (ie 9, 10, 16) causes a failure. What am I missing? backticks. Use `9`, `10`, etc. Having column names that begin with numbers is a really bad design decision. "9a123" (unquoted, of course) will work, as you've noticed, but e.g. "

Re: Error 1064

2010-06-08 Thread Mattia Merzi
Hi Brad, 2010/6/8 Brad Scott : [...] > Any line beginning with just a number (ie 9, 10, 16) causes a failure. What > am I missing? you should add backticks ( ` ) at both ends of the column name, e.g. `7c` varchar(255) NOT NULL default '', I think your export should have been done with the opt

Error 1064

2010-06-08 Thread Brad Scott
I am receiving this error: ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to you MySQL server version for the right syntax to use near '16 varchar(255) NOT NULL default 'Not applicable', 17a varch I have version 4.0.16 and have a dump file that I'm trying

RE: Connecting Remotely to MySQL Server

2010-06-08 Thread Qu, Gang
If you only allow local connection, your setup should works, otherwise, you need to specify from which host you allow the connection in your grant statement. I think you need a DNS entry for your first question, not so sure about the question. From: Andy [mailto:listan...@gmail.com] Sent: Mond

Re: Why UTF8 need 24bit in MySQL?

2010-06-08 Thread Ryan Chan
Hi, On Tue, Jun 8, 2010 at 12:44 AM, Warren Young wrote: >  The Unicode consortium has stated that Unicode will > never require more than 21 bits per character[*], and 24 bits is the next > even multiple of 8 up from that. Maybe off topic, but just curious...If 3 bytes is enough for all Unicode

Re: how to setup replication - MySQL 5.0.x - Migration and new databases

2010-06-08 Thread Rob Wultsch
On Mon, Jun 7, 2010 at 11:59 PM, Götz Reinicke - IT-Koordinator wrote: > Hi, > > we do have different LAMP systems and recently I started to put some > mysql databases on one, new master server. (RedHat, Fredora, MySQL 4.x - > 5.0.xx) MySQL 4.X is EOL. I strongly suggest not using it for new proj

Greatly Enhanced LINQ Capabilities in Devart ADO.NET Data Providers

2010-06-08 Thread Julia Samarska
Devart Email: i...@devart.com Web: http://www.devart.com FOR IMMEDIATE RELEASE CONTACT INFORMATION: Julia Samarska jul...@devart.com 08-Jun-2010 Greatly Enhanced LINQ Capabilities in Devart ADO.NET Data Providers Devart has recently announced the release of dotConnect products for Oracle, My