Sonntag, September 02, 2007

Downloadable Version 0.05

After all I have got to build a pre-packaged version again. Thanks to the Fat-Jar Eclipse plugin it was just a matter of a few clicks. Version 0.05 (downloadable here or from the Google Code download page) contains the changes described in the previous post.

Kommentare:

in10d hat gesagt…

How can I run it? Which Java version does it need?

[filip@sulaco:~]$ java -version
java version "1.5.0_10"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_10-b03)
Java HotSpot(TM) Client VM (build 1.5.0_10-b03, mixed mode, sharing)



[filip@sulaco:~]$ java -jar MySQLIndexAnalyzer_0.05.jar
Exception in thread "main" java.lang.UnsupportedClassVersionError: Bad version number in .class file
at java.lang.ClassLoader.defineClass1(Native Method)
at java.lang.ClassLoader.defineClass(ClassLoader.java:620)
at com.simontuffs.onejar.JarClassLoader.defineClass(JarClassLoader.java:580)
at com.simontuffs.onejar.JarClassLoader.findClass(JarClassLoader.java:494)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at com.simontuffs.onejar.Boot.run(Boot.java:240)
at com.simontuffs.onejar.Boot.main(Boot.java:89)

Daniel Schneller hat gesagt…

I believe I compiled this with Java 6.
I will go and build with Java 5 again. In the meantime you could check out from SVN and compile with your version of Java of you need it immediately.

Daniel Schneller hat gesagt…

It took a while, but I recompiled with Java 5. The download packages have been replaced.

kotnik hat gesagt…

Same again :(

kotnik@exitserver:~$ java -version
java version "1.5.0_06"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_06-b05)
Java HotSpot(TM) Server VM (build 1.5.0_06-b05, mixed mode)

kotnik@exitserver:~$ java -jar MySQLIndexAnalyzer_0.05_j5.jar
Exception in thread "main" java.lang.UnsupportedClassVersionError: Bad version number in .class file
at java.lang.ClassLoader.defineClass1(Native Method)
at java.lang.ClassLoader.defineClass(ClassLoader.java:620)
at com.simontuffs.onejar.JarClassLoader.defineClass(JarClassLoader.java:580)
at com.simontuffs.onejar.JarClassLoader.findClass(JarClassLoader.java:494)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at com.simontuffs.onejar.Boot.run(Boot.java:240)
at com.simontuffs.onejar.Boot.main(Boot.java:89)

acornejo hat gesagt…

Hi

I'm very new to java. I have
[root@test-tts]/usr/java/jre1.6.0_05/bin# ./java -version
java version "1.6.0_05"
Java(TM) SE Runtime Environment (build 1.6.0_05-b13)
Java HotSpot(TM) Client VM (build 10.0-b19, mixed mode, sharing)


but when runing the index analizer i get:

[root@test-tts]/usr/java/jre1.6.0_05/bin# ./java /downloads/MySQLIndexAnalyzer_0.05.jar
Exception in thread "main" java.lang.NoClassDefFoundError: /downloads/MySQLIndexAnalyzer_0/05/jar
Caused by: java.lang.ClassNotFoundException: .downloads.MySQLIndexAnalyzer_0.05.jar
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)


does I need the java 1.5xx?

Thanks

Daniel Schneller hat gesagt…

The easiest way is to use Java6. Apparently something went wrong with the Java5 compatible repackaging. Sorry for that.

Use "java -jar MySQL...jar" with a Java6 VM and you should be fine.

Anonym hat gesagt…

This is unfortunate for Mac OSX users.

Cannot run this software.

[dshao@coelacanth Downloads]: java -version
java version "1.5.0_16"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_16-b06-284)
Java HotSpot(TM) Client VM (build 1.5.0_16-133, mixed mode, sharing)

And I dont think there is a version of javase6 for macosx.

please compile version for java 5

Anonym hat gesagt…

Can`t connect using pipes!

Please check this page about mysql pipe connection:

http://waltercedric.com/component/content/article/1217.html

Anonym hat gesagt…

Can`t connect using pipes!

Please check this page about mysql pipe connection:

http://waltercedric.com/component/content/article/1217.html

Anonym hat gesagt…

Can`t connect using pipes!

Please check this page about mysql pipe connection:

http://waltercedric.com/component/content/article/1217.html

Anonym hat gesagt…

Can`t connect using pipes!

Please check this page about mysql pipe connection:

waltercedric.com/component/content/article/1217.html

Anonym hat gesagt…

Can`t connect using pipes!

Please check this page about mysql pipe connection:

waltercedric .com /component/ content/ article/1217. html

Anonym hat gesagt…

Sorry about many comments, I didn't understand german

boxmonkey hat gesagt…

I'm not sure if this is the right place for this, but I'm wondering if there's any way to get at the underlying data that MySQL Analyzer has generated. I'd really like to see the size of each table and each index, not just the redundant ones. Our databases are massive, so running the analyzer is an all day thing, so I'm hoping that now that it has completed there's an easy way for me to get at that data.

Daniel Schneller hat gesagt…

The information you need is available form the information_schema database, available since MySQL 5.0.

This is what the query analyzer uses, in earlier versions you have to use different show table status commands.

So basically this tool is just a frontend which also filters some information out. Have a look at the source for the queries it issues or just read the documentation on the information_schema in the MySQL manual. I think you will find everything you need there.

Daniel