[ANN]VTD-XML 2.9

VTD-XML 2.9, the next generation XML Processing API for SOA and Cloud computing, has been released. Please visit https://sourceforge.net/projects/vtd-xml/files/ to download the latest version. a.. Strict Conformance a.. VTD-XML now fully conforms to XML namespace 1.0 spec b.. Performan

[ANN] VTD-XML 2.8

Version 2.8 of VTD-XML, the next generation XML parsing/indexing/Xpath lib, has been released. Please visit https://sourceforge.net/projects/vtd-xml/files/ to download the latest version. a.. Expansion of Core VTD-XML API a.. VTDGen adds support for capturing white spaces b.. VTDNa

Re: if there're a tool which can replace mysql-proxy?

Forgot to post the URL in the event you are interested: http://www.mysql.com/news-and-events/web-seminars/display-306.html -- Jimmy Jimmy Guerrero wrote: Hello, One additional note in regards to learning more about the current state of MySQL Proxy and connecting with Proxy developers

Re: if there're a tool which can replace mysql-proxy?

e Engineer @ Sun who will be talking about Proxy in general, but also some advanced topics. Thanks, -- Jimmy Mark Matthews wrote: On Mar 24, 2009, at 8:06 AM, Claudio Nanni wrote: Question: Hello Claudio, my company tried the mysql-proxy about one year ago(may be more) but could not u

Re: MySQL Guru Needed!!

Hello, Depending on your budget and SLA needs, check out the support offerings available directly from MySQL/Sun. http://www.mysql.com/products/enterprise/features.html -- Jimmy bruce wrote: Hi. I've got a situation where I need to reach out/talk to a mysql guru every now and then. Fo

Fatal error: Illegal or unknown default time zone 'UTC'

sing different values for detault-time-zone by the way, but it gave a fatal error for each. Anyone know what's going on here? UTC clearly is a legal and known default time zone. I'd like to enable that option in my my.cnf file again. Anyone know what to do about this? Best regards, Jimmy

Re: Question on replication

Hello, Check out: --replicate-do-db=db_name http://dev.mysql.com/doc/refman/5.0/en/replication-options.html -- Jimmy Kandy Wong wrote: Hi, Is there a replication setup method just to replicate a specific database not all the databases or exclude a specific database not to be replicated

Re: recommended high availability setups

Hello, It isn't without its pros and cons (just like any other HA solution), but you might want to check out DRBD. http://dev.mysql.com/doc/refman/5.1/en/faqs-mysql-drbd-heartbeat.html -- Jimmy Bryan Irvine wrote: What's the recommended method for high-availability setups? I&#x

Re: Securing the Data

