MySQL Conference at Oslo

A couple of weeks ago I went to a MySQL Conference which has been kept in Lysaker, Oslo at ORACLE Office.

17 March 2015, Lysaker, Oslo

It was a database conference at Oracle building about MySQL and MySQL News and the rest.

They develop more InnoDB for a better transactional operations.

Replication for a better scalability.

Swedish Police uses MySQL; also, Facebook, Booking.com, Linkedin, CISCO and others.


They, I mean these two guys, brought infos about MEM (MySQL Enterprise Monitor). I have to admit that I didn't know about that.

And, also, they said something about MySQL Query Analiser.

MySQL has a developers team at Trondheim.


MEM (MySQL Enterprise Monitor)

MEM (MySQL Enterprise Monitor) works on Apache. It is a Java Application. To monitorize a
MySQL Server you need to put an agent on your Database Server.

HADOOP

I have to see what they did about this. (80% big data platform).


MAX 2 TB for MySQL

SQL and NoSQL access to data.


SSD optimization




DUMP and RESTORE

mysql> SET innodb_buffer_pool_dump_at_shutdown=ON;


Transportable TABLES

FLUSH date for EXPORT;

Optimizer
EXPLAIN (this is used at the beginning and is not so precise)
….
OPTIMISER ( this is used at the end of a query and it has a better presentation as a result)
EXPLAIN [FORMAT=____] FOR CONNECTION ;
SERVER-SIDE STATEMENT TIMEOUT;
SELECT M;

MySQL Fabric

This is for using more databases, using mirrors. This is helping us not to do manual work when one of the servers is down. :(
There is a farm of MySQL Servers and they work like a team.

I'll be back with documentation. Here I've put only a short sketch of mine made into Conference.

Math library in Java ME

Math.round() is not available in J2ME.
So, it's hard to round a double.

VB Script

I've needed to access an Access file from an html file. I did could do this using VBScript. It is running very well with Internet Explorer and could be a solutions in Corporatist offices wher security level is too paranoic.

Now I'm working with vbscripts. I use it to generate local xml files. Those xml files I use  to keep data from Access files to be easier to read in my network. The answer of my small app (.hta file) is much faster then if I read straight from MS Access file.

So, I used following code to generate a new .xml file:

<script type='text/vbscript'> 
        Set oFS = CreateObject("Scripting.FileSystemObject") 
           Const strXmlFile = "Documents.xml" 
           Set objXMLFile = oFS.OpenTextFile(strXmlFile, 2, True, 0) 
            objXMLFile.WriteLine "" 
            objXMLFile.WriteLine ""'" href=""Documents.xsl""?>" 
            objXMLFile.WriteLine "" 
           'Set myFolder = oFS.GetFolder("Documents") 
            'For Each File In myFolder.Files 
            'FileLast = File.DateLastModified 
            'FileMod = DateDiff("d", FileLast, Now) 
            '    If FileMod < 5 Then 
             'Corporate = File.Name 
             'myDate = Split(FileLast,"/") 
             'myYear = Left(myDate(2),4) 
             'myMonth = myDate(0) 
             'myURL = "Whatever your URL is" 
             'Download = "Wherever your download site is" 
             'Call CreateXML(Corporate,myYear,myMonth,myURL,Download) 
             Call CreateXML("Corporatia","myYear","myMonth","myURL","Download") 
              
                'End If 
            'Next 
           'This next call will run once the "CreateXML" has finished. 
           Call CloseXML() 
           Function CreateXML(Corporate,myYear,myMonth,myURL,Download) 
            objXMLFile.WriteLine vbTab & "" 
            objXMLFile.WriteLine vbTab & vbTab & "" & Corporate & "" 
            objXMLFile.WriteLine vbTab & vbTab & "" & myYear & "" 
            objXMLFile.WriteLine vbTab & vbTab & "" & myMonth & "" 
            objXMLFile.WriteLine vbTab & vbTab & "" & myURL & "" 
            objXMLFile.WriteLine vbTab & vbTab & "" & Download & "" 
            objXMLFile.WriteLine vbTab & "
"            End Function 
           Function CloseXML() 
            objXMLFile.WriteLine "
"              wscript.echo "Completed XML Creation" 
           End Function 

          </script>

VBA Excel - Syntax for "for"

Syntax for "for":

For i = 4 To 2000 

    ' do something                

Next i 

MS Access - open form in another database

If you want to open a new form from another Access file you can use following code:

Public Sub OpenForeignForm()  
 Dim appAccess As Access.Application  
 Set appAccess = CreateObject("Access.Application")  
 appAccess.OpenCurrentDatabase "C:\MyPath\DataBaseName2.mdb"  
 appAccess.DoCmd.OpenForm "FormName"  
 Set appAccess = Nothing 
End Sub