dqy012345 2019-06-14 10:23
浏览 567

一段时间后,XAMPP变得非常缓慢

Does anyone ever encounter the MYSQL in XAMPP being super slow after sometime?

I have a unity application that asking a string to be downloaded with this php script.

<?php
include 'Config.php'; // Just a normal mysqli connection setup


    //the post from Unity.
    $var_uniqueID       = $_POST['uniqueID_Post'];

    $conn = OpenCon(); // open connection

    //create a query
    $sql = "SELECT 
                var_name,
                var_value
            FROM variable_current_values
            WHERE uniqueID = '".$var_uniqueID."' ";

    $result = mysqli_query($conn, $sql);



    if( mysqli_num_rows($result) > 0)
    {
        //show data for each row
        while($row = mysqli_fetch_assoc($result))
        {
            echo "".$row['var_name'] . 
                 "|".$row['var_value'] . "";
        }
    }

    CloseCon($conn); // close the connection
?>

This PHP script is being called with c# script of UnityWebRequest

    //www variable
    private UnityWebRequest unityWebRequest;

    void Update ()
    {
        if (unityWebRequest == null)
        {
            //fetch The data Widget
            StartCoroutine(RealDataFetchWhere(this.name)); 
        }
    }

    private IEnumerator RealDataFetchWhere(string _uniqueIDPost)
    {
        //gives the unique key
        WWWForm fetchingForm = new WWWForm();
        fetchingForm.AddField("uniqueID_Post", _uniqueIDPost);


        //load and wait until the data is downloaded
        unityWebRequest = UnityWebRequest.Post(**thePHPLink**, fetchingForm);
        yield return unityWebRequest.SendWebRequest();

        string data = unityWebRequest.downloadHandler.text;
        print("the Data is : " + data); 

    }

At first everything seems to be fine. Data is downloaded perfectly(almost in realtime speed).

However after like more than 10 minutes, the XAMPP mySQL starting to slow down considerably.
I try to modified the data manually in XAMPP and it takes about 5 - 8 seconds until the "row is affected"
If i leave them longer without closing my unity program, XAMPP start to freeze and disconnected.

Does anyone know the solutions to counter this problem ?

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 RPA正常跑,cmd输入cookies跑不出来
    • ¥15 求帮我调试一下freefem代码
    • ¥15 matlab代码解决,怎么运行
    • ¥15 R语言Rstudio突然无法启动
    • ¥15 关于#matlab#的问题:提取2个图像的变量作为另外一个图像像元的移动量,计算新的位置创建新的图像并提取第二个图像的变量到新的图像
    • ¥15 改算法,照着压缩包里边,参考其他代码封装的格式 写到main函数里
    • ¥15 用windows做服务的同志有吗
    • ¥60 求一个简单的网页(标签-安全|关键词-上传)
    • ¥35 lstm时间序列共享单车预测,loss值优化,参数优化算法
    • ¥15 Python中的request,如何使用ssr节点,通过代理requests网页。本人在泰国,需要用大陆ip才能玩网页游戏,合法合规。