Hi Carlos,
Have you tried and benchmark hivedb.
any body reviewed hivedb. Please share the experience.
Krishna
On Fri, Jan 22, 2010 at 11:47 PM, Carlos Proal wrote:
>
> Hi Krishna
>
> Depending on your programming language, you can use http://www.hivedb.org/
>
> Also you can try the "new" Spid
I handle this by having each developer put the scripts into a folder named:
MMDD
Where the folder name is the date of the next scheduled release.
Under that folder each script is named MMDD_NNN_DESCRIPTION.sql
Where MMDD in this case is the date the script was created and NNN is
the
Huh? This makes no sense.
There is one single file "UPDATES.sql" that has ALL the changes in it.
In order to prefix a line, it would need to be commented. It would also
need to be one single change per line. Highly inefficient.
This still doesn't solve the fact that different developers check
Hi
Thanks for all the responses. In the end I opted for
a separate UserPasswords table, which records all old passwords. When a
user changes their password, this table is checked. NB All passwords are
stored in SHA256.
Thanks again for your advice.
Regards
Neil
On Wed, Jan 20, 2010 at 12:08
Hi Krishna
Depending on your programming language, you can use http://www.hivedb.org/
Also you can try the "new" Spider Storage Engine http://spiderformysql.com/
I have not tried this one but seems interesting and there are a couple
reviews by Giuseppe Maxia that can help you:
http://datachar
>-Original Message-
>From: Albert Padley [mailto:ap3des...@gmail.com]
>Sent: Friday, January 22, 2010 12:37 PM
>To: mysql@lists.mysql.com
>Subject: Join Suddenly Failing
>
>I have a website that gets used once a year for a soccer tournament. It has
>been working fine since 2006. No script c
More precisely, you'll be better off always using explicit joins - that way
you not only prevent this, but also unexpected problems and the need to
review code when something happens to your DB schema.
On Fri, Jan 22, 2010 at 6:42 PM, Scott Swaim wrote:
> I ran into this when I upgraded from 4.
On Fri, January 22, 2010 09:42, Scott Swaim wrote:
> I ran into this when I upgraded from 4.0.xx to 5.0.xx There was a change
> in
> the logic for the Joins. I determined that the FROM clause needs to be in
> parenthesis. i.e.FROM (team, person, teamperson) this allows all of
> the
> fields
Scott,
Thanks. That appears to be the solution.
Albert
On Fri, Jan 22, 2010 at 10:42 AM, Scott Swaim wrote:
> I ran into this when I upgraded from 4.0.xx to 5.0.xx There was a change
> in
> the logic for the Joins. I determined that the FROM clause needs to be in
> parenthesis. i.e.FROM
I ran into this when I upgraded from 4.0.xx to 5.0.xx There was a change in
the logic for the Joins. I determined that the FROM clause needs to be in
parenthesis. i.e.FROM (team, person, teamperson) this allows all of the
fields in all of the tables to be used. The change was made in mysql
I have a website that gets used once a year for a soccer tournament. It has
been working fine since 2006. No script changes since it was last used in
2009. All of a sudden the following script started throwing an error.
SELECT contactinfo.contactdata, contactinfo.ContactID FROM team, person,
teamp
skip-networking is OFF
On 1/22/2010 12:09 PM, Mark Matthews wrote:
On Jan 22, 2010, at 10:49 AM, Mark Witczak wrote:
Alright, here is the entire log entry:
Jan 21, 2010 9:40:35 PM org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextInitialized()
Jan 21, 2010 9:40
On Jan 22, 2010, at 10:49 AM, Mark Witczak wrote:
> Alright, here is the entire log entry:
>
> Jan 21, 2010 9:40:35 PM org.apache.catalina.core.ApplicationContext log
> INFO: ContextListener: contextInitialized()
> Jan 21, 2010 9:40:35 PM org.apache.catalina.core.ApplicationContext log
> INFO: S
Alright, here is the entire log entry:
Jan 21, 2010 9:40:35 PM org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextInitialized()
Jan 21, 2010 9:40:35 PM org.apache.catalina.core.ApplicationContext log
INFO: SessionListener: contextInitialized()
Jan 21, 2010 9:43:06 PM or
On Jan 22, 2010, at 10:21 AM, Mark Witczak wrote:
> [snip]
> I create the WAR (jar cvf testapp.war *), undeploy the old version and
> redeploy the new one through Tomcat Web Application Manager. Then restart
> Tomcat (sudo /etc/init.d/tomcat restart). The result is:
>
> Jan 21, 2010 9:40:35 P
I'm very new to MySQL, Tomcat, connection pooling, JSP, etc. and I've
been banging my head against a wall for two weeks trying to get a simple
program to connect to a MySQL database.
*Vital Stats:*
Ubuntu 9.10, Java 1.6.0_0, Java Servelet 2.5, Java Server Pages 2.1,
JSTL 1.2, Apache2, Tomcat
Running 5.1.34 on XP
Box has been working for form some time, however last night it
asserted out. I've attached the log output, below. I've taken the
query, that is listed, and run it without any trouble -- its only
issue being that it could use some rewriting.
I'd greatly appreciate any help i
Hi List,
I am looking opensource tool for mysql sharding. One is mysql-proxy, but it
is in alpha stage.
Another one is spock proxy.
Any one benchmark spock proxy. Is there other tools also.
Please share views with mysql sharding Any response is highly appreciated.
Thanks,
Krishna
Hi,
How big is sample.sql dump ?
there are many different things, might taking the time. dns resolve issue,
network issue
tcp0 0 www.myweb.:mysql A.B.C.D:8366 *TIME_WAIT* (It should
established)
load on the server, check mysql processlist (any wrong query is there)
Thanks,
Krishn
Krishna Chandra Prajapati schrieb:
> Hi list,
>
> I want to insert 1 records/sec into table. There can be n number of
> tables with unique data in each. What are the possible ways to do ?
>
i prefer mysqlimport. just sort your output into a file that is named like the
table
you wish to i
Did you check the server load when it took 10 min.
Check the query log, number of connections and the number of queries in
query log at that time.
We need to analyze the system with the collected data what we have for
monitoring.
Thanks
Suresh Kuna
On Fri, Jan 22, 2010 at 12:25 PM, madunix wrote
Simple: prefix the change files with mmddhhmm formatted timestamps, so
they sort correctly :-)
On Thu, Jan 21, 2010 at 11:31 PM, Daevid Vincent wrote:
> Exactly what Johan said.
>
> I keep structure like so:
>
> develo...@mypse /var/www/dart2/UPDATES $ ll
> -rw-rw-rw- 1 developer developer 5
22 matches
Mail list logo