Hello, http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html discusses some available encrypt and decrypt functions native to MySQL. -- Jimmy Sujatha S wrote: Thanks for the update. Is there any method to encrypt the data on mysql? Regards, Suja On 1/11/08, [EMAIL PROTECTED

Re: Circular replication

Hello, EDS and MySQL are having a webinar on the subject of circular replication today. Check out: http://www.mysql.com/news-and-events/web-seminars/index.html If you can't make it today, it will be archived in the "On-Demand" section. -- Jimmy Alex Arul Lurthu wrote: Chain

Re: hardware & clusters

Also, there is a cluster specific list: [EMAIL PROTECTED] Jimmy Guerrero Sr Product Manager MySQL, Inc Houston, TX Ricardo Oliveira wrote: Hi, As usual, everything is heavilly dependant on your specific scenario. Anyway, as a rule of thumb, databases benefit a LOT from RAM, and storage nodes

Re: 64 bit build for Windows?

Hello, http://dev.mysql.com/downloads/mysql/5.0.html#winx64 Let me know if that helps. -- Jimmy James Eaton wrote: Is there a 64 bit build of MySQL 5.0 available for Windows Server 2003 64 bit edition? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: MySQL cluster for windows

Cluster to Windows. -- Jimmy Yi, Ung wrote: I would be interested in cluster for windows. At least at our shop, we consider Windows servers easier to deploy so if we can have HA option for windows/mysql it'll be great. Thanks, Yi -Original Message- From: Rolando Edwards [mailto:[

Re: MySQL cluster for windows

on Mac- Linux - Unix platforms. (Just not Windows) Hope that helps, Jimmy Rolando Edwards wrote: What was the last release of MySQL 5.0.x that supported Cluster ??? - Original Message - From: "Jimmy Guerrero" <[EMAIL PROTECTED]> To: "C K" <[EMAIL PROTECTE

Re: MySQL cluster for windows

to do a new port and maintain it. This actually would be great community project for anyone that is up for it. -- Jimmy C K wrote: I have read some where that MySQL cluster will be available in 5.1 release, will it? Is there some progress in this regard? Thanks CPK -- MySQL General Mailing

Re: Getting list of queries run against a database

Hello, To get started, have you tried enabling the slow query log? http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html "The slow query log can be used to find queries that take a long time to execute and are therefore candidates for optimization." Jimmy Guerrero Sr Produ

Re: Master-Slave System Using Different Versions of MySQL

Hello, Did you already check: http://dev.mysql.com/doc/refman/5.0/en/replication-compatibility.html "You cannot replicate from a master that uses a newer binary log format to a slave that uses an older format (for example, from MySQL 5.0 to MySQL 4.1.)" Thanks, Jimmy Guerrero

Re: MYSQL data replication

Hello, Hmmm, I just reread your post and noticed the requirement of 50-60 slaves hanging off a single master. DRBD would NOT be the right solution here. -- Jimmy Jimmy Guerrero wrote: Hello, Although you state that there is no requirement for near real time synchronization, an

Re: MYSQL data replication

also gives you failover capabilities. Mohd posted a blog on his experience yesterday. See: http://blog.irwan.name/?p=118 Jimmy Guerrero Sr Product Manager MySQL, Inc Houston, TX sol beach wrote: I have limited experience with MYSQL replication; which is why I am hoping others with more

RE: MySQL Licensing

Hello, I would recommend posting your question in the Licensing Fourm: http://forums.mysql.com/list.php?4 Also, please refer to our FAQ: http://www.mysql.com/company/legal/licensing/ Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc > -Original Message- > From: I have a qu

RE: MySQL on a ram disk?

looking for, with the added benefit of high availability. More info at: http://www.mysql.com/products/database/cluster/ Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc > -Original Message- > From: Ryan Stille [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 08, 2006 8:2

RE: MyISAM vs InnoDB

/storage-engines.html Thanks, Jimmy Guerrero MySQL, Inc > -Original Message- > From: Francis [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 31, 2006 2:25 PM > To: mysql@lists.mysql.com > Subject: MyISAM vs InnoDB > > Hi list, > > Question about MyI

RE: Encryption

Hello, Have you taken a look at: http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html That might give you a good start. Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc > -Original Message- > From: Cummings, Shawn (GNAPs) [mailto:[EMAIL PROTECTED] > Sen

RE: where are the .MYI and .MYD files?

/dev.mysql.com/doc/refman/5.0/en/upgrading-to-arch.html Jimmy Guerrero Sr Product Manager MySQL, Inc > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 07, 2006 4:32 PM > To: mysql@lists.mysql.com > Subject: where are the .

RE: How to draw data model diagrams from existing schema?

Hello, Check out MySQL Workbench (Part of the MySQL GUI Tools Bundle) if you haven't already done so: http://dev.mysql.com/downloads/gui-tools/5.0.html Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc > -Original Message- > From: news [mailto:[EMAIL PROTECTED] On Behalf

RE: Web Seminar Events

hem happen. Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc > -Original Message- > From: Jesse [mailto:[EMAIL PROTECTED] > Sent: Friday, August 25, 2006 12:13 PM > To: MySQL List > Subject: Web Seminar Events > > Why is it that the Newsletter goes out after th

RE: Moving Databases from v4.0.23 to v5.0.24

Hello, REPEAT is indeed a reserved word in MySQL in 5.0 http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html Jimmy Guerrero Sr Product Manager MySQL, Inc > -Original Message- > From: Kurt Cypher [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 09, 2006 3:13 PM &g

RE: Replication vs. Clustering

http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster-faq.html Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc > -Original Message- > From: Jesse [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 27, 2006 7:23 AM > To: MySQL List > Subject: Replication vs. Clustering

RE: MySQL Cluster

Hello, MySQL Cluster has been available since version 4.1. For production purposes we recommend the GA version of 5.0. For the testing of new features (Disk-Data, Replication, etc) take a look at the latest 5.1 version. Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc > -Origi

RE: mysql + LVS

nks, Jimmy Guerrero MySQL, Inc > -Original Message- > From: Winn Johnston [mailto:[EMAIL PROTECTED] > Sent: Monday, July 24, 2006 3:26 PM > To: mysql@lists.mysql.com > Subject: mysql + LVS > > How stable has it become to run an instance of mysql ontop of >

RE: Synro MySQL databases

/sqlyog/index.php Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc > -Original Message- > From: Brian E Boothe [mailto:[EMAIL PROTECTED] > Sent: Monday, July 24, 2006 10:16 AM > To: MySQL List > Subject: Synro MySQL databases > > HI all i have a question,

RE: Anyone interested in a 4gl compiler ?

Hello, Have you taken a look at MySQL Forge? http://forge.mysql.com/ Great place check out other projects or users working on projects who may be interested in what your working on. Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc > -Original Message- > From: Mike Aubury [

RE: udf configuration

Hello, If you have not already done so, you may also try the MySQL forum for UDFs at: http://forums.mysql.com/list.php?118 Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc > -Original Message- > From: Yong Lee [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 19, 200

RE: Books on MySQL 5

Hello, You might want to check out Guy Harrison's book on SP's. http://www.amazon.com/gp/product/0596100892/102-8915813-3282553?v=glance&n=2 83155 Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc > -Original Message- > From: Chris White [mailto:[EMAIL PROTEC

RE: How To Pronounce MySQL

Hello, I'll take the easy way out and quote http://dev.mysql.com/doc/refman/5.0/en/what-is.html "The official way to pronounce "MySQL" is "My Ess Que Ell" (not "my sequel"), but we don't mind if you pronounce it as "my sequel" or in some ot

RE: MySQL (GPL License)

Hello, If you are still unsure about the licensing, this may help... http://www.mysql.com/company/legal/licensing/ http://www.mysql.com/company/legal/licensing/faq.html There are also related links off to the right concerning the Open Source License and Commercial License. Thanks, Jimmy

RE: MySQL Server

Hello, Is there a particular reason you need to be working with version 3.23 (besides it being part of the RHL distro?) You might want to start with version 5.0 or 4.1. http://dev.mysql.com/downloads/ Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc > -Original Message- >

RE: Passwords in Mysql5.x

Hello, Have you taken a look at the following sections in the manual? http://dev.mysql.com/doc/refman/5.0/en/user-names.html http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html Thanks, Jimmy Guerrero Sr Product Manager

RE: MySQL documentor - not MySQL Workbench

Hello, Although not open-source, our partner Embarcadero Technologies offers one of the best ER tools out there for design, diagraming, documentation and reverse/forward engineering. ERStudio www.embarcadero.com/products/erstudio/index.html Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc

RE: MySQL Clustering

t for it's availability. Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc > -Original Message- > From: Ben Clewett [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 30, 2006 6:48 AM > To: mysql@lists.mysql.com > Subject: MySQL Clustering > > Dear MySQL, > &

RE: possible to select from multiple databases?

Hello, Have you taken a look at the FEDERATED storage engine? http://dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html It is a storage engine that accesses data in tables of remote databases rather than in local tables. Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc

RE: ~Mysql cluster info~

Hello, Not at this time, currently 5.1 is in Beta. We should see a release candidate soon, but I can't commit to a specific date at this time. Thanks, Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA > -Original Message- > From: Moh

RE: ~Mysql cluster info~

still reside in memory. Might be worth checking out, however 55 GB is def. on the large size for a MySQL Cluster configuration. Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com > -Original Message- > From: Mohammed Abdul Azeem [mailto:[EMAIL PROTECTED] > Sen

RE: Visual database design system

Hello, Might want to check out ERStudio from Embarcadero Technologies. http://www.embarcadero.com/products/erstudio/ Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA -Original Message- From: Adi [mailto:[EMAIL PROTECTED] Sent: Friday, February 03

RE: 4 GIG Limitation

Hello, Check out http://dev.mysql.com/doc/refman/5.0/en/table-size.html Also, not sure if it's a typo but MySQL 11.8 is a ways off. Did you mean 4.1 or 5.0? Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA Phone: (713) 636-9239 -Original Me

RE: Performance of MEMORY/HEAP-tables compared to mysql-cluster?

API to access data.) As, Sherri suggests another storage engine might be a better play here. Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX -Original Message- From: sheeri kritzer [mailto:[EMAIL PROTECTED] Sent: Friday, January 27, 2006 11:11 AM To: Jan

RE: Collect SQL Statements

seconds to execute or didn't use indexes See http://dev.mysql.com/doc/refman/5.0/en/log-files.html for more info on setting up and analyzing these logs. Thanks, Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA -Original Message- From: Mo

RE: MySQL database design documentation

for remote admin depending on your setup and security needs. Thanks, Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA Phone: (713) 636-9239 -Original Message- From: Maurice van Peursem [mailto:[EMAIL PROTECTED] Sent: Thursday, January 05, 2006 3:37 PM

RE: Report tool - Mysql

. If it's reports/documentation about your DB you are after you might want to check out Embarcadero's ERStudio, which is imho the best ERD tool on the market. Thanks, Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA -Original Message- Fr

RE: MySQL5

ons] command [command-options] 3. If you are interestd in the graphical tools we offer, you can find the links at: http://dev.mysql.com/downloads/ The Administrator, Query Browser and Migration Toolkit are available for download on that page. Thanks, Jimmy Guerrero, Senior Product Manager MySQL

RE: Store Procedures

Hola, Una introducción basica y ejemplos se pueden encontrar aquí: http://www.quest-pipelines.com/newsletter-v6/0105_D.htm http://www.quest-pipelines.com/newsletter-v6/0205_D.htm Tambien aqui: http://www.databasejournal.com/features/mysql/article.php/3525581 Jimmy Guerrero, Senior Product

RE: how to create binary logging for a database

Hello, The reference manual is great place to start for this type of information. http://dev.mysql.com/doc/refman/5.0/en/binary-log.html --log-bin[=file_name] is the mysqld startup command. Thanks, Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA Phone: (713

RE: to track the changes in database mySQL

MySQL with the --log option will create the query log. Note, there are some important differences between the bin and query log. See http://dev.mysql.com/doc/refman/5.0/en/query-log.html for more info. Thanks, Jimmy -Original Message- From: Satyanarayana_Kesani [mailto:[EMAIL P

RE: to track the changes in database mySQL

ta to suit your needs. Thanks, Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA -Original Message- From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] Sent: Monday, December 12, 2005 11:14 PM To: Satyanarayana_Kesani; mysql@lists.mysql.com Su

RE: copying data!!!

Hello, We expect to offer native support for LDAP and PAM authentication, late next year. Thanks, Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com -Original Message- From: Sachin Bhugra [mailto:[EMAIL PROTECTED] Sent: Friday, December 09, 2005 1:38 PM To: mysql

RE: Now what's that called?

Hello, Are you think of Eventum? http://dev.mysql.com/downloads/other/eventum/ Thanks, Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA Phone: (713) 636-9239 Are you MySQL Certified? www.mysql.com/training//certification -Original Message- From

Auth Problem

*: mysql_connect(): Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in */var/htdocs/"removed"/htdocs/shop/catalog/includes/functions/database.php* on line *19* Unable to connect to database server! wtf did i wrong that its not working with this account? kind regards ji

RE: 'Sum' syntax

Is there any reason that you need to "sum" the id? I'm assuming that you're trying to "count". Ya? -Original Message- From: Noamn [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 5:22 PM To: [EMAIL PROTECTED] Subject: 'Sum' syntax I'm using v3.23.51 on Linux. Can anyone expla

SUM and GROUP BY with UNION

600B<-- from table_b how can i do a SUM on tCount and GROUP BY amount and block with this two set of record? result should be like this tCountamountblock 4 400A 2400B 10 600A 10 600 B Thanx Jimmy

Japanese, Korean and English in same mysql db

owsed over posts about problems with sorting/searching mixed Japanese/English/other languages. Is the only option available to me is to preprocess these strings into something (Unicode ?) before storing and searching for them in the DB. Thanks. Jimmy Vo [EMAIL PROT

Re: Win and Linux ?

Hi jeremy Thanks for the quick response. Appreciate it. One more clarification though... How about bringing the database from Unix/liux to Windows. Still OK? THANKS!! :) jimmy >From: Jeremy Zawodny <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Jimmy Fernandez <[EMA

Win and Linux ? Ver 3 and Ver 4 compatibility ?

ver 4.0 ? 2. If I made the database in Windows version of MySQL can I bring the database over to a Unix or Linux machine ? What are the changes I have to make if any ? THANKS in advance. Cheers Jimmy _ Chat with friends online

Några frågor

Hejsan 1. Kan man köra MySQL i DOS eller måste man ha Windows installerat ??? 2. Finns det något Windows baserat redskap som man kan redigera i databasens tabeller och/eller lägga till/ta bort tabeller, spalter och kolumner ??? Tack på förhand. MvH. Jimmy

sql: DATETIME - MONTH( select problem)

today so it's a current one. > >My problem is that I can't get the months in between when, how do I do that? >Any ideas? >$current_month is a php variable. > >(MONTH(start)= '$current_month' OR MONTH(end) = '$current_month&#